// GET: /Issue/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbl_Issue tbl_issue = db.tbl_Issue.Find(id); if (tbl_issue == null) { return(HttpNotFound()); } return(View(tbl_issue)); }
public JsonResult DeleteConfirmed(int id) { string success = string.Empty; // return Json(success, JsonRequestBehavior.AllowGet); tbl_Issue tbl_issue = db.tbl_Issue.Find(id); db.tbl_Issue.Remove(tbl_issue); int result = db.SaveChanges(); if (result > 0) { success = "Data delete successfully"; } // return Json(success, JsonRequestBehavior.AllowGet); return(Json(new { result = success })); }
public long SaveUpdateServiceIssue(ServiceIssueModel model) { ShomaRMEntities db = new ShomaRMEntities(); var userNameExists = db.tbl_Issue.Where(p => p.IssueID != model.IssueID && p.Issue == model.Issue).FirstOrDefault(); if (userNameExists == null) { if (model.IssueID == 0) { var IssueData = new tbl_Issue() { CausingIssueID = model.CausingIssueID, ServiceIssueID = model.ServiceIssueID, Issue = model.Issue, }; db.tbl_Issue.Add(IssueData); db.SaveChanges(); model.IssueID = IssueData.IssueID; } else { var SIssueData = db.tbl_Issue.Where(p => p.IssueID == model.IssueID).FirstOrDefault(); if (SIssueData != null) { SIssueData.CausingIssueID = model.CausingIssueID; SIssueData.ServiceIssueID = model.ServiceIssueID; SIssueData.Issue = model.Issue; db.SaveChanges(); } else { throw new Exception(model.Issue + " not exists in the system."); } } return(model.IssueID); } else { throw new Exception(model.Issue + " already exists in the system."); } }
public ActionResult Edit([Bind(Include = "id,GRN,demandNo,itemId,brandId,colorId,demandQty,receiveQty,issueQty,unitId,priceId,departmentId,dateTime,calanNo")] tbl_Issue tbl_issue) { if (ModelState.IsValid) { db.Entry(tbl_issue).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.brandId = new SelectList(db.tbl_Brand, "id", "name", tbl_issue.brandId); ViewBag.colorId = new SelectList(db.tbl_Color, "id", "name", tbl_issue.colorId); ViewBag.demandNo = new SelectList(db.tbl_Demand, "id", "demandNo", tbl_issue.demandNo); ViewBag.demandQty = new SelectList(db.tbl_Demand, "id", "demandNo", tbl_issue.demandQty); ViewBag.departmentId = new SelectList(db.tbl_Department, "id", "name", tbl_issue.departmentId); ViewBag.itemId = new SelectList(db.tbl_ItemMaster, "id", "name", tbl_issue.itemId); ViewBag.priceId = new SelectList(db.tbl_Price, "id", "id", tbl_issue.priceId); ViewBag.GRN = new SelectList(db.tbl_Receive, "id", "receiveNo", tbl_issue.GRN); ViewBag.receiveQty = new SelectList(db.tbl_Receive, "id", "receiveNo", tbl_issue.receiveQty); ViewBag.unitId = new SelectList(db.tbl_Unit, "id", "name", tbl_issue.unitId); return(View(tbl_issue)); }
// GET: /Issue/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbl_Issue tbl_issue = db.tbl_Issue.Find(id); if (tbl_issue == null) { return(HttpNotFound()); } ViewBag.brandId = new SelectList(db.tbl_Brand, "id", "name", tbl_issue.brandId); ViewBag.colorId = new SelectList(db.tbl_Color, "id", "name", tbl_issue.colorId); ViewBag.demandNo = new SelectList(db.tbl_Demand, "id", "demandNo", tbl_issue.demandNo); ViewBag.demandQty = new SelectList(db.tbl_Demand, "id", "demandQty", tbl_issue.demandQty); ViewBag.departmentId = new SelectList(db.tbl_Department, "id", "name", tbl_issue.departmentId); ViewBag.itemId = new SelectList(db.tbl_ItemMaster, "id", "name", tbl_issue.itemId); ViewBag.priceId = new SelectList(db.tbl_Price, "id", "price", tbl_issue.priceId); ViewBag.GRN = new SelectList(db.tbl_Receive, "id", "GRN", tbl_issue.GRN); ViewBag.receiveQty = new SelectList(db.tbl_Receive, "id", "receiveQty", tbl_issue.receiveQty); ViewBag.unitId = new SelectList(db.tbl_Unit, "id", "name", tbl_issue.unitId); return(View(tbl_issue)); }