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