public ActionResult DeleteUser(int UserId)
{
DataAccessLayout objDB = new DataAccessLayout();
int result = objDB.DELETE(UserId);
TempData["userOBJ"] = result;
ModelState.Clear();
return(RedirectToAction("index"));
}
public ActionResult UpdateUser(ListTablaViewModel objUsu)
{
if (ModelState.IsValid)
{
DataAccessLayout objDB = new DataAccessLayout();
string result = objDB.UPDATEDATA(objUsu);
TempData["userOBJ"] = result;
return(RedirectToAction("index"));
}
else
{
ModelState.AddModelError("", "Error en la Edicion de datos");
return(View());
}
}
public ActionResult generarReporte()
{
DataAccessLayout objDB = new DataAccessLayout();
ReportDocument rd = new ReportDocument();
rd.Load(Path.Combine(Server.MapPath("~/Reports"), "CrystalReport2.rpt"));
rd.SetDataSource(objDB.GetData().ToList());
Response.Buffer = false;
Response.ClearContent();
Response.ClearHeaders();
try
{
Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, SeekOrigin.Begin);
return(File(stream, "application/pdf", "Lista_Usuarios.pdf"));
}catch (Exception ex)
{
throw ex;
}
}
public ActionResult GetUsuarioById(int UserId)
{
DataAccessLayout objDB = new DataAccessLayout();
return(Json(objDB.GetDataBYID(UserId), JsonRequestBehavior.AllowGet));
}
public JsonResult GetInfo()
{
DataAccessLayout objDB = new DataAccessLayout();
return(Json(objDB.GetData(), JsonRequestBehavior.AllowGet));
}
