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