public ActionResult EditWellClass(int id) { var wellClass = new WellClass(); try { if (id < 1) { wellClass.Error = "Invalid Selection!"; wellClass.ErrorCode = -1; return(Json(wellClass, JsonRequestBehavior.AllowGet)); } var myViewObj = new WellClasServices().GetWellClass(id); if (myViewObj == null || myViewObj.WellClassId < 1) { wellClass.Error = "Well Class Information could not be retrieved."; wellClass.ErrorCode = -1; return(Json(wellClass, JsonRequestBehavior.AllowGet)); } Session["_wellClass"] = myViewObj; myViewObj.ErrorCode = myViewObj.WellClassId; return(Json(myViewObj, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message); wellClass.Error = "An unknown error was Well Class Information could not be retrieved."; wellClass.ErrorCode = -1; return(Json(wellClass, JsonRequestBehavior.AllowGet)); } }
public int UpdateWellClassCheckDuplicate(WellClass wellClass) { try { if (wellClass == null) { return(-2); } using (var db = new DPRDataMigrationEngineDBEntities()) { if (db.WellClasses.Any()) { if (db.WellClasses.Count(m => m.Name.ToLower().Replace(" ", string.Empty) == wellClass.Name.ToLower().Replace(" ", string.Empty) && m.WellClassId != wellClass.WellClassId) > 0) { return(-3); } } db.WellClasses.Attach(wellClass); db.Entry(wellClass).State = EntityState.Modified; return(db.SaveChanges()); } } catch (Exception ex) { ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message); return(0); } }
public ActionResult DeleteWellClass(int id) { var wellClass = new WellClass(); try { if (id < 1) { wellClass.Error = "Invalid Selection"; wellClass.ErrorCode = 0; return(Json(wellClass, JsonRequestBehavior.AllowGet)); } if (new WellClasServices().DeleteWellClassCheckReferences(id)) { wellClass.Error = "Well Class Information was successfully deleted."; wellClass.ErrorCode = 1; return(Json(wellClass, JsonRequestBehavior.AllowGet)); } wellClass.Error = "Process Failed! Please try again later"; wellClass.ErrorCode = 0; return(Json(wellClass, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message); wellClass.Error = "An unknown error was encountered. Please contact the Administrator or try again later."; wellClass.ErrorCode = 0; return(Json(wellClass, JsonRequestBehavior.AllowGet)); } }
public ActionResult AddWellClass(WellClass wellClass) { ModelState.Clear(); ViewBag.LoadStatus = "0"; try { if (!ModelState.IsValid) { wellClass.Error = "Please supply all required fields and try again"; wellClass.ErrorCode = -1; return(Json(wellClass, JsonRequestBehavior.AllowGet)); } var wx = ValidateControl(wellClass); if (wx.Code < 1) { wellClass.Error = wx.Error; wellClass.ErrorCode = -1; return(Json(wellClass, JsonRequestBehavior.AllowGet)); } var k = new WellClasServices().AddWellClassCheckDuplicate(wellClass); if (k < 1) { if (k == -3) { wellClass.Error = "Well Class already exists"; wellClass.ErrorCode = -3; return(Json(wellClass, JsonRequestBehavior.AllowGet)); } wellClass.Error = "Process Failed! Please contact the Admin or try again later"; wellClass.ErrorCode = 0; return(Json(wellClass, JsonRequestBehavior.AllowGet)); } wellClass.Error = "Record was added successfully"; wellClass.ErrorCode = 1; wellClass.WellClassId = k; return(Json(wellClass, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message); wellClass.Error = "An unknown error was encountered. Request could not be serviced. Please try again later."; wellClass.ErrorCode = 0; return(Json(wellClass, JsonRequestBehavior.AllowGet)); } }
public int CreateWellClassAddClassification(string wellClassName, int wellId) { try { using (var db = new DPRDataMigrationEngineDBEntities()) { var myObj = db.WellClasses.Where(s => s.Name.ToLower().Replace(" ", string.Empty).Trim() == wellClassName.ToLower().Replace(" ", string.Empty).Trim()).ToList(); if (!myObj.Any()) { var wellClass = new WellClass { Name = wellClassName.Trim() }; var processedWellClass = db.WellClasses.Add(wellClass); db.SaveChanges(); if (processedWellClass.WellClassId > 0) { var newWellClassification = new WellClassification { WellClassId = processedWellClass.WellClassId, WellId = wellId }; var processedWellClassification = new WellClassificationServices().AddWellClassificationCheckDuplicate(newWellClassification); return(processedWellClassification); } } var edt = new WellClassification { WellClassId = myObj[0].WellClassId, WellId = wellId }; var dsx = new WellClassificationServices().AddWellClassificationCheckDuplicate(edt); return(dsx); } } catch (Exception ex) { ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message); return(0); } }
private static GenericValidator ValidateControl(WellClass model) { var gVal = new GenericValidator(); try { if (string.IsNullOrEmpty(model.Name.Trim())) { gVal.Error = "Please enter WellClass Name."; gVal.Code = 0; return(gVal); } gVal.Code = 1; return(gVal); } catch (Exception ex) { gVal.Error = "Process validation failed. Please supply all required fields and try again."; gVal.Code = 0; return(gVal); } }
public ActionResult EditWellClass(WellClass wellClass) { ModelState.Clear(); ViewBag.LoadStatus = "0"; try { if (Session["_wellClass"] == null) { wellClass.Error = "Session has expired"; wellClass.ErrorCode = 0; return(Json(wellClass, JsonRequestBehavior.AllowGet)); } var oldWellClass = Session["_wellClass"] as WellClass; if (oldWellClass == null || oldWellClass.WellClassId < 1) { wellClass.Error = "Session has expired"; wellClass.ErrorCode = 0; return(Json(wellClass, JsonRequestBehavior.AllowGet)); } if (!ModelState.IsValid) { wellClass.Error = "Please supply all required fields and try again"; wellClass.ErrorCode = -1; return(Json(wellClass, JsonRequestBehavior.AllowGet)); } var wx = ValidateControl(wellClass); if (wx.Code < 1) { wellClass.Error = wx.Error; wellClass.ErrorCode = -1; return(Json(wellClass, JsonRequestBehavior.AllowGet)); } oldWellClass.Name = wellClass.Name; oldWellClass.Description = wellClass.Description; var k = new WellClasServices().UpdateWellClassCheckDuplicate(oldWellClass); if (k < 1) { if (k == -3) { wellClass.Error = "Well Class already exists"; wellClass.ErrorCode = 0; return(Json(wellClass, JsonRequestBehavior.AllowGet)); } wellClass.Error = "Process Failed! Please contact the Admin or try again later"; wellClass.ErrorCode = 0; return(Json(wellClass, JsonRequestBehavior.AllowGet)); } wellClass.Error = "Well Class Information was successfully updated"; wellClass.ErrorCode = 1; return(Json(wellClass, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message); wellClass.Error = "An unknown error was encountered. Request could not be serviced. Please try again later."; wellClass.ErrorCode = 0; return(Json(wellClass, JsonRequestBehavior.AllowGet)); } }