protected void Button1_Click(object sender, EventArgs e)
{
try
{
IEmployeeBLL objEmployeeMng = EmployeeFactoryBLL.createEmployeeBLobj();
IEmployeeBO objEmployee = EmployeeBOFactory.createEmpBO();
objEmployee.EmployeeName = txtempname.Text;
objEmployee.DOJ = DateTime.Parse(txtdoj.Text);
objEmployee.DOB = DateTime.Parse(txtdob.Text);
objEmployee.Location = txtloc.Text;
objEmployee.Gender = txtgend.Text;
objEmployee.CTC = Convert.ToInt32(txtctc.Text);
objEmployee.Designation = txtdesignation.Text;
objEmployee.UnitHeadID = Convert.ToInt32(ddlunithead.SelectedValue);
objEmployee.ProjectId = 100001;
int ID = objEmployeeMng.addEmployee(objEmployee);
int id = Int32.Parse(Session["CandID"].ToString());
ICandidateBLL obj = CandidateFactoryBLL.createCandidateBLobj();
ICandidateBO objBo = CandidateFactoryBO.createEmployeeBO(id);
obj.deleteCandidate(id);
Response.Write("<script>if(confirm('Details Submitted Successfully. Employee ID :" + ID + "')){document.location='AddSelectedCandidates_HR.aspx';}</script>");
}
catch (Exception)
{ }
}
protected void BtnUpdate_Click(object sender, EventArgs e)
{
try
{
string empName = txtEmpName.Text;
string designation = txtdesignation.Text;
Int32 ctc = Convert.ToInt32(txtctc.Text);
Int32 unitHead = Convert.ToInt32(txtUnitHead.Text);
IEmployeeBO objBo = EmployeeBOFactory.createEmployeeBO(empName, designation, ctc, unitHead);
IEmployeeBLL objBll = EmployeeFactoryBLL.createEmployeeBLL();
int res = objBll.editEmployees(objBo);
if (res > 0)
{
Response.Write("<script>if(confirm('Employee Details Updated Successfully.')){document.location='EditEmployeeDetails.aspx';}</script>");
}
else
{
Response.Write("<script>if(confirm('Employee not Details Updated Successfully.')){document.location='EditEmployeeDetails.aspx';}</script>");
}
}
catch (Exception)
{
}
}
public List <IEmployeeBO> displayeverythingDB()
{
try
{
List <IEmployeeBO> newlist = new List <IEmployeeBO>();
string str = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;
SqlConnection conn = new SqlConnection(str);
conn.Open();
SqlCommand command = new SqlCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "displayeverything";
command.Connection = conn;
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
int employeeid = Convert.ToInt32(reader["employee_ID"]);
IEmployeeBO obj = EmployeeBOFactory.createemp1(employeeid);
newlist.Add(obj);
}
return(newlist);
}
catch (Exception ex)
{
throw ex;
}
}
public List <IEmployeeBO> displayallDB()
{
try
{
List <IEmployeeBO> list = new List <IEmployeeBO>();
string str = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;
SqlConnection conn = new SqlConnection(str);
conn.Open();
SqlCommand command = new SqlCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "displayallBGC";
command.Connection = conn;
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
int adminid = Convert.ToInt32(reader["AdministratorID"]);
string bgcstatus = Convert.ToString(reader["bgcStatus"]);
DateTime statuschangetime = Convert.ToDateTime(reader["StatusChangeTime"]);
string employeename = Convert.ToString(reader["EmployeeName"]);
IEmployeeBO obj = EmployeeBOFactory.CreateEmp2(adminid, bgcstatus, statuschangetime, employeename);
list.Add(obj);
}
return(list);
}
catch (Exception)
{
throw;
}
}
/// <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);
}
protected void BGCgrdview_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
GridViewRow row = BGCgrdview.Rows[e.RowIndex];
Label lbladminid2 = (Label)row.FindControl("lbladminid2");
DropDownList ddlstatus = (DropDownList)row.FindControl("ddlstatus");
Label lblStatusChangeTime2 = (Label)row.FindControl("lblStatusChangeTime2");
int adminid = Convert.ToInt32(lbladminid2.Text);
string status = ddlstatus.SelectedValue;
DateTime statuschangetime = DateTime.Now;
IEmployeeBO objbo = EmployeeBOFactory.CreateEmployee(adminid, status, statuschangetime);
IEmployeeBLL objbll = EmployeeFactoryBLL.createnew();
int check = objbll.displayapproved(objbo);
if (check > 0)
{
BGCgrdview.EditIndex = -1;
bgcdata();
}
else
{
Response.Redirect("<script>alert('Employee details are not updated please update again')</script>");
}
}
catch (Exception ex)
{
Response.Write("<script>alert('Exception: " + ex.Message + "');</script>");
}
}
/// <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);
}
protected void submit_button_Click(object sender, EventArgs e)
{
try
{
//for (int i = 0; i <= 5; i++)
//{
int employeeid = Convert.ToInt32(ddlAdmin.SelectedItem.Text);
string status = "Pending";
DateTime statusChangeTime = DateTime.Now;
int role_id = 3;
int administratorID = 0;
IEmployeeBO empadd = EmployeeBOFactory.createemp(employeeid, status, statusChangeTime, role_id, administratorID);
IEmployeeBLL empbll = EmployeeFactoryBLL.createnew();
List <IEmployeeBO> list = empbll.everythingdisplay();
//foreach (IEmployeeBO item in list)
//{
// if(item.EmployeeID==500002)
// Response.Write("found");
//}
var match = list.Exists(p => p.EmployeeID == employeeid);
if (match == false)
{
int check = empbll.addadmin(empadd);
ddlAdmin.Items.Remove(ddlAdmin.SelectedItem.Text);
if (check > 0)
{
binddata();
}
}
else
{
Response.Write("<script>alert('The employee selected is already a BGC ADMINISTRATOR please select another employee.');</script>");
ddlAdmin.Items.Remove(ddlAdmin.SelectedItem.Text);
binddata();
}
}
catch (Exception ex)
{
Response.Write("<script>alert('Exception: " + ex.Message + "');</script>");
}
}
protected void BtnSubmit_Click(object sender, EventArgs e)
{
try
{
LblEmpID.Visible = true;
LblEmpName.Visible = true;
LblDesgn.Visible = true;
LblCTC.Visible = true;
LblUnitHeadID.Visible = true;
txtEmpID.Visible = true;
txtEmpName.Visible = true;
txtdesignation.Visible = true;
txtctc.Visible = true;
rectc.Visible = true;
redesignation.Visible = true;
rfvctc.Visible = true;
rfvdesignation.Visible = true;
txtUnitHead.Visible = true;
BtnUpdate.Visible = true;
BtnCancel.Visible = true;
BtnSubmit.Visible = false;
LblEmpID1.Visible = false;
ddlEmpID.Visible = false;
int id = Convert.ToInt32(ddlEmpID.SelectedValue);
Session["empid"] = ddlEmpID.SelectedValue;
txtEmpID.Text = Session["empid"].ToString();
IEmployeeBO objBo = EmployeeBOFactory.createEmployeeBO(id);
IEmployeeBLL objBll = EmployeeFactoryBLL.createEmployeeBLL();
txtEmpName.Text = objBll.getEmpName(id);
txtUnitHead.Text = Convert.ToString(objBll.getUnitHeadId(id));
txtctc.Text = Convert.ToString(objBll.getctc(id));
txtdesignation.Text = objBll.getDesignation(id);
txtUnitHead.DataBind();
txtEmpName.DataBind();
ddlEmpID.Items.Insert(0, "--Select--");
}
catch (Exception)
{
}
}
protected void bindData()
{
try
{
for (int i = 0; i < 5; i++)
{
List <IEmployeeBO> list = EmployeeBOFactory.createEmployeeBO();
IEmployeeBLL objBLL = EmployeeFactoryBLL.createEmployeeBLL();
list = objBLL.ViewEmployee();
grdEmployee.DataSource = list;
if (list.Count != 0)
{
grdEmployee.DataBind();
}
else
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Employee Doesnot Exit')", true);
}
}
}catch (Exception)
{ }
}
/// <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;
}
}
public List <string> getEmployeeNameDB()
{
List <string> listid = EmployeeBOFactory.createintList1();
string name;
SqlConnection conn = new SqlConnection();
string str = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;
conn.ConnectionString = str;
conn.Open();
SqlCommand command = new SqlCommand();
command.Connection = conn;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "sp_getEmployeeName";
command.Connection = conn;
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
name = Convert.ToString(reader["EmployeeName"]);;
listid.Add(name);
}
return(listid);
}
public List <IEmployeeBO> viewEmployeeDB()
{
List <IEmployeeBO> list = new List <IEmployeeBO>();
try
{
SqlConnection conn = new SqlConnection();
string str = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;
conn.ConnectionString = str;
conn.Open();
SqlCommand command = new SqlCommand();
command.Connection = conn;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "sp_displayEmployee";
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
int empID = Convert.ToInt32(reader["EmployeeID"]);
DateTime dateOfBirth = Convert.ToDateTime(reader["DOB"]);
DateTime dateOfJoining = Convert.ToDateTime(reader["DOJ"]);
string designation = Convert.ToString(reader["Designation"]);
string location = Convert.ToString(reader["Location"]);
string gender = Convert.ToString(reader["Gender"]);
Int32 ctc = Convert.ToInt32(reader["CTC"]);
int unitHeadID = Convert.ToInt32(reader["UnitHeadiD"]);
int projectID = Convert.ToInt32(reader["ProjectID"]);
IEmployeeBO objBO = EmployeeBOFactory.createEmployeeBO(empID, dateOfBirth, dateOfJoining, designation, location, gender, ctc, unitHeadID, projectID);
list.Add(objBO);
}
}
catch (Exception)
{
}
return(list);
}
public List <int> getEmployeeIDDB()
{
List <int> listUH = EmployeeBOFactory.createintList();
int uhID;
SqlConnection conn = new SqlConnection();
string str = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;
conn.ConnectionString = str;
conn.Open();
SqlCommand command = new SqlCommand();
command.Connection = conn;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "sp_getEmployeeID";
command.Connection = conn;
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
uhID = Convert.ToInt32(reader["EmployeeID"]);
listUH.Add(uhID);
}
return(listUH);
}
/// <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;
}
}
