public ActionResult EditWellCompletionType(int id) { var wellCompletionType = new WellCompletionType(); try { if (id < 1) { wellCompletionType.Error = "Invalid Selection!"; wellCompletionType.ErrorCode = -1; return(Json(wellCompletionType, JsonRequestBehavior.AllowGet)); } var myViewObj = new WellCompletionTypeServices().GetWellCompletionType(id); if (myViewObj == null || myViewObj.WellCompletionTypeId < 1) { wellCompletionType.Error = "Well Completion Type Information could not be retrieved."; wellCompletionType.ErrorCode = -1; return(Json(wellCompletionType, JsonRequestBehavior.AllowGet)); } Session["_wellCompletionType"] = myViewObj; myViewObj.ErrorCode = myViewObj.WellCompletionTypeId; return(Json(myViewObj, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message); wellCompletionType.Error = "An unknown error was Well Completion Type Information could not be retrieved."; wellCompletionType.ErrorCode = -1; return(Json(wellCompletionType, JsonRequestBehavior.AllowGet)); } }
public ActionResult DeleteWellCompletionType(int id) { var wellCompletionType = new WellCompletionType(); try { if (id < 1) { wellCompletionType.Error = "Invalid Selection"; wellCompletionType.ErrorCode = 0; return(Json(wellCompletionType, JsonRequestBehavior.AllowGet)); } if (new WellCompletionTypeServices().DeleteWellCompletionTypeCheckReferences(id)) { wellCompletionType.Error = "Well Completion Type Information was successfully deleted."; wellCompletionType.ErrorCode = 1; return(Json(wellCompletionType, JsonRequestBehavior.AllowGet)); } wellCompletionType.Error = "Process Failed! Please try again later"; wellCompletionType.ErrorCode = 0; return(Json(wellCompletionType, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message); wellCompletionType.Error = "An unknown error was encountered. Please contact the Administrator or try again later."; wellCompletionType.ErrorCode = 0; return(Json(wellCompletionType, JsonRequestBehavior.AllowGet)); } }
public int UpdateWellCompletionTypeCheckDuplicate(WellCompletionType wellCompletionType) { try { if (wellCompletionType == null) { return(-2); } using (var db = new DPRDataMigrationEngineDBEntities()) { if (db.WellCompletionTypes.Any()) { if (db.WellCompletionTypes.Count(m => m.Type.ToLower().Replace(" ", string.Empty) == wellCompletionType.Type.ToLower().Replace(" ", string.Empty) && m.WellCompletionTypeId != wellCompletionType.WellCompletionTypeId) > 0) { return(-3); } } db.WellCompletionTypes.Attach(wellCompletionType); db.Entry(wellCompletionType).State = EntityState.Modified; return(db.SaveChanges()); } } catch (Exception ex) { ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message); return(0); } }
public ActionResult AddWellCompletionType(WellCompletionType wellCompletionType) { ModelState.Clear(); ViewBag.LoadStatus = "0"; try { if (!ModelState.IsValid) { wellCompletionType.Error = "Please supply all required fields and try again"; wellCompletionType.ErrorCode = -1; return(Json(wellCompletionType, JsonRequestBehavior.AllowGet)); } var wx = ValidateControl(wellCompletionType); if (wx.Code < 1) { wellCompletionType.Error = wx.Error; wellCompletionType.ErrorCode = -1; return(Json(wellCompletionType, JsonRequestBehavior.AllowGet)); } var k = new WellCompletionTypeServices().AddWellCompletionTypeCheckDuplicate(wellCompletionType); if (k < 1) { if (k == -3) { wellCompletionType.Error = "Well Completion Type already exists"; wellCompletionType.ErrorCode = 0; return(Json(wellCompletionType, JsonRequestBehavior.AllowGet)); } wellCompletionType.Error = "Process Failed! Please contact the Admin or try again later"; wellCompletionType.ErrorCode = 0; return(Json(wellCompletionType, JsonRequestBehavior.AllowGet)); } wellCompletionType.Error = "Record was added successfully"; wellCompletionType.ErrorCode = 1; wellCompletionType.WellCompletionTypeId = k; return(Json(wellCompletionType, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message); wellCompletionType.Error = "An unknown error was encountered. Request could not be serviced. Please try again later."; wellCompletionType.ErrorCode = 0; return(Json(wellCompletionType, JsonRequestBehavior.AllowGet)); } }
private static GenericValidator ValidateControl(WellCompletionType model) { var gVal = new GenericValidator(); try { if (string.IsNullOrEmpty(model.Type.Trim())) { gVal.Error = "Please enter Well Completion Type 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 EditWellCompletionType(WellCompletionType wellCompletionType) { ModelState.Clear(); ViewBag.LoadStatus = "0"; try { if (Session["_wellCompletionType"] == null) { wellCompletionType.Error = "Session has expired"; wellCompletionType.ErrorCode = 0; return(Json(wellCompletionType, JsonRequestBehavior.AllowGet)); } var oldWellCompletionType = Session["_wellCompletionType"] as WellCompletionType; if (oldWellCompletionType == null || oldWellCompletionType.WellCompletionTypeId < 1) { wellCompletionType.Error = "Session has expired"; wellCompletionType.ErrorCode = 0; return(Json(wellCompletionType, JsonRequestBehavior.AllowGet)); } if (!ModelState.IsValid) { wellCompletionType.Error = "Please supply all required fields and try again"; wellCompletionType.ErrorCode = -1; return(Json(wellCompletionType, JsonRequestBehavior.AllowGet)); } var wx = ValidateControl(wellCompletionType); if (wx.Code < 1) { wellCompletionType.Error = wx.Error; wellCompletionType.ErrorCode = -1; return(Json(wellCompletionType, JsonRequestBehavior.AllowGet)); } oldWellCompletionType.Type = wellCompletionType.Type; var k = new WellCompletionTypeServices().UpdateWellCompletionTypeCheckDuplicate(oldWellCompletionType); if (k < 1) { if (k == -3) { wellCompletionType.Error = "Well Completion Type already exists"; wellCompletionType.ErrorCode = 0; return(Json(wellCompletionType, JsonRequestBehavior.AllowGet)); } wellCompletionType.Error = "Process Failed! Please contact the Admin or try again later"; wellCompletionType.ErrorCode = 0; return(Json(wellCompletionType, JsonRequestBehavior.AllowGet)); } wellCompletionType.Error = "Well Completion Type Information was successfully updated"; wellCompletionType.ErrorCode = 1; return(Json(wellCompletionType, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message); wellCompletionType.Error = "An unknown error was encountered. Request could not be serviced. Please try again later."; wellCompletionType.ErrorCode = 0; return(Json(wellCompletionType, JsonRequestBehavior.AllowGet)); } }