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