public IHttpActionResult PlaceOrder(MyOrderModel myOrderModel)
{
if (myOrderModel.OrderID == 0)
{
MyOrder objcl = new MyOrder();
objcl.OrderID = myOrderModel.OrderID;
objcl.UserID = myOrderModel.UserID;
objcl.OrderTotal = myOrderModel.OrderTotal;
objcl.OrderDate = DateTime.Now;
db.MyOrders.Add(objcl);
db.SaveChanges();
int id = objcl.OrderID;
foreach (var item in myOrderModel.CartModel)
{
OrderDetail orderDetail = new OrderDetail();
orderDetail.OrderDate = DateTime.Now;
orderDetail.TotalPrice = (int)item.TotalPrice;
orderDetail.Quantity = item.Quantity;
orderDetail.OrderID = id;
orderDetail.ProductID = item.ProductID;
db.OrderDetails.Add(orderDetail);
db.SaveChanges();
var cart = db.Carts.Where(w => w.CartID == item.CartID).FirstOrDefault();
if (cart != null)
{
db.Carts.Remove(cart);
db.SaveChanges();
return(Ok("Success"));
}
}
}
return(Ok("Success"));
}
public EditMyReviewsPage(MyOrderModel editMyOrderMdl)
{
InitializeComponent();
BindingContext = App.Locator.EditMyReviewsPage;
this._editMyOrderMdl = editMyOrderMdl;
App.Locator.EditMyReviewsPage.Init(_editMyOrderMdl);
}
internal void Init(MyOrderModel editMyOrderMdl)
{
Image = editMyOrderMdl.Image;
Title = editMyOrderMdl.Title;
ProductColor = editMyOrderMdl.ProductColor;
Price = editMyOrderMdl.Price;
Review = editMyOrderMdl.Descraptions;
if (int.Parse(editMyOrderMdl.Rating) == 3)
{
star1 = "star";
star2 = "star";
star3 = "star";
star4 = "unfilledStar";
star5 = "unfilledStar";
}
else if (int.Parse(editMyOrderMdl.Rating) == 4)
{
star1 = "star";
star2 = "star";
star3 = "star";
star4 = "star";
star5 = "unfilledStar";
}
else if (int.Parse(editMyOrderMdl.Rating) == 5)
{
star1 = "star";
star2 = "star";
star3 = "star";
star4 = "star";
star5 = "star";
}
}
public MyOrderDetailsPage(MyOrderModel myOrderMdl)
{
InitializeComponent();
BindingContext = App.Locator.MyOrderDetailsPage;
this._myOrderMdl = myOrderMdl;
App.Locator.MyOrderDetailsPage.Init(_myOrderMdl);
}
internal void Init(MyOrderModel myOrderMdl)
{
Image = myOrderMdl.Image;
OrderDate = myOrderMdl.OrderDate;
Title = myOrderMdl.Title;
ProductColor = myOrderMdl.ProductColor;
Price = myOrderMdl.Price;
FrameColor = myOrderMdl.FrameColor;
OrderStatus = myOrderMdl.OrderStatus;
}
// GET: View Order/Details/5 查看订单详情
public ActionResult ViewDetails(int orderId)
{
MyOrderModel sd = new MyOrderModel();
List <tblOrder> allTblOrder = sd.tblOrder.ToList();
//List<tblOrderHistory> allTblHistory = sd.tblOrderHistory.ToList();
//List<tblCustomer> allTblCustomer = sd.tblCustomer.ToList();
//join tables
var multipletable = from c in allTblOrder
where c.OrderID == orderId
select new OrderDetail {
orderDetails = c
};
return(View(multipletable));
}
public int EditOrder(MyOrderModel model)
{
throw new NotImplementedException();
}
public IHttpActionResult PlaceOrder(MyOrderModel myOrderModel)
{
try
{
if (myOrderModel.OrderID == 0)
{
MyOrder objcl = new MyOrder();
objcl.OrderID = myOrderModel.OrderID;
objcl.UserID = myOrderModel.UserID;
objcl.OrderTotal = myOrderModel.OrderTotal;
objcl.OrderDate = DateTime.Now;
db.MyOrders.Add(objcl);
db.SaveChanges();
int id = objcl.OrderID;
foreach (var item in myOrderModel.CartModel)
{
OrderDetail orderDetail = new OrderDetail();
orderDetail.OrderDate = DateTime.Now;
orderDetail.TotalPrice = (int)item.TotalPrice;
orderDetail.Quantity = item.Quantity;
orderDetail.OrderID = id;
orderDetail.ProductID = item.ProductID;
db.OrderDetails.Add(orderDetail);
db.SaveChanges();
try
{
var productData = db.Products.Where(p => p.ProductID == item.ProductID).FirstOrDefault();
{
// Product product = new Product();
productData.Quantity = productData.Quantity - item.Quantity;
if (productData.Quantity == 0)
{
productData.InStock = false;
}
else
{
productData.InStock = true;
}
productData.ModifiedDate = DateTime.Now;
db.Entry(productData).State = EntityState.Modified;
db.SaveChanges();
}
}
catch (Exception exp)
{
return(Ok(exp));
}
var cart = db.Carts.Where(w => w.CartID == item.CartID).FirstOrDefault();
if (cart != null)
{
db.Carts.Remove(cart);
db.SaveChanges();
}
}
}
return(Ok("Success"));
}
catch (Exception e)
{
return(Ok(e));
}
}
public IHttpActionResult PlaceOrder(MyOrderModel myOrderModel)
{
//int ProdQuantityToCart = db.Products.Where(w => w.ProductID == myOrderModel.CartModel.ProductID).Select(x => x.Quantity).FirstOrDefault();
//int CartQuantity = db.Carts.Where(w => w.UserID==).Select(x => x.Quantity).FirstOrDefault();
if (myOrderModel.OrderID == 0)
{
MyOrder objcl = new MyOrder();
objcl.OrderID = myOrderModel.OrderID;
objcl.UserID = myOrderModel.UserID;
objcl.OrderTotal = myOrderModel.OrderTotal;
objcl.OrderDate = DateTime.Now;
if (myOrderModel.CartModel.Count() == 0)
{
return(Ok("Cart is Empty"));
}
else
{
db.MyOrders.Add(objcl);
db.SaveChanges();
}
int id = objcl.OrderID;
// var oid = db.MyOrders.Where(x => x.OrderID == id).FirstOrDefault();
foreach (var item in myOrderModel.CartModel)
{
OrderDetail orderDetail = new OrderDetail();
orderDetail.OrderDate = DateTime.Now;
orderDetail.TotalPrice = (int)item.TotalPrice;
orderDetail.Quantity = item.Quantity;
orderDetail.OrderID = id;
orderDetail.ProductID = item.ProductID;
db.OrderDetails.Add(orderDetail);
db.SaveChanges();
try
{
var productData = db.Products.Where(p => p.ProductID == item.ProductID).FirstOrDefault();
{
// Product product = new Product();
productData.Quantity = productData.Quantity - item.Quantity;
if (productData.Quantity == 0)
{
productData.InStock = false;
}
else if (productData.Quantity < 0)
{
return(Ok("Product Quantity should not be in Negative Number"));
}
else
{
productData.InStock = true;
}
productData.ModifiedDate = DateTime.Now;
db.Entry(productData).State = EntityState.Modified;
db.SaveChanges();
}
}
catch (Exception exp)
{
return(Ok(exp));
}
var cart = db.Carts.Where(w => w.CartID == item.CartID).FirstOrDefault();
if (cart != null)
{
db.Carts.Remove(cart);
db.SaveChanges();
return(Ok("Success"));
}
}
}
return(Ok("Success"));
}
