public ActionResult DeleteConfirmed(int id) { AspNetSalaryDetail aspNetSalaryDetail = db.AspNetSalaryDetails.Find(id); db.AspNetSalaryDetails.Remove(aspNetSalaryDetail); 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)); }
// POST: AspNetSalaryDetail/Edit/5 // To protect from overposting attacks, please enable the specific properties you want to bind to, for // more details see http://go.microsoft.com/fwlink/?LinkId=317598. //[HttpPost] //[ValidateAntiForgeryToken] //public ActionResult Edit([Bind(Include = "Id,BasicSalary,MedicalAllowance,AccomodationAllowance,GrossSalary,Bonus,EOPSchool,TotalSchoolPayble,FineCutOff,ADVSalary,PF,EOPEmployee,TotalDeduction,Salary,IncomeTax,ATaxSalary,SalaryHold,Total,Status")] AspNetSalaryDetail aspNetSalaryDetail) //{ // if (ModelState.IsValid) // { // db.Entry(aspNetSalaryDetail).State = EntityState.Modified; // db.SaveChanges(); // return RedirectToAction("Index"); // } // return View(aspNetSalaryDetail); //} // GET: AspNetSalaryDetail/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AspNetSalaryDetail aspNetSalaryDetail = db.AspNetSalaryDetails.Find(id); if (aspNetSalaryDetail == null) { return(HttpNotFound()); } return(View(aspNetSalaryDetail)); }