public async Task <IActionResult> _IndexPlc(string dataFrom, string dataTo)
{
// Modific datele de afisat in functie de selectie din View
if (dataFrom == null)
{
dataFrom = _auxiliar.GetOneMonthBeforeDate();
}
if (dataTo == null)
{
dataTo = _auxiliar.GetTomorrowDate();
}
IEnumerable <PlcModel> ListaDeAfisat = await _context.Plcs.ToListAsync();
return(PartialView(ListaDeAfisat.Where(item => _auxiliar.IsDateBetween(item.DataCreation.ToString("dd.MM.yyyy HH:mm:ss"), dataFrom, dataTo))));
// return View(await _context.ProbaModels.ToListAsync());
}
public async Task <IActionResult> _Index(DateProbaDeAfisat selectieAfisareDate, string dataFrom, string dataTo, string ecranMic)
{
ViewBag.IsMallScreen = ecranMic;
// Salvez in ViewBag userName si Rol pentru a folosi in View
ViewBag.UserName = HttpContext.Session.GetString("UserName");
ViewBag.Rol = HttpContext.Session.GetString("Rol");
// Daca nu e logat redirectionez la Pagina de Login
if (ViewBag.UserName == null)
{
return(RedirectToAction("Index", "Home"));
}
// Modific datele de afisat in functie de selectie din View
if (dataFrom == null)
{
dataFrom = Auxiliar.GetOneMonthBeforeDate();
}
if (dataTo == null)
{
dataTo = Auxiliar.GetTomorrowDate();
}
IEnumerable <ProbaModel> ListaDeAfisat = await _context.ProbaModels.ToListAsync();
switch (selectieAfisareDate)
{
// Afiseaza toate datele
case DateProbaDeAfisat.Toate:
ListaDeAfisat = await _context.ProbaModels.ToListAsync();
break;
// Afiseaza doar datele introduse de operator
case DateProbaDeAfisat.ProbaIntrodusa:
ListaDeAfisat = _context.ProbaModels.Where(item => item.DataPreluare == "-" && item.DataRaspunsCalitate == "-");
break;
// Afiseaza doar datele cu probele prelevate de operator calitate
case DateProbaDeAfisat.ProbaPreluata:
ListaDeAfisat = _context.ProbaModels.Where(item => item.DataPreluare != "-" && item.DataRaspunsCalitate == "-");
break;
// Afiseaza doar datele cu rezultat la calitate
case DateProbaDeAfisat.ProbaRezultat:
ListaDeAfisat = _context.ProbaModels.Where(item => item.DataPreluare != "-" && item.DataRaspunsCalitate != "-");
break;
// Afiseaza doar datele cu RNC
case DateProbaDeAfisat.ProbaRNC:
ListaDeAfisat = _context.ProbaModels.Where(item => item.RezultatProba == Rezultat.RNC);
break;
default:
break;
}
return(PartialView(ListaDeAfisat.Where(item => Auxiliar.IsDateBetween(item.DataPrelevare, dataFrom, dataTo))));
// return View(await _context.ProbaModels.ToListAsync());
}
// Functie exportare data to excel file
public async Task <IActionResult> ExportToExcelAsync(string dataFrom, string dataTo)
{
//return Content(dataFrom + "<==>" + dataTo);
List <IndexModel> listaSql = await _context.IndexModels.ToListAsync();
IEnumerable <IndexModel> listaExcel = listaSql.Where(model => model.PlcName == "PlcCuptor");
// Extrage datele cuprinse intre limitele date de operator
IEnumerable <IndexModel> listaDeAfisat = listaExcel.Where(model => Auxiliar.IsDateBetween(model.Data, dataFrom, dataTo));
var stream = new MemoryStream();
using (var pck = new ExcelPackage(stream))
{
ExcelWorksheet ws = pck.Workbook.Worksheets.Add("Cuptor");
ws.Cells["A1:Z1"].Style.Font.Bold = true;
ws.Cells["A1"].Value = "Id";
ws.Cells["B1"].Value = "Data";
ws.Cells["C1"].Value = "Nume Plc";
ws.Cells["D1"].Value = "Index gaz";
ws.Cells["E1"].Value = "Consum gaz";
int rowStart = 2;
foreach (var elem in listaDeAfisat)
{
ws.Cells[string.Format("A{0}", rowStart)].Value = elem.Id;
ws.Cells[string.Format("B{0}", rowStart)].Value = elem.Data;
ws.Cells[string.Format("C{0}", rowStart)].Value = elem.PlcName;
ws.Cells[string.Format("D{0}", rowStart)].Value = elem.IndexValue;
ws.Cells[string.Format("E{0}", rowStart)].Value = elem.GazValue;
rowStart++;
}
ws.Cells["A:AZ"].AutoFitColumns();
pck.Save();
}
stream.Position = 0;
string excelName = "RaportGazCuptor.xlsx";
return(File(stream, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", excelName));
}
public async Task <IActionResult> Index()
{
// Salvez in ViewBag userName si Rol pentru a folosi in View
ViewBag.UserName = HttpContext.Session.GetString("UserName");
ViewBag.Rol = HttpContext.Session.GetString("Rol");
// Daca nu e logat redirectionez la Pagina de Login
if (ViewBag.UserName == null)
{
return(RedirectToAction("Index", "Home"));
}
// Logiga afisare date doar pt o luna inainte
ViewBag.dataFrom = Auxiliar.GetOneMonthBeforeDate();
ViewBag.dataTo = Auxiliar.GetTomorrowDate();
List <ProbaModel> ListaSql = await _context.ProbaModels.ToListAsync();
IEnumerable <ProbaModel> ListaDeAfisat = ListaSql.Where(item => Auxiliar.IsDateBetween(item.DataPrelevare, ViewBag.dataFrom, ViewBag.dataTo));
return(View(ListaDeAfisat));
}
// Functie exportare data to excel file
public async Task <IActionResult> ExportToExcelAsync(string dataFrom, string dataTo)
{
//return Content(dataFrom + "<==>" + dataTo);
List <ProbaModel> listaExcel = await _context.ProbaModels.ToListAsync();
// Extrage datele cuprinse intre limitele date de operator
IEnumerable <ProbaModel> listaDeAfisat = listaExcel.Where(model => Auxiliar.IsDateBetween(model.DataPrelevare, dataFrom, dataTo));
var stream = new MemoryStream();
using (var pck = new ExcelPackage(stream))
{
ExcelWorksheet ws = pck.Workbook.Worksheets.Add("Sheet1");
ws.Cells["A1:Z1"].Style.Font.Bold = true;
ws.Cells["A1"].Value = "Id";
ws.Cells["B1"].Value = "Data prelevare";
ws.Cells["C1"].Value = "Sigla furnizor";
ws.Cells["D1"].Value = "Sarja";
ws.Cells["E1"].Value = "Diametru";
ws.Cells["F1"].Value = "Calitate";
ws.Cells["G1"].Value = "Nr cuptor";
ws.Cells["H1"].Value = "Tip Tratament Termic";
ws.Cells["I1"].Value = "Cap bara";
ws.Cells["J1"].Value = "Tip proba";
ws.Cells["K1"].Value = "User name";
ws.Cells["L1"].Value = "Obs operator";
ws.Cells["M1"].Value = "Data preluare";
ws.Cells["N1"].Value = "Data raspuns";
ws.Cells["O1"].Value = "User name calitate";
ws.Cells["P1"].Value = "Rezultat proba";
ws.Cells["Q1"].Value = "KV1";
ws.Cells["R1"].Value = "KV2";
ws.Cells["S1"].Value = "KV3";
ws.Cells["T1"].Value = "Temperatura";
ws.Cells["U1"].Value = "Duritate HB";
ws.Cells["V1"].Value = "Obs Calitate";
int rowStart = 2;
foreach (var elem in listaDeAfisat)
{
ws.Cells[string.Format("A{0}", rowStart)].Value = elem.ProbaModelId;
ws.Cells[string.Format("B{0}", rowStart)].Value = elem.DataPrelevare;
ws.Cells[string.Format("C{0}", rowStart)].Value = elem.SiglaFurnizor;
ws.Cells[string.Format("D{0}", rowStart)].Value = elem.Sarja;
ws.Cells[string.Format("E{0}", rowStart)].Value = elem.Diametru;
ws.Cells[string.Format("F{0}", rowStart)].Value = elem.Calitate;
ws.Cells[string.Format("G{0}", rowStart)].Value = elem.NumarCuptor;
ws.Cells[string.Format("H{0}", rowStart)].Value = elem.TipTratamentTermic;
ws.Cells[string.Format("I{0}", rowStart)].Value = elem.TipCapBara;
ws.Cells[string.Format("J{0}", rowStart)].Value = elem.Tipproba;
ws.Cells[string.Format("K{0}", rowStart)].Value = elem.UserName;
ws.Cells[string.Format("L{0}", rowStart)].Value = elem.ObservatiiOperator;
ws.Cells[string.Format("M{0}", rowStart)].Value = elem.DataPreluare;
ws.Cells[string.Format("N{0}", rowStart)].Value = elem.DataRaspunsCalitate;
ws.Cells[string.Format("O{0}", rowStart)].Value = elem.NumeUtilizatorCalitate;
ws.Cells[string.Format("P{0}", rowStart)].Value = elem.RezultatProba;
ws.Cells[string.Format("Q{0}", rowStart)].Value = elem.KV1;
ws.Cells[string.Format("R{0}", rowStart)].Value = elem.KV2;
ws.Cells[string.Format("S{0}", rowStart)].Value = elem.KV3;
ws.Cells[string.Format("T{0}", rowStart)].Value = elem.Temperatura;
ws.Cells[string.Format("U{0}", rowStart)].Value = elem.DuritateHB;
ws.Cells[string.Format("V{0}", rowStart)].Value = elem.ObservatiiCalitate;
rowStart++;
}
ws.Cells["A:AZ"].AutoFitColumns();
pck.Save();
}
stream.Position = 0;
string excelName = "RaportTrackingMostre.xlsx";
return(File(stream, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", excelName));
}
