public ActionResult EditWellType(int id)
{
var wellType = new WellType();
try
{
if (id < 1)
{
wellType.Error = "Invalid Selection!";
wellType.ErrorCode = -1;
return(Json(wellType, JsonRequestBehavior.AllowGet));
}
var myViewObj = new WellTypeServices().GetWellType(id);
if (myViewObj == null || myViewObj.WellTypeId < 1)
{
wellType.Error = "Well Type Information could not be retrieved.";
wellType.ErrorCode = -1;
return(Json(wellType, JsonRequestBehavior.AllowGet));
}
Session["_wellType"] = myViewObj;
myViewObj.ErrorCode = myViewObj.WellTypeId;
return(Json(myViewObj, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
wellType.Error = "An unknown error was Well Type Information could not be retrieved.";
wellType.ErrorCode = -1;
return(Json(wellType, JsonRequestBehavior.AllowGet));
}
}
private List <WellType> GetWellTypes()
{
var wellTypeList = new WellTypeServices().GetAllOrderedWellTypes() ?? new List <WellType>();
if (!wellTypeList.Any())
{
return(new List <WellType>());
}
return(wellTypeList);
}
public ViewResult WellTypes()
{
var wellTypeList = new WellTypeServices().GetAllOrderedWellTypes() ?? new List <WellType>();
if (!wellTypeList.Any())
{
ViewBag.Title = "Well Type SetUp";
return(View(wellTypeList));
}
ViewBag.Title = "Manage Well Types";
return(View(wellTypeList));
}
public ActionResult AddWellType(WellType wellType)
{
ModelState.Clear();
ViewBag.LoadStatus = "0";
try
{
if (!ModelState.IsValid)
{
wellType.Error = "Please supply all required fields and try again";
wellType.ErrorCode = -1;
return(Json(wellType, JsonRequestBehavior.AllowGet));
}
var wx = ValidateControl(wellType);
if (wx.Code < 1)
{
wellType.Error = wx.Error;
wellType.ErrorCode = -1;
return(Json(wellType, JsonRequestBehavior.AllowGet));
}
wellType.Title = wellType.Title;
var k = new WellTypeServices().AddWellTypeCheckDuplicate(wellType);
if (k < 1)
{
if (k == -3)
{
wellType.Error = "Well Type already exists";
wellType.ErrorCode = 0;
return(Json(wellType, JsonRequestBehavior.AllowGet));
}
wellType.Error = "Process Failed! Please contact the Admin or try again later";
wellType.ErrorCode = 0;
return(Json(wellType, JsonRequestBehavior.AllowGet));
}
wellType.Error = "Record was added successfully";
wellType.ErrorCode = 1;
wellType.WellTypeId = k;
return(Json(wellType, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
wellType.Error = "An unknown error was encountered. Request could not be serviced. Please try again later.";
wellType.ErrorCode = 0;
return(Json(wellType, JsonRequestBehavior.AllowGet));
}
}
private List <WellType> GetWellTypes()
{
try
{
var wellTypes = new WellTypeServices().GetAllOrderedWellTypes() ?? new List <WellType>();
if (!wellTypes.Any())
{
return(new List <WellType>());
}
return(wellTypes);
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
return(new List <WellType>());
}
}
public ViewResult WellWorkovers(string returnMsg = null, int returnCode = 0)
{
try
{
var wellWorkOverReasonList = GetWellWorkoverReasons();
if (!wellWorkOverReasonList.Any())
{
ViewBag.Title = "Well Workover Reason SetUp";
return(View("~/Views/WellWorkOverReason/WellWorkOverReasons.cshtml", wellWorkOverReasonList));
}
var equipmentList = GetEquipmets();
if (!equipmentList.Any())
{
ViewBag.Edit = 0;
ViewBag.Title = "Equipment SetUp";
var equipmentTypeList = new EquipmentTypeServices().GetAllOrderedEquipmentTypes() ?? new List <EquipmentType>();
if (!equipmentTypeList.Any())
{
ViewBag.Edit = 0;
ViewBag.Title = "Equipment Type SetUp";
return(View("~/Views/EquipmentType/EquipmentTypes.cshtml", new List <EquipmentType>()));
}
return(View("~/Views/Equipment/Equipments.cshtml", Tuple.Create(equipmentTypeList, new List <Equipment>())));
}
var wells = GetWells();
if (!wells.Any())
{
ViewBag.Edit = 1;
ViewBag.Title = "Well Set Up";
var wellTypeList = new WellTypeServices().GetAllOrderedWellTypes() ?? new List <WellType>();
if (!wellTypeList.Any())
{
ViewBag.Edit = 0;
ViewBag.Title = "Well Type Set Up";
return(View("~/Views/WellType/WellTypes.cshtml", new List <WellType>()));
}
var companyList = new CompanyServices().GetAllOrderedCompanies() ?? new List <Company>();
if (!companyList.Any())
{
ViewBag.Edit = 0;
ViewBag.Title = "Company SetUp";
return(View("~/Views/Company/Companies.cshtml", new List <Company>()));
}
var wellClassList = GetWellClasses();
if (!wellClassList.Any())
{
ViewBag.Edit = 0;
ViewBag.Title = "well Class Set Up";
return(View("~/Views/WellClass/WellClasses.cshtml", wellClassList));
}
return(View("~/Views/Well/Wells.cshtml", new WellViewModel {
WellTypes = wellTypeList, Companies = companyList, WellClasses = wellClassList, Wells = new List <Well>()
}));
}
var yearList = GetYears();
var monthList = GetMonths();
int dataCount;
var wellWorkOvers = GetWellWorkovers(ItemsPerPage, PageNumber, out dataCount);
if (!wellWorkOvers.Any())
{
ViewBag.Edit = 1;
ViewBag.Title = "Well Workover SetUp";
return(View(new WellWorkoverViewModel
{
WellWorkOverReasons = wellWorkOverReasonList,
Equipments = equipmentList,
WellObjects = wells,
WellWorkOvers = new List <WellWorkover>()
}));
}
var txx = new WellWorkoverViewModel
{
WellWorkOverReasons = wellWorkOverReasonList,
Equipments = equipmentList,
WellObjects = wells,
WellWorkOvers = wellWorkOvers
};
ViewBag.Title = "Manage Well Workovers";
Session["_workoverPage"] = 1;
return(View(txx));
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
var txx = new WellWorkoverViewModel
{
WellWorkOverReasons = GetWellWorkoverReasons(),
Equipments = GetEquipmets(),
WellObjects = GetWells(),
WellWorkOvers = new List <WellWorkover>()
};
ViewBag.Title = "Manage Well Workovers";
return(View(txx));
}
}
private Well ProcessRecord(DataRowView dv, ref string msg)
{
if (dv == null)
{
return(null);
}
try
{
var mInfo = new Well
{
Name = dv.Row["Well_Name"].ToString().Trim()
};
var spuDate = dv.Row["SPud_Date"].ToString().Trim();
if (!string.IsNullOrEmpty(spuDate))
{
DateTime d1;
var realDate = DateTime.TryParse(spuDate, out d1);
if (!realDate)
{
msg = "Invalid Spud Date";
return(null);
}
mInfo.SpudDate = d1;
}
////else
////{
//// msg = "Please provide Spud Date.";
//// return null;
////}
var fieldName = mInfo.Name.Trim().Trim().ToLower().Split('-')[0];
if (!string.IsNullOrEmpty(fieldName))
{
var field = new FieldServices().GetFieldIdByFieldName(fieldName);
if (field.FieldId < 1)
{
msg = "Field Information could not be processed.";
return(null);
}
mInfo.FieldId = field.FieldId;
}
else
{
msg = "Please provide Field Name";
return(null);
}
double dept = 0;
if (!string.IsNullOrEmpty(dv.Row["Total_Dept"].ToString().Trim()))
{
var totalDeptStr = dv.Row["Total_Dept"].ToString().Trim();
var deptResult = double.TryParse(totalDeptStr, out dept);
if (!deptResult || dept < 1)
{
dept = 0;
}
}
mInfo.TotalDept = dept;
var remarks = dv.Row["Remarks"].ToString().Trim();
if (!string.IsNullOrEmpty(remarks))
{
mInfo.Remarks = remarks.Trim();
}
var wellTypeName = dv.Row["WellType_Name"].ToString().Trim();
if (!string.IsNullOrEmpty(wellTypeName))
{
var wellTypeId = new WellTypeServices().GetWellTypeId(wellTypeName);
mInfo.WellTypeId = wellTypeId;
}
else
{
msg = "Well Type name is empty";
return(null);
}
var techAllowed = dv.Row["Technical_Allowed"].ToString().Trim();
if (!string.IsNullOrEmpty(techAllowed))
{
double outRes;
var techAllowedResult = double.TryParse(techAllowed, out outRes);
if (techAllowedResult && outRes > 0)
{
mInfo.TechnicalAllowable = outRes;
}
}
var wellClassName = dv.Row["WellClass_Name"].ToString().Trim();
if (!string.IsNullOrEmpty(wellClassName))
{
mInfo.WellClassName = wellClassName.Trim();
}
return(mInfo);
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
return(null);
}
}
private Well ProcessRecord(DataRowView dv, ref string msg)
{
if (dv == null)
{
return(null);
}
try
{
var mInfo = new Well
{
Name = dv.Row["Well_Name"].ToString().Trim(),
};
var spuDate = dv.Row["SPud_Date"].ToString().Trim();
DateTime d1;
if (!string.IsNullOrEmpty(spuDate))
{
var realDate = DateTime.TryParse(spuDate, out d1);
if (!realDate)
{
mInfo.SpudDate = DateTime.Now;
}
mInfo.SpudDate = d1;
}
else
{
mInfo.SpudDate = DateTime.Now;
}
double dept = 0;
if (!string.IsNullOrEmpty(dv.Row["Total_Dept"].ToString().Trim()))
{
var totalDeptStr = dv.Row["Total_Dept"].ToString().Trim();
var deptResult = double.TryParse(totalDeptStr, out dept);
if (!deptResult || dept < 1)
{
dept = 0;
}
}
mInfo.TotalDept = dept;
var remarks = dv.Row["Remarks"].ToString().Trim();
if (!string.IsNullOrEmpty(remarks))
{
mInfo.Remarks = remarks.Trim();
}
var wellTypeName = dv.Row["WellType_Name"].ToString().Trim();
if (!string.IsNullOrEmpty(wellTypeName))
{
var wellTypeId = new WellTypeServices().GetWellTypeId(wellTypeName);
mInfo.WellTypeId = wellTypeId;
}
else
{
mInfo.WellTypeId = (int)OtherNotAvailable.Not_Available;
}
var techAllowed = dv.Row["Technical_Allowed"].ToString().Trim();
if (!string.IsNullOrEmpty(techAllowed))
{
double outRes;
var techAllowedResult = double.TryParse(techAllowed, out outRes);
if (techAllowedResult && outRes > 0)
{
mInfo.TechnicalAllowable = outRes;
}
}
//var blockName = dv.Row["Field_Name"].ToString().Trim();
//if (!string.IsNullOrEmpty(blockName))
//{
// var blockId = new WellTypeServices().GetWellTypeId(wellTypeName);
// if (blockId < 1)
// {
// mInfo.WellTypeId = (int)OtherNotAvailable.Not_Available;
// }
// else
// {
// mInfo.BlockId = blockId;
// }
//}
//else
//{
// mInfo.WellTypeId = (int)OtherNotAvailable.Not_Available;
//}
var wellId = new WellServices().AddWellCheckDuplicate2(mInfo);
if (wellId > 0)
{
var wellClassName = dv.Row["WellClass_Name"].ToString().Trim();
if (!string.IsNullOrEmpty(wellClassName))
{
var status = new WellClasServices().CreateWellClassAddClassification(wellClassName, wellId);
if (status < 1)
{
msg = "Well could not be classified";
return(null);
}
}
}
mInfo.WellId = wellId;
return(mInfo);
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
return(null);
}
}
