public ActionResult GetWells(WellQuery queryBuilder)
{
if (queryBuilder == null)
{
return(Json(new List <WellReportObject>(), JsonRequestBehavior.AllowGet));
}
if (queryBuilder.WellTypeId < 1 && queryBuilder.CompanyId < 1 && ((queryBuilder.StartDate != null && queryBuilder.StartDate.Value.Year == 0001) || (queryBuilder.StartDate == null)) && ((queryBuilder.EndDate != null && queryBuilder.EndDate.Value.Year == 0001) || (queryBuilder.EndDate == null)) && queryBuilder.BlockId < 1 && queryBuilder.WellClassId < 1 && queryBuilder.FieldId < 1 && queryBuilder.TerrainId < 1 && queryBuilder.ZoneId < 1)
{
return(Json(new List <WellReportObject>(), JsonRequestBehavior.AllowGet));
}
var wellList = new WellServices().GetOrderedWellReportObjects(queryBuilder) ?? new List <WellReportObject>();
if (!wellList.Any())
{
return(Json(new List <WellReportObject>(), JsonRequestBehavior.AllowGet));
}
Session["_successfulWellQuery"] = queryBuilder;
var jsonResult = Json(wellList, JsonRequestBehavior.AllowGet);
jsonResult.MaxJsonLength = int.MaxValue;
return(jsonResult);
}
public ActionResult GetMoreWells()
{
int pageNumber = 1;
var o = Session["_workOverWellpageNumber"];
if (o != null)
{
var tfd = (int)o;
if (tfd < 1)
{
pageNumber = PageNumber;
}
else
{
pageNumber += tfd;
}
}
var dfg = new WellServices().GetWells(400, pageNumber);
if (!dfg.Any())
{
return(Json(new List <WellObject>(), JsonRequestBehavior.AllowGet));
}
Session["_workOverWellpageNumber"] = pageNumber;
return(Json(dfg, JsonRequestBehavior.AllowGet));
}
public ActionResult GetWells2(int queryId)
{
if (queryId < 1)
{
return(Json(new List <WellReportObject>(), JsonRequestBehavior.AllowGet));
}
var query = new WellQueryBuilderServices().GetWellQuery(queryId);
if (query == null || query.WellQueryId < 1)
{
return(Json(new List <WellReportObject>(), JsonRequestBehavior.AllowGet));
}
var wellList = new WellServices().GetOrderedWellReportObjects(query) ?? new List <WellReportObject>();
if (!wellList.Any())
{
return(Json(new List <WellReportObject>(), JsonRequestBehavior.AllowGet));
}
var jsonResult = Json(wellList, JsonRequestBehavior.AllowGet);
jsonResult.MaxJsonLength = int.MaxValue;
return(jsonResult);
}
private List <Well> GetWells(int itemsPerPage, int pageNumber, out int dataCount)
{
try
{
var fxs = new WellServices().GetAllOrderedWells(itemsPerPage, pageNumber, out dataCount) ?? new List <Well>();
if (!fxs.Any())
{
return(new List <Well>());
}
dataCount = dataCount - 1;
ViewBag.DataCount = dataCount.ToString(CultureInfo.InvariantCulture);
var totalPages = dataCount / itemsPerPage;
// Counting the last page
if (dataCount % itemsPerPage != 0)
{
totalPages++;
}
fxs.Remove(fxs.Find(m => m.WellId == (int)OtherNotAvailable.Not_Available));
//ViewBag.ItemCount = (pageNumber * itemsPerPage) - 150;
ViewBag.TotalPages = totalPages;
ViewBag.Page = pageNumber;
return(fxs);
}
catch (Exception ex)
{
dataCount = 0;
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
return(new List <Well>());
}
}
private List <DocObject> GetYears()
{
var jxs = new WellServices().GetSpudYears();
if (!jxs.Any())
{
return(new List <DocObject>());
}
var tdv = new List <DocObject>();
jxs.ForEach(m =>
{
var gt = 0;
var ds = int.TryParse(m, out gt);
if (ds && gt > 0)
{
tdv.Add(new DocObject
{
DocName = m,
DocId = int.Parse(m)
});
}
});
return(tdv.OrderByDescending(m => m.DocName).ToList());
}
private List <WellObject> GetWells()
{
var ttg = new WellServices().GetWells(200, PageNumber);
if (!ttg.Any())
{
return(new List <WellObject>());
}
Session["_workOverWellpageNumber"] = 1;
return(ttg);
}
private ActionResult GetSelect2Wells()
{
try
{
var fxs = new WellServices().GetWells() ?? new List <Well>();
if (!fxs.Any())
{
return(Json(new List <Well>(), JsonRequestBehavior.AllowGet));
}
return(Json(fxs, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
return(Json(new List <Well>(), JsonRequestBehavior.AllowGet));
}
}
private List <WellReportObject> GetWellObjects(int itemsPerPage, int pageNumber, long companyId)
{
try
{
var wellList = new WellServices().GetWellObjects(itemsPerPage, pageNumber, companyId) ?? new List <WellReportObject>();
if (!wellList.Any())
{
return(new List <WellReportObject>());
}
return(wellList);
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
return(new List <WellReportObject>());
}
}
public ActionResult EditWell(int id)
{
var well = new Well();
try
{
if (id < 1)
{
well.Error = "Invalid Selection!";
well.ErrorCode = -1;
return(Json(well, JsonRequestBehavior.AllowGet));
}
var myViewObj = new WellServices().GetWell(id);
if (myViewObj == null || myViewObj.WellId < 1)
{
well.Error = "Well Information could not be retrieved.";
well.ErrorCode = -1;
return(Json(well, JsonRequestBehavior.AllowGet));
}
Session["_well"] = myViewObj;
myViewObj.ErrorCode = myViewObj.WellId;
if (well.SpudDate != null)
{
well.Date = ((DateTime)well.SpudDate).ToString("yyyy/MM/dd");
}
return(Json(myViewObj, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
well.Error = "An unknown error was Well Information could not be retrieved.";
well.ErrorCode = -1;
return(Json(well, JsonRequestBehavior.AllowGet));
}
}
private WellCompletion ProcessRecord2(DataRowView dv, ref string msg, int completionTypeId)
{
if (dv == null)
{
return(null);
}
try
{
var wellName = dv.Row["wellname"].ToString().Replace(" ", "").Replace(",", "").Trim();
if (string.IsNullOrEmpty(wellName.Trim()))
{
return(null);
}
var mInfo = new WellCompletion
{
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["datecompleted(yyyy/MM/dd)"].ToString().Trim();
if (string.IsNullOrEmpty(year))
{
msg = "Completion Date is empty.";
return(null);
}
else
{
DateTime outYear;
var yrResult = DateTime.TryParse(year, out outYear);
if (!yrResult)
{
msg = "Completion Date is empty.";
return(null);
}
else
{
mInfo.DateCompleted = outYear;
}
}
var completionStatus = dv.Row["isinitialcompletion(YES/NO)"].ToString().Trim();
if (string.IsNullOrEmpty(completionStatus))
{
msg = "Please indicate if Well Completion is Initial or ortherwise.";
return(null);
}
else
{
if (completionStatus.Trim().ToLower().Replace(" ", "") == "yes")
{
mInfo.IsInitial = true;
}
if (completionStatus.Trim().ToLower().Replace(" ", "") == "no")
{
mInfo.IsInitial = false;
}
}
double l1;
double up1;
double l2;
double up2;
var lowerInter1 = dv.Row["lower_interval_1"].ToString().Trim();
if (string.IsNullOrEmpty(lowerInter1))
{
msg = "Please provide lower Interval 1.";
return(null);
}
else
{
double outLint;
var dtResult = double.TryParse(lowerInter1, out outLint);
if (!dtResult && outLint < 1)
{
msg = "Please provide a valid lower Interval 1.";
return(null);
}
else
{
l1 = outLint;
}
}
var upperInter = dv.Row["upper_interval_1"].ToString().Trim();
if (string.IsNullOrEmpty(upperInter))
{
msg = "Please provide Upper Interval 1.";
return(null);
}
else
{
double outUpint;
var dtResult = double.TryParse(upperInter, out outUpint);
if (!dtResult && outUpint < 1)
{
msg = "Please provide a valid Upper Interval 1.";
return(null);
}
else
{
up1 = outUpint;
}
}
var lowerInter2 = dv.Row["lower_interval_2"].ToString().Trim();
if (string.IsNullOrEmpty(lowerInter2))
{
msg = "Please provide lower Interval 2.";
return(null);
}
else
{
double outLint2;
var dtResult = double.TryParse(lowerInter2, out outLint2);
if (!dtResult && outLint2 < 1)
{
msg = "Please provide a valid lower Interval 2.";
return(null);
}
else
{
l2 = outLint2;
}
}
var upperInter2 = dv.Row["upper_interval_2"].ToString().Trim();
if (string.IsNullOrEmpty(upperInter2))
{
msg = "Please provide Upper Interval 2.";
return(null);
}
else
{
double outUpint2;
var dtResult = double.TryParse(upperInter2, out outUpint2);
if (!dtResult && outUpint2 < 1)
{
msg = "Please provide a valid Upper Interval 2.";
return(null);
}
else
{
up2 = outUpint2;
}
}
if (!string.IsNullOrEmpty(dv.Row["equipmentused"].ToString().Trim()))
{
var dfv = dv.Row["equipmentused"].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 empty.";
return(null);
}
mInfo.WellCompletionTypeId = completionTypeId;
var vvz = new WellCompletionServices().AddWellCompletionCheckDuplicate3(mInfo);
if (vvz < 1)
{
msg = "Well Completion Interval for the same Period, Reason, Completion Type and Equipment already exists for this well.";
return(null);
}
var wellCompInt = new WellCompletionInterval
{
LowerInterval = l1,
WellCompletionId = vvz,
UpperInterval = up1,
DateCompleted = mInfo.DateCompleted.ToString(),
LastUpdatedTime = DateTime.Now.ToString("G")
};
var vvzk = new WellCompletionIntervalServices().AddWellCompletionIntervalCheckDuplicate(wellCompInt);
if (vvzk < 1)
{
msg = "Well Completion Information could not be processed.";
return(null);
}
var tdd = new WellCompletionInterval
{
LowerInterval = l2,
WellCompletionId = vvz,
UpperInterval = up2,
DateCompleted = mInfo.DateCompleted.ToString(),
LastUpdatedTime = DateTime.Now.ToString("G")
};
var vvzk2 = new WellCompletionIntervalServices().AddWellCompletionIntervalCheckDuplicate(tdd);
if (vvzk2 < 1)
{
new WellCompletionIntervalServices().DeleteWellCompletionIntervalCheckReferences(vvzk);
msg = "Well Completion Information could not be processed.";
return(null);
}
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);
}
}
public ActionResult WellUpload(HttpPostedFileBase file)
{
try
{
if (file.ContentLength > 0)
{
const string folderPath = "~/BulkUploadTemplate";
var fileName = file.FileName;
var path = folderPath + "/" + fileName;
if (System.IO.File.Exists(Server.MapPath(path)))
{
System.IO.File.Delete(Server.MapPath(path));
}
file.SaveAs(Server.MapPath(folderPath + "/" + fileName));
var mList = new List <Well>();
var msg = string.Empty;
if (!new WellUploadManager().Import(Server.MapPath(path), "well", ref mList, ref msg))
{
ViewBag.ErrorCode = -1;
ViewBag.ErrorMessage = msg;
return(View());
}
if (!mList.Any())
{
ViewBag.ErrorCode = -1;
ViewBag.ErrorMessage = msg;
return(View());
}
var errorList = new List <Well>();
var succesList = new List <Well>();
foreach (var wellInfo in mList)
{
var wellId = new WellServices().AddWellCheckDuplicate2(wellInfo);
if (wellId < 1)
{
errorList.Add(wellInfo);
}
else
{
succesList.Add(wellInfo);
if (wellId > 0)
{
if (!string.IsNullOrEmpty(wellInfo.WellClassName))
{
new WellClasServices().CreateWellClassAddClassification(wellInfo.WellClassName, wellId);
}
}
}
}
if (errorList.Any() && succesList.Any())
{
var ts = succesList.Count + " records were successfully uploaded." +
"\n" + errorList.Count + " record(s) could not be uploaded due to duplicates/unknown errors encountered.";
ViewBag.ErrorCode = -1;
if (msg.Length > 0)
{
ts += "<br/>" + msg;
}
ViewBag.ErrorMessage = ts;
return(View());
}
if (errorList.Any() && !succesList.Any())
{
var ts = errorList.Count + " records could not be uploaded due to duplicates/unknown errors encountered.";
ViewBag.ErrorCode = -1;
if (msg.Length > 0)
{
ts += "<br/>" + msg;
}
ViewBag.ErrorMessage = ts;
return(View());
}
if (!errorList.Any() && succesList.Any())
{
ViewBag.ErrorCode = 5;
//ViewBag.ErrorMessage = mList.Count + " records were successfully uploaded.";
var tsx = succesList.Count + " records were successfully uploaded.";
if (msg.Length > 0)
{
tsx += "<br/>" + msg;
}
ViewBag.ErrorMessage = tsx;
return(View());
}
//return View("Wells", new WellViewModel { WellTypes = GetWellTypes(), Companies = GetCompanies(), Blocks = GetBlocks(), Wells = GetWells(ItemsPerPage, PageNumber, out dataCount), WellClasses = GetWellClasses() });
}
ViewBag.ErrorCode = -1;
ViewBag.ErrorMessage = "The selected file is invalid";
return(View());
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
ViewBag.ErrorCode = -1;
ViewBag.ErrorMessage = "The selected file is invalid";
return(View());
}
}
public ActionResult EditWell(Well well)
{
ModelState.Clear();
ViewBag.LoadStatus = "0";
try
{
if (Session["_well"] == null)
{
well.Error = "Session has expired";
well.ErrorCode = 0;
return(Json(well, JsonRequestBehavior.AllowGet));
}
var oldWell = Session["_well"] as Well;
if (oldWell == null || oldWell.WellId < 1)
{
well.Error = "Session has expired";
well.ErrorCode = -1;
return(Json(well, JsonRequestBehavior.AllowGet));
}
if (!ModelState.IsValid)
{
well.Error = "Please supply all required wells and try again";
well.ErrorCode = -1;
return(Json(well, JsonRequestBehavior.AllowGet));
}
var wx = ValidateControl(well);
if (wx.Code < 1)
{
well.Error = wx.Error;
well.ErrorCode = -1;
return(Json(well, JsonRequestBehavior.AllowGet));
}
oldWell.SpudDate = well.SpudDate;
oldWell.Name = well.Name;
oldWell.TechnicalAllowable = well.TechnicalAllowable;
oldWell.WellTypeId = well.WellTypeId;
oldWell.TotalDept = well.TotalDept;
oldWell.Remarks = well.Remarks;
if (well.SpudDate != null)
{
well.Date = ((DateTime)well.SpudDate).ToString("yyyy/MM/dd");
}
var k = new WellServices().UpdateWellCheckDuplicate(oldWell);
if (k < 1)
{
if (k == -3)
{
well.Error = "Well already exists";
well.ErrorCode = 0;
return(Json(well, JsonRequestBehavior.AllowGet));
}
well.Error = "Process Failed! Please contact the Admin or try again later";
well.ErrorCode = 0;
return(Json(well, JsonRequestBehavior.AllowGet));
}
well.Error = "Well Information was successfully updated";
well.ErrorCode = 1;
return(Json(well, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
well.Error = "An unknown error was encountered. Request could not be serviced. Please try again later.";
well.ErrorCode = 0;
return(Json(well, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddWell(Well well)
{
ModelState.Clear();
ViewBag.LoadStatus = "0";
try
{
if (!ModelState.IsValid)
{
well.Error = "Please supply all required fields and try again";
well.ErrorCode = -1;
return(Json(well, JsonRequestBehavior.AllowGet));
}
var wx = ValidateControl(well);
if (wx.Code < 1)
{
well.Error = wx.Error;
well.ErrorCode = -1;
return(Json(well, JsonRequestBehavior.AllowGet));
}
var k = new WellServices().AddWellCheckDuplicate(well);
if (k < 1)
{
if (k == -3)
{
well.Error = "Well already exists";
well.ErrorCode = -3;
return(Json(well, JsonRequestBehavior.AllowGet));
}
if (k == -4)
{
well.Error = "Well has already been classified";
well.ErrorCode = -3;
return(Json(well, JsonRequestBehavior.AllowGet));
}
well.Error = "Process Failed! Please contact the Admin or try again later";
well.ErrorCode = 0;
return(Json(well, JsonRequestBehavior.AllowGet));
}
if (well.SpudDate != null)
{
well.Date = ((DateTime)well.SpudDate).ToString("yyyy/MM/dd");
}
well.Error = "Record was added successfully";
well.ErrorCode = 1;
well.WellId = k;
return(Json(well, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
well.Error = "An unknown error was encountered. Request could not be serviced. Please try again later.";
well.ErrorCode = 0;
return(Json(well, 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);
}
}
