public ActionResult checkOut(TBL_ORDER O) { List <cart> adcart = TempData["cart"] as List <cart>; TBL_INVOICE i = new TBL_INVOICE(); i.INV_FK_USR = Convert.ToInt32(Session["u_id"].ToString()); i.INV_DATE = System.DateTime.Now; i.INV_TOTALIBILL = (float)TempData["total"]; db.TBL_INVOICE.Add(i); db.SaveChanges(); foreach (var item in adcart) { TBL_ORDER od = new TBL_ORDER(); od.O_FK_PROD = item.productid; od.O_FK_INV = i.INV_ID; od.O_DATE = System.DateTime.Now; od.O_QTY = item.qty; od.O_UNITPRICE = (int)item.price; od.O_BILL = item.bill; db.TBL_ORDER.Add(od); db.SaveChanges(); } TempData.Remove("total"); TempData.Remove("cart"); TempData["msg"] = "Transaction completed..."; TempData.Keep(); return(RedirectToAction("Index")); }
public ActionResult Create([Bind(Include = "idCupon,cantidad,codigo,fechaCaducidad,porcentajeDescuento,descripcion")] Cupon cupon) { if (ModelState.IsValid) { db.Cupon.Add(cupon); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(cupon)); }
public ActionResult Create([Bind(Include = "idTalle,descripcion")] Talle talle) { if (ModelState.IsValid) { db.Talle.Add(talle); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(talle)); }
public ActionResult Create([Bind(Include = "idGarantia,descripcion,duracion")] Garantia garantia) { if (ModelState.IsValid) { db.Garantia.Add(garantia); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(garantia)); }
public ActionResult Create([Bind(Include = "idColor,descripcion")] Color color) { if (ModelState.IsValid) { db.Color.Add(color); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(color)); }
public ActionResult Create([Bind(Include = "idBanco,nombre")] Banco banco) { if (ModelState.IsValid) { db.Banco.Add(banco); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(banco)); }
public ActionResult Create([Bind(Include = "idCategoria,descripcion")] Categoria categoria) { if (ModelState.IsValid) { db.Categoria.Add(categoria); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(categoria)); }
public ActionResult Create([Bind(Include = "idSubCategoria,idCategoria,descripcion")] SubCategoria subCategoria) { if (ModelState.IsValid) { db.SubCategoria.Add(subCategoria); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.idCategoria = new SelectList(db.Categoria, "idCategoria", "descripcion", subCategoria.idCategoria); return(View(subCategoria)); }
public ActionResult Create(Usuario usuario) { if (ModelState.IsValid) { db.Usuario.Add(usuario); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.idEstadoUsuario = new SelectList(db.UsuarioEstado, "idEstado", "descripcion", usuario.idEstadoUsuario); return(View(usuario)); }
public ActionResult Create([Bind(Include = "idSucursal,idDireccion,telefono,email,descripcion")] Sucursal sucursal) { if (ModelState.IsValid) { db.Sucursal.Add(sucursal); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.idDireccion = new SelectList(db.Direccion, "idDireccion", "direccion1", sucursal.idDireccion); return(View(sucursal)); }
public ActionResult Create([Bind(Include = "idUsuario,userName,email,cantidadPenalizacion,idEstadoUsuario")] Usuario usuario) { if (ModelState.IsValid) { db.Usuario.Add(usuario); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.idEstadoUsuario = new SelectList(db.UsuarioEstado, "idEstado", "descripcion", usuario.idEstadoUsuario); return(View(usuario)); }
public ActionResult Create([Bind(Include = "datosPersonalesId,nombre,apellido,dni,idDireccion")] DatosPersonales datosPersonales) { if (ModelState.IsValid) { db.DatosPersonales.Add(datosPersonales); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.idDireccion = new SelectList(db.Direccion, "idDireccion", "direccion1", datosPersonales.idDireccion); return(View(datosPersonales)); }
public ActionResult Create([Bind(Include = "id,name,hash,status")] Color color) { if (ModelState.IsValid) { color.status = true; db.Colors.Add(color); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(color)); }
public ActionResult Create([Bind(Include = "idCostoEnvio,idLocalidad,Importe")] CostoEnvio costoEnvio) { if (ModelState.IsValid) { db.CostoEnvio.Add(costoEnvio); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.idLocalidad = new SelectList(db.Localidad, "id", "localidad1", costoEnvio.idLocalidad); return(View(costoEnvio)); }
public ActionResult Create(Category category) { category.status = true; if (ModelState.IsValid) { db.Categories.Add(category); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(category)); }
public ActionResult Create([Bind(Include = "idStock,idSucursal,idProducto,cantidad,minimo,maximo")] Stock stock) { if (ModelState.IsValid) { db.Stock.Add(stock); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.idProducto = new SelectList(db.Producto, "idProducto", "descripcion", stock.idProducto); ViewBag.idSucursal = new SelectList(db.Sucursal, "idSucursal", "descripcion", stock.idSucursal); return(View(stock)); }
public ActionResult Create(SubCategory subCategory) { subCategory.status = true; if (ModelState.IsValid) { db.SubCategories.Add(subCategory); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.catId = new SelectList(db.Categories, "id", "name", subCategory.catId); return(View(subCategory)); }
public ActionResult Create([Bind(Include = "idProducto,idSubCategoria,descripcion,idTalle,precioUnitario,idGarantia,idColor,esDestacado")] Producto producto) { if (ModelState.IsValid) { db.Producto.Add(producto); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.idColor = new SelectList(db.Color, "idColor", "descripcion", producto.idColor); ViewBag.idGarantia = new SelectList(db.Garantia, "idGarantia", "descripcion", producto.idGarantia); ViewBag.idSubCategoria = new SelectList(db.SubCategoria, "idSubCategoria", "descripcion", producto.idSubCategoria); ViewBag.idTalle = new SelectList(db.Talle, "idTalle", "descripcion", producto.idTalle); return(View(producto)); }
public IHttpActionResult DeleteProductById(int id) { if (!ModelState.IsValid) { return(BadRequest("Invalid data")); } try { using (var ctx = new ecommerceEntities()) { var prodructItem = ctx.Products.Where(x => x.ID == id).FirstOrDefault(); if (prodructItem != null) { ctx.Products.Remove(prodructItem); ctx.SaveChanges(); } else { return(BadRequest("Invalid data")); } } } catch (Exception ex) { return(BadRequest("Invalid data")); } return(Ok()); }
protected void btnPost_Click(object sender, EventArgs e) { using (ecommerceEntities context = new ecommerceEntities()) { if (Session["CustomerID"] != null) { int CustID = Convert.ToInt16(Session["CustomerID"].ToString()); int ProdID = Convert.ToInt16(Request.QueryString["ProductID"]); Review rv = new Review() { ReviewTitle = txtReviewTitle.Text, ReviewDescription = txtReviewDetail.Text, CustomerID = CustID, ProductID = ProdID, Rating = Convert.ToInt16(ddlRatings.SelectedValue), ReviewDate = DateTime.Now }; context.Reviews.Add(rv); context.SaveChanges(); string notifyTitle = "Review added"; string message = "Your review has been posted on the product page. Thanks for helping others."; string notification = string.Format("?notifyTitle={0}¬ificationDescription={1}", notifyTitle, message); Response.Redirect("~/product.aspx?ProductID=" + ViewState["prodid"].ToString() + "&" + notification); } } }
protected void btnAdd_Click(object sender, EventArgs e) { try { //Save the file on server's folder kepping the original filename flImageUpload.SaveAs(Server.MapPath(@"~\Site_data\product_images\" + flImageUpload.FileName)); Product pr = new Product { ProductName = txtName.Text, ProductDescription = txtDescription.Text, ProductPrice = Convert.ToDecimal(txtPrice.Text), ProductImageURL = @"~\Site_data\product_images\" + flImageUpload.FileName, Discount = Convert.ToInt16(string.IsNullOrEmpty(txtDiscount.Text) ? "0" : txtDiscount.Text), CategoryID = Convert.ToInt16(ddlCategory.SelectedValue) }; using (ecommerceEntities context = new ecommerceEntities()) { context.Products.Add(pr); context.SaveChanges(); } lblStatus.Text = "Product successfully uploaded."; lblStatus.ForeColor = System.Drawing.Color.Green; hlAddFeature.NavigateUrl = "~/Admin/addFeatures.aspx?ProductID=" + pr.ProductID; } catch (System.IO.DirectoryNotFoundException ex) { lblStatus.ForeColor = System.Drawing.Color.Red; lblStatus.Text = "Select an image first"; } }
public IHttpActionResult PostAddNewProduct(ProductDTO product) { if (product == null) { return(BadRequest("Invalid data")); } try { using (var ctx = new ecommerceEntities()) { ctx.Products.Add(new Product() { Name = product.Name, Price = product.Price, Description = product.Description, UnitInStock = product.UnitInStock }); ctx.SaveChanges(); } } catch (Exception ex) { return(BadRequest("Invalid data")); } return(Ok()); }
public IHttpActionResult PutProductById(ProductDTO product) { if (!ModelState.IsValid) { return(BadRequest("Invalid data")); } try { using (var ctx = new ecommerceEntities()) { var prodructItem = ctx.Products.Where(x => x.ID == product.ID).FirstOrDefault(); if (prodructItem != null) { prodructItem.Name = product.Name; prodructItem.Price = product.Price; prodructItem.Description = product.Description; prodructItem.UnitInStock = product.UnitInStock; ctx.SaveChanges(); } else { return(BadRequest("Invalid data")); } } } catch (Exception ex) { return(BadRequest("Invalid data")); } return(Ok()); }
public IHttpActionResult PostAddOrder([FromBody] int productId) { if (!ModelState.IsValid) { return(BadRequest("Invalid data")); } try { using (var ctx = new ecommerceEntities()) { var productItem = ctx.Products.Where(x => x.ID == productId).FirstOrDefault(); if (productItem != null && productItem.UnitInStock > 0) { ctx.Orders.Add(new Order() { ProductID = productId, Quantity = 1, TotalAmount = 1 * productItem.Price, Date = DateTime.Now }); productItem.UnitInStock = productItem.UnitInStock - 1; ctx.SaveChanges(); } else { return(BadRequest("The product is not available")); } } } catch (Exception ex) { return(BadRequest("Invalid data")); } return(Ok()); }
public ActionResult ShopBasket(FormCollection form) { if (ModelState.IsValid) { String[] claves = form.AllKeys; foreach (string clave in claves) { string id = clave.Split('_')[1]; string valor = form[clave]; OrdenCompraDetalle ocd = db.OrdenCompraDetalle.Find(Convert.ToInt32(id)); ocd.cantidad = Convert.ToInt32(valor); db.Entry(ocd).State = EntityState.Modified; db.SaveChanges(); } } return(RedirectToAction("ShopBasket")); }
public ActionResult CustomerRegister(Registro registro) { if (ModelState.IsValid) { try { Direccion dir = new Direccion() { direccion1 = registro.Direccion, codigoPostal = registro.CodigoPostal, idLocalidad = registro.idLocalidad }; db.Direccion.Add(dir); db.SaveChanges(); DatosPersonales dp = new DatosPersonales() { nombre = registro.Nombre, apellido = registro.Apellido, dni = registro.DNI, telefono = registro.Telefono, idDireccion = dir.idDireccion }; db.DatosPersonales.Add(dp); db.SaveChanges(); WebSecurity.CreateUserAndAccount(registro.UserName, registro.Password, new { Email = registro.UserEmail, idEstadoUsuario = 1, idDatosPersonales = dp.datosPersonalesId }); if (WebSecurity.UserExists(registro.UserName)) { Roles.AddUserToRole(registro.UserName, "Cliente"); } if (WebSecurity.Login(registro.UserName, registro.Password)) { return(RedirectToAction("ShopCategory", "Producto")); } else { return(RedirectToAction("Home", "Shared")); } } catch (MembershipCreateUserException e) { ModelState.AddModelError("", e.StatusCode.ToString()); } } ViewBag.idLocalidad = new SelectList(db.Localidad, "id", "localidad1", registro.idLocalidad); return(View(registro)); }
public IHttpActionResult PutOrderById(int id, OrderDTO order) { if (!ModelState.IsValid) { return(BadRequest("Invalid data")); } try { using (var ctx = new ecommerceEntities()) { var orderItem = ctx.Orders.Where(x => x.ID == order.ID).FirstOrDefault(); var productItem = ctx.Products.Where(x => x.ID == order.ProductID).FirstOrDefault(); if (productItem != null) { if (orderItem.Quantity != order.Quantity) { if (order.Quantity > orderItem.Quantity && productItem.UnitInStock >= (order.Quantity - orderItem.Quantity)) { productItem.UnitInStock = productItem.UnitInStock - (order.Quantity - orderItem.Quantity); } else if (order.Quantity < orderItem.Quantity) { productItem.UnitInStock = productItem.UnitInStock - (order.Quantity - orderItem.Quantity); } else { return(BadRequest("Insufficient Count")); } orderItem.Quantity = order.Quantity; orderItem.TotalAmount = productItem.Price * order.Quantity; orderItem.Date = order.Date; ctx.SaveChanges(); } else { return(BadRequest("No change in order count")); } } else { return(BadRequest("Invalid data")); } } } catch (Exception ex) { return(BadRequest("Invalid data")); } return(Ok()); }
protected void btnChange_Click(object sender, EventArgs e) { using (ecommerceEntities context = new ecommerceEntities()) { //Getting user info based on session variable int id = (int)Session["CustomerID"]; Customer cust = context.Customers.Where(i => i.CustomerID == id).FirstOrDefault(); cust.Password = txtPassword.Text; context.SaveChanges(); } lblError.Visible = true; lblError.Text = "Password successfully updated"; }
public ActionResult editPedidosDetalles(FormCollection formCollection) { string id = formCollection["id"]; string estatus = formCollection["estatus"]; string observaciones = formCollection["observaciones"]; int e; var orden = db.PEDIDO_PROVEEDOR.Find(int.Parse(id)); if (estatus.Equals("Autorizado")) { e = 0; } else { e = 2; } orden.AUTORIZADO = e; orden.OBSERVACIONES = observaciones; orden.FECHA_ACTUALIZACION = System.DateTime.Now; db.Entry(orden).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); ViewBag.showSuccessAlert = true; return(RedirectToAction("Pedidos", "Finanzas")); }
public ActionResult Create(Brand brand, HttpPostedFileBase image) { var myAccount = new Account { ApiKey = "826331127339442", ApiSecret = "8SQi6Vti80ZwES3LeeBDFnSqBWQ", Cloud = "dycqowxvx" }; Cloudinary _cloudinary = new Cloudinary(myAccount); var uploadParams = new ImageUploadParams() { File = new FileDescription(image.FileName, image.InputStream) }; var uploadResult = _cloudinary.Upload(uploadParams); brand.image = uploadResult.SecureUri.AbsoluteUri; brand.status = true; if (ModelState.IsValid) { db.Brands.Add(brand); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(brand)); }