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