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