public ActionResult Edit(Ytbl_ProgCorteModels model)
{
//model.Date_Programed =;
foreach (var item in Ytbl_ProgCorteModels.ListProgCorte)
{
model.Document_Name = item.Document_Name;
model.Customer_Number_Upload = item.Customer_Number_Upload;
model.Nick_User = item.Nick_User;
model.Date_Upload = item.Date_Upload;
model.Date_Programed = item.Date_Programed;
}
Ytbl_ProgCorteModels ProgCorte = new Ytbl_ProgCorteModels();
if (ProgCorte.UpdateYtbl_ProgCorte(model))
{
TempData["AlertMessage"] = "CORTE EDITADO CON EXITO";
return(RedirectToAction("Index"));
}
else
{
TempData["AlertMessage"] = "Error al editar el corte";
return(View("Error"));
}
}
public ActionResult Create(Ytbl_ProgCorteModels model)
{
foreach (var item in Ytbl_ProgCorteModels.ListProgCorte)
{
model.Document_Name = item.Document_Name;
model.Document_Name = item.Document_Name;
model.Customer_Number_Upload = item.Customer_Number_Upload;
model.Nick_User = item.Nick_User;
model.Date_Programed = DateTime.Now;
model.Date_Upload = DateTime.Now;
model.IsValid = "N";
}
if (model.ExecuteSave(model))
{
TempData["AlertMessage"] = "CORTE CREADO CON EXITO";
return(RedirectToAction("Index"));
}
else
{
TempData["AlertMessage"] = "Error al crear el corte";
return(View("Error"));
}
}
public ActionResult Index()
{
Ytbl_ProgCorteModels progCorte = new Ytbl_ProgCorteModels();
List <Ytbl_ProgCorteModels> listProgCorte = new List <Ytbl_ProgCorteModels>();
listProgCorte = progCorte.SelectYtbl_ProgCorte();
return(View(listProgCorte));
}
public ActionResult Edit(int id)
{
Ytbl_ProgCorteModels progCorte = new Ytbl_ProgCorteModels();
List <Ytbl_ProgCorteModels> ListProgCorte = new List <Ytbl_ProgCorteModels>();
progCorte = progCorte.SelectYtbl_ProgCorteId(id);
ListProgCorte.Add(progCorte);
Ytbl_ProgCorteModels.ListProgCorte = ListProgCorte;
return(View(progCorte));
}
public void TestGuardaProgCorte()
{
Ytbl_ProgCorteModels save = new Ytbl_ProgCorteModels();
save.Document_Name = "Prueba1";
save.Customer_Number_Upload = "1";
save.Nick_User = "******";
save.Date_Programed = DateTime.Now;
save.Date_Upload = DateTime.Now;
save.IsValid = "Y";
//save.SaveYtbl_ProgCorte();
}
public ActionResult Create()
{
Ytbl_ProgCorteModels ProgCorte = new Ytbl_ProgCorteModels();
foreach (var item in Ytbl_ProgCorteModels.ListProgCorte)
{
ProgCorte.Document_Name = item.Document_Name;
ProgCorte.Customer_Number_Upload = item.Customer_Number_Upload;
ProgCorte.Nick_User = item.Nick_User;
ProgCorte.Date_Programed = DateTime.Now;
ProgCorte.Date_Upload = DateTime.Now;
ProgCorte.IsValid = "N";
}
return(View(ProgCorte));
}
public ActionResult View(int id)
{
Ytbl_ProgCorteModels model = new Ytbl_ProgCorteModels();
ViewData["bancos"] = model.getStadistic(id, "BANCO");
ViewData["ciudad"] = model.getStadistic(id, "CIUDAD");
ViewData["negocio"] = model.getStadistic(id, "BUSINESS");
ViewData["empresaFacturadora"] = model.getStadistic(id, "COMPANY");
ViewData["cuentas"] = model.getStadistic(id, "CUENTAS");
ViewBag.view = true;
return(View());
}
public ActionResult ExportToExcel(int id)
{
Ytbl_ProgCorteModels corteResult = new Ytbl_ProgCorteModels();
var gv = new GridView();
gv.DataSource = corteResult.getReport(id);
gv.DataBind();
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename=DemoExcel.xls");
Response.ContentType = "application/ms-excel";
Response.Charset = "";
StringWriter objStringWriter = new StringWriter();
HtmlTextWriter objHtmlTextWriter = new HtmlTextWriter(objStringWriter);
gv.RenderControl(objHtmlTextWriter);
Response.Output.Write(objStringWriter.ToString());
Response.Flush();
Response.End();
return(View("Result"));
}
public void TestConsultaCortes()
{
Ytbl_ProgCorteModels progCorte = new Ytbl_ProgCorteModels();
List <Ytbl_ProgCorteModels> listProgCorte = new List <Ytbl_ProgCorteModels>();
List <Ytbl_ProgCorteModels> comparaLista = new List <Ytbl_ProgCorteModels>();
Ytbl_ProgCorteModels save = new Ytbl_ProgCorteModels();
save.Document_Name = "Prueba1";
save.Customer_Number_Upload = "1";
save.Nick_User = "******";
save.Date_Programed = DateTime.Now;
save.Date_Upload = DateTime.Now;
save.IsValid = "Y";
comparaLista.Add(save);
listProgCorte = progCorte.SelectYtbl_ProgCorte();
Assert.AreEqual(comparaLista.Count, listProgCorte.Count);
}
public ActionResult Result(int id)
{
Ytbl_ProgCorteModels corteResult = new Ytbl_ProgCorteModels();
return(View(corteResult.getReport(id)));
}
private List <Ytbl_DetalleProgCorteModels> UploadFile(HttpPostedFileBase upload)
{
List <Ytbl_DetalleProgCorteModels> DetalleCorteLista = new List <Ytbl_DetalleProgCorteModels>();
int i = 0;
DetalleCorteLista.Clear();
string fileName = upload.FileName;
string filePath4 = Path.GetTempPath();
string filePath = Path.Combine(filePath4, fileName);
upload.SaveAs(filePath);
using (var reader = new StreamReader(filePath))
{
string headerLine = reader.ReadLine();
while (!reader.EndOfStream)
{
var line = reader.ReadLine();
var values = line.Split(';');
Ytbl_DetalleProgCorteModels DetalleProgCorte = new Ytbl_DetalleProgCorteModels();
DetalleProgCorte.counter = i++;
if (values[0] != null)
{
DetalleProgCorte.CpartyId = Int64.Parse(values[0]);
}
else
{
DetalleProgCorte.CpartyId = null;
}
if (values[1] != null)
{
DetalleProgCorte.CpartyAccountId = Int64.Parse(values[1]);
}
else
{
DetalleProgCorte.CpartyAccountId = null;
}
if (values[2] != null)
{
DetalleProgCorte.CitemId = Int64.Parse(values[2]);
}
else
{
DetalleProgCorte.CitemId = null;
}
if (values[3] != null)
{
DetalleProgCorte.Ciudad = int.Parse(values[3]);
}
else
{
DetalleProgCorte.Ciudad = null;
}
if (values[4] != null)
{
DetalleProgCorte.BancoId = values[4];
}
else
{
DetalleProgCorte.BancoId = null;
}
if (values[5] != null)
{
DetalleProgCorte.FormaPago = values[5];
}
else
{
DetalleProgCorte.FormaPago = null;
}
if (values[6] != null)
{
DetalleProgCorte.EmpresaFacturadora = values[6];
}
else
{
DetalleProgCorte.EmpresaFacturadora = null;
}
if (values[7] != null)
{
DetalleProgCorte.TipoNegocio = values[7];
}
else
{
DetalleProgCorte.TipoNegocio = null;
}
try
{
if (values[8] != null)
{
DetalleProgCorte.FieldV1 = values[8];
}
}
catch (IndexOutOfRangeException ex)
{
DetalleProgCorte.FieldV1 = null;
}
try
{
if (values[9] != null)
{
DetalleProgCorte.FieldV2 = values[9];
}
}
catch (IndexOutOfRangeException ex)
{
DetalleProgCorte.FieldV2 = null;
}
try
{
if (values[10] != null)
{
DetalleProgCorte.FieldN1 = int.Parse(values[10]);
}
}
catch (IndexOutOfRangeException ex)
{
DetalleProgCorte.FieldN1 = null;
}
try
{
if (values[11] != null)
{
DetalleProgCorte.FieldN2 = int.Parse(values[11]);
}
}
catch (IndexOutOfRangeException ex)
{
DetalleProgCorte.FieldN2 = null;
}
try
{
if (values[12] != null)
{
DetalleProgCorte.FieldD1 = DateTime.Parse(values[12]);
}
}
catch (IndexOutOfRangeException ex)
{
DetalleProgCorte.FieldD1 = null;
}
DetalleProgCorte.Status = "P";
DetalleCorteLista.Add(DetalleProgCorte);
}
}
Ytbl_ProgCorteModels CreateNew = new Ytbl_ProgCorteModels();
HttpContext ctx = System.Web.HttpContext.Current;
string User = ctx.Session["usuario"].ToString();
CreateNew.Document_Name = fileName;
CreateNew.Customer_Number_Upload = i.ToString();
CreateNew.Nick_User = User;
CreateNew.IsValid = "N";
List <Ytbl_ProgCorteModels> ListProgCorte = new List <Ytbl_ProgCorteModels>();
ListProgCorte.Add(CreateNew);
Ytbl_ProgCorteModels.ListProgCorte = null;
Ytbl_ProgCorteModels.ListProgCorte = ListProgCorte;
Ytbl_ProgCorteModels.DetalleCorte = null;
Ytbl_ProgCorteModels.DetalleCorte = DetalleCorteLista;
return(DetalleCorteLista);
}
