Skip to main content

Dotnet IMP

Dot Net Project Code

1) Table Creation

CREATE TABLE [dbo].[Batches](

[Bat

Publish Post
chId] [bigint] IDENTITY(1,1) NOT NULL,

[BatchNo] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[FromTiming] [datetime] NULL,

[ToTiming] [datetime] NULL,

[EnteredBy] [bigint] NULL,

[EnteredDate] [datetime] NULL,

[UpdatedBy] [bigint] NULL,

[UpdateDate] [datetime] NULL,

[IsActive] [bit] NULL,

CONSTRAINT [PK_Batches] PRIMARY KEY CLUSTERED

(

2) Stored Procedure:

create procedure [dbo].[USP_IDFU_Baches]

(@Type char(1)=null,

@Batchid bigint=null,

@BatchNo varchar(20)=null,

@FromTiming datetime=null,

@ToTiming datetime=null,

@EnteredBy bigint=null,

@EnteredDate datetime=null,

@UpdatedBy bigint=null,

@UpdateDate datetime=null,

@IsActive bit=null)

as

if(@type='I')begin

insert into Batches(BatchNo,FromTiming,ToTiming,EnteredBy,EnteredDate,UpdatedBy,

UpdateDate,IsActive)

values(@BatchNo,@FromTiming,@ToTiming,@EnteredBy,@EnteredDate,@UpdatedBy,

@UpdateDate,1)

end

if(@type='D')

begin

declare @sts bit

select @sts=isactive from Batches where batchid=@batchid

if(@sts=1) begin

update Batches set isactive=0 where batchid=@batchid

end

else begin

update Batches set isactive=1 where batchid=@batchid

end

end

if(@type='F')begin

select *from Batches where IsActive =1

end

if(@type='U')begin

update Batches set BatchNo=@BatchNo,FromTiming=@FromTiming,ToTiming=@ToTiming,

EnteredBy=@EnteredBy,EnteredDate=@EnteredDate,UpdatedBy=@UpdatedBy,

UpdateDate=@UpdateDate,IsActive=@IsActive where batchid=@batchid

end

if(@type='SF')begin

select * from TranieeBatches s where s.batchid=@batchid

end

3) Class file Creation:

using System;

using System.Collections.Generic;

using System.Text;

using System.Data;

using System.Configuration;

using System.Data.SqlClient;

namespace VBOMS.API

{

public class Batches:DbManager

{

# region veriables

private Int64 _BatchID;

private string _BatchNo;

private string _FromTiming;

private string _ToTiming;

private Int64 _EnteredBy;

private DateTime _EnterDate;

private Int64 _UpdatedBy;

private DateTime _UpdateDate;

private bool _IsActive;

#endregion

#region properties

public Int64 BatchID

{

get { return _BatchID; }

set { _BatchID = value; }

}

public string BatchNo

{

get { return _BatchNo; }

set { _BatchNo = value; }

}

public string FromTiming

{

get { return _FromTiming; }

set { _FromTiming = value; }

}

public string ToTiming

{

get { return _ToTiming; }

set { _ToTiming = value; }

}

public Int64 EnteredBy

{

get { return _EnteredBy; }

set { _EnteredBy = value; }

}

public DateTime EnterDate

{

get { return _EnterDate; }

set { _EnterDate = value; }

}

public Int64 UpdatedBy

{

get { return _UpdatedBy; }

set { _UpdatedBy = value; }

}

public DateTime UpdateDate

{

get { return _UpdateDate; }

set { _UpdateDate = value; }

}

public bool IsActive

{

get { return _IsActive; }

set { _IsActive = value; }

}

#endregion

#region functions

public bool Save()

{

try

{

SqlParameter[] parameter = new SqlParameter[]

{

new SqlParameter("@type","I"),

new SqlParameter("@BatchID",this.BatchID),

new SqlParameter("@BatchNo",this.BatchNo),

new SqlParameter("@FromTiming",this.FromTiming),

new SqlParameter("@ToTiming",this.ToTiming),

new SqlParameter("@EnteredBy",this.EnteredBy),

new SqlParameter("@EnteredDate",this.EnterDate),

new SqlParameter("@UpdatedBy",this.UpdatedBy),

new SqlParameter("@UpDateDate",this.UpdateDate),

new SqlParameter("@IsActive",this.IsActive)

};

int result = ExecuteNonQuery("USP_IDFU_Baches", parameter);

if (result > 0)

{

return true;

}

else

{

return false;

}

}

catch (Exception ex)

{

return false;

}

}

public bool Update()

{

try

{

SqlParameter[] parameter = new SqlParameter[]

{

new SqlParameter("@type","U"),

new SqlParameter("@BatchID",this.BatchID),

new SqlParameter("@BatchNo",this.BatchNo),

new SqlParameter ("@FromTiming",this.FromTiming),

new SqlParameter("@ToTiming",this.ToTiming),

new SqlParameter("@EnteredBy",this.EnteredBy),

new SqlParameter("@EnteredDate",this.EnterDate),

new SqlParameter("@UpdatedBy",this.UpdatedBy),

new SqlParameter("@UpDateDate",this.UpdateDate),

new SqlParameter("@IsActive",this.IsActive)

};

int result = ExecuteNonQuery("USP_IDFU_Baches", parameter);

if (result > 0)

{

return true;

}

else

{

return false;

}

}

catch (Exception ex)

{

return false;

}

}

public bool Delete()

{

try

{

SqlParameter[] parameter = new SqlParameter[]

{

new SqlParameter("@type","D"),

new SqlParameter("@BatchID",this.BatchID),

new SqlParameter("@IsActive",this.IsActive)

};

int result = ExecuteNonQuery("USP_IDFU_Baches", parameter);

if (result > 0)

{

return true;

}

else

{

return false;

}

}

catch (Exception ex)

{

return false;

}

}

public DataSet Fecth()

{

try

{

DbManager objDb = new DbManager();

SqlParameter[] parameter = new SqlParameter[]

{

new SqlParameter("@type","F"),

//new SqlParameter("@BatchID",this.BatchID),

//new SqlParameter("@BatchNo",this.BatchNo),

//new SqlParameter ("@FromTimings",this.FromTiming),

//new SqlParameter("@ToTiming",this.ToTiming),

//new SqlParameter("@EnteredBy",this.EnteredBy),

//new SqlParameter("@EnterDate",this.EnterDate),

//new SqlParameter("@UpdatedBy",this.UpdatedBy),

//new SqlParameter("@UpDateDate",this.UpdateDate),

//new SqlParameter("@IsActive",this.IsActive)

};

DataSet ds=objDb.ExecuteDataSet("USP_IDFU_Baches", parameter);

return ds;

}

catch (Exception ex)

{

throw;

}

}

public DataSet SelectFecth()

{

try

{

DbManager objDb = new DbManager();

SqlParameter[] parameter = new SqlParameter[]

{

new SqlParameter("@type","SF"),

//new SqlParameter("@BatchID",this.BatchID),

//new SqlParameter("@BatchNo",this.BatchNo),

//new SqlParameter ("@FromTimings",this.FromTiming),

//new SqlParameter("@ToTiming",this.ToTiming),

//new SqlParameter("@EnteredBy",this.EnteredBy),

//new SqlParameter("@EnterDate",this.EnterDate),

//new SqlParameter("@UpdatedBy",this.UpdatedBy),

//new SqlParameter("@UpDateDate",this.UpdateDate),

//new SqlParameter("@IsActive",this.IsActive)

};

DataSet ds = objDb.ExecuteDataSet("USP_IDFU_Baches", parameter);

return ds;

}

catch (Exception ex)

{

throw;

}

}

#endregion

}

}

4) DB Manager:

using System;

using System.Collections.Generic;

using System.Text;

using System.Data;

using System.Data.SqlClient;

using System.Configuration;

namespace VBOMS.API

{

public class DbManager

{

SqlConnection objCon;

SqlCommand objCmd;

SqlDataAdapter objAd;

DataSet objDS;

private void Connection()

{

objCon = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ConnectionString);

if (objCon.State == ConnectionState.Closed)

objCon.Open();

}

public int ExecuteNonQuery(string objStr, SqlParameter[] parameter)

{

try

{

Connection();

objCmd = new SqlCommand();

objCmd.Connection = objCon;

objCmd.CommandText = objStr;

objCmd.CommandType = CommandType.StoredProcedure;

objCmd.Parameters.AddRange(parameter);

int result = objCmd.ExecuteNonQuery();

objCon.Close();

return result;

}

catch (Exception ex)

{

throw;

}

}

public object ExecuteScalar(string objStr, SqlParameter[] parameter)

{

try

{

objCmd = new SqlCommand();

objCmd.Connection = objCon;

objCmd.CommandText = objStr;

objCmd.CommandType = CommandType.StoredProcedure;

Connection();

objCmd.Parameters.AddRange(parameter);

object result = objCmd.ExecuteScalar();

objCon.Close();

return result;

}

catch (Exception ex)

{

throw;

}

}

public DataSet ExecuteDataSet(string objStr, SqlParameter[] parameter)

{

try

{

objCmd = new SqlCommand();

objDS = new DataSet();

Connection();

objCmd.CommandText = objStr;

objCmd.CommandType = CommandType.StoredProcedure;

objCmd.Connection = objCon;

objCmd.Parameters.AddRange(parameter);

objAd = new SqlDataAdapter();

objAd.SelectCommand = objCmd;

objAd.Fill(objDS);

return objDS;

}

catch (Exception ex)

{

throw;

}

}

}

}

5) ASPX Form:

Ø Form Design:

Ø Source Code: (frmBatches.aspx)

<%@ Page Language="C#" AutoEventWireup="true" Codebehind="frmBatches.aspx.cs" Inherits="VBOMS.frmBatches"

MasterPageFile="VBOMS.Master" %>

<asp:Content ID="Content1" runat="server" ContentPlaceHolderID="vbContentPlaceHolder">

<table align="center">

<tr align="center">

<td align="right">

BatchNotd>

<td>

:td>

<td>

<asp:TextBox ID="txtBatchNo" runat="server">asp:TextBox>

td>

tr>

<tr align="center">

<td align="right">

FromTimingtd>

<td>

:td>

<td>

<asp:TextBox ID="txtFromTiming" runat="server">asp:TextBox>

td>

tr>

<tr align="center">

<td align="right">

ToTimingtd>

<td >

:td>

<td>

<asp:TextBox ID="txtToTiming" runat="server">asp:TextBox>

td>

tr>

<tr>

<td colspan="3" align="center">

<asp:HiddenField ID="hdnBatchesId" runat="server" />

td>

tr>

<tr align="center">

<td align="center" colspan="3">

<asp:Button ID="btnSave" runat="server" CssClass="buttonStyle" Text="Save" OnClick="btnSave_Click" />

<asp:Button ID="btnCancel" runat="server" Text="Cancel" CssClass="buttonStyle" OnClick="btnCancel_Click" CausesValidation="False" />

td>

tr>

<tr>

<td align="center" colspan="3">

<asp:Label ID="lblmessage" runat="server" Text="lblMessage" BackColor="White">asp:Label>td>

tr>

<tr>

<td align="center" colspan="3">

<table align="center" border="0" cellpadding="2" cellspacing="0">

<tr>

<td>

<asp:GridView ID="gvBatches" runat="server" AutoGenerateColumns="false"

OnRowDeleting="gvBatches_RowDeleting" OnRowEditing="gvBatches_RowEditing" >

<Columns>

<asp:BoundField DataField="BatchNo" HeaderText="BatchNo" />

<asp:BoundField DataField="FromTiming" HeaderText="FromTiming" />

<asp:BoundField DataField="ToTiming" HeaderText="ToTiming" />

<asp:BoundField DataField="BatchId" HeaderText="BatchId" ItemStyle-CssClass="hidecolumn"

HeaderStyle-CssClass="hidecolumn" />

<asp:ButtonField ButtonType="Link" HeaderText="Edit" Text="Edit" CommandName="edit" />

<asp:ButtonField ButtonType="Link" Text="Delete" CommandName="Delete" />

Columns>

asp:GridView>

td>

tr>

table>

td>

tr>

table>

asp:Content>

Ø frmBatches.Aspx.Cs

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using VBOMS.API;

namespace VBOMS

{

public partial class frmBatches : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

FillBatches();

}

}

protected void btnSave_Click(object sender, EventArgs e)

{

Batches objBatch = new Batches();

objBatch.BatchNo = txtBatchNo.Text;

objBatch.FromTiming = txtFromTiming.Text;

objBatch.ToTiming = txtToTiming.Text;

objBatch.EnterDate = DateTime.UtcNow.AddHours(5.5);

objBatch.UpdateDate = DateTime.UtcNow.AddHours(5.5);

objBatch.IsActive = true;

bool result = false;

objBatch.BatchID = onvert.ToInt32(Request.QueryString["BatchId"]);

if (hdnBatchesId.Value=="")

{

result = objBatch.Save();

}

else

{

objBatch.BatchID = Convert.ToInt32(hdnBatchesId.Value);

result = objBatch.Update();

}

if (result)

{

lblmessage.Text = "Updated Successfully";

ClearControlsData();

FillBatches();

}

else

{

lblmessage.Text = "Already Exist";

}

}

public void FillBatches()

{

Batches objBatch = new Batches();

DataSet objDS = new DataSet();

objDS = objBatch.Fecth();

if (objDS.Tables[0].Rows.Count > 0)

{

gvBatches.DataSource = objDS;

gvBatches.DataBind();

}

}

private void ClearControlsData()

{

txtBatchNo.Text = "";

txtFromTiming.Text = "";

txtToTiming.Text = "";

}

protected void gvBatches_RowEditing(object sender, GridViewEditEventArgs e)

{

txtBatchNo.Text = gvBatches.Rows[e.NewEditIndex].Cells[0].Text;

txtFromTiming.Text = gvBatches.Rows[e.NewEditIndex].Cells[1].Text;

txtToTiming.Text = gvBatches.Rows[e.NewEditIndex].Cells[2].Text;

hdnBatchesId.Value = gvBatches.Rows[e.NewEditIndex].Cells[3].Text;

}

protected void btnCancel_Click(object sender, EventArgs e)

{

ClearControlsData();

}

protected void gvBatches_RowDeleting(object sender, GridViewDeleteEventArgs e)

{

Batches objbatch = new Batches();

objbatch.BatchID = Convert.ToInt32(gvBatches.Rows[e.RowIndex].Cells[3].Text);

if (objbatch.Delete())

{

lblmessage.Text = "Status Changed Succuessfully";

FillBatches();

}

}

}

}

6) Web Config:

configSections>

<connectionStrings>

<add name="conStr" connectionString="data source=VIJAY\DATASERVER;user id=sa;pwd=vb_123;database=VBOMS"/>

<add name="VBOMSConnectionString1" connectionString="Data Source=VIJAY\DATASERVER;Initial Catalog=VBOMS;User ID=sa;Password=vb_123" providerName="System.Data.SqlClient"/>

connectionStrings>

How to Fill Data in DropDownList:

public void FillOccupation()

{

OccupationDetails objOd = new OccupationDetails();

DataSet ds = new DataSet();

ds = objOd.Fetch();

if (ds.Tables[0].Rows.Count > 0)

{

ddlOccupation.DataValueField = "OccupationId";

ddlOccupation.DataTextField = "OccupationName";

ddlOccupation.DataSource = ds;

ddlOccupation.DataBind();

ddlOccupation.Items.Insert(0, "Select");

}

}

How to Fill Data in GridView:

public void FillOccupation()

{

OccupationDetails objOc = new OccupationDetails();

DataSet objDs = new DataSet();

objDs = objOc.Fetch();

if (objDs.Tables[0].Rows.Count > 0)

{

gvOccupation.DataSource = objDs;

}

else

{

gvOccupation.DataSource = null;

}

gvOccupation.DataBind();

}

Row Editing and Deleting:

protected void gvOccupation_RowEditing(object sender,GridViewEditEventArgs e)

{

txtOccupation.Text = gvOccupation.Rows[e.NewEditIndex].Cells[0].Text;

hdnOccupationId.Value = gvOccupation.Rows[e.NewEditIndex].Cells[1].Text;

}

protected void gvOccupation_RowDeleting(object sender, GridViewDeleteEventArgs e)

{

OccupationDetails objOc = new OccupationDetails();

objOc.OccupationId = Convert.ToInt32(gvOccupation.Rows[e.RowIndex].Cells[01].Text);

if (objOc.Delete())

{

lblMessage.Text = "Status Changed Successfully";

FillOccupation();

}

}

FrmRegistration.aspx:

Under Save Button:

protected void btnSave_Click(object sender, EventArgs e)

{

Registration objReg = new Registration();

objReg.FirstName = txtFirstName.Text;

objReg.LastName = txtLastName.Text;

objReg.DOB = Convert.ToDateTime(txtDOB.Text);

objReg.Gender = rblGender.Text;

objReg.PhoneNo = txtPhoneNo.Text;

objReg.EmailId = txtEmailId.Text;

objReg.OccupationId = Convert.ToInt32(ddlOccupation.SelectedItem.Value);

objReg.TechnologyId = Convert.ToInt32(ddlTechnology.SelectedValue);

objReg.ReferenceID = Convert.ToInt32(ddlReference.SelectedValue);

objReg.IsOnline = rblIsOnline.SelectedValue;

if (objReg.save())

{

Address objAdd = new Address();

objAdd.TraineeID = objReg.TraineeId;

objAdd.CurrentLocation = txtCurrentLocation.Text;

objAdd.Country = ddlCountry.SelectedItem.Text;

objAdd.PinCode = Convert.ToInt32(txtPinCode.Text);

objAdd.EnteredDate = DateTime.UtcNow.AddHours(5.5);

objAdd.UpdatedDate = DateTime.UtcNow.AddHours(5.5);

if (objAdd.Save())

{

bool isEduSaved = false;

EducationDetails objEdu = new EducationDetails();

objEdu.TraineeID = Convert.ToInt16(objAdd.TraineeID);

objEdu.EnterDate = DateTime.UtcNow.AddHours(5.5);

objEdu.UpdateDate = DateTime.UtcNow.AddHours(5.5);

foreach (GridViewRow row in gvEducationType.Rows)

{

objEdu.EducationTypeId = row.Cells[0].Text == " " ? Convert.ToInt16(0) : Convert.ToInt16(row.Cells[0].Text);

TextBox txtCour = (TextBox)row.FindControl("txtCourse");

objEdu.Course = txtCour.Text;

TextBox txtUniName = (TextBox)row.FindControl("txtUniversity");

objEdu.University = txtUniName.Text;

TextBox txtYearPass = (TextBox)row.FindControl("txtYearOfPassing");

objEdu.YearOfPassing = Convert.ToDateTime(txtYearPass.Text);

TextBox txtAggrigate = (TextBox)row.FindControl("txtAggregate");

objEdu.Aggregate = float.Parse(txtAggrigate.Text);

isEduSaved = objEdu.Save();

}

if (isEduSaved)

{

Certification objCer = new Certification();

objCer.Technology = txtTechnology.Text;

objCer.CoursePeriod = Convert.ToDateTime(txtCoursePeriod.Text);

objCer.EnteredDate = DateTime.UtcNow.AddHours(5.5);

objCer.UpdatedDate = DateTime.UtcNow.AddHours(5.5);

if (objCer.Save())

{

string strBody = "WelCome To ViswgnaBharathi" +

" Welcome to Viswgna Bharathi, Your Userid : " + txtEmailId.Text + " Password : " + txtPassword.Text + "";

if (Utility.SendMail(txtEmailId.Text, "vkouru@viswgnabharathi.com", "Your Registration is Successful", strBody))

{

lblMessage.Text = "Message Send Successfully";

}

else

{

lblMessage.Text = "Message Sending Failed";

}

}

else

{

lblMessage.Text = "Already Existed";

}

}

else

{

lblMessage.Text = "Please check your details once again";

}

}

}

}

frmLogin.aspx:

Under Login Button:

protected void btnLoging_Click(object sender, EventArgs e)

{

UserLogin objlogin = new UserLogin();

objlogin.UserName = txtUsername.Text;

objlogin.Password = txtPassword.Text;

if (objlogin.CheckLoginDetails())

{

lblmessage.Text = "Login SuccessFully";

}

else

{

lblmessage.Text = "Invalid User";

}

}

CheckLoginDetails()

public bool CheckLoginDetails()

{

SqlParameter[] objSqlParams = new SqlParameter[]

{

new SqlParameter("@Type","CL"),

new SqlParameter("@UserName",this.UserName),

new SqlParameter("@PassWord",this.Password)

};

DataSet objDs = ExecuteDataSet("USP_IDFU_UserLogin", objSqlParams);

if (objDs.Tables[0].Rows.Count > 0)

{

return true;

}

else

return false;

//return (objDs.Tables[0].Rows.Count > 0);

}

StorePrcedure:

ALTER procedure [dbo].[USP_IDFU_UserLogin]

(@Type char(1)=null,

@UserId bigint=null,

@UserName varchar(50)=null,

@PassWord varchar(30)=null,

@EnterDate datetime=null,

@UpdatedDate datetime=null,

@IsActive bit=null)

as

if(@Type='I')begin

insert into UserLogin(UserName,PassWord,EnterDate,UpdatedDate,IsActive)

values(@UserName,@PassWord,@EnterDate,@UpdatedDate,@IsActive)

end

if(@Type='D')begin

delete from UserLogin where UserId=@UserId

end

if(@Type='F')begin

select *from UserLogin where UserName=@UserName and PassWord=@PassWord

end

if(@Type='U')begin

update UserLogin set UserName=@UserName,PassWord=@PassWord,EnterDate=@EnterDate,

UpdatedDate=@UpdatedDate,IsActive=@IsActive where UserId=@UserId

end

if(@type='CL')begin

select * from UserLogin where UserName=@UserName and PassWord=@PassWord

end

Dot Net Project Code

1) Table Creation

CREATE TABLE [dbo].[Batches](

[BatchId] [bigint] IDENTITY(1,1) NOT NULL,

[BatchNo] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[FromTiming] [datetime] NULL,

[ToTiming] [datetime] NULL,

[EnteredBy] [bigint] NULL,

[EnteredDate] [datetime] NULL,

[UpdatedBy] [bigint] NULL,

[UpdateDate] [datetime] NULL,

[IsActive] [bit] NULL,

CONSTRAINT [PK_Batches] PRIMARY KEY CLUSTERED

(

2) Stored Procedure:

create procedure [dbo].[USP_IDFU_Baches]

(@Type char(1)=null,

@Batchid bigint=null,

@BatchNo varchar(20)=null,

@FromTiming datetime=null,

@ToTiming datetime=null,

@EnteredBy bigint=null,

@EnteredDate datetime=null,

@UpdatedBy bigint=null,

@UpdateDate datetime=null,

@IsActive bit=null)

as

if(@type='I')begin

insert into Batches(BatchNo,FromTiming,ToTiming,EnteredBy,EnteredDate,UpdatedBy,

UpdateDate,IsActive)

values(@BatchNo,@FromTiming,@ToTiming,@EnteredBy,@EnteredDate,@UpdatedBy,

@UpdateDate,1)

end

if(@type='D')

begin

declare @sts bit

select @sts=isactive from Batches where batchid=@batchid

if(@sts=1) begin

update Batches set isactive=0 where batchid=@batchid

end

else begin

update Batches set isactive=1 where batchid=@batchid

end

end

if(@type='F')begin

select *from Batches where IsActive =1

end

if(@type='U')begin

update Batches set BatchNo=@BatchNo,FromTiming=@FromTiming,ToTiming=@ToTiming,

EnteredBy=@EnteredBy,EnteredDate=@EnteredDate,UpdatedBy=@UpdatedBy,

UpdateDate=@UpdateDate,IsActive=@IsActive where batchid=@batchid

end

if(@type='SF')begin

select * from TranieeBatches s where s.batchid=@batchid

end

3) Class file Creation:

using System;

using System.Collections.Generic;

using System.Text;

using System.Data;

using System.Configuration;

using System.Data.SqlClient;

namespace VBOMS.API

{

public class Batches:DbManager

{

# region veriables

private Int64 _BatchID;

private string _BatchNo;

private string _FromTiming;

private string _ToTiming;

private Int64 _EnteredBy;

private DateTime _EnterDate;

private Int64 _UpdatedBy;

private DateTime _UpdateDate;

private bool _IsActive;

#endregion

#region properties

public Int64 BatchID

{

get { return _BatchID; }

set { _BatchID = value; }

}

public string BatchNo

{

get { return _BatchNo; }

set { _BatchNo = value; }

}

public string FromTiming

{

get { return _FromTiming; }

set { _FromTiming = value; }

}

public string ToTiming

{

get { return _ToTiming; }

set { _ToTiming = value; }

}

public Int64 EnteredBy

{

get { return _EnteredBy; }

set { _EnteredBy = value; }

}

public DateTime EnterDate

{

get { return _EnterDate; }

set { _EnterDate = value; }

}

public Int64 UpdatedBy

{

get { return _UpdatedBy; }

set { _UpdatedBy = value; }

}

public DateTime UpdateDate

{

get { return _UpdateDate; }

set { _UpdateDate = value; }

}

public bool IsActive

{

get { return _IsActive; }

set { _IsActive = value; }

}

#endregion

#region functions

public bool Save()

{

try

{

SqlParameter[] parameter = new SqlParameter[]

{

new SqlParameter("@type","I"),

new SqlParameter("@BatchID",this.BatchID),

new SqlParameter("@BatchNo",this.BatchNo),

new SqlParameter("@FromTiming",this.FromTiming),

new SqlParameter("@ToTiming",this.ToTiming),

new SqlParameter("@EnteredBy",this.EnteredBy),

new SqlParameter("@EnteredDate",this.EnterDate),

new SqlParameter("@UpdatedBy",this.UpdatedBy),

new SqlParameter("@UpDateDate",this.UpdateDate),

new SqlParameter("@IsActive",this.IsActive)

};

int result = ExecuteNonQuery("USP_IDFU_Baches", parameter);

if (result > 0)

{

return true;

}

else

{

return false;

}

}

catch (Exception ex)

{

return false;

}

}

public bool Update()

{

try

{

SqlParameter[] parameter = new SqlParameter[]

{

new SqlParameter("@type","U"),

new SqlParameter("@BatchID",this.BatchID),

new SqlParameter("@BatchNo",this.BatchNo),

new SqlParameter ("@FromTiming",this.FromTiming),

new SqlParameter("@ToTiming",this.ToTiming),

new SqlParameter("@EnteredBy",this.EnteredBy),

new SqlParameter("@EnteredDate",this.EnterDate),

new SqlParameter("@UpdatedBy",this.UpdatedBy),

new SqlParameter("@UpDateDate",this.UpdateDate),

new SqlParameter("@IsActive",this.IsActive)

};

int result = ExecuteNonQuery("USP_IDFU_Baches", parameter);

if (result > 0)

{

return true;

}

else

{

return false;

}

}

catch (Exception ex)

{

return false;

}

}

public bool Delete()

{

try

{

SqlParameter[] parameter = new SqlParameter[]

{

new SqlParameter("@type","D"),

new SqlParameter("@BatchID",this.BatchID),

new SqlParameter("@IsActive",this.IsActive)

};

int result = ExecuteNonQuery("USP_IDFU_Baches", parameter);

if (result > 0)

{

return true;

}

else

{

return false;

}

}

catch (Exception ex)

{

return false;

}

}

public DataSet Fecth()

{

try

{

DbManager objDb = new DbManager();

SqlParameter[] parameter = new SqlParameter[]

{

new SqlParameter("@type","F"),

//new SqlParameter("@BatchID",this.BatchID),

//new SqlParameter("@BatchNo",this.BatchNo),

//new SqlParameter ("@FromTimings",this.FromTiming),

//new SqlParameter("@ToTiming",this.ToTiming),

//new SqlParameter("@EnteredBy",this.EnteredBy),

//new SqlParameter("@EnterDate",this.EnterDate),

//new SqlParameter("@UpdatedBy",this.UpdatedBy),

//new SqlParameter("@UpDateDate",this.UpdateDate),

//new SqlParameter("@IsActive",this.IsActive)

};

DataSet ds=objDb.ExecuteDataSet("USP_IDFU_Baches", parameter);

return ds;

}

catch (Exception ex)

{

throw;

}

}

public DataSet SelectFecth()

{

try

{

DbManager objDb = new DbManager();

SqlParameter[] parameter = new SqlParameter[]

{

new SqlParameter("@type","SF"),

//new SqlParameter("@BatchID",this.BatchID),

//new SqlParameter("@BatchNo",this.BatchNo),

//new SqlParameter ("@FromTimings",this.FromTiming),

//new SqlParameter("@ToTiming",this.ToTiming),

//new SqlParameter("@EnteredBy",this.EnteredBy),

//new SqlParameter("@EnterDate",this.EnterDate),

//new SqlParameter("@UpdatedBy",this.UpdatedBy),

//new SqlParameter("@UpDateDate",this.UpdateDate),

//new SqlParameter("@IsActive",this.IsActive)

};

DataSet ds = objDb.ExecuteDataSet("USP_IDFU_Baches", parameter);

return ds;

}

catch (Exception ex)

{

throw;

}

}

#endregion

}

}

4) DB Manager:

using System;

using System.Collections.Generic;

using System.Text;

using System.Data;

using System.Data.SqlClient;

using System.Configuration;

namespace VBOMS.API

{

public class DbManager

{

SqlConnection objCon;

SqlCommand objCmd;

SqlDataAdapter objAd;

DataSet objDS;

private void Connection()

{

objCon = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ConnectionString);

if (objCon.State == ConnectionState.Closed)

objCon.Open();

}

public int ExecuteNonQuery(string objStr, SqlParameter[] parameter)

{

try

{

Connection();

objCmd = new SqlCommand();

objCmd.Connection = objCon;

objCmd.CommandText = objStr;

objCmd.CommandType = CommandType.StoredProcedure;

objCmd.Parameters.AddRange(parameter);

int result = objCmd.ExecuteNonQuery();

objCon.Close();

return result;

}

catch (Exception ex)

{

throw;

}

}

public object ExecuteScalar(string objStr, SqlParameter[] parameter)

{

try

{

objCmd = new SqlCommand();

objCmd.Connection = objCon;

objCmd.CommandText = objStr;

objCmd.CommandType = CommandType.StoredProcedure;

Connection();

objCmd.Parameters.AddRange(parameter);

object result = objCmd.ExecuteScalar();

objCon.Close();

return result;

}

catch (Exception ex)

{

throw;

}

}

public DataSet ExecuteDataSet(string objStr, SqlParameter[] parameter)

{

try

{

objCmd = new SqlCommand();

objDS = new DataSet();

Connection();

objCmd.CommandText = objStr;

objCmd.CommandType = CommandType.StoredProcedure;

objCmd.Connection = objCon;

objCmd.Parameters.AddRange(parameter);

objAd = new SqlDataAdapter();

objAd.SelectCommand = objCmd;

objAd.Fill(objDS);

return objDS;

}

catch (Exception ex)

{

throw;

}

}

}

}

5) ASPX Form:

Ø Form Design:

Ø Source Code: (frmBatches.aspx)

<%@ Page Language="C#" AutoEventWireup="true" Codebehind="frmBatches.aspx.cs" Inherits="VBOMS.frmBatches"

MasterPageFile="VBOMS.Master" %>

<asp:Content ID="Content1" runat="server" ContentPlaceHolderID="vbContentPlaceHolder">

<table align="center">

<tr align="center">

<td align="right">

BatchNotd>

<td>

:td>

<td>

<asp:TextBox ID="txtBatchNo" runat="server">asp:TextBox>

td>

tr>

<tr align="center">

<td align="right">

FromTimingtd>

<td>

:td>

<td>

<asp:TextBox ID="txtFromTiming" runat="server">asp:TextBox>

td>

tr>

<tr align="center">

<td align="right">

ToTimingtd>

<td >

:td>

<td>

<asp:TextBox ID="txtToTiming" runat="server">asp:TextBox>

td>

tr>

<tr>

<td colspan="3" align="center">

<asp:HiddenField ID="hdnBatchesId" runat="server" />

td>

tr>

<tr align="center">

<td align="center" colspan="3">

<asp:Button ID="btnSave" runat="server" CssClass="buttonStyle" Text="Save" OnClick="btnSave_Click" />

<asp:Button ID="btnCancel" runat="server" Text="Cancel" CssClass="buttonStyle" OnClick="btnCancel_Click" CausesValidation="False" />

td>

tr>

<tr>

<td align="center" colspan="3">

<asp:Label ID="lblmessage" runat="server" Text="lblMessage" BackColor="White">asp:Label>td>

tr>

<tr>

<td align="center" colspan="3">

<table align="center" border="0" cellpadding="2" cellspacing="0">

<tr>

<td>

<asp:GridView ID="gvBatches" runat="server" AutoGenerateColumns="false"

OnRowDeleting="gvBatches_RowDeleting" OnRowEditing="gvBatches_RowEditing" >

<Columns>

<asp:BoundField DataField="BatchNo" HeaderText="BatchNo" />

<asp:BoundField DataField="FromTiming" HeaderText="FromTiming" />

<asp:BoundField DataField="ToTiming" HeaderText="ToTiming" />

<asp:BoundField DataField="BatchId" HeaderText="BatchId" ItemStyle-CssClass="hidecolumn"

HeaderStyle-CssClass="hidecolumn" />

<asp:ButtonField ButtonType="Link" HeaderText="Edit" Text="Edit" CommandName="edit" />

<asp:ButtonField ButtonType="Link" Text="Delete" CommandName="Delete" />

Columns>

asp:GridView>

td>

tr>

table>

td>

tr>

table>

asp:Content>

Ø frmBatches.Aspx.Cs

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using VBOMS.API;

namespace VBOMS

{

public partial class frmBatches : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

FillBatches();

}

}

protected void btnSave_Click(object sender, EventArgs e)

{

Batches objBatch = new Batches();

objBatch.BatchNo = txtBatchNo.Text;

objBatch.FromTiming = txtFromTiming.Text;

objBatch.ToTiming = txtToTiming.Text;

objBatch.EnterDate = DateTime.UtcNow.AddHours(5.5);

objBatch.UpdateDate = DateTime.UtcNow.AddHours(5.5);

objBatch.IsActive = true;

bool result = false;

objBatch.BatchID = onvert.ToInt32(Request.QueryString["BatchId"]);

if (hdnBatchesId.Value=="")

{

result = objBatch.Save();

}

else

{

objBatch.BatchID = Convert.ToInt32(hdnBatchesId.Value);

result = objBatch.Update();

}

if (result)

{

lblmessage.Text = "Updated Successfully";

ClearControlsData();

FillBatches();

}

else

{

lblmessage.Text = "Already Exist";

}

}

public void FillBatches()

{

Batches objBatch = new Batches();

DataSet objDS = new DataSet();

objDS = objBatch.Fecth();

if (objDS.Tables[0].Rows.Count > 0)

{

gvBatches.DataSource = objDS;

gvBatches.DataBind();

}

}

private void ClearControlsData()

{

txtBatchNo.Text = "";

txtFromTiming.Text = "";

txtToTiming.Text = "";

}

protected void gvBatches_RowEditing(object sender, GridViewEditEventArgs e)

{

txtBatchNo.Text = gvBatches.Rows[e.NewEditIndex].Cells[0].Text;

txtFromTiming.Text = gvBatches.Rows[e.NewEditIndex].Cells[1].Text;

txtToTiming.Text = gvBatches.Rows[e.NewEditIndex].Cells[2].Text;

hdnBatchesId.Value = gvBatches.Rows[e.NewEditIndex].Cells[3].Text;

}

protected void btnCancel_Click(object sender, EventArgs e)

{

ClearControlsData();

}

protected void gvBatches_RowDeleting(object sender, GridViewDeleteEventArgs e)

{

Batches objbatch = new Batches();

objbatch.BatchID = Convert.ToInt32(gvBatches.Rows[e.RowIndex].Cells[3].Text);

if (objbatch.Delete())

{

lblmessage.Text = "Status Changed Succuessfully";

FillBatches();

}

}

}

}

6) Web Config:

configSections>

<connectionStrings>

<add name="conStr" connectionString="data source=VIJAY\DATASERVER;user id=sa;pwd=vb_123;database=VBOMS"/>

<add name="VBOMSConnectionString1" connectionString="Data Source=VIJAY\DATASERVER;Initial Catalog=VBOMS;User ID=sa;Password=vb_123" providerName="System.Data.SqlClient"/>

connectionStrings>

How to Fill Data in DropDownList:

public void FillOccupation()

{

OccupationDetails objOd = new OccupationDetails();

DataSet ds = new DataSet();

ds = objOd.Fetch();

if (ds.Tables[0].Rows.Count > 0)

{

ddlOccupation.DataValueField = "OccupationId";

ddlOccupation.DataTextField = "OccupationName";

ddlOccupation.DataSource = ds;

ddlOccupation.DataBind();

ddlOccupation.Items.Insert(0, "Select");

}

}

How to Fill Data in GridView:

public void FillOccupation()

{

OccupationDetails objOc = new OccupationDetails();

DataSet objDs = new DataSet();

objDs = objOc.Fetch();

if (objDs.Tables[0].Rows.Count > 0)

{

gvOccupation.DataSource = objDs;

}

else

{

gvOccupation.DataSource = null;

}

gvOccupation.DataBind();

}

Row Editing and Deleting:

protected void gvOccupation_RowEditing(object sender,GridViewEditEventArgs e)

{

txtOccupation.Text = gvOccupation.Rows[e.NewEditIndex].Cells[0].Text;

hdnOccupationId.Value = gvOccupation.Rows[e.NewEditIndex].Cells[1].Text;

}

protected void gvOccupation_RowDeleting(object sender, GridViewDeleteEventArgs e)

{

OccupationDetails objOc = new OccupationDetails();

objOc.OccupationId = Convert.ToInt32(gvOccupation.Rows[e.RowIndex].Cells[01].Text);

if (objOc.Delete())

{

lblMessage.Text = "Status Changed Successfully";

FillOccupation();

}

}

FrmRegistration.aspx:

Under Save Button:

protected void btnSave_Click(object sender, EventArgs e)

{

Registration objReg = new Registration();

objReg.FirstName = txtFirstName.Text;

objReg.LastName = txtLastName.Text;

objReg.DOB = Convert.ToDateTime(txtDOB.Text);

objReg.Gender = rblGender.Text;

objReg.PhoneNo = txtPhoneNo.Text;

objReg.EmailId = txtEmailId.Text;

objReg.OccupationId = Convert.ToInt32(ddlOccupation.SelectedItem.Value);

objReg.TechnologyId = Convert.ToInt32(ddlTechnology.SelectedValue);

objReg.ReferenceID = Convert.ToInt32(ddlReference.SelectedValue);

objReg.IsOnline = rblIsOnline.SelectedValue;

if (objReg.save())

{

Address objAdd = new Address();

objAdd.TraineeID = objReg.TraineeId;

objAdd.CurrentLocation = txtCurrentLocation.Text;

objAdd.Country = ddlCountry.SelectedItem.Text;

objAdd.PinCode = Convert.ToInt32(txtPinCode.Text);

objAdd.EnteredDate = DateTime.UtcNow.AddHours(5.5);

objAdd.UpdatedDate = DateTime.UtcNow.AddHours(5.5);

if (objAdd.Save())

{

bool isEduSaved = false;

EducationDetails objEdu = new EducationDetails();

objEdu.TraineeID = Convert.ToInt16(objAdd.TraineeID);

objEdu.EnterDate = DateTime.UtcNow.AddHours(5.5);

objEdu.UpdateDate = DateTime.UtcNow.AddHours(5.5);

foreach (GridViewRow row in gvEducationType.Rows)

{

objEdu.EducationTypeId = row.Cells[0].Text == " " ? Convert.ToInt16(0) : Convert.ToInt16(row.Cells[0].Text);

TextBox txtCour = (TextBox)row.FindControl("txtCourse");

objEdu.Course = txtCour.Text;

TextBox txtUniName = (TextBox)row.FindControl("txtUniversity");

objEdu.University = txtUniName.Text;

TextBox txtYearPass = (TextBox)row.FindControl("txtYearOfPassing");

objEdu.YearOfPassing = Convert.ToDateTime(txtYearPass.Text);

TextBox txtAggrigate = (TextBox)row.FindControl("txtAggregate");

objEdu.Aggregate = float.Parse(txtAggrigate.Text);

isEduSaved = objEdu.Save();

}

if (isEduSaved)

{

Certification objCer = new Certification();

objCer.Technology = txtTechnology.Text;

objCer.CoursePeriod = Convert.ToDateTime(txtCoursePeriod.Text);

objCer.EnteredDate = DateTime.UtcNow.AddHours(5.5);

objCer.UpdatedDate = DateTime.UtcNow.AddHours(5.5);

if (objCer.Save())

{

string strBody = "WelCome To ViswgnaBharathi" +

" Welcome to Viswgna Bharathi, Your Userid : " + txtEmailId.Text + " Password : " + txtPassword.Text + "";

if (Utility.SendMail(txtEmailId.Text, "vkouru@viswgnabharathi.com", "Your Registration is Successful", strBody))

{

lblMessage.Text = "Message Send Successfully";

}

else

{

lblMessage.Text = "Message Sending Failed";

}

}

else

{

lblMessage.Text = "Already Existed";

}

}

else

{

lblMessage.Text = "Please check your details once again";

}

}

}

}

frmLogin.aspx:

Under Login Button:

protected void btnLoging_Click(object sender, EventArgs e)

{

UserLogin objlogin = new UserLogin();

objlogin.UserName = txtUsername.Text;

objlogin.Password = txtPassword.Text;

if (objlogin.CheckLoginDetails())

{

lblmessage.Text = "Login SuccessFully";

}

else

{

lblmessage.Text = "Invalid User";

}

}

CheckLoginDetails()

public bool CheckLoginDetails()

{

SqlParameter[] objSqlParams = new SqlParameter[]

{

new SqlParameter("@Type","CL"),

new SqlParameter("@UserName",this.UserName),

new SqlParameter("@PassWord",this.Password)

};

DataSet objDs = ExecuteDataSet("USP_IDFU_UserLogin", objSqlParams);

if (objDs.Tables[0].Rows.Count > 0)

{

return true;

}

else

return false;

//return (objDs.Tables[0].Rows.Count > 0);

}

StorePrcedure:

ALTER procedure [dbo].[USP_IDFU_UserLogin]

(@Type char(1)=null,

@UserId bigint=null,

@UserName varchar(50)=null,

@PassWord varchar(30)=null,

@EnterDate datetime=null,

@UpdatedDate datetime=null,

@IsActive bit=null)

as

if(@Type='I')begin

insert into UserLogin(UserName,PassWord,EnterDate,UpdatedDate,IsActive)

values(@UserName,@PassWord,@EnterDate,@UpdatedDate,@IsActive)

end

if(@Type='D')begin

delete from UserLogin where UserId=@UserId

end

if(@Type='F')begin

select *from UserLogin where UserName=@UserName and PassWord=@PassWord

end

if(@Type='U')begin

update UserLogin set UserName=@UserName,PassWord=@PassWord,EnterDate=@EnterDate,

UpdatedDate=@UpdatedDate,IsActive=@IsActive where UserId=@UserId

end

if(@type='CL')begin

select * from UserLogin where UserName=@UserName and PassWord=@PassWord

end

Labels:

Comments

Post a Comment

Popular posts from this blog

Drawing Line Charts In asp.net

LineChart.cs import the following namespaces using System.Drawing; using System.Drawing.Drawing2D; using System.Drawing.Imaging; using System.Collections; public class LineChart { public Bitmap Bitmapb; public string strTitle = "Default Title"; public ArrayList ArrayListchartValues = new ArrayList(); public float ftXorigin = 0, ftYorigin = 0; public float ftScaleX, ftScaleY; public float ftXdivs = 2, ftYdivs = 2; private int intWidth, intHeight; private Graphics Graphicsg; private Page Pagep; struct datapoint { public float ftx; public float fty; public bool bolvalid; } //initialize public LineChart(int intmyWidth, int intmyHeight, Page myPage) { intWidth = intmyWidth; intHeight = intmyHeight; ftScaleX = intmyWidth; ftScaleY = intmyHeight; Bitmapb = new Bitmap(intmyWidth, intmyHeight); Graphicsg = Graphics.FromImage(Bitmapb); Pagep = myPage; } pu
Post a Comment
Read more

AJAX

ASP.NET AJAX From Wikipedia, the free encyclopedia Jump to: navigation, search ASP.NET AJAX is a set of extensions to ASP.NET developed by Microsoft for implementing Ajax functionality. It is released under the Microsoft Public License. Contents [hide] • 1 Road Map • 2 Browser support • 3 ASP.NET AJAX Suite • 4 Microsoft Ajax Library • 5 The UpdatePanel Control • 6 Script Controls and Extenders • 7 Web-services and JSON • 8 See also • 9 References • 10 External links [edit] Road Map In its early development stages, ASP.NET AJAX was given the code name Atlas. Initial releases were made public to the development community in the form of CTPs (Community Technical Previews). The production version, ASP.NET AJAX 1.0 RTM; was released on January 23, 2007[1][2] as an extension to ASP.NET 2.0. Important release milestones for ASP.NET AJAX are as follows: • CTPs - October, December 2005, January, March, April, June, July 2006 • Beta - October, November 2006 • Release Candidate (RC) - December 2
Post a Comment
Read more