public System.Web.Mvc.JsonResult InsertMonthlyBills(MonthlyBill monthlyBill)
{
using (BillsEntities entities = new BillsEntities())
{
entities.MonthlyBills.Add(monthlyBill);
entities.SaveChanges();
}
return(Json(monthlyBill));
}
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"));
}
// 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)));
}
// GET: WeeklyBills/Delete/5
//public ActionResult Delete(int? id)
//{
// if (id == null)
// {
// return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
// }
// WeeklyBill weeklyBill = db.WeeklyBills.Find(id);
// if (weeklyBill == null)
// {
// return HttpNotFound();
// }
// return View(weeklyBill);
//}
//[HttpPost]
//, ActionName("Delete")
//[ValidateAntiForgeryToken]
public ActionResult Deletejq(int?id)
{
using (BillsEntities entities = new BillsEntities())
{
WeeklyBill weeklyBill = db.WeeklyBills.Find(id);
db.WeeklyBills.Remove(weeklyBill);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult Delete(int id)
{
using (BillsEntities entities = new BillsEntities())
{
MonthlyBill mb = (from c in entities.MonthlyBills
where c.id == id
select c).FirstOrDefault();
entities.MonthlyBills.Remove(mb);
entities.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult UpdateWeeklyBills(WeeklyBill weeklyBill)
{
using (BillsEntities entities = new BillsEntities())
{
WeeklyBill updatedBills = (from c in entities.WeeklyBills
where c.id == weeklyBill.id
select c).FirstOrDefault();
updatedBills.Bill = weeklyBill.Bill;
updatedBills.Cost = weeklyBill.Cost;
updatedBills.DayOfWeek = weeklyBill.DayOfWeek;
entities.SaveChanges();
}
return(new EmptyResult());
}
public ActionResult UpdateMonthlyPaid(MonthlyBill monthlyPaid)
{
using (BillsEntities entities = new BillsEntities())
{
MonthlyBill updatedPaid = (from c in entities.MonthlyBills
where c.id == monthlyPaid.id
select c).FirstOrDefault();
updatedPaid.Paid_ = monthlyPaid.Paid_;
entities.SaveChanges();
}
//return View(monthlyBill);
return(RedirectToAction("Index"));
}
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"));
}
public ActionResult UpdateMonthlyBills(MonthlyBill monthlyBill)
{
using (BillsEntities entities = new BillsEntities())
{
MonthlyBill updatedBills = (from c in entities.MonthlyBills
where c.id == monthlyBill.id
select c).FirstOrDefault();
updatedBills.Bill = monthlyBill.Bill;
updatedBills.Date = monthlyBill.Date;
updatedBills.Cost = monthlyBill.Cost;
updatedBills.Paid_ = monthlyBill.Paid_;
entities.SaveChanges();
}
//return View(monthlyBill);
return(RedirectToAction("Index"));
}
public ActionResult Update(BringHomePay bringHomePay)
{
using (BillsEntities entities = new BillsEntities())
{
BringHomePay updateBringHome = (from b in entities.BringHomePays
where b.id == bringHomePay.id
select b).FirstOrDefault();
updateBringHome.amount = bringHomePay.amount;
updateBringHome.Name = bringHomePay.Name;
updateBringHome.Frequency = bringHomePay.Frequency;
updateBringHome.DayOfWeek = bringHomePay.DayOfWeek;
updateBringHome.PickOnePayDate = bringHomePay.PickOnePayDate;
entities.SaveChanges();
}
return(RedirectToAction("Index"));
}
