//GET: api/Orders
public IHttpActionResult GetAll()
{
var orderL = new List <OrdersModel>();
var or = db.Orders.ToList();
foreach (var o in or)
{
var orderD = new List <Order_detail>();
var orM = new OrdersModel();
orM.ID = o.ID;
orM.Date = o.Date;
orderL.Add(orM);
var ord = db.Order_details.Where(od => od.OrderID == orM.ID).ToList();
foreach (var od in ord)
{
var orDM = new Order_detail
{
ID = od.ID,
Quantity = od.Quantity,
StatusOrder = od.StatusOrder,
TotalPrice = od.TotalPrice,
SubTotalPrice = od.SubTotalPrice,
ProductID = od.ProductID,
OrderID = od.OrderID
};
orderD.Add(orDM);
}
orM.Order_details = orderD.ToList();
}
db.SaveChanges();
return(Ok(orderL));
}
public IHttpActionResult PutOrder_details(int id, Order_details order_details)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != order_details.ID)
{
return(BadRequest());
}
db.Entry(order_details).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!Order_detailsExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult Save(customer customer)
{
if (!ModelState.IsValid)
{
var viewModel = new CustomerViewModel
{
Customer = customer
};
return(View("CustomerForm", viewModel));
}
if (customer.customer_id == 0)
{
db.customers.Add(customer);
}
else
{
var customerInDb = db.customers.Where(x => x.customer_id == customer.customer_id).SingleOrDefault();
customerInDb.first_name = customer.first_name;
customerInDb.last_name = customer.last_name;
customerInDb.birth_date = customer.birth_date;
customerInDb.phone = customer.phone;
customerInDb.address = customer.address;
customerInDb.city = customer.city;
customerInDb.state = customer.state;
}
db.SaveChanges();
return(RedirectToAction("CustomerList"));
}
public ActionResult Create([Bind(Include = "productId,categoryId,brandId,Name,Price,ProductImg")] Product product)
{
if (ModelState.IsValid)
{
WebImage ProductImg = null;
var newFileName = "";
var imagePath = "";
//RIJEŠITI NESTED IF
//zašto ne prihvaća HttpPostedFileBase tip??
if (ProductImg != null)
{
newFileName = Guid.NewGuid().ToString() + "_" +
Path.GetFileName(ProductImg.FileName);
imagePath = @"~\Content\Images\" + newFileName;
ProductImg.Save(@"~\" + imagePath);
}
db.Products.Add(product);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.brandId = new SelectList(db.Brands, "BrandId", "Name", product.brandId);
ViewBag.categoryId = new SelectList(db.Categories, "CategoryId", "Name", product.categoryId);
return(View(product));
}
public IHttpActionResult PutDiscount(int id, Discount discount)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != discount.ID)
{
return(BadRequest());
}
db.Entry(discount).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!DiscountExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PutProductImage(int id, ProductImage productImage)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != productImage.Id)
{
return(BadRequest());
}
db.Entry(productImage).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ProductImageExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public object Update(Product product, HttpPostedFileBase up)
{
var update = db.Products.SingleOrDefault(p => p.id == product.id);
if (ModelState.IsValid)
{
update.name = product.name;
update.price = product.price;
update.description = product.description;
update.category_id = product.category_id;
if (up != null)
{
String path = Path.Combine(Server.MapPath("~/Uploads"), up.FileName);
up.SaveAs(path);
update.image = up.FileName;
}
db.Entry(update).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Details/" + product.id));
}
else
{
return(HttpNotFound());
}
}
public ActionResult Create(Customer customer)
{
if (ModelState.IsValid)
{
db.Customers.Add(customer);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult Create(ProductSold product)
{
if (ModelState.IsValid)
{
db.ProductSolds.Add(product);
db.SaveChanges();
}
return(View());
}
public ActionResult Create(Store store)
{
if (ModelState.IsValid)
{
db.Stores.Add(store);
db.SaveChanges();
}
return(View("Index"));
}
public ActionResult Update([Bind(Include = "id,name,number_of_product")] Category category)
{
if (ModelState.IsValid)
{
db.Entry(category).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("List"));
}
return(View(category));
}
public ActionResult Create([Bind(Include = "Id,Provider_Name")] SalesProvider salesProvider)
{
if (ModelState.IsValid)
{
db.SalesProviders.Add(salesProvider);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(salesProvider));
}
public ActionResult Create([Bind(Include = "GenreId,Name,Description")] Genre genre)
{
if (ModelState.IsValid)
{
db.Genre.Add(genre);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(genre));
}
public ActionResult Create([Bind(Include = "Id,Total_Sale")] Sale sale)
{
if (ModelState.IsValid)
{
db.Sales.Add(sale);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(sale));
}
public ActionResult Create([Bind(Include = "Id,Name")] ProductCategory productCategory)
{
if (ModelState.IsValid)
{
db.ProductCategories.Add(productCategory);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(productCategory));
}
public ActionResult Create([Bind(Include = "ProveedorId,Nombre,RUC,Celular,Telefono,Correo,Direccion,Estado")] Proveedor proveedor)
{
if (ModelState.IsValid)
{
db.Proveedor.Add(proveedor);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(proveedor));
}
public ActionResult Create([Bind(Include = "CategoriaId,Nombre,Descripcion,Estado")] Categoria categoria)
{
if (ModelState.IsValid)
{
db.Categoria.Add(categoria);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(categoria));
}
public ActionResult Create([Bind(Include = "ArtistId,Name")] Artist artist)
{
if (ModelState.IsValid)
{
db.Artist.Add(artist);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(artist));
}
public ActionResult Create([Bind(Include = "Id,Name,Location")] Store store)
{
if (ModelState.IsValid)
{
db.Stores.Add(store);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(store));
}
public ActionResult Create([Bind(Include = "Id,Name,Price,ProductCategoryId,Discontinued,FeaturedProduct")] Product product)
{
if (ModelState.IsValid)
{
db.Products.Add(product);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ProductCategoryId = new SelectList(db.ProductCategories, "Id", "Name", product.ProductCategoryId);
return(View(product));
}
public ActionResult Create([Bind(Include = "OrderId,OrderDate,Username,FirstName,LastName,City,Phone,Total,AlbumId")] Order order)
{
if (ModelState.IsValid)
{
db.Order.Add(order);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.AlbumId = new SelectList(db.Album, "AlbumId", "Title", order.AlbumId);
return(View(order));
}
public ActionResult Create([Bind(Include = "Id,Product_Name,Product_Price,Product_Quantity,Product_Description,Id_Provider")] SalesProduct salesProduct)
{
if (ModelState.IsValid)
{
db.SalesProducts.Add(salesProduct);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Id_Provider = new SelectList(db.SalesProviders, "Id", "Provider_Name", salesProduct.Id_Provider);
return(View(salesProduct));
}
public ActionResult Create([Bind(Include = "Id,Name,Price,Image,Description,Category_Id")] Product product)
{
if (ModelState.IsValid)
{
db.Products.Add(product);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Category_Id = new SelectList(db.Categories, "Id", "Name", product.Category_Id);
return(View(product));
}
public ActionResult Create([Bind(Include = "ProductId,StoreId,AmountInStock")] ProductStore productStore)
{
if (ModelState.IsValid)
{
db.ProductStores.Add(productStore);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ProductId = new SelectList(db.Products, "Id", "Name", productStore.ProductId);
ViewBag.StoreId = new SelectList(db.Stores, "Id", "Name", productStore.StoreId);
return(View(productStore));
}
public ActionResult Create(Product product)
{
if (ModelState.IsValid)
{
db.Products.Add(product);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CategoryId = new SelectList(db.Categories, "CategoryId", "Name", product.CategoryId);
ViewBag.BrandId = new SelectList(db.Brands, "BrandId", "Name", product.BrandId);
return(View(product));
}
public ActionResult Create([Bind(Include = "AlbumId,GenreId,ArtistID,Title,Price,AlbumArtUrl")] Album album)
{
if (ModelState.IsValid)
{
db.Album.Add(album);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ArtistID = new SelectList(db.Artist, "ArtistId", "Name", album.ArtistID);
ViewBag.GenreId = new SelectList(db.Genre, "GenreId", "Name", album.GenreId);
return(View(album));
}
public ActionResult Create([Bind(Include = "ProductoId,CategoriaId,ProveedorId,Denominacion,Descripcion,PrecioUnitario,Existencias,Estado")] Producto producto)
{
if (ModelState.IsValid)
{
db.Producto.Add(producto);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CategoriaId = new SelectList(db.Categoria, "CategoriaId", "Nombre", producto.CategoriaId);
ViewBag.ProveedorId = new SelectList(db.Proveedor, "ProveedorId", "Nombre", producto.ProveedorId);
return(View(producto));
}
public ActionResult Create([Bind(Include = "OrderDetailId,OrderId,AlbumId,Quantity,UnitPrice")] OrderDetail orderDetail)
{
if (ModelState.IsValid)
{
db.OrderDetail.Add(orderDetail);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.AlbumId = new SelectList(db.Album, "AlbumId", "Title", orderDetail.AlbumId);
ViewBag.OrderId = new SelectList(db.Order, "OrderId", "Username", orderDetail.OrderId);
return(View(orderDetail));
}
public ActionResult AddressAndPayment(FormCollection values)
{
var order = new Order();
TryUpdateModel(order);
try
{
if (!values["Accept"].Contains("true"))
{
return(View(order));
}
else
{
order.Username = User.Identity.Name;
order.OrderDate = DateTime.Now;
storeDB.Orders.Add(order);
storeDB.SaveChanges();
var cart = ShoppingCart.GetCart(this.HttpContext);
cart.CreateOrder(order);
return(RedirectToAction("Complete", new { id = order.OrderId }));
}
}
catch
{
return(View(order));
}
}
public ActionResult AddressAndPayment(FormCollection values)
{
var order = new Order();
TryUpdateModel(order);
try
{
order.UserName = User.Identity.Name;
order.OrderDate = DateTime.Now;
//Save Order
storeDB.Orders.Add(order);
storeDB.SaveChanges();
//Process the order
var cart = ShoppingCart.GetCart(this.HttpContext);
cart.CreateOrder(order);
return(RedirectToAction("Complete",
new { id = order.OrderId }));
}
catch
{
//Invalid - redisplay with errors
return(View(order));
}
}
protected void dlUnits_ItemCommand(object source, DataListCommandEventArgs e)
{
int id = int.Parse(e.CommandArgument.ToString());
TaobaoTesting.StoreEntities db = new StoreEntities();
db.Units.DeleteObject(db.Units.Single(x => x.ID.Equals(id)));
db.SaveChanges();
BindUnits();
}
protected void btnAddUnit_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtUnitName.Text.Trim()))
{
TaobaoTesting.StoreEntities db = new StoreEntities();
db.Units.AddObject(new Unit()
{
UnitName = txtUnitName.Text.Trim()
});
txtUnitName.Text = "";
db.SaveChanges();
BindUnits();
}
}