public ActionResult EditWellWorkOverReason(int id) { var wellWorkOverReason = new WellWorkOverReason(); try { if (id < 1) { wellWorkOverReason.Error = "Invalid Selection!"; wellWorkOverReason.ErrorCode = -1; return(Json(wellWorkOverReason, JsonRequestBehavior.AllowGet)); } var myViewObj = new WellWorkOverReasonServices().GetWellWorkOverReason(id); if (myViewObj == null || myViewObj.WellWorkOverReasonId < 1) { wellWorkOverReason.Error = "Well Workover Reason Information could not be retrieved."; wellWorkOverReason.ErrorCode = -1; return(Json(wellWorkOverReason, JsonRequestBehavior.AllowGet)); } Session["_wellWorkOverReason"] = myViewObj; myViewObj.ErrorCode = myViewObj.WellWorkOverReasonId; return(Json(myViewObj, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message); wellWorkOverReason.Error = "An unknown error was Well Workover Reason Information could not be retrieved."; wellWorkOverReason.ErrorCode = -1; return(Json(wellWorkOverReason, JsonRequestBehavior.AllowGet)); } }
public ViewResult WellWorkOverReasons() { var wellWorkOverReasonList = new WellWorkOverReasonServices().GetAllOrderedWellWorkOverReasons() ?? new List <WellWorkOverReason>(); if (!wellWorkOverReasonList.Any()) { ViewBag.Title = "Well Workover Reason SetUp"; return(View(wellWorkOverReasonList)); } wellWorkOverReasonList.Remove(wellWorkOverReasonList.Find(m => m.WellWorkOverReasonId == (int)OtherNotAvailable.Not_Available)); ViewBag.Title = "Manage Well Workover Reasons"; return(View(wellWorkOverReasonList)); }
public ActionResult AddWellWorkOverReason(WellWorkOverReason wellWorkOverReason) { ModelState.Clear(); ViewBag.LoadStatus = "0"; try { if (!ModelState.IsValid) { wellWorkOverReason.Error = "Please supply all required fields and try again"; wellWorkOverReason.ErrorCode = -1; return(Json(wellWorkOverReason, JsonRequestBehavior.AllowGet)); } var wx = ValidateControl(wellWorkOverReason); if (wx.Code < 1) { wellWorkOverReason.Error = wx.Error; wellWorkOverReason.ErrorCode = -1; return(Json(wellWorkOverReason, JsonRequestBehavior.AllowGet)); } var k = new WellWorkOverReasonServices().AddWellWorkOverReason(wellWorkOverReason); if (k < 1) { if (k == -3) { wellWorkOverReason.Error = "Well Workover Reason already exists"; wellWorkOverReason.ErrorCode = -3; return(Json(wellWorkOverReason, JsonRequestBehavior.AllowGet)); } wellWorkOverReason.Error = "Process Failed! Please contact the Admin or try again later"; wellWorkOverReason.ErrorCode = 0; return(Json(wellWorkOverReason, JsonRequestBehavior.AllowGet)); } wellWorkOverReason.Error = "Record was added successfully"; wellWorkOverReason.ErrorCode = 1; wellWorkOverReason.WellWorkOverReasonId = k; return(Json(wellWorkOverReason, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message); wellWorkOverReason.Error = "An unknown error was encountered. Request could not be serviced. Please try again later."; wellWorkOverReason.ErrorCode = 0; return(Json(wellWorkOverReason, JsonRequestBehavior.AllowGet)); } }
public ActionResult EditWellWorkOverReason(WellWorkOverReason wellWorkOverReason) { ModelState.Clear(); ViewBag.LoadStatus = "0"; try { if (Session["_wellWorkOverReason"] == null) { wellWorkOverReason.Error = "Session has expired"; wellWorkOverReason.ErrorCode = 0; return(Json(wellWorkOverReason, JsonRequestBehavior.AllowGet)); } var oldWellWorkOverReason = Session["_wellWorkOverReason"] as WellWorkOverReason; if (oldWellWorkOverReason == null || oldWellWorkOverReason.WellWorkOverReasonId < 1) { wellWorkOverReason.Error = "Session has expired"; wellWorkOverReason.ErrorCode = 0; return(Json(wellWorkOverReason, JsonRequestBehavior.AllowGet)); } if (!ModelState.IsValid) { wellWorkOverReason.Error = "Please supply all required fields and try again"; wellWorkOverReason.ErrorCode = -1; return(Json(wellWorkOverReason, JsonRequestBehavior.AllowGet)); } var wx = ValidateControl(wellWorkOverReason); if (wx.Code < 1) { wellWorkOverReason.Error = wx.Error; wellWorkOverReason.ErrorCode = -1; return(Json(wellWorkOverReason, JsonRequestBehavior.AllowGet)); } oldWellWorkOverReason.Title = wellWorkOverReason.Title; oldWellWorkOverReason.Description = wellWorkOverReason.Description; var k = new WellWorkOverReasonServices().UpdateWellWorkOverReason(oldWellWorkOverReason); if (k < 1) { if (k == -3) { wellWorkOverReason.Error = "Well Workover Reason already exists"; wellWorkOverReason.ErrorCode = 0; return(Json(wellWorkOverReason, JsonRequestBehavior.AllowGet)); } wellWorkOverReason.Error = "Process Failed! Please contact the Admin or try again later"; wellWorkOverReason.ErrorCode = 0; return(Json(wellWorkOverReason, JsonRequestBehavior.AllowGet)); } wellWorkOverReason.Error = "Well Workover Reason Information was successfully updated"; wellWorkOverReason.ErrorCode = 1; return(Json(wellWorkOverReason, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message); wellWorkOverReason.Error = "An unknown error was encountered. Request could not be serviced. Please try again later."; wellWorkOverReason.ErrorCode = 0; return(Json(wellWorkOverReason, JsonRequestBehavior.AllowGet)); } }
private WellWorkover ProcessRecord(DataRowView dv, ref string msg) { if (dv == null) { return(null); } try { var wellName = dv.Row["well_name"].ToString().Replace(" ", "").Replace(",", "").Trim(); if (string.IsNullOrEmpty(wellName.Trim())) { return(null); } var mInfo = new WellWorkover { WellName = wellName, }; var ttcg = new WellServices().GetWellIdByName(wellName); if (ttcg < 1) { msg = "Well Information could not be processed"; return(null); } mInfo.WellId = ttcg; var year = dv.Row["workover_Completion_year(yyyy)"].ToString().Trim(); long outYear; var yrResult = long.TryParse(year, out outYear); if (!yrResult && outYear < 1) { msg = "Invalid Workover Completion Year."; return(null); } else { mInfo.Year = outYear; } //workover_Completion_year(yyyy) var month = dv.Row["workover_Completion_month(MM)"].ToString().Trim(); int outMonth; var mnResult = int.TryParse(month, out outMonth); if (!mnResult && outMonth < 1) { msg = "Invalid Workover Completion Month."; return(null); } else { mInfo.Month = outMonth; } mInfo.DateCompleted = outYear + "/" + outMonth + "/01"; if (!string.IsNullOrEmpty(dv.Row["equipment_used"].ToString().Trim())) { var dfv = dv.Row["equipment_used"].ToString().Trim(); var equipmentId = new EquipmentServices().GetEquipmentId(dfv); if (equipmentId < 1) { msg = "Equipment Information could not be processed"; return(null); } mInfo.EquipmentId = equipmentId; } else { msg = "Equipment used is empty."; return(null); } var reason = dv.Row["workover_reason"].ToString().Trim(); if (!string.IsNullOrEmpty(reason)) { var dfv = reason; var reasonId = new WellWorkOverReasonServices().GetWellWorkOverReasonIdByName(dfv); if (reasonId < 1) { msg = "Workover Reason Information could not be processed"; return(null); } mInfo.WellWorkOverReasonId = reasonId; } else { msg = "Workover Reason is empty"; return(null); } var status = new WellWorkoverServices().AddWellWorkoverCheckDuplicates(mInfo, mInfo.WellId, mInfo.WellWorkOverReasonId, mInfo.Month, mInfo.Year); if (status < 1) { if (status == -3) { msg = "Well workover for the same Period, Reason and Equipment already exists for this well."; return(null); } msg = "An error encountered during upload."; return(null); } mInfo.WellWorkOverId = status; return(mInfo); } catch (Exception ex) { ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message); return(null); } }