public async Task <ActionResult> DeleteConfirmed(int id)
{
UpcomingBills_Alter upcomingBills_Alter = await db.UpcomingBills_Alter.FindAsync(id);
db.UpcomingBills_Alter.Remove(upcomingBills_Alter);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public ActionResult Update(UpcomingBills_Alter upcomingBill_alter)
{
using (BillsEntities entities = new BillsEntities())
{
db.UpcomingBills_Alter.Add(upcomingBill_alter);
db.SaveChanges();
entities.sp_Cleanup_UpcomingBill_Alter();
}
return(RedirectToAction("Index"));
}
public async Task <ActionResult> Edit([Bind(Include = "id,TheDate,DayOfWeek,Name,Amount,Type,UserID")] UpcomingBills_Alter upcomingBills_Alter)
{
if (ModelState.IsValid)
{
db.Entry(upcomingBills_Alter).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(upcomingBills_Alter));
}
public async Task <ActionResult> Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
UpcomingBills_Alter upcomingBills_Alter = await db.UpcomingBills_Alter.FindAsync(id);
if (upcomingBills_Alter == null)
{
return(HttpNotFound());
}
return(View(upcomingBills_Alter));
}
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"));
}
