public bool EmployeeSalaryAddEdit(EmpSalaryModel obj, string CallType) { connection(); SqlCommand com = new SqlCommand("sp_ManageEmpSalary", con); com.CommandType = CommandType.StoredProcedure; com.Parameters.AddWithValue("@id", obj.id); com.Parameters.AddWithValue("@EmpId", obj.EmpId); com.Parameters.AddWithValue("@Salary", obj.Salary); com.Parameters.AddWithValue("@SalaryMonth", obj.SalaryMonth); com.Parameters.AddWithValue("@SalaryYear", obj.SalaryYear); com.Parameters.AddWithValue("@CallType", CallType); con.Open(); int i = com.ExecuteNonQuery(); con.Close(); if (i >= 1) { return(true); } else { return(false); } }
public ActionResult EditEmployeeSalary1() { EmpSalaryModel EmpSal = new EmpSalaryModel(); EmpSal.id = Convert.ToInt32(Request.Form["id"]); EmpSal.EmpId = Convert.ToInt32(Request.Form["EmpId"]); EmpSal.Salary = Convert.ToInt32(Request.Form["Salary"]); EmpSal.SalaryYear = Convert.ToInt32(Request.Form["SalaryYear"]); EmpSal.SalaryMonth = Convert.ToInt32(Request.Form["SalaryMonth"]); try { bool DuplicateSalary = false; if (ModelState.IsValid) { EmpRepository EmpRepo = new EmpRepository(); if (EmpRepo.CheckDuplicateEmpSalary(EmpSal.id.ToString(), EmpSal.EmpId.ToString(), EmpSal.SalaryYear.ToString(), EmpSal.SalaryMonth.ToString())) { DuplicateSalary = true; } else { if (EmpRepo.EmployeeSalaryAddEdit(EmpSal, "update")) { return(RedirectToAction("EmployeeSalaryList", new { id = EmpSal.EmpId })); } } } if (DuplicateSalary) { ViewBag.ErrorMessage = "Salary is already entered for " + MonthName(EmpSal.SalaryMonth) + ", " + EmpSal.SalaryYear + " for this employee!"; } else { ViewBag.ErrorMessage = "System error. Please try again!"; } ViewBag.Message = ""; } catch { ViewBag.ErrorMessage = "System error. Please try again!"; ViewBag.Message = ""; } ViewBag.Title = "HRMS - Edit Employee Salary"; EmpRepository empRep = new EmpRepository(); EmployeeModel emp = empRep.GetSingleEmployeeOnId(EmpSal.EmpId.ToString()); @ViewBag.EmpName = emp.EmpName + " (#" + emp.EmpId.ToString() + ")"; EmpSal = empRep.GetSingleEmployeeSalaryOnId(Convert.ToString(EmpSal.id)); @ViewBag.SalMonth = EmpSal.SalaryMonth; @ViewBag.EmpId = emp.EmpId.ToString(); return(View(EmpSal)); }
public ActionResult EditEmployeeSalary(string id) { ViewBag.Title = "HRMS - Edit Employee Salary"; EmpRepository empRo = new EmpRepository(); ModelState.Clear(); EmpRepository empRep = new EmpRepository(); EmpSalaryModel empSal = empRo.GetSingleEmployeeSalaryOnId(id); string empid = Convert.ToString(empSal.EmpId); EmployeeModel emp = empRep.GetSingleEmployeeOnId(empid); @ViewBag.EmpName = emp.EmpName + " (#" + emp.EmpId.ToString() + ")"; @ViewBag.EmpId = emp.EmpId.ToString(); @ViewBag.SalMonth = empSal.SalaryMonth; return(View(empRo.GetSingleEmployeeSalaryOnId(id))); }
public ActionResult DeleteEmployeeSalary(string id) { EmpSalaryModel EmpSal = new EmpSalaryModel(); EmpSal.id = Convert.ToInt32(id); EmpSal.EmpId = 0; EmpSal.Salary = 0; EmpSal.SalaryYear = 0; EmpSal.SalaryMonth = 0; try { EmpRepository EmpRepo = new EmpRepository(); EmpSal = EmpRepo.GetSingleEmployeeSalaryOnId(id); if (EmpRepo.EmployeeSalaryAddEdit(EmpSal, "delete")) { return(RedirectToAction("EmployeeSalaryList", new { id = EmpSal.EmpId })); } ViewBag.Message = ""; } catch { return(RedirectToAction("GetAllEmpDetails")); } /*ViewBag.Title = "HRMS - Edit Employee Salary"; * EmpRepository empRep = new EmpRepository(); * EmployeeModel emp = empRep.GetSingleEmployeeOnId(EmpSal.EmpId.ToString()); * * @ViewBag.EmpName = emp.EmpName + " (#" + emp.EmpId.ToString() + ")"; * EmpSal = empRep.GetSingleEmployeeSalaryOnId(Convert.ToString(EmpSal.id)); * @ViewBag.SalMonth = EmpSal.SalaryMonth; * @ViewBag.EmpId = emp.EmpId.ToString(); * return View(EmpSal);*/ return(View()); }