public ActionResult DeleteConfirmed(int id) { salida salida = db.salida.Find(id); db.salida.Remove(salida); db.SaveChanges(); return(RedirectToAction("Index")); }
public void generarReporte() { Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application(); int i = 2; salida salidaaux = new salida(); Excel.Workbook xlWorkBook; Excel.Worksheet xlWorkSheet; object misValue = System.Reflection.Missing.Value; xlWorkBook = xlApp.Workbooks.Add(misValue); xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1); if (xlApp == null) { MessageBox.Show("Excel is not properly installed!!"); return; } xlWorkSheet.Cells[1, 1] = "MatriculaUsuario"; xlWorkSheet.Cells[1, 2] = "Articulo"; xlWorkSheet.Cells[1, 3] = "MatriculaSolicitante"; xlWorkSheet.Cells[1, 4] = "Hora"; xlWorkSheet.Cells[1, 5] = "Fecha"; xlWorkSheet.Cells[1, 6] = "Cantidad"; //usu = uvm.context.context.usuario.Where(u => u.Matricula == txtMatri.Text).FirstOrDefault(); foreach (var salida in salidas) { xlWorkSheet.Cells[i, 1] = salida.USUARIO_Matricula; articulo = svm.context.context.producto.Where(s => s.idProducto == salida.PRODUCTO_idProducto).FirstOrDefault(); xlWorkSheet.Cells[i, 2] = articulo.Nombre; xlWorkSheet.Cells[i, 3] = salida.USUARIO_Matricula1; xlWorkSheet.Cells[i, 4] = salida.hora.ToString(); xlWorkSheet.Cells[i, 5] = salida.fecha; xlWorkSheet.Cells[i, 6] = salida.cantidad; i++; } try { xlWorkBook.SaveAs("D:\\ReporteSalidas.xls", Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue); xlWorkBook.Close(true, misValue, misValue); xlApp.Quit(); Marshal.ReleaseComObject(xlWorkSheet); Marshal.ReleaseComObject(xlWorkBook); Marshal.ReleaseComObject(xlApp); MessageBox.Show("Reporte generado con éxito."); } catch { MessageBox.Show("No se pudo generar el reporte."); } }
public ActionResult Edit([Bind(Include = "id,idempleado,tipo,motivo,fesalida")] salida salida) { if (ModelState.IsValid) { db.Entry(salida).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.idempleado = new SelectList(db.empleado, "id", "codigo", salida.idempleado); return(View(salida)); }
public ActionResult Create([Bind(Include = "id,idempleado,tipo,motivo,fesalida")] salida salida, DateTime?Fecha = null, string tipo = "") { if (ModelState.IsValid) { salida.fesalida = Fecha.Value.Date; salida.tipo = tipo; db.salida.Add(salida); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.idempleado = new SelectList(db.empleado, "id", "codigo", salida.idempleado); return(View(salida)); }
// GET: Salida/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } salida salida = db.salida.Find(id); if (salida == null) { return(HttpNotFound()); } return(View(salida)); }
// GET: Salida/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } salida salida = db.salida.Find(id); if (salida == null) { return(HttpNotFound()); } ViewBag.idempleado = new SelectList(db.empleado, "id", "codigo", salida.idempleado); return(View(salida)); }
public void AddSalida(salida _salida) { using (var api = new BusinessContext()) { try { api.AddSalida(_salida); } catch (Exception ex) { return; } Salidas.Add(_salida); } }