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