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