public IActionResult CaptureRatio(NetCorePSAV.Models.NCRModel.SearchNCR nCR, string Consulta, string Exporta)
{
GCCorePSAV.Data.clsQuery cls = new GCCorePSAV.Data.clsQuery();
if (!string.IsNullOrEmpty(Exporta))
{
return(RedirectToAction("ExportCRResult", nCR));
}
if (Consulta.Equals("1"))
{
List <NetCorePSAV.Models.NCRModel.PreConsultaNCR> preConsultaNCRs = cls.GetPreConsultaNCRs(nCR);
if (preConsultaNCRs.Count > 0)
{
ViewBag.TieneFilas = true; //Location - Cascade
ViewBag.Locations = cls.GetNLocations();
//MotivoLb
ViewBag.LBMotivo = cls.GetMotivos();
}
else
{
ViewBag.Locations = cls.GetNLocations();
//MotivoLb
ViewBag.LBMotivo = cls.GetMotivos();
ViewBag.TieneFilas = false;
}
ViewBag.CRResult = preConsultaNCRs;
}
return(View(nCR));
}
// GET: /<controller>/
public IActionResult CaptureRatio()
{
GCCorePSAV.Data.clsQuery cls = new GCCorePSAV.Data.clsQuery();
ViewBag.TieneFilas = false;
//Location - Cascade
ViewBag.Locations = cls.GetNLocations();
//MotivoLb
ViewBag.LBMotivo = cls.GetMotivos();
return(View());
}
public IActionResult ExportCRResult(NetCorePSAV.Models.NCRModel.SearchNCR nCR)
{
GCCorePSAV.Data.clsQuery cls = new GCCorePSAV.Data.clsQuery();
try
{
var fileDownloadName = "CaptureRatio.xlsx";
var reportsFolder = "reports";
var fileInfo = new FileInfo(Path.Combine(_hostingEnvironment.WebRootPath, reportsFolder, fileDownloadName));
byte[] ReportArray;
using (ExcelPackage package = new ExcelPackage(fileInfo))
{
ExcelWorksheet ews = package.Workbook.Worksheets[1];
//obtiene lista entera de consulta de ncr
List <NetCorePSAV.Models.NCRModel.NCRReporte> reportes = cls.GetCRReportes(nCR);
//llena campos de lista ncr
for (int i = 0; i < reportes.Count; i++)
{
ews.Cells["A" + (i + 3).ToString()].Value = reportes[i].nloc;
ews.Cells["b" + (i + 3).ToString()].Value = reportes[i].numloc;
ews.Cells["c" + (i + 3).ToString()].Value = reportes[i].region;
ews.Cells["d" + (i + 3).ToString()].Value = reportes[i].ciudad;
ews.Cells["e" + (i + 3).ToString()].Value = cls.GetNameSMDet(reportes[i].det, "1");
ews.Cells["f" + (i + 3).ToString()].Value = cls.GetNameSMDet(reportes[i].smgr, "2");
ews.Cells["g" + (i + 3).ToString()].Value = reportes[i].prospecto;
ews.Cells["h" + (i + 3).ToString()].Value = reportes[i].empresa;
ews.Cells["i" + (i + 3).ToString()].Value = reportes[i].correo;
ews.Cells["j" + (i + 3).ToString()].Value = reportes[i].telefono;
ews.Cells["k" + (i + 3).ToString()].Value = reportes[i].etiqueta;
ews.Cells["l" + (i + 3).ToString()].Value = reportes[i].tipoevento;
ews.Cells["m" + (i + 3).ToString()].Value = reportes[i].nomevento;
ews.Cells["n" + (i + 3).ToString()].Value = Convert.ToDateTime(reportes[i].finicio).ToString("dd/MM/yyyy");
ews.Cells["o" + (i + 3).ToString()].Value = Convert.ToDateTime(reportes[i].ffin).ToString("dd/MM/yyyy");
ews.Cells["p" + (i + 3).ToString()].Value = reportes[i].ciaav;
ews.Cells["q" + (i + 3).ToString()].Value = reportes[i].lb;
ews.Cells["q" + (i + 3).ToString()].Style.Numberformat.Format = "0.00";
ews.Cells["r" + (i + 3).ToString()].Value = reportes[i].lbm;
ews.Cells["s" + (i + 3).ToString()].Value = reportes[i].servadic;
ews.Cells["t" + (i + 3).ToString()].Value = reportes[i].lpe;
ews.Cells["u" + (i + 3).ToString()].Value = Convert.ToDateTime(reportes[i].fpe).ToString("dd/MM/yyyy");
ews.Cells["v" + (i + 3).ToString()].Value = reportes[i].comentarios;
}
//termina excel
ReportArray = package.GetAsByteArray();
}
return(File(ReportArray, XlsxContentType, "CaptureRatio_" + System.DateTime.Now.ToString("ddMMyyyy") + ".xlsx"));
}
catch (Exception ex) { ViewBag.datashow = ex.Message; return(View()); }
}
public IActionResult NewCR(NetCorePSAV.Models.NCRModel.newCRView NCR, string hiddenEle)
{
GCCorePSAV.Data.clsQuery cls = new GCCorePSAV.Data.clsQuery();
if (ModelState.IsValid)
{
NCR.sadic = hiddenEle;
//get send items to sum ammounts
string[] arrayServAdic = hiddenEle.Split(',');
double valor = 0;
foreach (string str in arrayServAdic)
{
valor = valor + cls.GetServAdicAmmount(str);
}
NCR.LB = valor.ToString();
//end get items
cls.SaveNCR(NCR);
return(RedirectToAction("CaptureRatio"));
}
else
{
//get all data from DB
//DET
ViewBag.DET = cls.GetDETs();
//SAles Manager
ViewBag.RepVtas = cls.RepVtas();
//Location - Cascade
ViewBag.Locations = cls.GetNLocations();
ViewBag.datasourceC = cls.GetCiudades();
ViewBag.datasourceI = cls.GetNuLocations();
//Etiqueta
ViewBag.Etiquetas = cls.GetEtiquetas();
//TipoEvento
ViewBag.TipoEvento = cls.GetTipoEventos();
//MotivoLb
ViewBag.LBMotivo = cls.GetMotivos();
//Sadic
ViewBag.sadic = cls.GetSadics();
return(View());
}
}
public IActionResult NewCR()
{
GCCorePSAV.Data.clsQuery cls = new GCCorePSAV.Data.clsQuery();
//get all data from DB
//DET
ViewBag.DET = cls.GetDETs();
//SAles Manager
ViewBag.RepVtas = cls.RepVtas();
//Location - Cascade
ViewBag.Locations = cls.GetNLocations();
ViewBag.datasourceC = cls.GetCiudades();
ViewBag.datasourceI = cls.GetNuLocations();
//Etiqueta
ViewBag.Etiquetas = cls.GetEtiquetas();
//TipoEvento
ViewBag.TipoEvento = cls.GetTipoEventos();
//MotivoLb
ViewBag.LBMotivo = cls.GetMotivos();
//Sadic
ViewBag.sadic = cls.GetSadics();
return(View());
}