// GET: CSCASEs/Create public ActionResult Create() { CSCASE curRec = new CSCASE(); curRec.STAMP = 1; return(View(curRec)); }
public ActionResult Edit([Bind(Include = "CASECODE,CASEDESC,MAPSFIX,STAMP")] CSCASE cSCASE) { if (ModelState.IsValid) { ASIDBConnection newdb = new ASIDBConnection(); try { CSCASE curRec = newdb.CSCASEs.Find(cSCASE.CASECODE); if (curRec.STAMP == cSCASE.STAMP) { cSCASE.STAMP = cSCASE.STAMP + 1; db.Entry(cSCASE).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } else { ModelState.AddModelError(string.Empty, "Record is modified"); } } catch (Exception e) { ModelState.AddModelError(string.Empty, e.Message); } finally { newdb.Dispose(); } } return(View(cSCASE)); }
public ActionResult DeleteConfirmed(string id) { CSCASE cSCASE = db.CSCASEs.Find(MyHtmlHelpers.ConvertByteStrToId(id)); db.CSCASEs.Remove(cSCASE); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Create([Bind(Include = "CASECODE,CASEDESC,MAPSFIX,STAMP")] CSCASE cSCASE) { if (ModelState.IsValid) { try { db.CSCASEs.Add(cSCASE); db.SaveChanges(); return(RedirectToAction("Index")); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { //string message = string.Format("{0}:{1}", // validationErrors.Entry.Entity.ToString(), // validationError.ErrorMessage); // raise a new exception nesting // the current instance as InnerException ModelState.AddModelError(validationError.PropertyName, validationError.ErrorMessage); } } } catch (DbUpdateException ex) { UpdateException updateException = (UpdateException)ex.InnerException; if (updateException != null) { if (updateException.InnerException != null) { var sqlException = (FirebirdSql.Data.FirebirdClient.FbException)updateException.InnerException; foreach (var error in sqlException.Errors) { if (error.Message != null) { ModelState.AddModelError(string.Empty, error.Message); } } } else { ModelState.AddModelError(string.Empty, updateException.Message); } } else { ModelState.AddModelError(string.Empty, updateException.Message); } } } return(View(cSCASE)); }
public ActionResult Create([Bind(Include = "CASECODE,CASEDESC,MAPSFIX,STAMP")] CSCASE cSCASE) { if (ModelState.IsValid) { db.CSCASEs.Add(cSCASE); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(cSCASE)); }
public ActionResult DeleteConfirmed(string id) { CSCASE cSCASE = db.CSCASEs.Find(MyHtmlHelpers.ConvertByteStrToId(id)); try { db.CSCASEs.Remove(cSCASE); db.SaveChanges(); return(RedirectToAction("Index")); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { //string message = string.Format("{0}:{1}", // validationErrors.Entry.Entity.ToString(), // validationError.ErrorMessage); // raise a new exception nesting // the current instance as InnerException ModelState.AddModelError(validationError.PropertyName, validationError.ErrorMessage); } } } catch (DbUpdateException ex) { UpdateException updateException = (UpdateException)ex.InnerException; if (updateException != null) { if (updateException.InnerException != null) { var sqlException = (FirebirdSql.Data.FirebirdClient.FbException)updateException.InnerException; foreach (var error in sqlException.Errors) { if (error.Message != null) { ModelState.AddModelError(string.Empty, error.Message); } } } else { ModelState.AddModelError(string.Empty, updateException.Message); } } else { ModelState.AddModelError(string.Empty, updateException.Message); } } return(View(cSCASE)); }
// GET: CSCASEs/Details/5 public ActionResult Details(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CSCASE cSCASE = db.CSCASEs.Find(MyHtmlHelpers.ConvertByteStrToId(id)); if (cSCASE == null) { return(HttpNotFound()); } return(View(cSCASE)); }
public ActionResult EditJobCase(CSBILL cSBILL) { string UseView = "Partial/EditJobCase"; ModelState.Remove("JOBNO"); ModelState.Remove("CASENO"); ModelState.Remove("CASECODE"); ModelState.Remove("JOBCASE"); ModelState.Remove("ITEMDESC"); ModelState.Remove("ITEMSPEC"); ModelState.Remove("ITEMTYPE"); ModelState.Remove("TAXRATE"); ModelState.Remove("ITEMAMT1"); ModelState.Remove("ITEMAMT2"); ModelState.Remove("TAXAMT1"); ModelState.Remove("TAXAMT2"); //ModelState.Clear(); CSJOBD csRec = db.CSJOBDs.Find(cSBILL.JOBNO, cSBILL.CASENO); if (csRec != null) { cSBILL.CASECODE = csRec.CASECODE; CSCASE csCase = db.CSCASEs.Find(csRec.CASECODE); if (csCase != null) { cSBILL.ITEMDESC = csCase.CASEDESC; cSBILL.ITEMSPEC = csRec.CASEMEMO; } } else { UseView = "Partial/EditJobCaseNoJOBD"; ViewBag.CASECODE = new SelectList(db.CSCASEs, "CASECODE", "CASEDESC", cSBILL.CASECODE); } ViewBag.TAXCODE = new SelectList(db.CSTAXTYPEs.Select(s => new { TAXCODE = s.TAXCODE, TAXDESC = s.TAXTYPE + "|" + s.TAXRCODE + "|" + s.TAXRATE.ToString() + "|" + s.EFFECTIVE_START.ToString() + "|" + s.EFFECTIVE_END.ToString() + "|" + s.TAXDESC }), "TAXCODE", "TAXDESC", cSBILL.TAXCODE); ViewBag.ITEMTYPE = new SelectList(db.CSITEMs, "ITEMTYPE", "ITEMDESC", cSBILL.ITEMTYPE); return(PartialView(UseView, cSBILL)); }
public ActionResult Edit([Bind(Include = "CASECODE,CASEDESC,MAPSFIX,STAMP")] CSCASE cSCASE) { if (ModelState.IsValid) { ASIDBConnection newdb = new ASIDBConnection(); try { CSCASE curRec = newdb.CSCASEs.Find(cSCASE.CASECODE); if (curRec.STAMP == cSCASE.STAMP) { cSCASE.STAMP = cSCASE.STAMP + 1; db.Entry(cSCASE).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } else { ModelState.AddModelError(string.Empty, "Record is modified"); } } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { //string message = string.Format("{0}:{1}", // validationErrors.Entry.Entity.ToString(), // validationError.ErrorMessage); // raise a new exception nesting // the current instance as InnerException ModelState.AddModelError(validationError.PropertyName, validationError.ErrorMessage); } } } catch (DbUpdateException ex) { UpdateException updateException = (UpdateException)ex.InnerException; if (updateException != null) { if (updateException.InnerException != null) { var sqlException = (FirebirdSql.Data.FirebirdClient.FbException)updateException.InnerException; foreach (var error in sqlException.Errors) { if (error.Message != null) { ModelState.AddModelError(string.Empty, error.Message); } } } else { ModelState.AddModelError(string.Empty, updateException.Message); } } else { ModelState.AddModelError(string.Empty, updateException.Message); } } catch (Exception e) { ModelState.AddModelError(string.Empty, e.Message); } finally { newdb.Dispose(); } } return(View(cSCASE)); }