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);
}
}
