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