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