public int UpdateEmployeeInfo(EmployeeInfoEntity oEmployeeInfoEntity)
{
con = oConnectionDatabase.DatabaseConnection();
int i = 0;
cmd = new SqlCommand("UPDATE tblEmployeeInfo SET EmployeeID='" + oEmployeeInfoEntity.EmployeeID + "',EmployeeName='" + oEmployeeInfoEntity.EmployeeName + "',Designation='" + oEmployeeInfoEntity.Designation + "',RegistrationNo='" + oEmployeeInfoEntity.RegistrationNo + "', BranchCode ='" + oEmployeeInfoEntity.BranchCode + "', MobileNo ='" + oEmployeeInfoEntity.MobileNo + "', LastModifiedBy ='" + oEmployeeInfoEntity.LastModifiedBy + "' WHERE ID=" + oEmployeeInfoEntity.ID, con);
try
{
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
i = 1;
}
catch { }
con.Close();
return(i);
}
public int DeleteEmployeeInfo(EmployeeInfoEntity oEmployeeInfoEntity)
{
con = oConnectionDatabase.DatabaseConnection();
int i = 0;
cmd = new SqlCommand("DELETE FROM tblEmployeeInfo WHERE ID=" + oEmployeeInfoEntity.ID, con);
try
{
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
i = 1;
}
catch { }
con.Close();
return(i);
}
public int InsertEmployeeInfo(EmployeeInfoEntity oEmployeeInfoEntity)
{
con = oConnectionDatabase.DatabaseConnection();
int i = 0;
cmd = new SqlCommand("INSERT INTO tblEmployeeInfo (EmployeeID,EmployeeName,Designation,RegistrationNo,BranchCode,MobileNo,CreateBy,LastModifiedBy) VALUES('" + oEmployeeInfoEntity.EmployeeID + "','" + oEmployeeInfoEntity.EmployeeName + "','" + oEmployeeInfoEntity.Designation + "','" + oEmployeeInfoEntity.RegistrationNo + "','" + oEmployeeInfoEntity.BranchCode + "','" + oEmployeeInfoEntity.MobileNo + "','" + oEmployeeInfoEntity.CreateBy + "','" + oEmployeeInfoEntity.LastModifiedBy + "')", con);
try
{
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
i = 1;
}
catch { }
con.Close();
return(i);
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
TextBox txtGrEmployeeID = (TextBox)GridView1.Rows[e.RowIndex].FindControl("GrEmployeeID");
TextBox txtGrEmployeeName = (TextBox)GridView1.Rows[e.RowIndex].FindControl("GrEmployeeName");
TextBox txtGrDesignation = (TextBox)GridView1.Rows[e.RowIndex].FindControl("GrDesignation");
TextBox txtGrRegistrationNo = (TextBox)GridView1.Rows[e.RowIndex].FindControl("GrRegistrationNo");
TextBox txtGrBranchCode = (TextBox)GridView1.Rows[e.RowIndex].FindControl("GrBranchCode");
TextBox txtGrMobileNo = (TextBox)GridView1.Rows[e.RowIndex].FindControl("GrMobileNo");
//TextBox txtGrLastModifiedBy = DateTime.Now.ToString();
EmployeeInfoEntity oEmployeeInfoEntity = new EmployeeInfoEntity();
oEmployeeInfoEntity.EmployeeID = txtGrEmployeeID.Text;
oEmployeeInfoEntity.EmployeeName = txtGrEmployeeName.Text;
oEmployeeInfoEntity.Designation = txtGrDesignation.Text;
oEmployeeInfoEntity.RegistrationNo = txtGrRegistrationNo.Text;
oEmployeeInfoEntity.BranchCode = txtGrBranchCode.Text;
oEmployeeInfoEntity.MobileNo = txtGrMobileNo.Text;
oEmployeeInfoEntity.LastModifiedBy = DateTime.Now.ToShortDateString();
oEmployeeInfoEntity.ID = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value.ToString());
int i = oEmployeeInfoDAO.UpdateEmployeeInfo(oEmployeeInfoEntity);
string message = "";
GridView1.EditIndex = -1;
if (i == 1)
{
message = "Data Updated Successfully";
}
else
{
message = "Data Not Updated!";
}
gridViewBind();
ScriptManager.RegisterClientScriptBlock(Page, this.GetType(), "MessageBox", "alert('" + message + "')", true);
Clear();
}
protected void btnBSave_Click1(object sender, EventArgs e)
{
oEmployeeInfoEntity = new EmployeeInfoEntity();
oEmployeeInfoEntity.EmployeeID = txtEmployeeID.Text;
oEmployeeInfoEntity.EmployeeName = txtEmployeeName.Text;
oEmployeeInfoEntity.Designation = txtDesignation.Text;
oEmployeeInfoEntity.RegistrationNo = txtRegistrationNo.Text;
oEmployeeInfoEntity.BranchCode = txtBranchCode.SelectedItem.Value;
oEmployeeInfoEntity.MobileNo = txtMobileNo.Text;
oEmployeeInfoEntity.CreateBy = DateTime.Now.ToShortDateString();
oEmployeeInfoEntity.LastModifiedBy = DateTime.Now.ToShortDateString();
string condition = " where EmployeeID='" + oEmployeeInfoEntity.EmployeeID + "'";
DataTable dt = oEmployeeInfoDAO.GetEmployeeInfo(condition);
string message = "";
if (dt.Rows.Count == 0)
{
int i = oEmployeeInfoDAO.InsertEmployeeInfo(oEmployeeInfoEntity);
if (i == 1)
{
message = "Data Inserted Successfully";
Clear();
}
else
{
message = "Data Not Inserted";
}
}
else
{
message = "Data Alreay in DataBase";
}
ScriptManager.RegisterClientScriptBlock(Page, this.GetType(), "MessageBox", "alert('" + message + "')", true);
gridViewBind();
Clear();
}
