//------------------- Add and get --------- public DisplayEmployeeDetails AddEmployee(DisplayEmployeeDetails model) { Salary salary = new Salary(); try { var sqlFormattedDate = model.HireDate.ToString("MM/dd/yyyy"); using (this.connection) { SqlCommand command = new SqlCommand("spAddEmployee", this.connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@EName", model.EName); command.Parameters.AddWithValue("@Gender", model.Gender); command.Parameters.AddWithValue("@HireDay", sqlFormattedDate); command.Parameters.AddWithValue("@DeptNo", model.DeptNo); command.Parameters.AddWithValue("@Email", model.Email ?? ""); command.Parameters.AddWithValue("@BirthDay", model.BirthDay ?? ""); command.Parameters.AddWithValue("@JobDiscription", model.JobDiscription ?? ""); command.Parameters.AddWithValue("@ProfileImage", model.Image ?? ""); this.connection.Open(); Object result = command.ExecuteScalar(); this.connection.Close(); if (result != null) { salary.EmpId = Convert.ToInt32(result.ToString()); salary.EmpSal = model.EmpSal; salary.SalaryMonth = model.SalaryMonth; this.AddEmployeeSalary(salary); return(model); } return(null); } } catch (Exception e) { throw new Exception(e.Message); } finally { this.connection.Close(); } }
public DisplayEmployeeDetails GetEmployeeById(int id) { try { using (this.connection) { DisplayEmployeeDetails employee = new DisplayEmployeeDetails(); SqlCommand command = new SqlCommand("spGetEmployeeById", this.connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@EmpId", id); this.connection.Open(); SqlDataReader dataReader = command.ExecuteReader(); if (dataReader.HasRows) { while (dataReader.Read()) { employee.EmpId = Convert.ToInt32(dataReader["EmpId"]); employee.EName = dataReader["EName"].ToString(); employee.Gender = Convert.ToChar(dataReader["Gender"]); employee.DeptNo = Convert.ToInt32(dataReader["DeptNo"]); employee.DeptName = dataReader["DeptName"].ToString(); employee.EmpSal = Convert.ToDouble(dataReader["EmpSal"]); employee.HireDate = Convert.ToDateTime(dataReader["HireDay"]); employee.Image = dataReader["ProfileImage"].ToString(); employee.JobDiscription = dataReader["JobDiscription"].ToString(); } return(employee); } return(null); } } catch (Exception e) { throw new Exception(e.Message); } finally { this.connection.Close(); } }
//---------------------------------------------------------------------- //--------- Update Employee -------------------------------------------- public DisplayEmployeeDetails UpdateEmployee(DisplayEmployeeDetails details) { try { using (this.connection) { this.connection.Open(); using (var transaction = this.connection.BeginTransaction()) { SqlCommand employeeUpdate = new SqlCommand("spUpdateEmployee", this.connection, transaction); employeeUpdate.CommandType = CommandType.StoredProcedure; employeeUpdate.Parameters.AddWithValue("@EmpId", details.EmpId); employeeUpdate.Parameters.AddWithValue("@EName", details.EName); employeeUpdate.Parameters.AddWithValue("@Gender", details.Gender); employeeUpdate.Parameters.AddWithValue("@HireDay", details.HireDate); employeeUpdate.Parameters.AddWithValue("@DeptNo", details.DeptNo); employeeUpdate.Parameters.AddWithValue("@JobDiscription", details.JobDiscription == null?"" : details.JobDiscription); employeeUpdate.Parameters.AddWithValue("@SalaryMonth", details.SalaryMonth); employeeUpdate.Parameters.AddWithValue("@EmpSal", details.EmpSal); employeeUpdate.Parameters.AddWithValue("@ProfileImage", details.Image ?? ""); var result = employeeUpdate.ExecuteNonQuery(); transaction.Commit(); if (result != 0) { return(details); } return(null); } } } catch (Exception e) { throw new Exception(e.Message); } finally { this.connection.Close(); } }
public DisplayEmployeeDetails UpdateEmployee(DisplayEmployeeDetails details) { return(this.repo.UpdateEmployee(details)); }
public DisplayEmployeeDetails AddEmployee(DisplayEmployeeDetails model) { return(this.repo.AddEmployee(model)); }
protected void BindTextBoxValues(int empId) { try { DisplayEmployeeDetails displayEmployee = employee.GetEmployeeById(empId); EmpId.Text = displayEmployee.EmpId.ToString(); name.Text = displayEmployee.EName; if (displayEmployee.Image == "../Assets/Ellipse -3") { profile1.Checked = true; } if (displayEmployee.Image == "../Assets/Ellipse -1") { profile2.Checked = true; } if (displayEmployee.Image == "../Assets/Ellipse -8") { profile3.Checked = true; } if (displayEmployee.Image == "../Assets/Ellipse -7") { profile4.Checked = true; } if (displayEmployee.Gender == 'M') { male.Checked = true; female.Checked = false; } else { male.Checked = false; female.Checked = true; } switch (displayEmployee.DeptName) { case "HR": hr.Checked = true; break; case "Sales": sales.Checked = true; break; case "Finance": finance.Checked = true; break; case "Engineer": engineer.Checked = true; break; case "Others": others.Checked = true; break; } salary.Text = displayEmployee.EmpSal.ToString(); string d = displayEmployee.HireDate.Day.ToString(); int m = displayEmployee.HireDate.Month; string monthName = DateTimeFormatInfo.CurrentInfo.GetAbbreviatedMonthName(m); string y = displayEmployee.HireDate.Year.ToString(); day.Items[day.SelectedIndex].Text = d.ToString(); month.Items[month.SelectedIndex].Text = monthName.ToString(); year.Items[year.SelectedIndex].Text = y.ToString(); notes.Text = displayEmployee.JobDiscription; } catch (Exception ex) { throw new Exception(ex.Message); } }