private async Task SetViewBagsForDates(VMRuloFilters ruloFilters) { ViewBag.dtBegin = ruloFilters.dtBegin.ToString("yyyy-MM-dd"); ViewBag.dtEnd = ruloFilters.dtEnd.ToString("yyyy-MM-dd"); var testCategoryList = await factory.TestCategories.GetTestCategoryList(); var testCategorylist2 = WebUtilities.Create <TestCategory>(testCategoryList, "TestCategoryID", "TestCode", true, "All"); var definitionProcessList = await factory.DefinationProcesses.GetDefinationProcessList(); var definitionProcessList2 = WebUtilities.Create <DefinationProcess>(definitionProcessList, "DefinationProcessID", "Name", true, "All"); ViewBag.TestCategorytList = testCategorylist2; ViewBag.DefinitionProcessList = definitionProcessList2; ViewBag.ModalTestResultList = System.Text.Json.JsonSerializer.Serialize(testCategorylist2); ViewBag.numLote = ruloFilters.numLote; ViewBag.numBeam = ruloFilters.numBeam; ViewBag.numLoom = ruloFilters.numLoom; ViewBag.numPiece = ruloFilters.numPiece; ViewBag.txtStyle = ruloFilters.txtStyle; ViewBag.numTestCategory = ruloFilters.numTestCategory; ViewBag.numDefinitionProcess = ruloFilters.numDefinitionProcess; ViewBag.folioNumber = ruloFilters.FolioNumber; //Style list var styleList = await factory.Rulos.GetRuloStyleList(); ViewBag.StyleList = styleList; }
public async Task <IActionResult> Index(VMRuloFilters ruloFilters) { ruloFilters.dtEnd = ruloFilters.dtEnd.AddDays(1).AddMilliseconds(-1); var result = await factory.Rulos.GetRuloListFromFilters(ruloFilters); await SetViewBagsForDates(ruloFilters); return(View(result)); }
public async Task <IActionResult> Index() { VMRuloFilters ruloFilters = new VMRuloFilters(); ruloFilters.dtBegin = DateTime.Today.AddMonths(-1); ruloFilters.dtEnd = DateTime.Today.AddDays(1).AddMilliseconds(-1); var result = await factory.Rulos.GetRuloListFromBetweenDate(ruloFilters.dtBegin, ruloFilters.dtEnd); await SetViewBagsForDates(ruloFilters); return(View(result)); }
public async Task <IActionResult> ExportToExcel(VMRuloFilters ruloFilters) { ruloFilters.dtEnd = ruloFilters.dtEnd.AddDays(1).AddMilliseconds(-1); var result = await factory.Rulos.GetRuloListFromFilters(ruloFilters); ExportToExcel export = new ExportToExcel(); string reportName = "Finishing Report"; string fileName = $"Finishing Report_{DateTime.Today.Year}_{DateTime.Today.Month.ToString().PadLeft(2, '0')}_{DateTime.Today.Day.ToString().PadLeft(2, '0')}.xlsx"; var fileResult = await export.Export <VMRulo>("Global Denim S.A. de C.V.", "Finishing", reportName, fileName, result.ToList()); if (!fileResult.Item1) { return(NotFound()); } return(fileResult.Item2); }
public abstract Task <IEnumerable <VMRulo> > GetRuloListFromFilters(VMRuloFilters ruloFilters);
public override async Task <IEnumerable <VMRulo> > GetRuloListFromFilters(VMRuloFilters ruloFilters) { var query = repository.GetQueryable(x => !x.IsDeleted && ((x.CreatedDate <= ruloFilters.dtEnd && x.CreatedDate >= ruloFilters.dtBegin) || (x.CreatedDate <= ruloFilters.dtBegin && x.CreatedDate >= ruloFilters.dtEnd))); var rulos = ( from r in query where (!(ruloFilters.numLote > 0) || r.Lote == ruloFilters.numLote.ToString()) && (!(ruloFilters.numBeam > 0) || r.Beam == ruloFilters.numBeam) && (!(ruloFilters.numLoom > 0) || r.Loom == ruloFilters.numLoom) && (!(ruloFilters.numPiece > 0) || r.Piece == ruloFilters.numPiece) && (!(ruloFilters.FolioNumber > 0) || r.FolioNumber == ruloFilters.FolioNumber) && ((string.IsNullOrWhiteSpace(ruloFilters.txtStyle)) || r.Style.Contains(ruloFilters.txtStyle)) select r ).ToList(); var testResults = await testResultRepository.GetWhere(x => !x.IsDeleted); var testCategories = await testCategoryRepository.GetWhere(x => x.TestCategoryID != 0); var result = (from r in rulos join tr in testResults.ToList() on r.TestResultID equals tr.TestResultID into ljTR from subTR in ljTR.DefaultIfEmpty() join tc in testCategories.ToList() on subTR?.TestCategoryID equals tc.TestCategoryID into ljTC from subTC in ljTC.DefaultIfEmpty() select new VMRulo { RuloID = r.RuloID, Lote = r.Lote, Beam = r.Beam, Loom = r.Loom, Piece = r.Piece, Style = r.Style, StyleName = r.StyleName, Width = r.Width, EntranceLength = r.EntranceLength, ExitLength = r.ExitLength, IsWaitingAnswerFromTest = r.IsWaitingAnswerFromTest, TestResultID = r.TestResultID, CanContinue = subTR?.CanContinue ?? false, TestCategoryID = subTC?.TestCategoryID ?? 0, TestCategoryCode = subTC?.TestCode ?? string.Empty }).ToList(); if (ruloFilters.numDefinitionProcess != 0) { var ruloProcess = ruloProcessRepository.GetQueryable(x => !x.IsDeleted && ((x.BeginningDate <= ruloFilters.dtEnd && x.BeginningDate >= ruloFilters.dtBegin) || (x.BeginningDate <= ruloFilters.dtBegin && x.BeginningDate >= ruloFilters.dtEnd)) && x.EndDate == null && x.DefinationProcessID == ruloFilters.numDefinitionProcess).ToList(); result = (from r in result join rp in ruloProcess on r.RuloID equals rp.RuloID where rp.DefinationProcessID == ruloFilters.numDefinitionProcess select r).ToList(); } if (ruloFilters.numTestCategory != 0) { result = result.Where(x => x.TestCategoryID == ruloFilters.numTestCategory).ToList(); } var sql = query.ToQueryString(); return(result); }