public int Create(ReceiptBody t) { int result = 0; try { //Initiate the instance of DBContext using BillingContext context = new BillingContext(); //check specific record for same ReceiptNo is exist or not var receipt = context.ReceiptBodies.FirstOrDefault(c => c.ReceiptNo == t.ReceiptNo); if (receipt == null) { //adding receiptbody object to context context.Add(t); //save changes return(result = context.SaveChanges()); } else { context.Update(t); return(result = context.SaveChanges()); } } catch (Exception ex) { Exc.ErMessage(ex); return(result = 0); } }
public ActionResult DeleteConfirmed(int id) { ReceiptBody receiptBody = db.ReceiptBodies.Find(id); db.ReceiptBodies.Remove(receiptBody); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "ReceiptBodyID,LineTotal,ReceiptHeaderID,TemplateID")] ReceiptBody receiptBody) { if (ModelState.IsValid) { db.Entry(receiptBody).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ReceiptHeaderID = new SelectList(db.ReceiptHeaders, "ReceiptHeaderID", "ReceiptHeaderID", receiptBody.ReceiptHeaderID); ViewBag.TemplateID = new SelectList(db.Templates, "TemplateID", "Description", receiptBody.TemplateID); return(View(receiptBody)); }
public ActionResult Create([Bind(Include = "ReceiptBodyID,LineTotal,ReceiptHeaderID,TemplateID")] ReceiptBody receiptBody) { if (ModelState.IsValid) { _db.ReceiptBodies.Add(receiptBody); _db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ReceiptHeaderID = new SelectList(_db.ReceiptHeaders, "ReceiptHeaderID", "ReceiptHeaderID", receiptBody.ReceiptHeaderID); ViewBag.TemplateID = new SelectList(_db.Templates, "TemplateID", "Description", receiptBody.TemplateID); return(View(receiptBody)); }
// GET: ReceiptBodies/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ReceiptBody receiptBody = db.ReceiptBodies.Find(id); if (receiptBody == null) { return(HttpNotFound()); } return(View(receiptBody)); }
public int Update(ReceiptBody t) { int result = 0; try { using BillingContext context = new BillingContext(); context.Update(t); return(result = context.SaveChanges()); } catch (Exception ex) { Exc.ErMessage(ex); return(result); } }
// GET: ReceiptBodies/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ReceiptBody receiptBody = db.ReceiptBodies.FirstOrDefault(x => x.ReceiptBodyID == id); if (receiptBody == null) { return(HttpNotFound()); } ViewBag.ReceiptHeaderID = new SelectList(db.ReceiptHeaders, "ReceiptHeaderID", "ReceiptHeaderID", receiptBody.ReceiptHeaderID); ViewBag.TemplateID = new SelectList(db.Templates, "TemplateID", "Description", receiptBody.TemplateID); return(View(receiptBody)); }