public ActionResult UserDelSolicitud(tblSolicitude collection)
{
var optionValue = Request.Form["Solicitud"];
System.Web.HttpContext.Current.Session["idSol"] = optionValue;
return(RedirectToAction("UserDelSolicitud2"));
}
public ActionResult UserDelSolicitud2(tblSolicitude collection)
{
//Eliminación de la solicitud
string idSol = System.Web.HttpContext.Current.Session["idSol"].ToString();
var db = new DBPawnshopEntitiesConection();
SqlParameter param1 = new SqlParameter("@id", idSol);
db.Database.ExecuteSqlCommand("deleteSolicitude @id", param1);
return(RedirectToAction("UserDelSolicitud"));
}
public ActionResult UserEditSolicitud2(tblSolicitude collection)
{
string idSol = System.Web.HttpContext.Current.Session["idSol"].ToString();
//Editar solicitud
SqlParameter param1 = new SqlParameter("@id", idSol);
SqlParameter param2 = new SqlParameter("@fecha", collection.solFecha);
SqlParameter param3 = new SqlParameter("@hora", collection.solHora);
var db = new DBPawnshopEntitiesConection();
db.Database.ExecuteSqlCommand("updateSoliData @id, @fecha, @hora", param1, param2, param3);
TempData["Prueba"] = "SI";
@ViewData["ID"] = TempData["Prueba"];
return(View());
}
public ActionResult UserRegSolicitud2(tblSolicitude collection)
{
//Sesiones de usuario y producto
string idUser = System.Web.HttpContext.Current.Session["id"].ToString();
string idGar = System.Web.HttpContext.Current.Session["idGar"].ToString();
//Registrar solicitud respecto al producto
SqlParameter param1 = new SqlParameter("@id", idUser);
SqlParameter param2 = new SqlParameter("@idProd", idGar);
SqlParameter param3 = new SqlParameter("@fecha", collection.solFecha);
SqlParameter param4 = new SqlParameter("@hora", collection.solHora);
var db = new DBPawnshopEntitiesConection();
db.Database.ExecuteSqlCommand("setSolicitude @id,@idProd, @fecha, @hora", param1, param2, param3, param4);
TempData["Prueba"] = "SI";
@ViewData["ID"] = TempData["Prueba"];
return(View());
}
