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