/// <summary>
/// This method saves the employee cdetails in the database.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void BtnSave_Click(object sender, EventArgs e)
{
IEmployee objEmployee = EmployeeBOFactory.CreateEmployeeObject();
IAdminBLL objBLL = AdminBLLFactory.CreateAdminBLLObject();
ILogin objLogin = LoginBOFactory.CreateLoginObject();
try
{
objEmployee.FirstName = txtFirstName.Text;
objEmployee.LastName = txtLastName.Text;
objEmployee.RoleId = Convert.ToInt32(ddlRole.SelectedValue);
objEmployee.Dob = Convert.ToDateTime(txtDOB.Text);
objEmployee.Doj = Convert.ToDateTime(txtDOJ.Text);
objEmployee.Address = (txtAddress.Text);
objEmployee.State = Convert.ToString(ddlState.SelectedItem);
objEmployee.City = Convert.ToString(ddlCity.SelectedItem);
objEmployee.MobileNumber = Convert.ToInt64(txtContact.Text);
bool IsAdded = objBLL.AddEmployeeDetails(objEmployee);
lblMessage.Text = "Employee details saved successfully. The Employee Id is : " + objEmployee.EmployeeId;
}
catch (Exception ex)
{
lblMessage.Text = "An error occurred while saving Employee details";
}
finally
{
objEmployee = null;
objBLL = null;
}
clearInput(Page.Controls);
}
/// <summary>
/// Function will update the new role allocated to the selected employee id in the database.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnUP_Click(object sender, EventArgs e)
{
//IEmployee objEmployee = EmployeeBOFactory.CreateEmployeeObject();
IAdminBLL objBLL = AdminBLLFactory.CreateAdminBLLObject();
ILogin objLogin = LoginBOFactory.CreateLoginObject();
List <IEmployee> lstEmp = new List <IEmployee>();
try
{
bool isNotSelected = false;
for (int i = 0; i < gvshowItems.Rows.Count; i++)
{
GridViewRow gvEmployeeRow = gvshowItems.Rows[i];
IEmployee objEmployee = EmployeeBOFactory.CreateEmployeeObject();
objEmployee.EmployeeId = Convert.ToInt32(gvEmployeeRow.Cells[0].Text);
//objEmployee.FirstName = (gvEmployeeRow.Cells[2].Text);
//objEmployee.LastName = (gvEmployeeRow.Cells[3].Text);
objEmployee.RoleId = Convert.ToInt32(((DropDownList)gvEmployeeRow.FindControl("ddlNewRole")).SelectedItem.Value);
//objEmployee.MobileNumber = Convert.ToInt64(gvEmployeeRow.Cells[5].Text);
if (objEmployee.RoleId == 10 || objEmployee.RoleId == 11 || objEmployee.RoleId == 12 || objEmployee.RoleId == 13)
{
lstEmp.Add(objEmployee);
}
}
//objEmployee.RoleId =Convert.ToInt32(ddlNewRole.SelectedValue);
bool IsUpdated = false;
if (!isNotSelected)
{
IsUpdated = objBLL.UpdateEmployeeDetails(lstEmp);
}
if (IsUpdated)
{
lblMessage.Text = "Employee details Updated successfully.";
}
else
{
lblMessage.Text = "An error occurred while updating Employee details";
}
}
catch (Exception ex)
{
lblMessage.Text = "An error occurred while updating Employee details";
}
finally
{
objBLL = null;
}
}
/// <summary>
/// This method fetch a particular recird from the data base for the view profile page.
/// </summary>
/// <returns>returns object of employee BO</returns>
public IEmployee GetEmployee(int employeeID)
{
SqlConnection objSQLConn = null;
SqlCommand objSQLCommand = null;
IEmployee objEmployee = EmployeeBOFactory.CreateEmployeeObject();
try
{
objSQLConn = new SqlConnection(strConnectionString);
objSQLConn.Open();
objSQLCommand = new SqlCommand("usp_GetEmployee", objSQLConn);
objSQLCommand.Parameters.AddWithValue("@EmployeeID", employeeID);
objSQLCommand.Parameters["@EmployeeID"].Direction = System.Data.ParameterDirection.Input;
objSQLCommand.CommandType = System.Data.CommandType.StoredProcedure;
SqlDataReader objSQLReader = objSQLCommand.ExecuteReader();
while (objSQLReader.Read())
{
objEmployee.EmployeeId = Convert.ToInt32(objSQLReader["EmployeeID"]);
objEmployee.FirstName = Convert.ToString(objSQLReader["EmployeeFirstName"]);
objEmployee.LastName = Convert.ToString(objSQLReader["EmployeeLastName"]);
objEmployee.RoleName = Convert.ToString(objSQLReader["RoleName"]);
objEmployee.Dob = Convert.ToDateTime(objSQLReader["DateOfBirth"]);
objEmployee.Doj = Convert.ToDateTime(objSQLReader["DateOfJoining"]);
objEmployee.Address = Convert.ToString(objSQLReader["Address"]);
objEmployee.City = Convert.ToString(objSQLReader["City"]);
objEmployee.State = Convert.ToString(objSQLReader["State"]);
objEmployee.MobileNumber = Convert.ToInt64(objSQLReader["ContactNumber"]);
// lstEmployee.Add(objEmployee);
}
objSQLReader.Close();
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (objSQLConn != null && objSQLConn.State != System.Data.ConnectionState.Closed)
{
objSQLConn.Close();
}
}
return(objEmployee);
}
/// <summary>
/// This method displays the list of employees working in the organisation.
/// </summary>
/// <returns>returns the list of employees</returns>
public List <IEmployee> GetEmployeeDetailsList()
{
SqlConnection objSQLConn = null;
SqlCommand objSQLCommand = null;
List <IEmployee> lstEmployee = new List <IEmployee>();
try
{
objSQLConn = new SqlConnection(strConnectionString);
objSQLConn.Open();
objSQLCommand = new SqlCommand("usp_GetEmployeeDetails", objSQLConn);
objSQLCommand.CommandType = System.Data.CommandType.StoredProcedure;
SqlDataReader objSQLReader = objSQLCommand.ExecuteReader();
while (objSQLReader.Read())
{
IEmployee objEmployee = EmployeeBOFactory.CreateEmployeeObject();
objEmployee.EmployeeId = Convert.ToInt32(objSQLReader["EmployeeID"]);
objEmployee.FirstName = Convert.ToString(objSQLReader["EmployeeFirstName"]);
objEmployee.LastName = Convert.ToString(objSQLReader["EmployeeLastName"]);
objEmployee.RoleName = Convert.ToString(objSQLReader["RoleName"]);
objEmployee.Dob = Convert.ToDateTime(objSQLReader["DateOfBirth"]);
objEmployee.Doj = Convert.ToDateTime(objSQLReader["DateOfJoining"]);
objEmployee.Address = Convert.ToString(objSQLReader["Address"]);
objEmployee.City = Convert.ToString(objSQLReader["State"]);
objEmployee.State = Convert.ToString(objSQLReader["City"]);
objEmployee.MobileNumber = Convert.ToInt64(objSQLReader["ContactNumber"]);
lstEmployee.Add(objEmployee);
}
objSQLReader.Close();
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (objSQLConn != null && objSQLConn.State != System.Data.ConnectionState.Closed)
{
objSQLConn.Close();
}
}
return(lstEmployee);
}
/// <summary>
/// This method will allow to update the edited fields.
/// </summary>
protected void btnUpdate_Click(object sender, EventArgs e)
{
IAdminBLL objBLL = AdminBLLFactory.CreateAdminBLLObject();
IEmployee objEmployee = EmployeeBOFactory.CreateEmployeeObject();
try
{
bool isUpdated = false;
objEmployee.EmployeeId = Convert.ToInt32(lblEmployeeIdDynamic2.Text);
objEmployee.Address = (txtAddress2).Text;
objEmployee.State = Convert.ToString(ddlState2.SelectedItem);
objEmployee.City = Convert.ToString(ddlCity2.SelectedItem);
objEmployee.MobileNumber = Convert.ToInt64(txtContact2.Text);
bool IsAdded = objBLL.UpdateEmployee(objEmployee);
isUpdated = true;
//objEmployee.EmployeeId = Convert.ToInt32(gvEmployeeRow.Cells[1].Text);
//objEmployee.FirstName = (gvEmployeeRow.Cells[2].Text);
//objEmployee.LastName = (gvEmployeeRow.Cells[3].Text);
//objEmployee.RoleName = gvEmployeeRow.Cells[4].Text;
//objEmployee.MobileNumber = Convert.ToInt64(gvEmployeeRow.Cells[5].Text);
//selectedItemList1.Add(objEmployee);
if (isUpdated)
{
lblMessage.Text = "Updated successfully";
}
else
{
lblMessage.Text = "Unable to update";
}
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
}
/// <summary>
/// Function will allow to update the employee details based on selected check box.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnUpdate_Click(object sender, EventArgs e)
{
IAdminBLL objBLL = AdminBLLFactory.CreateAdminBLLObject();
gvManageEmployee.Visible = false;
btnDelete.Visible = false;
btnUpdate.Visible = false;
btnUP.Visible = true;
try
{
bool isEmployeeSelected = false;
//bool isDeleted = false;
//loop through the grid to find the selected item
for (int i = 0; i < gvManageEmployee.Rows.Count; i++)
{
GridViewRow gvEmployeeRow = gvManageEmployee.Rows[i];
isEmployeeSelected = (Boolean)((CheckBox)gvEmployeeRow.FindControl("chkSelect")).Checked;
if (isEmployeeSelected)
{
IEmployee objEmployee = EmployeeBOFactory.CreateEmployeeObject();
objEmployee.EmployeeId = Convert.ToInt32(gvEmployeeRow.Cells[1].Text);
objEmployee.FirstName = (gvEmployeeRow.Cells[2].Text);
objEmployee.LastName = (gvEmployeeRow.Cells[3].Text);
objEmployee.RoleName = gvEmployeeRow.Cells[4].Text;
objEmployee.MobileNumber = Convert.ToInt64(gvEmployeeRow.Cells[5].Text);
selectedItemList1.Add(objEmployee);
}
}
if (selectedItemList1.Count != 0)
{
gvshowItems.DataSource = selectedItemList1;
}
gvshowItems.DataBind();
if (selectedItemList1.Count == 0)
{
gvManageEmployee.Visible = true;
lblMessage.Text = "Please select employee";
}
//else
//{
// //isDeleted = objBLL.DeleteEmployeeDetails(selectedItemList1);
// //if (!IsPostBack)
// //{
// //}
// //if (isEmployeeSelected)
// //{
// // lblMessage.Text = "Please select an employee";
// //}
// //if (isDeleted)
// {
// //lblMessage.Text = "Employee(s) deleted successfully";
// }
//
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
}
