public ActionResult Create([Bind(Include = "Bill,Cost,id,DayOfWeek,UserID")] WeeklyBill weeklyBill)
{
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";
}
if (ModelState.IsValid)
{
weeklyBill.UserID = userIdValue;
db.WeeklyBills.Add(weeklyBill);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(weeklyBill));
}
public ActionResult Create([Bind(Include = "id,KeyBalance1,DateTime,UserID")] KeyBalance keyBalance)
{
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";
}
if (ModelState.IsValid)
{
keyBalance.UserID = userIdValue;
db.KeyBalances.Add(keyBalance);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(keyBalance));
}
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 System.Web.Mvc.JsonResult InsertMonthlyBills(MonthlyBill monthlyBill)
{
using (BillsEntities entities = new BillsEntities())
{
entities.MonthlyBills.Add(monthlyBill);
entities.SaveChanges();
}
return(Json(monthlyBill));
}
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 Create([Bind(Include = "id,Name,amount,DayOfWeek,Frequency,PickOnePayDate,UserID")] BringHomePay bringHomePay)
{
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";
}
if (ModelState.IsValid)
{
bringHomePay.UserID = userIdValue;
db.BringHomePays.Add(bringHomePay);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(bringHomePay));
}
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"));
}
