public List <WellCompletion> GetCompletionsBySearchDate(GenericSearch search) { try { var wellCompletions = new WellCompletionServices().GetAllOrderedCompletionsByMonth(search.Month, search.Year); if (!wellCompletions.Any()) { return(new List <WellCompletion>()); } wellCompletions.ForEach(m => { m.EquipmentName = m.Equipment.Name; m.WellName = m.Well.Name; m.WellCompletionTypeName = m.WellCompletionType.Type; m.EquipmentName = m.Equipment.Name; }); return(wellCompletions); } catch (Exception ex) { ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message); return(new List <WellCompletion>()); } }
public ActionResult GetWellCompletions2(int queryId) { if (queryId < 1) { return(Json(new List <WellCompletionReportObject>(), JsonRequestBehavior.AllowGet)); } var query = new WellCompletionQueryBuilderServices().GetWellCompletionQuery(queryId); if (query == null || query.WellCompletionQueryId < 1) { return(Json(new List <WellCompletionReportObject>(), JsonRequestBehavior.AllowGet)); } var wellCompletionList = new WellCompletionServices().GetWellCompletionReports(query) ?? new List <WellCompletionReportObject>(); if (!wellCompletionList.Any()) { return(Json(new List <WellCompletionReportObject>(), JsonRequestBehavior.AllowGet)); } var jsonResult = Json(wellCompletionList, JsonRequestBehavior.AllowGet); jsonResult.MaxJsonLength = int.MaxValue; return(jsonResult); }
public ViewResult WellCompletionIntervals() { var wellCompletionList = new WellCompletionServices().GetAllOrderedWellCompletions() ?? new List <WellCompletion>(); if (!wellCompletionList.Any()) { ViewBag.Edit = 1; ViewBag.Title = "Well Completion SetUp"; var wellCompletionTypeList = new WellCompletionTypeServices().GetAllOrderedWellCompletionTypes() ?? new List <WellCompletionType>(); if (!wellCompletionTypeList.Any()) { ViewBag.Edit = 0; ViewBag.Title = "Well Completion Type SetUp"; return(View("~/Views/WellCompletionType/WellCompletionTypes.cshtml", new List <WellCompletionType>())); } } wellCompletionList.ForEach(m => { m.WellName = m.Well.Name; m.WellCompletionTypeName = m.WellCompletionType.Type; m.EquipmentName = m.Equipment.Name; }); var wellCompletionIntervalList = new WellCompletionIntervalServices().GetAllOrderedWellCompletionIntervals() ?? new List <WellCompletionInterval>(); if (!wellCompletionIntervalList.Any()) { ViewBag.Edit = 0; ViewBag.Title = "Well Completion Interval SetUp"; return(View(Tuple.Create(wellCompletionList, new List <WellCompletionInterval>()))); } wellCompletionIntervalList.ForEach(m => { m.DatecomPletedString = m.DateCompleted; m.WellName = wellCompletionList.Find(x => x.WellId == m.WellCompletion.WellId).Well.Name; }); var txx = Tuple.Create(wellCompletionList, wellCompletionIntervalList); ViewBag.Title = "Manage Well Completion Intervals"; return(View(txx)); }
private List <WellCompletionObject> GetWellComletionObjects(int itemsPerPage, int pageNumber) { try { var wellCompletions = new WellCompletionServices().GetWellObjects(itemsPerPage, pageNumber); if (!wellCompletions.Any()) { return(new List <WellCompletionObject>()); } return(wellCompletions); } catch (Exception ex) { return(new List <WellCompletionObject>()); } }
private List <WellCompletionReportObject> GetWellCompletionStaticReports(int itemsPerPage, int pageNumber, GenericSearch search) { try { var wellCompletions = new WellCompletionServices().GetWellStaticCompletionReport(itemsPerPage, pageNumber, search.Month, search.Year); if (!wellCompletions.Any()) { return(new List <WellCompletionReportObject>()); } return(wellCompletions); } catch (Exception ex) { ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message); return(new List <WellCompletionReportObject>()); } }
private List <WellCompletion> GetWellComletions(int itemsPerPage, int pageNumber, out int dataCount) { try { var wellCompletions = new WellCompletionServices().GetAllOrderedWellCompletions(itemsPerPage, pageNumber, out dataCount); if (!wellCompletions.Any()) { dataCount = 0; ViewBag.TotalPages = 0; ViewBag.Page = 1; return(new List <WellCompletion>()); } ViewBag.PrDataCount = dataCount.ToString(CultureInfo.InvariantCulture); var totalPages = dataCount / itemsPerPage; if (dataCount % itemsPerPage != 0) { totalPages++; } ViewBag.PrTotalPages = totalPages; ViewBag.PrPage = pageNumber; wellCompletions.ForEach(m => { m.WellName = m.Well.Name; m.WellCompletionTypeName = m.WellCompletionType.Type; m.EquipmentName = m.Equipment.Name; }); return(wellCompletions); } catch (Exception ex) { dataCount = 0; ViewBag.TotalPages = 0; ViewBag.Page = 1; return(new List <WellCompletion>()); } }
private List <WellCompletion> GetWellComletionReportByQueryPeriods(GenericSearch search) { try { var wellCompletions = new WellCompletionServices().GetAllOrderedWellCompletionReportByPeriod(search.Month, search.Year); if (!wellCompletions.Any()) { return(new List <WellCompletion>()); } return(wellCompletions); } catch (Exception ex) { //dataCount = 0; //ViewBag.TotalPages = 0; //ViewBag.Page = 1; return(new List <WellCompletion>()); } }
private List <DocObject> GetYears() { var jxs = new WellCompletionServices().GetWellCompletionYears(); if (!jxs.Any()) { return(new List <DocObject>()); } var tdv = new List <DocObject>(); jxs.ForEach(m => { var ts = int.Parse(m); if (!tdv.Exists(t => t.DocId == ts)) { tdv.Add(new DocObject { DocName = m, DocId = ts }); } }); return(tdv.OrderByDescending(m => m.DocName).ToList()); }
public ActionResult GetWellCompletions(WellCompletionQuery queryBuilder) { if (queryBuilder == null) { return(Json(new List <WellCompletionReportObject>(), JsonRequestBehavior.AllowGet)); } if (queryBuilder.EquipmentId < 1 && 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.CompletionTypeId < 1 && queryBuilder.WellClassId < 1 && queryBuilder.TerrainId < 1 && queryBuilder.ZoneId < 1 && queryBuilder.WellId < 1) { return(Json(new List <WellCompletionReportObject>(), JsonRequestBehavior.AllowGet)); } var wellCompletionList = new WellCompletionServices().GetWellCompletionReports(queryBuilder) ?? new List <WellCompletionReportObject>(); if (!wellCompletionList.Any()) { return(Json(new List <WellCompletionReportObject>(), JsonRequestBehavior.AllowGet)); } Session["_successfulWellCompletionQuery"] = queryBuilder; var jsonResult = Json(wellCompletionList, JsonRequestBehavior.AllowGet); jsonResult.MaxJsonLength = int.MaxValue; return(jsonResult); }