// GET: UpcomingBills public ActionResult Index(string sortOrder, string currentFilter, string searchString, int?page) { var claimsIdentity = User.Identity as ClaimsIdentity; var userIdClaim = claimsIdentity.Claims .FirstOrDefault(x => x.Type == ClaimTypes.NameIdentifier); if (userIdClaim != null) { userIdValue = userIdClaim.Value; } else { userIdValue = "tempuser"; } using (var context = new BillsEntities()) { context.sp_DateOfEachBill(); } ViewBag.CurrentSort = sortOrder; if (searchString != null) { page = 1; } else { searchString = currentFilter; } ViewBag.CurrentFilter = searchString; ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "name_desc" : ""; ViewBag.DateSortParm = sortOrder == "Date" ? "date_desc" : "Date"; var upcomingbills = from up in db.UpcomingBills where up.UserID == userIdValue select up; if (!String.IsNullOrEmpty(searchString)) { upcomingbills = upcomingbills.Where(s => s.Name.Contains(searchString)); } switch (sortOrder) { case "Date": upcomingbills = upcomingbills.OrderBy(s => s.TheDate); break; default: upcomingbills = upcomingbills.OrderBy(s => s.TheDate); break; } int pageSize = 100; int pageNumber = (page ?? 1); return(View(upcomingbills.ToPagedList(pageNumber, pageSize))); }
public ActionResult UpdateUpcomingPaid(UpcomingBills_Alter upComingPaid) { using (BillsEntities entities = new BillsEntities()) { UpcomingBills_Alter updatedPaid = (from c in entities.UpcomingBills_Alter where c.id == upComingPaid.id select c).FirstOrDefault(); db.UpcomingBills_Alter.Add(upComingPaid); db.SaveChanges(); entities.sp_Cleanup_UpcomingBill_Alter(); entities.sp_DateOfEachBill(); entities.SaveChanges(); } return(RedirectToAction("Index", "UpcomingBills")); }