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);
}
