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; } }