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