public JsonResult SalaryDelete(int id = 0)
{
tbl_Salary salary = db.tbl_Salary.Where(x => x.SalaryID == id).FirstOrDefault();
db.tbl_Salary.Remove(salary);
db.SaveChanges();
return(Json(true, JsonRequestBehavior.AllowGet));
}
public ActionResult salaryList(string keyword, tbl_Salary salary)
{
var results = (from item in db.tbl_Salary where item.tbl_staffInfo.Name.Contains(keyword) select item).ToList();
var pageIndex = salary.Page ?? 1;
salary.SalaryListResults = results.ToPagedList(pageIndex, RecordsPerPage);
return(View(salary));
}
public ActionResult salaryList(tbl_Salary salary)
{
var results = (from item in db.tbl_Salary
select item).ToList().OrderBy(p => p.SalaryID);
var pageIndex = salary.Page ?? 1;
salary.SalaryListResults = results.ToPagedList(pageIndex, RecordsPerPage);
return(View(salary));
//return View(db.Salaries.ToList());
}
public ActionResult salaryUpdate(tbl_Salary bc, int id = 0)
{
tbl_Salary bc1 = db.tbl_Salary.FirstOrDefault(s => s.SalaryID == salaryid);
bc1.StaffID = bc.StaffID;
bc1.BasicAmount = bc.BasicAmount;
bc1.AllowanceAmount = bc.AllowanceAmount;
bc1.TotalAmount = bc.TotalAmount;
bc1.DetuctionAmount = bc.DetuctionAmount;
bc1.AdvanceAmount = bc.AdvanceAmount;
bc1.AdvanceBack = bc.AdvanceBack;
bc1.LoanAmount = bc.LoanAmount;
bc1.LoanBack = bc.LoanBack;
if (bc1 == null)
{
return(HttpNotFound());
}
db.SaveChanges();
ViewBag.StaffID = new SelectList(db.tbl_staffInfo, "StaffID", "Name");
return(View(bc1));
}
public ActionResult salaryUpdate(int id = 0)
{
salaryid = id;
tbl_Salary bc = db.tbl_Salary.FirstOrDefault(s => s.SalaryID == salaryid);
if (bc == null)
{
return(HttpNotFound());
}
ViewBag.StaffID = new SelectList(db.tbl_staffInfo, "StaffID", "Name");
ViewBag.GetBasicAmount = bc.BasicAmount;
ViewBag.GetAllowanceAmount = bc.AllowanceAmount;
ViewBag.GetTotalAmount = bc.TotalAmount;
ViewBag.GetDetuctionAmount = bc.DetuctionAmount;
ViewBag.GetAdvanceAmount = bc.AdvanceAmount;
ViewBag.GetAdvanceBack = bc.AdvanceBack;
ViewBag.GetLoanAmount = bc.LoanAmount;
ViewBag.GetLoanBack = bc.LoanBack;
ViewBag.GetGrandTotalAmount = bc.GrandTotalAmount;
return(View(bc));
}
public ActionResult addsalary(tbl_Salary salary)
{
if (ModelState.IsValid)
{
string userid = "";
string userSettings = "";
if (Request.Cookies["UserSettings"] != null)
{
if (Request.Cookies["UserSettings"]["UserName"] != null)
{
userSettings = Request.Cookies["UserSettings"]["UserName"]; userid = Request.Cookies["UserSettings"]["UserId"];
}
}
salary.EnterDate = DateTime.Today;
salary.UserInfoID = Convert.ToInt32(userid);
db.tbl_Salary.Add(salary);
db.SaveChanges();
return(RedirectToAction("addsalary"));
}
ViewBag.StaffID = new SelectList(db.tbl_staffInfo, "StaffID", "Name");
ViewBag.UserInfoID = new SelectList(db.tbl_UserInfo, "UserInfoID", "UserName");
return(View(salary));
}
partial void Deletetbl_Salary(tbl_Salary instance);
partial void Updatetbl_Salary(tbl_Salary instance);
partial void Inserttbl_Salary(tbl_Salary instance);
