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 List <Production> GetProducttionsBySearchDate(GenericSearch search) { try { var productions = new ProductionServices().GetAllOrderedProductionsByMonth(search.Month, search.Year); if (!productions.Any()) { return(new List <Production>()); } productions.ForEach(m => { m.FieldName = m.Field.Name; m.ProductName = m.Product.Name; m.MonthName = Enum.GetName(typeof(MonthList), m.Month); m.Quantity = Convert.ToDecimal(m.Quantity).ToString("#,##0"); }); return(productions); } catch (Exception ex) { ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message); return(new List <Production>()); } }
private void AddButtonSearch(Control control, ComponentItemDto componentDto, ConfigurationColumnFillDto config_fill, ref int position_y, ref int position_x) { Button btn = new Button(); btn.Parent = control; btn.Name = $"btn_search_{componentDto.Group}"; btn.Text = "..."; btn.Location = new System.Drawing.Point(position_x + 20, position_y); var code = componentDto.ConfigurationColumns.FirstOrDefault(fi => fi.Id == config_fill.ConfigurationColumnSourceId); var val = componentDto.ConfigurationColumns.FirstOrDefault(fi => fi.Id == config_fill.ConfigurationColumnDestinationId); var search = new SearchDto() { LabelDescriptionName = val.Title, LabelIdName = code.Title, SearchItems = code.EnableValues, ColumnSourceName = $"{code.Name}_{code.Id}", ColumnDestinationName = $"{val.Name}_{val.Id}", }; btn.Click += (object sender, EventArgs e) => { var form = new GenericSearch(search, this); form.Show(); }; position_y += 40; position_x += btn.Width; }
public GenericSearchedDataDto MapGenericSearchedDataToDto(GenericSearch genericSearchObj, string tableName) { GenericSearchedDataDto genericSearchedDataDto = new GenericSearchedDataDto(); genericSearchedDataDto.TableName = tableName; genericSearchedDataDto.RetrievedDataKey = genericSearchObj.RetrievedDataKey; genericSearchedDataDto.RetrievedDataName = genericSearchObj.RetrievedDataName; genericSearchedDataDto.RetrievedDataClientId = genericSearchObj.RetrievedDataClientId; return(genericSearchedDataDto); }
public void Search_NullSearchProperty_Throws() { var request = CreateRequest(); request.Text = null; var search = new GenericSearch(CreateProvider(), null); search.Invoking(x => x.Search(Query, request)) .Should() .ThrowExactly <NullReferenceException>(); }
public void Paginate_NoRows_Throws() { var request = CreateRequest(); request.Page = 1; var provider = CreateProvider(x => x.RowsDefinition = new RowsExpression <Request, Result>("Something")); var search = new GenericSearch(provider, null); search.Invoking(x => x.Paginate(Query, request)) .Should() .ThrowExactly <NullReferenceException>(); }
public void Paginate_ZeroRows_Throws() { var request = CreateRequest(); request.Page = 1; var provider = CreateProvider(); var search = new GenericSearch(provider, null); search.Invoking(x => x.Paginate(Query, request)) .Should() .ThrowExactly <ArgumentOutOfRangeException>(); }
public void Missing_Configuration_Throws() { var configurationProvider = new Mock <IListConfigurationProvider>(); configurationProvider.Setup(x => x.GetConfiguration(It.IsAny <Type>())).Returns((ListConfiguration)null); var request = CreateRequest(); var search = new GenericSearch(configurationProvider.Object, null); search.Invoking(x => x.Search(Query, request)) .Should() .ThrowExactly <MissingConfigurationException>(); }
public void Search_Succeeds() { var search = new GenericSearch(CreateProvider(), null); var request = CreateRequest(); request.Text.Is = TextSearch.Comparer.Contains; request.Text.Term = "ir"; var result = Query.Search(search, request).ToArray(); result.Length.Should().Be(2); result[0].Id.Should().Be(1); result[1].Id.Should().Be(3); }
public ActionResult GetProductionsByMonth(GenericSearch search) { try { if (search.Year < 1) { ViewBag.ErrorCode = -1; ViewBag.ErrorMessage = "Please provide a valid Report Year"; return(View("Productions", new ProductionViewModel { Products = GetProducts(), Fields = GetFields(), YearList = GetYears(), MonthList = GetMonths(), Productions = new List <Production>() })); } var productions = GetProducttionsBySearchDate(search); ViewBag.Title = "Manage Productions"; ViewBag.ErrorCode = 5; ViewBag.ErrorMessage = ""; return(View("Productions", new ProductionViewModel { Products = GetProducts(), Fields = GetFields(), YearList = GetYears(), MonthList = GetMonths(), Productions = productions })); } catch (Exception ex) { ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message); ViewBag.ErrorCode = -1; ViewBag.ErrorMessage = "An error was encountered, the seach operation could not be completed."; return(View("Productions", new ProductionViewModel { Products = GetProducts(), Fields = GetFields(), YearList = GetYears(), MonthList = GetMonths(), Productions = new List <Production>() })); } }
public void Paginate_Succeeds() { var search = new GenericSearch(CreateProvider(), null); var request = CreateRequest(); request.Page = 2; request.Rows = 3; var result = Query.Paginate(search, request).ToArray(); result.Length.Should().Be(3); result[0].Id.Should().Be(4); result[1].Id.Should().Be(5); result[2].Id.Should().Be(6); }
public void Search_ModelCache_Succeeds() { var request = CreateRequest(); request.Text.Is = TextSearch.Comparer.Contains; request.Text.Term = "ir"; var modelCache = new Mock <IRequestModelProvider>(); modelCache.Setup(x => x.GetCurrentRequestModel()).Returns(request); var search = new GenericSearch(CreateProvider(), modelCache.Object); var result = Query.Search(search).ToArray(); result.Length.Should().Be(2); result[0].Id.Should().Be(1); result[1].Id.Should().Be(3); }
public void Sort_Succeeds() { var search = new GenericSearch(CreateProvider(), null); var request = CreateRequest(); request.Ordx = nameof(Item.Text); request.Ordd = Direction.Descending; var result = Query.Sort(search, request).ToArray(); result[0].Id.Should().Be(3); result[1].Id.Should().Be(6); result[2].Id.Should().Be(7); result[3].Id.Should().Be(2); result[4].Id.Should().Be(4); result[5].Id.Should().Be(1); result[6].Id.Should().Be(5); }
public void Paginate_ModelCache_Succeeds() { var request = CreateRequest(); request.Page = 2; request.Rows = 3; var modelCache = new Mock <IRequestModelProvider>(); modelCache.Setup(x => x.GetCurrentRequestModel()).Returns(request); var search = new GenericSearch(CreateProvider(), modelCache.Object); var result = Query.Paginate(search).ToArray(); result.Length.Should().Be(3); result[0].Id.Should().Be(4); result[1].Id.Should().Be(5); result[2].Id.Should().Be(6); }
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>()); } }
public void Sort_NullDirection_Succeeds() { var request = CreateRequest(); request.Ordx = nameof(Item.Text); var modelCache = new Mock <IRequestModelProvider>(); modelCache.Setup(x => x.GetCurrentRequestModel()).Returns(request); var search = new GenericSearch(CreateProvider(), modelCache.Object); var result = Query.Sort(search, request).ToArray(); result[0].Id.Should().Be(1); result[1].Id.Should().Be(2); result[2].Id.Should().Be(3); result[3].Id.Should().Be(4); result[4].Id.Should().Be(5); result[5].Id.Should().Be(6); result[6].Id.Should().Be(7); }
public IEnumerable <ISearchEngine> GetEngineList() { var enginesConfig = this.config["engines"]; if (string.IsNullOrWhiteSpace(enginesConfig)) { return(new List <ISearchEngine>()); } var engines = enginesConfig.Split(','); if (engines == null || engines.Length <= 0) { return(new List <ISearchEngine>()); } return(engines.Select(engine => { var strs = engine.Split(':'); engine = strs[0]; var searchEngine = this.searcherConfig?.GetSearchEngine(engine); if (searchEngine == null) { searchEngine = new GenericSearch(this.config, engine); } if (strs.Length > 1 && float.TryParse(strs[1], out float weight)) { searchEngine.Weight = weight; } else { searchEngine.Weight = 1.0f; } return searchEngine; })); }
public ActionResult GetProductionsByQueryDateDate(GenericSearch search) { try { if (search.Year < 1) { ViewBag.ErrorCode = -1; ViewBag.ErrorMessage = "Please provide a valid Report Year"; return(View("Report", new ProductionViewModel { Products = new List <Product>(), Fields = new List <Field>(), YearList = GetYears(), MonthList = GetMonths(), ProductionObjects = new List <ProductionObject>() })); } if (search.Month > 0) { ViewBag.SearchPeriod = Enum.GetName(typeof(MonthList), search.Month) + "/" + search.Year; } else { ViewBag.SearchPeriod = search.Year; } var txd = new ProductionServices().GetProductionStaticReportByPeriod(PageNumber, ItemsPerPage, search.Month, search.Year); if (!txd.Any()) { ViewBag.ErrorMessage = "No record found"; ViewBag.ErrorCode = -1; return(View("Report", new ProductionViewModel { Products = new List <Product>(), Fields = new List <Field>(), YearList = GetYears(), MonthList = GetMonths(), ProductionObjects = new List <ProductionObject>() })); } var txx = new ProductionViewModel { Products = new List <Product>(), Fields = new List <Field>(), YearList = GetYears(), MonthList = GetMonths(), ProductionObjects = txd }; Session["_prodRepoPage"] = 1; Session["_prodRepoGenSearch"] = search; return(View("Report", txx)); } catch (Exception ex) { ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message); ViewBag.ErrorMessage = "No record found"; ViewBag.ErrorCode = -1; return(View("Report", new ProductionViewModel { Products = new List <Product>(), Fields = new List <Field>(), YearList = GetYears(), MonthList = GetMonths(), Productions = new List <Production>() })); } }
public GenericSearchedDataDto MapObjectToDto(Object iGenericSearchObj, string tableName) { GenericSearch genericSearchObj = (GenericSearch)iGenericSearchObj; return(MapGenericSearchedDataToDto(genericSearchObj, tableName)); }
private List <WellWorkoverReportObject> GetWorkoverObjects(int pageNumber, int itemsPerPage, GenericSearch search) { try { var wellWorkoverObjects = new WellWorkoverServices().GetMoreWellWorkoverReport(itemsPerPage, pageNumber, search.Month, search.Year); if (!wellWorkoverObjects.Any()) { return(new List <WellWorkoverReportObject>()); } return(wellWorkoverObjects); } catch (Exception ex) { return(new List <WellWorkoverReportObject>()); } }
public ActionResult GetWorkoversByQueryDate(GenericSearch search) { try { if (search.Year < 1) { ViewBag.ErrorCode = -1; ViewBag.ErrorMessage = "Please provide a valid Report Year"; return(View("Report", new WellWorkoverViewModel { WellWorkOverReasons = new List <WellWorkOverReason>(), Equipments = new List <Equipment>(), Wells = new List <Well>(), WellWorkOvers = new List <WellWorkover>(), WellWorkoverReportObjects = new List <WellWorkoverReportObject>(), YearList = GetYears(), MonthList = GetMonths() })); } if (search.Month > 0) { ViewBag.SearchPeriod = Enum.GetName(typeof(MonthList), search.Month) + "/" + search.Year; } else { ViewBag.SearchPeriod = search.Year; } var txd = GetWorkoverObjects(PageNumber, ItemsPerPage, search); if (!txd.Any()) { return(View("Report", new WellWorkoverViewModel { WellWorkOverReasons = new List <WellWorkOverReason>(), Equipments = new List <Equipment>(), Wells = new List <Well>(), WellWorkOvers = new List <WellWorkover>(), WellWorkoverReportObjects = new List <WellWorkoverReportObject>(), YearList = GetYears(), MonthList = GetMonths() })); } var txx = new WellWorkoverViewModel { WellWorkOverReasons = new List <WellWorkOverReason>(), Equipments = new List <Equipment>(), Wells = new List <Well>(), WellWorkOvers = new List <WellWorkover>(), WellWorkoverReportObjects = txd, YearList = GetYears(), MonthList = GetMonths() }; Session["_workRepoPage"] = 1; Session["_workoverRepoGenSearch"] = search; return(View("Report", txx)); } catch (Exception ex) { ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message); ViewBag.ErrorMessage = "No record found"; ViewBag.ErrorCode = -1; return(View("Report", new WellWorkoverViewModel { WellWorkOverReasons = new List <WellWorkOverReason>(), Equipments = new List <Equipment>(), Wells = new List <Well>(), WellWorkOvers = new List <WellWorkover>(), YearList = GetYears(), MonthList = GetMonths() })); } }
public ActionResult GetWellWorkoversByMonth(GenericSearch search) { try { if (search.Month < 1) { ViewBag.ErrorCode = -1; ViewBag.ErrorMessage = "Please provide a valid Report Month"; return(View("WellWorkovers", new WellWorkoverViewModel { WellWorkOverReasons = new List <WellWorkOverReason>(), Equipments = new List <Equipment>(), Wells = new List <Well>(), WellWorkOvers = new List <WellWorkover>(), YearList = GetYears(), MonthList = GetMonths() })); } if (search.Year < 1) { ViewBag.ErrorCode = -1; ViewBag.ErrorMessage = "Please provide a valid Search Year"; return(View("WellWorkovers", new WellWorkoverViewModel { WellWorkOverReasons = new List <WellWorkOverReason>(), Equipments = new List <Equipment>(), Wells = new List <Well>(), WellWorkOvers = new List <WellWorkover>(), YearList = GetYears(), MonthList = GetMonths() })); } var wellWorkOvers = GetWorkoversBySearchDate(search.Month, search.Year); ViewBag.SearchPeriod = Enum.GetName(typeof(MonthList), search.Month) + "/" + search.Year; ViewBag.Title = "Manage Well Workovers"; if (!wellWorkOvers.Any()) { ViewBag.ErrorCode = -1; ViewBag.ErrorMessage = "No record found"; return(View("WellWorkovers", new WellWorkoverViewModel { WellWorkOverReasons = GetWellWorkoverReasons(), Equipments = GetEquipmets(), WellObjects = GetWells(), WellWorkOvers = new List <WellWorkover>(), YearList = GetYears(), MonthList = GetMonths() })); } ViewBag.ErrorCode = 5; ViewBag.ErrorMessage = ""; return(View("~/Views/WellWorkOver/WellWorkovers.cshtml", new WellWorkoverViewModel { WellWorkOverReasons = GetWellWorkoverReasons(), Equipments = GetEquipmets(), WellObjects = GetWells(), WellWorkOvers = wellWorkOvers, YearList = GetYears(), MonthList = GetMonths() })); } catch (Exception ex) { ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message); ViewBag.ErrorCode = -1; ViewBag.ErrorMessage = "An error was encountered, the seach operation could not be completed."; return(View("~/Views/WellWorkOver/WellWorkovers.cshtml", new WellWorkoverViewModel { WellWorkOverReasons = GetWellWorkoverReasons(), Equipments = GetEquipmets(), WellObjects = GetWells(), WellWorkOvers = new List <WellWorkover>(), YearList = GetYears(), MonthList = GetMonths() })); } }
private List <ProductionObject> GetProductionObjects(int pageNumber, int itemsPerPage, GenericSearch search) { try { var productionObjects = new ProductionServices().GetProductionStaticReportByPeriod(itemsPerPage, pageNumber, search.Month, search.Year); if (!productionObjects.Any()) { return(new List <ProductionObject>()); } return(productionObjects); } catch (Exception ex) { return(new List <ProductionObject>()); } }
public ActionResult GetWellCompletionsByQueryDateDate(GenericSearch search) { try { if (search.Year < 1) { ViewBag.ErrorCode = -1; ViewBag.ErrorMessage = "Please provide a valid Report Year"; return(View("Report", new WellCompletionViewModel { WellCompletionTypes = new List <WellCompletionType>(), Wells = new List <Well>(), Equipments = new List <Equipment>(), WellCompletions = new List <WellCompletion>(), WellCompletionReportObjects = new List <WellCompletionReportObject>(), MonthList = GetMonths(), YearList = GetYears() })); } var txd = GetWellCompletionStaticReports(ItemsPerPage, PageNumber, search); if (!txd.Any()) { ViewBag.ErrorMessage = "No record found"; ViewBag.ErrorCode = -1; if (search.Month < 1) { ViewBag.SearchPeriod = search.Year; } if (search.Month > 0) { ViewBag.SearchPeriod = Enum.GetName(typeof(MonthList), search.Month) + "/" + search.Year; } return(View("Report", new WellCompletionViewModel { WellCompletionTypes = new List <WellCompletionType>(), Wells = new List <Well>(), Equipments = new List <Equipment>(), WellCompletions = new List <WellCompletion>(), WellCompletionReportObjects = new List <WellCompletionReportObject>(), MonthList = GetMonths(), YearList = GetYears() })); } ViewBag.SearchPeriod = Enum.GetName(typeof(MonthList), search.Month) + "/" + search.Year; var txx = new WellCompletionViewModel { WellCompletionTypes = new List <WellCompletionType>(), Wells = new List <Well>(), Equipments = new List <Equipment>(), WellCompletions = new List <WellCompletion>(), WellCompletionReportObjects = txd, MonthList = GetMonths(), YearList = GetYears() }; Session["_wellCompRepoGenSearch"] = search; Session["_wellCompRepoPage"] = 1; return(View("Report", txx)); } catch (Exception ex) { ViewBag.ErrorMessage = "No record found"; ViewBag.ErrorCode = -1; ViewBag.SearchPeriod = Enum.GetName(typeof(MonthList), search.Month) + "/" + search.Year; return(View("Report", new WellCompletionViewModel { WellCompletionTypes = new List <WellCompletionType>(), Wells = new List <Well>(), Equipments = new List <Equipment>(), WellCompletions = new List <WellCompletion>(), WellCompletionReportObjects = new List <WellCompletionReportObject>(), MonthList = GetMonths(), YearList = GetYears() })); } }
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>()); } }