public ActionResult DeleteConfirmed(DateTime id) { SALARYREPORT sALARYREPORT = db.SALARYREPORTs.Find(id); db.SALARYREPORTs.Remove(sALARYREPORT); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Index(SALARYREPORT rp) { var tAXREPORTs = db.TAXREPORTs.Where(x => x.Month == rp.Month).ToList(); if (tAXREPORTs == null) { return(View()); } return(View(tAXREPORTs)); }
public ActionResult Edit([Bind(Include = "Month,EmployeeID,Allowance,SalaryStandard,WorkDay,SalaryWorkDay,Bonus,Insurance,Overtime,IncomeTax,Advance,RealSalary")] SALARYREPORT sALARYREPORT) { if (ModelState.IsValid) { db.Entry(sALARYREPORT).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.EmployeeID = new SelectList(db.EMPLOYEEs, "EmployeeID", "EmployeeName", sALARYREPORT.EmployeeID); return(View(sALARYREPORT)); }
public ActionResult Index(SALARYREPORT rp) { Session["MainTitle"] = "Báo cáo tiền lương"; Session["SubTitle"] = "Tiền lương"; var sALARYREPORT = db.SALARYREPORTs.Where(x => x.Month == rp.Month).ToList(); if (sALARYREPORT == null) { return(View()); } return(View(sALARYREPORT)); }
// GET: SALARYREPORTs/Delete/5 public ActionResult Delete(DateTime id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } SALARYREPORT sALARYREPORT = db.SALARYREPORTs.Find(id); if (sALARYREPORT == null) { return(HttpNotFound()); } return(View(sALARYREPORT)); }
public ActionResult Load() { Session["MainTitle"] = "Quản lý tiền lương"; Session["SubTitle"] = "Bảng lương tháng"; DateTime date = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1, 0, 0, 0); //var sALARYREPORT = db.SALARYREPORTs.Where(x => x.Month == date).ToList(); var employeelist = db.EMPLOYEEs.Where(x => x.State == true).ToList(); foreach (EMPLOYEE e in employeelist) { if (db.SALARYREPORTs.Count(x => x.EmployeeID == e.EmployeeID && x.Month == date) == 0) { int hourPay = CalculateStandardHourSalary(e); var report = db.TIMEKEEPINGREPORTs.Find(date, e.EmployeeID); var sALARYREPORT = new SALARYREPORT { EmployeeID = e.EmployeeID, EMPLOYEE = e, Month = date, AbsentHaveSalary = db.TIMEKEEPINGREPORTs.Where(x => x.EmployeeID == e.EmployeeID && x.Month.Month == date.Month && x.Month.Year == date.Year).First().SumAbsentHaveSalary, AbsentHaveSalaryValue = CalculateAbsentSalary(e, date), NormalOverTimeSalary = CalculateNormalOvertimeSalary(report, hourPay), DayOffOverTimeSalary = CalculateDayOffOvertimeSalary(report, hourPay), SpecialDayOffOverTimeSalary = CalculateSpecialDayOffOvertimeSalary(report, hourPay), NightNormalOverTimeSalary = CalculateNightNormalOvertimeSalary(report, hourPay), NightDayOffOverTimeSalary = CalculateNightDayOffOvertimeSalary(report, hourPay), NightSpecialDayOffOverTimeSalary = CalculateNightSpecialDayOffOvertimeSalary(report, hourPay), OverTimeSalary = CalculateOvertimeSalary(e, date), Allowance = CalculateTotalAllowance(e, date), Advance = CalculateAdvanced(e, date), IncomeTax = CalculateIncomeTax(e, date), StandardSalary = CalculateStandardSalary(e, date), WorkDay = db.TIMEKEEPINGREPORTs.Where(x => x.EmployeeID == e.EmployeeID && x.Month.Month == date.Month && x.Month.Year == date.Year).First().SumWorkDay, WorkDaySalary = CalculateWorkDaySalary(e, date), TotalInsurancePay = CalculateTotalInsurancePay(e, date), RealSalary = CalculateSalary(e, date) }; db.SALARYREPORTs.Add(sALARYREPORT); db.SaveChanges(); } else { continue; } } var sALARYREPORTs = db.SALARYREPORTs.Where(x => x.Month == date).ToList(); return(View(sALARYREPORTs)); }
// GET: SALARYREPORTs/Edit/5 public ActionResult Edit(DateTime id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } SALARYREPORT sALARYREPORT = db.SALARYREPORTs.Find(id); if (sALARYREPORT == null) { return(HttpNotFound()); } ViewBag.EmployeeID = new SelectList(db.EMPLOYEEs, "EmployeeID", "EmployeeName", sALARYREPORT.EmployeeID); return(View(sALARYREPORT)); }
// GET: SALARYREPORTs/Details/5 public ActionResult Details(string id, DateTime month) { Session["MainTitle"] = "Quản lý tiền lương"; Session["SubTitle"] = "Bảng lương chi tiết"; if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } SALARYREPORT sALARYREPORT = db.SALARYREPORTs.Find(month, id); if (sALARYREPORT == null) { return(HttpNotFound()); } return(View(sALARYREPORT)); }