public static List <sp_ProyectoGenerarFactura_Result> GenerarFactura(BILLS factura)
{
NorthwindEntities contexto = null;
List <sp_ProyectoGenerarFactura_Result> resultados =
new List <sp_ProyectoGenerarFactura_Result>();
try
{
contexto = new NorthwindEntities(); //Se inicializa megainstancia del Entity
//Se obtiene valores de consulta en BD
var consulta = contexto.sp_ProyectoGenerarFactura(factura.CustumerID, factura.fecha).ToList();
if (consulta != null) //Se verifica consulta sea diferente a NULL
{
foreach (var item in consulta) //Se recorre consulta
{
//Aqui se crea una instancia simple
sp_ProyectoGenerarFactura_Result r = new sp_ProyectoGenerarFactura_Result();
//se asigna valor de consulta en instancia simple
r.num_factura = item.num_factura;
r.CustumerID = item.CustumerID;
r.fecha = item.fecha;
resultados.Add(r);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(resultados);
}
public ActionResult DeleteConfirmed(int id)
{
BILLS bILLS = db.BILLS.Find(id);
db.BILLS.Remove(bILLS);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public static List <sp_ProyectoGenerarFactura_Result> GenerarFactura(BILLS factura)
{
try
{
return(AccesoDatos.GenerarFactura(factura));
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult Edit([Bind(Include = "NUMERO,FILENAME,DESCRIPTION,DATE_DOC,DATE_PAY,DATE_ADD,AMOUNT,CONTRAGENT_ID,PERIOD_ID,TYPES_ID")] BILLS bILLS)
{
if (ModelState.IsValid)
{
db.Entry(bILLS).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CONTRAGENT_ID = new SelectList(db.CONTRAGENTS, "ID", "NAME", bILLS.CONTRAGENT_ID);
ViewBag.PERIOD_ID = new SelectList(db.PERIODS, "ID", "SETTLEMENTPERIOD", bILLS.PERIOD_ID);
ViewBag.TYPES_ID = new SelectList(db.TYPESOFDOC, "ID", "TYPEOFDOC", bILLS.TYPES_ID);
return(View(bILLS));
}
// GET: BILLS/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BILLS bILLS = db.BILLS.Find(id);
if (bILLS == null)
{
return(HttpNotFound());
}
return(View(bILLS));
}
// GET: BILLS/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BILLS bILLS = db.BILLS.Find(id);
if (bILLS == null)
{
return(HttpNotFound());
}
ViewBag.CONTRAGENT_ID = new SelectList(db.CONTRAGENTS, "ID", "NAME", bILLS.CONTRAGENT_ID);
ViewBag.PERIOD_ID = new SelectList(db.PERIODS, "ID", "SETTLEMENTPERIOD", bILLS.PERIOD_ID);
ViewBag.TYPES_ID = new SelectList(db.TYPESOFDOC, "ID", "TYPEOFDOC", bILLS.TYPES_ID);
return(View(bILLS));
}
protected void btn_generarFactura_Click(object sender, ImageClickEventArgs e)
{
try
{
BILLS factura = new BILLS();
factura.CustumerID = ddl_clientes.SelectedValue.Trim().ToString();
factura.fecha = Convert.ToDateTime(DateTime.Now.ToLongTimeString());
List <sp_ProyectoGenerarFactura_Result> numero_factura = Logica.GenerarFactura(factura);
lbl_numero_factura.Text = Convert.ToString(numero_factura[0].num_factura);
ddl_clientes.Enabled = false;
btn_generarFactura.Enabled = false;
}
catch (Exception ex)
{
throw ex;
}
}
