public ActionResult AdminRegProduct(tblGarment collection)
{
try
{
//Registro de imagen
HttpPostedFileBase FileBase = Request.Files[0];
WebImage image = new WebImage(FileBase.InputStream);
string idUser = System.Web.HttpContext.Current.Session["id"].ToString();
SqlParameter param1 = new SqlParameter("@name", collection.gmtName);
SqlParameter param2 = new SqlParameter("@tipo", collection.gmtType);
SqlParameter param3 = new SqlParameter("@condicion", collection.gmtCondition);
SqlParameter param4 = new SqlParameter("@precio", collection.gmtPrice);
SqlParameter param5 = new SqlParameter("@user", idUser);
SqlParameter param6 = new SqlParameter("@img", collection.gmtImage = image.GetBytes());
//Registro de producto
var db = new DBPawnshopEntitiesConection();
db.Database.ExecuteSqlCommand("setGarmet @name, @tipo, @condicion, @precio,@user,@img", param1, param2, param3, param4, param5, param6);
TempData["Prueba"] = "SI";
@ViewData["ID"] = TempData["Prueba"];
return(View());
}
catch (Exception e)
{
return(View(e.Message));
}
}
public ActionResult DetailSoli(string id)
{
DBPawnshopEntitiesConection db = new DBPawnshopEntitiesConection();
SqlParameter param1 = new SqlParameter("@id", id);
//Datos del producto
var dataList = db.Database.SqlQuery <tblSolicitude>("getDatasSoli @id", param1).ToList();
var tipos = dataList.Select(x => x.solProdName);
var tipos2 = dataList.Select(x => x.solEstado);
String solProdName = tipos.First().ToString();
String solEstado = tipos2.First().ToString();
//Datos de usuario
string idUser = System.Web.HttpContext.Current.Session["id"].ToString();
SqlParameter param2 = new SqlParameter("@id", idUser);
var data = db.Database.SqlQuery <tblInfoUser>("sp_validarInfo @id", param2).ToList();
var tipo1 = data.Select(x => x.usInfFirstName);
var tipo2 = data.Select(x => x.usInfLastNameF);
var tipo3 = data.Select(x => x.usInfLastNameM);
String userName = tipo1.First().ToString();
String lstNameF = tipo2.First().ToString();
String lstNameM = tipo3.First().ToString();
//Datos de mensaje
@ViewData["Prodname"] = solProdName;
@ViewData["Soliestado"] = solEstado;
@ViewData["Username"] = userName;
@ViewData["LstnameF"] = lstNameF;
@ViewData["LstnameM"] = lstNameM;
return(View());
}
public ActionResult AdminListSolicitud()
{
DBPawnshopEntitiesConection db = new DBPawnshopEntitiesConection();
var data = db.Database.SqlQuery <tblSolicitude>("getListSolicitudes");
return(View(data.ToList()));
}
//Pagina de últimos mensajes
public ActionResult UserLastMessages()
{
DBPawnshopEntitiesConection db = new DBPawnshopEntitiesConection();
string idUser = System.Web.HttpContext.Current.Session["id"].ToString();
SqlParameter param1 = new SqlParameter("@id", idUser);
var data = db.Database.SqlQuery <tblSolicitude>("UserLastMessages @id", param1);
return(View(data.ToList()));
}
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"));
}
//Página de eliminar solicitud - formulario de eliminación
public ActionResult UserDelSolicitud2()
{
string idSol = System.Web.HttpContext.Current.Session["idSol"].ToString();
//Cargado de la data del producto creado
var db = new DBPawnshopEntitiesConection();
SqlParameter param1 = new SqlParameter("@id", idSol);
var data = db.Database.SqlQuery <tblSolicitude>("getDataSolicitude @id", param1).FirstOrDefault();
return(View(data));
}
//Página de eliminación de información - formulario de información
public ActionResult AdminDeleteInfo2()
{
//Cargado de datos de la información
string idBus = System.Web.HttpContext.Current.Session["idBus"].ToString();
var db = new DBPawnshopEntitiesConection();
SqlParameter param1 = new SqlParameter("@id", idBus);
var data = db.Database.SqlQuery <tblBusiness>("getDataBus @id", param1).SingleOrDefault();
return(View(data));
}
public ActionResult AdminDeleteInfo2(FormCollection collection)
{
//Eliminación de la información
string idBus = System.Web.HttpContext.Current.Session["idBus"].ToString();
var db = new DBPawnshopEntitiesConection();
SqlParameter param1 = new SqlParameter("@id", idBus);
db.Database.ExecuteSqlCommand("deleteBus @id", param1);
return(RedirectToAction("AdminDeleteInfo"));
}
//Página de editar servicios
public ActionResult AdminEditServices()
{
//Cargar lista de servicios
DBPawnshopEntitiesConection db = new DBPawnshopEntitiesConection();
var getServices = db.tblServices.ToList();
SelectList list = new SelectList(getServices, "servID", "servName");
ViewBag.Services = list;
return(View());
}
//Página de editar información
public ActionResult UserEditInfo()
{
//Cargado de datos del usuario
var idUser = System.Web.HttpContext.Current.Session["id"];
var db = new DBPawnshopEntitiesConection();
SqlParameter param1 = new SqlParameter("@id", idUser);
var data = db.Database.SqlQuery <tblInfoUser>("sp_validarInfo @id", param1).FirstOrDefault();
return(View(data));
}
//Paágina de editar servivios - Formulario de servicios
public ActionResult AdminEditServices2()
{
//Cargado de datos
string idServicio = System.Web.HttpContext.Current.Session["idServ"].ToString();
var db = new DBPawnshopEntitiesConection();
SqlParameter param1 = new SqlParameter("@id", idServicio);
var data = db.Database.SqlQuery <tblServices>("getDataServ @id", param1).FirstOrDefault();
return(View(data));
}
//Página de lista de productos
public ActionResult AdminListProduct()
{
//Lista de productos por usuario
DBPawnshopEntitiesConection db = new DBPawnshopEntitiesConection();
string idUser = System.Web.HttpContext.Current.Session["id"].ToString();
SqlParameter param1 = new SqlParameter("@id", idUser);
var data = db.Database.SqlQuery <tblGarment>("getProductData @id", param1);
return(View(data.ToList()));
}
public ActionResult AdminDeleteProduct2(FormCollection collection)
{
//Eliminación del producto
string idProd = System.Web.HttpContext.Current.Session["idGar"].ToString();
var db = new DBPawnshopEntitiesConection();
SqlParameter param1 = new SqlParameter("@id", idProd);
db.Database.ExecuteSqlCommand("deleteGarment @id", param1);
return(RedirectToAction("AdminDeleteProduct"));
}
public ActionResult ConfirmSolicitude(string id)
{
var db = new DBPawnshopEntitiesConection();
SqlParameter param1 = new SqlParameter("@id", id);
db.Database.ExecuteSqlCommand("confirmSolicitud @id", param1);
TempData["Pruebas"] = "SI";
@ViewData["ID"] = TempData["Pruebas"];
return(RedirectToAction("AdminNewSolicitud"));
}
//Pagína de eliminación de producto - formulario del producto
public ActionResult AdminDeleteProduct2()
{
//Cargado de los datos del producto
string idProd = System.Web.HttpContext.Current.Session["idGar"].ToString();
var db = new DBPawnshopEntitiesConection();
SqlParameter param1 = new SqlParameter("@id", idProd);
var data = db.Database.SqlQuery <tblGarment>("getDataGar @id", param1).FirstOrDefault();
return(View(data));
}
//Página de eliminación de información
public ActionResult AdminDeleteInfo()
{
//Lista de información
DBPawnshopEntitiesConection db = new DBPawnshopEntitiesConection();
var getInfo = db.tblBusiness.ToList();
SelectList list = new SelectList(getInfo, "bsID", "bsName");
ViewBag.Business = list;
return(View());
}
public ActionResult Create(tblUser collection)
{
//Creación de usuario
var db = new DBPawnshopEntitiesConection();
SqlParameter param1 = new SqlParameter("@email", collection.userEmail);
SqlParameter param2 = new SqlParameter("@key", collection.userKey);
SqlParameter param3 = new SqlParameter("@type", collection.userType);
var data = db.Database.ExecuteSqlCommand("setUserData @email, @key, @type", param1, param2, param3);
return(RedirectToAction("Index"));
}
//Página de eliminar solicitud
public ActionResult UserDelSolicitud()
{
string idUser = System.Web.HttpContext.Current.Session["id"].ToString();
SqlParameter param1 = new SqlParameter("@id", idUser);
DBPawnshopEntitiesConection db = new DBPawnshopEntitiesConection();
//Lista de solicitudes por usuario
var getSolicitude = db.Database.SqlQuery <tblSolicitude>("getSolicitudexUser @id", param1).ToList();
SelectList list = new SelectList(getSolicitude, "solID", "solProdName");
ViewBag.Services = list;
return(View());
}
//Página de edición de producto
public ActionResult AdminEditProduct()
{
string idUser = System.Web.HttpContext.Current.Session["id"].ToString();
SqlParameter param1 = new SqlParameter("@id", idUser);
DBPawnshopEntitiesConection db = new DBPawnshopEntitiesConection();
//Lista de productos por usuario
var getProducts = db.Database.SqlQuery <tblGarment>("getProducXUser @id", param1).ToList();
SelectList list = new SelectList(getProducts, "gmtID", "gmtName");
ViewBag.Services = list;
return(View());
}
public ActionResult Login(tblUser collection)
{
try
{
//Validación de formulario
var db = new DBPawnshopEntitiesConection();
SqlParameter param1 = new SqlParameter("@email", collection.userEmail);
SqlParameter param2 = new SqlParameter("@key", collection.userKey);
var data = db.Database.SqlQuery <tblUser>("sp_GetUserLogin @email, @key", param1, param2).SingleOrDefault();
if (data == null)
{
TempData["Prueba"] = "SI";
@ViewData["ID"] = TempData["Prueba"];
return(View());
}
else
{
//Validación de datos
SqlParameter param3 = new SqlParameter("@email", collection.userEmail);
SqlParameter param4 = new SqlParameter("@key", collection.userKey);
var dataList = db.Database.SqlQuery <tblUser>("sp_GetUserLogin @email, @key", param3, param4).ToList();
var tipos = dataList.Select(x => x.userType);
String tipo = tipos.First().ToString();
var ID = dataList.Select(x => x.ID);
String idUser = ID.First().ToString();
//Pagína de ADMIN
if (tipo == "Admin")
{
System.Web.HttpContext.Current.Session["id"] = idUser;
return(RedirectToAction("AdminIndex", "Admin"));
}
else
{
//Pagína de USER
if (tipo == "User")
{
System.Web.HttpContext.Current.Session["id"] = idUser;
return(RedirectToAction("UserIndex", "User"));
}
//Pagína de ERROR
else
{
return(View());
}
}
}
}
catch
{
return(View());
}
}
public ActionResult DetailsUser(string id)
{
var db = new DBPawnshopEntitiesConection();
SqlParameter param1 = new SqlParameter("@id", id);
var dataList = db.Database.SqlQuery <tblSolicitude>("getIDUserxSolic @id", param1).ToList();
var tipos = dataList.Select(x => x.solUserID);
String tipo = tipos.First().ToString();
SqlParameter parame1 = new SqlParameter("@ids", tipo);
var data = db.Database.SqlQuery <tblInfoUser>("getDatosUserxSoli @ids", parame1).FirstOrDefault();
return(View(data));
}
//Obtención de imagen de producto
public ActionResult getImageGar(string id)
{
var db = new DBPawnshopEntitiesConection();
tblGarment img = db.tblGarment.Find(id);
byte[] byteImage = img.gmtImage;
MemoryStream memoryStream = new MemoryStream(byteImage);
System.Drawing.Image image = System.Drawing.Image.FromStream(memoryStream);
memoryStream = new MemoryStream();
image.Save(memoryStream, ImageFormat.Jpeg);
memoryStream.Position = 0;
return(File(memoryStream, "image/jpg"));
}
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());
}
public ActionResult AdminRegServices(tblServices collection)
{
try
{
//Registrar datos
SqlParameter param1 = new SqlParameter("@name", collection.servName);
var db = new DBPawnshopEntitiesConection();
var data = db.Database.ExecuteSqlCommand("setServName @name", param1);
TempData["Prueba"] = "SI";
@ViewData["ID"] = TempData["Prueba"];
return(View());
}
catch (Exception e)
{
return(View(e.Message));
}
}
public ActionResult getImage()
{
//Obtención de imagen
string idProd = System.Web.HttpContext.Current.Session["idProduct"].ToString();
var db = new DBPawnshopEntitiesConection();
tblGarment img = db.tblGarment.Find(idProd);
byte[] byteImage = img.gmtImage;
//Asignación a memoria
MemoryStream memoryStream = new MemoryStream(byteImage);
System.Drawing.Image image = System.Drawing.Image.FromStream(memoryStream);
memoryStream = new MemoryStream();
image.Save(memoryStream, ImageFormat.Jpeg);
memoryStream.Position = 0;
return(File(memoryStream, "image/jpg"));
}
public ActionResult AdminEditProduct2(tblGarment collection)
{
//Obtención de datos del formulario
var db = new DBPawnshopEntitiesConection();
tblGarment _dbp = new tblGarment();
HttpPostedFileBase FileBase = Request.Files[0];
string idProd = System.Web.HttpContext.Current.Session["idGar"].ToString();
string idUser = System.Web.HttpContext.Current.Session["id"].ToString();
//Validación de edición de imagen
if (FileBase.ContentLength == 0)
{
//Edición de producto con misma imagen
_dbp = db.tblGarment.Find(idProd);
SqlParameter param1 = new SqlParameter("@id", idProd);
SqlParameter param2 = new SqlParameter("@name", collection.gmtName);
SqlParameter param3 = new SqlParameter("@tipo", collection.gmtType);
SqlParameter param4 = new SqlParameter("@condicion", collection.gmtCondition);
SqlParameter param5 = new SqlParameter("@precio", collection.gmtPrice);
SqlParameter param6 = new SqlParameter("@user", idUser);
SqlParameter param7 = new SqlParameter("@img", collection.gmtImage = _dbp.gmtImage);
var data = db.Database.ExecuteSqlCommand("updateGarmetData @id, @name,@tipo,@condicion,@precio,@user,@img", param1, param2, param3, param4, param5, param6, param7);
TempData["Prueba"] = "SI";
@ViewData["ID"] = TempData["Prueba"];
return(View());
}
else
{
//Edición de producto con nueva imagen
WebImage image = new WebImage(FileBase.InputStream);
SqlParameter param1 = new SqlParameter("@id", idProd);
SqlParameter param2 = new SqlParameter("@name", collection.gmtName);
SqlParameter param3 = new SqlParameter("@tipo", collection.gmtType);
SqlParameter param4 = new SqlParameter("@condicion", collection.gmtCondition);
SqlParameter param5 = new SqlParameter("@precio", collection.gmtPrice);
SqlParameter param6 = new SqlParameter("@user", idUser);
SqlParameter param7 = new SqlParameter("@img", collection.gmtImage = image.GetBytes());
var data = db.Database.ExecuteSqlCommand("updateGarmetData @id, @name,@tipo,@condicion,@precio,@user,@img", param1, param2, param3, param4, param5, param6, param7);
TempData["Prueba"] = "SI";
@ViewData["ID"] = TempData["Prueba"];
return(View());
}
}
public ActionResult AdminEditServices2(tblServices collection)
{
try
{
//Edición del servicio
string idServicios = System.Web.HttpContext.Current.Session["idServ"].ToString();
var db = new DBPawnshopEntitiesConection();
SqlParameter param1 = new SqlParameter("@id", idServicios);
SqlParameter param2 = new SqlParameter("@name", collection.servName);
var data = db.Database.ExecuteSqlCommand("updateServData @id, @name", param1, param2);
TempData["Prueba"] = "SI";
@ViewData["ID"] = TempData["Prueba"];
return(View());
}
catch (Exception e)
{
return(View(e.Message));
}
}
//Página de registrar información de usuario
public ActionResult UserRegInfo()
{
//Validar edición
var db = new DBPawnshopEntitiesConection();
string idUser = System.Web.HttpContext.Current.Session["id"].ToString();
SqlParameter param1 = new SqlParameter("@id", idUser);
var data = db.Database.SqlQuery <tblInfoUser>("exec sp_validarInfo @id", param1).ToList();
var tipos = data.Select(x => x.usID);
//Validar si existe información o no
if (tipos.FirstOrDefault() != null)
{
TempData["Pruebas"] = "SI";
@ViewData["IDs"] = TempData["Prueba"];
return(View());
}
else
{
return(View());
}
}
public ActionResult AdminRegInfo(tblBusiness collection)
{
try
{
//Registrar información del formulario
SqlParameter param1 = new SqlParameter("@name", collection.bsName);
SqlParameter param2 = new SqlParameter("@ubicacion", collection.bsLocation);
SqlParameter param3 = new SqlParameter("@email", collection.bsEmail);
SqlParameter param4 = new SqlParameter("@rama", collection.bsBranch);
SqlParameter param5 = new SqlParameter("@telefono", collection.bsPhone);
var db = new DBPawnshopEntitiesConection();
var data = db.Database.ExecuteSqlCommand("setInfoBs @name, @ubicacion, @email, @rama,@telefono", param1, param2, param3, param4, param5);
TempData["Prueba"] = "SI";
@ViewData["ID"] = TempData["Prueba"];
return(View());
}
catch (Exception e)
{
return(View(e.Message));
}
}
