// GET: /Advance/Delete/5 public JsonResult advancedDelete(int id = 0) { tbl_Advance advance = db.tbl_Advance.Where(x => x.AdvanceID == id).FirstOrDefault(); db.tbl_Advance.Remove(advance); db.SaveChanges(); return(Json(true, JsonRequestBehavior.AllowGet)); }
public ActionResult AdvancedList(string keyword, tbl_Advance advance) { var results = (from item in db.tbl_Advance where item.tbl_staffInfo.Name.Contains(keyword) select item).ToList(); var pageIndex = advance.Page ?? 1; advance.AdvancedListResults = results.ToPagedList(pageIndex, RecordsPerPage); return(View(advance)); }
public ActionResult AdvancedList(tbl_Advance advance) { var results = (from item in db.tbl_Advance select item).ToList().OrderBy(p => p.AdvanceID); var pageIndex = advance.Page ?? 1; advance.AdvancedListResults = results.ToPagedList(pageIndex, RecordsPerPage); return(View(advance)); //return View(db.Advances.ToList()); }
public ActionResult advanceUpdate(int id = 0) { advanceid = id; tbl_Advance bc = db.tbl_Advance.FirstOrDefault(a => a.AdvanceID == advanceid); if (bc == null) { return(HttpNotFound()); } ViewBag.StaffID = new SelectList(db.tbl_staffInfo, "StaffID", "Name"); ViewBag.GetSalary = bc.Salary; ViewBag.GetAdvanceDate = bc.AdvanceDate; ViewBag.GetAdvanceAmount = bc.AdvanceAmount; ViewBag.GetNewAdvance = bc.NewAdvance; ViewBag.GetAdvanceBack = bc.AdvanceBack; ViewBag.GetPaymentWay = bc.PaymentWay; ViewBag.GetGrandTotalAmount = bc.GrandTotalAmount; ViewBag.GetPaid = bc.Paid; return(View(bc)); }
public ActionResult advanceUpdate(tbl_Advance bc, int id = 0) { tbl_Advance bc1 = db.tbl_Advance.FirstOrDefault(a => a.AdvanceID == advanceid); bc1.StaffID = bc.StaffID; bc1.Salary = bc.Salary; bc1.AdvanceDate = bc.AdvanceDate; bc1.AdvanceAmount = bc.AdvanceAmount; bc1.NewAdvance = bc.NewAdvance; bc1.AdvanceBack = bc.AdvanceBack; bc1.PaymentWay = bc.PaymentWay; bc1.GrandTotalAmount = bc.GrandTotalAmount; bc1.Paid = bc.Paid; if (bc1 == null) { return(HttpNotFound()); } db.SaveChanges(); ViewBag.StaffID = new SelectList(db.tbl_staffInfo, "StaffID", "Name"); return(View(bc1)); }
public ActionResult addAdvanced(tbl_Advance advance) { 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"]; } } advance.EntryDate = DateTime.Today; advance.UserInfoID = Convert.ToInt32(userid); db.tbl_Advance.Add(advance); db.SaveChanges(); return(RedirectToAction("addAdvanced")); } ViewBag.StaffID = new SelectList(db.tbl_staffInfo, "StaffID", "Name"); ViewBag.UserInfoID = new SelectList(db.tbl_UserInfo, "UserInfoID", "UserName"); return(View(advance)); }