public ActionResult DeleteConfirmed(int id) { AspNetSalary aspNetSalary = db.AspNetSalaries.Find(id); db.AspNetSalaries.Remove(aspNetSalary); db.SaveChanges(); return(RedirectToAction("Index")); }
public JsonResult SaveSalary(Salary Salaries) { AspNetSalary salary = new AspNetSalary(); salary.Month = Salaries.Month; salary.Title = Salaries.Title; salary.VirtualRoleID = Salaries.VId; salary.Year = Salaries.Year; db.AspNetSalaries.Add(salary); db.SaveChanges(); var salaryID = db.AspNetSalaries.Select(x => x.Id).Max(); foreach (var item in Salaries.EmployeeSalary) { AspNetSalaryDetail details = new AspNetSalaryDetail(); details.GrossSalary = item.GrossSalary; details.AccomodationAllowance = null; details.AdvanceSalary = null; details.ATaxSalary = item.AfterTaxSalary; details.BasicSalary = null; details.Bonus = item.Bonus; details.EmployeeId = item.Id; details.MedicalAllowance = item.MedicalAllowance; details.TotalSalary = item.TotalSalary; details.AdvancePf = null; details.AfterCutSalary = item.AfterCutSalary; details.BTaxSalary = item.BeforeTaxSalary; details.EmployeeEOP = item.EmployeeEOP; details.EmployeePF = null; details.FineCut = item.FineCut; if (item.Status == "Hold") { details.SalaryHold = item.TotalSalary; } else if (item.HOLD != null) { foreach (var holds in item.HOLD) { var row = db.AspNetSalaryDetails.Where(x => x.Id == holds.id).Select(x => x).FirstOrDefault(); row.Status = "Paid"; } details.SalaryHold = 0; } details.Status = item.Status; details.Total = item.Total; details.SchoolEOP = null; details.Tax = item.Tax; details.SalaryId = salaryID; db.AspNetSalaryDetails.Add(details); } db.SaveChanges(); return(Json(salaryID, JsonRequestBehavior.AllowGet)); }
public ActionResult Edit([Bind(Include = "Id,Month,Title,VirtualRoleID")] AspNetSalary aspNetSalary) { if (ModelState.IsValid) { db.Entry(aspNetSalary).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.VirtualRoleID = new SelectList(db.AspNetVirtualRoles, "Id", "Name", aspNetSalary.VirtualRoleID); return(View(aspNetSalary)); }
public ActionResult Create([Bind(Include = "Id,Year,Month,Title,VirtualRoleID")] AspNetSalary aspNetSalary) { if (ModelState.IsValid) { db.AspNetSalaries.Add(aspNetSalary); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.VirtualRoleID = new SelectList(db.AspNetVirtualRoles, "Id", "Name", aspNetSalary.VirtualRoleID); return(View(aspNetSalary)); }
// GET: AspNetSalaries/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AspNetSalary aspNetSalary = db.AspNetSalaries.Find(id); if (aspNetSalary == null) { return(HttpNotFound()); } return(View(aspNetSalary)); }
// GET: AspNetSalaries/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AspNetSalary aspNetSalary = db.AspNetSalaries.Find(id); if (aspNetSalary == null) { return(HttpNotFound()); } ViewBag.VirtualRoleID = new SelectList(db.AspNetVirtualRoles, "Id", "Name", aspNetSalary.VirtualRoleID); return(View(aspNetSalary)); }
public ActionResult DeleteCnfm(int id) { AspNetSalary aspNetSalary = db.AspNetSalaries.Find(id); try { db.AspNetSalaries.Remove(aspNetSalary); db.SaveChanges(); return(RedirectToAction("Index")); } catch { ViewBag.Error = "It can't be deleted"; ViewBag.VirtualRoleID = new SelectList(db.AspNetVirtualRoles, "Id", "Name", aspNetSalary.VirtualRoleID); return(View("Details", aspNetSalary)); } }