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