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));
}
// 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 PartialViewResult InsertWeekly(WeeklyBill weeklyBillInsert)
{
string ASPUser = GetUserId();
var mgr = new GetBills();
mgr.InsertWeekly(weeklyBillInsert, ASPUser);
var model = new BillsViewModel();
model.WeeklyBills = mgr.getWeeklyBills(ASPUser);
return(PartialView("_PartialWeekly", model));
}
public bool UpdateWeekly(WeeklyBill weeklyBill)
{
string ASPUser = GetUserId();
var mgr = new GetBills();
mgr.UpdateWeekly(weeklyBill);
//var model = new BillsViewModel();
//model.WeeklyBills = mgr.getWeeklyBills(ASPUser);
//return PartialView("_PartialWeekly", model);
return(true);
}
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 bool UpdateWeekly(WeeklyBill weeklyBill)
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("id", weeklyBill.id);
parameters.Add("Bill", weeklyBill.Bill);
parameters.Add("Cost", weeklyBill.Cost);
parameters.Add("DayOfWeek", weeklyBill.DayOfWeek);
var procResponse = new Instance <dynamic>().Execute("dbo.updateWeeklyBills", parameters);
if (procResponse != null)
{
return(true);
}
return(false);
}
public bool InsertWeekly(WeeklyBill weeklyBill, string ASPUser)
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("Bill", weeklyBill.Bill);
parameters.Add("Cost", weeklyBill.Cost);
parameters.Add("DayOfWeek", weeklyBill.DayOfWeek);
parameters.Add("UserID", ASPUser); // TODO use ASP User once login added
var procResponse = new Instance <dynamic>().Execute("dbo.insertWeeklyBills", parameters);
if (procResponse != null)
{
return(true);
}
return(false);
}
