public static void get_order_detail(SortedList <int, order> orders)
{
order o = null;
SqlCommand cmd = new SqlCommand("select OrderNum, OrderDate, ProductID, Volume, Price from OrderDetails order by OrderNum, ProductId", DB.cnn());
SqlDataReader rdr = cmd.ExecuteReader();
int order_num = -1;
while (rdr.Read())
{
order_detail od = new order_detail();
od.order_num = (int)rdr.GetValue(0);
od.order_date = (DateTime)rdr.GetValue(1);
od.product_id = (int)rdr.GetValue(2);
od.volume = (int)rdr.GetValue(3);
od.price = (Double)rdr.GetValue(4);
if (od.order_num != order_num)
{
orders.TryGetValue(od.order_num, out o);
order_num = od.order_num;
}
if (o != null)
{
o.details.Add(od);
o.OnDetailChanged();
}
}
rdr.Close();
}
public order_detail Createorder_detail(Int32?orderID = null, Int32?productID = null, Decimal?unitPrice = null, Int16?quantity = null, Double?discount = null)
{
order_detail value = CreateObject <order_detail>();
if (orderID != null)
{
value.OrderID = orderID.Value;
}
if (productID != null)
{
value.ProductID = productID.Value;
}
if (unitPrice != null)
{
value.UnitPrice = unitPrice.Value;
}
if (quantity != null)
{
value.Quantity = quantity.Value;
}
if (discount != null)
{
value.Discount = discount.Value;
}
return(value);
}
/// <summary>
/// 从商品信息生成订单的构造函数
/// </summary>
/// <param name="uid"></param>
/// <param name="infos"></param>
public Order(string uid, MerchandiseInfoCashier[] infos)
{
orderList = new List <order_detail>(infos.Length);
foreach (MerchandiseInfoCashier info in infos)
{
string m_id = info.id;
bool found_same_id = false;
foreach (order_detail detail in orderList)
{
if (m_id == detail.id)
{
detail.num += 1;
found_same_id = true;
break;
}
}
if (found_same_id == false)
{
order_detail detail = new order_detail();
detail.id = m_id;
detail.num = 1;
orderList.Add(detail);
}
}
order_method = "1";
user_id = uid;
shop_id = shop_identify;
}
// POST: odata/OrderDetails
public async Task <IHttpActionResult> Post(order_detail order_detail)
{
if (!ModelState.IsValid)
{
_log.Error("OrderDetailsController:Put - Model was Invalid");
return(BadRequest(ModelState));
}
db.order_detail.Add(order_detail);
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateException)
{
if (order_detailExists(order_detail.order_detail_id))
{
return(Conflict());
}
else
{
throw;
}
}
return(Created(order_detail));
}
public ActionResult DeleteConfirmed(int id)
{
order_detail order_detail = db.order_detail.Find(id);
db.order_detail.Remove(order_detail);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public static void delete_order_details(order_detail od)
{
SqlCommand cmd = new SqlCommand("delete from OrderDetails where OrderNum=@OrderNum", DB.cnn());
SqlParameter p = new SqlParameter("@OrderNum", od.order_num); p.Direction = ParameterDirection.Input; cmd.Parameters.Add(p);
//cmd.Prepare();
cmd.ExecuteNonQuery();
}
public order_detail(order_detail od)
{
this.order_num = od.order_num;
this.order_date = od.order_date;
this.product_id = od.product_id;
this.price = od.price;
this.volume = od.volume;
}
public ActionResult CreateOrder()
{
int uID = (Int32)(Session["id"]);
int oID = 0;
using (OrderSystemEntities2 db = new OrderSystemEntities2())
{
user u = db.users.Where(x => x.id == uID).FirstOrDefault();
List <CartItem> items = (List <CartItem>)Session["cart"];
DateTime date = items[0].Date;
int service_time = items[0].ServiceTime;
float total_price = (float)items.Sum(x => x.Product.price * x.Quantity);
if (total_price > u.balance)
{
ViewBag.BalanceError = 1;
return(RedirectToAction("CheckOut", "CreateOrder"));
}
else
{
order order = new order()
{
userID = (Int32)(Session["id"]),
create_time = DateTime.Now,
take_date = date,
take_time = service_time,
is_cancle = false,
total_price = total_price,
reviewed = false,
receive_code = RandReceiveCode()
};
db.orders.Add(order);
db.SaveChanges();
int orderID = order.id;
oID = orderID;
foreach (CartItem item in items)
{
order_detail order_Detail = new order_detail()
{
orderID = orderID,
productID = item.Product.id,
quantity = item.Quantity,
price = item.Product.price,
total_price = item.Quantity * item.Product.price
};
db.order_detail.Add(order_Detail);
}
db.SaveChanges();
AddOrderToTransaction(order);
ViewBag.BalanceError = 0;
SendActivationEmail(u, order);
Session.Remove("cart");
}
}
return(RedirectToAction("Index", "OrderDetail", new { oID = oID }));
}
// PUT: odata/OrderDetails(5)
public async Task <IHttpActionResult> Put([FromODataUri] int key, Delta <order_detail> patch)
{
//var re = Request;
//var headers = re.Headers;
//var id = "";
//if (headers.Contains("id"))
//{
// id = headers.GetValues("id").First();
//}
var json = Newtonsoft.Json.JsonConvert.SerializeObject(patch);
_log.Info($"Model Object: {json}");
Validate(patch.GetEntity());
if (!ModelState.IsValid)
{
_log.Error("OrderDetailsController:Put - Model was Invalid");
_log.Info($"Model Object: {json}");
return(BadRequest(ModelState));
}
order_detail order_detail = await db.order_detail.FindAsync(key);
if (order_detail == null)
{
return(NotFound());
}
patch.Put(order_detail);
// Check to see if the we need to update the task status to completed.
//order_task order_task =
// db.order_task.FirstOrDefault(p => p.order_id == order_detail.order_id && p.task_code == "order");
//order_task.is_complete = "Y";
//order_task.completed_by = id;
//order_task.completed_date = DateTime.Now;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException ex)
{
if (!order_detailExists(key))
{
return(NotFound());
}
else
{
_log.Error("An Error Occurred in OrderDetailsController:Put", ex);
throw;
}
}
return(Updated(order_detail));
}
public ActionResult Edit([Bind(Include = "order_detail_id,order_id,productname,quiantity,build_time,total_price,productid,buy_id")] order_detail order_detail)
{
if (ModelState.IsValid)
{
db.Entry(order_detail).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.order_id = new SelectList(db.orders, "order_id", "buy_Name", order_detail.order_id);
return(View(order_detail));
}
public ActionResult AddOrder(string rname, string rphone, string raddress, string remark)
{
var time = DateTime.Now;
//string sqlFormattedDate = time.ToString("yyyy-MM-dd HH:mm:ss.fff");
order_form order = new order_form();
order.order_date = time;
order.member_account = appClass.Account;
order.remittance_account = "0000-0000-0000";
order.payment_method = "匯款";
order.shipping_status = "已接收訂單";
order.recipient_name = rname;
order.recipient_phone = rphone;
order.recipient_address = raddress;
order.remark = remark;
db.order_form.Add(order);
try { db.SaveChanges(); }
catch (System.Data.Entity.Validation.DbEntityValidationException ex)
{
throw ex;
}
order_detail orderDetail = new order_detail();
var cartlist = db.shopping_cart.Where(m => m.member_account == appClass.Account).ToList();
foreach (var item in cartlist)
{
orderDetail.order_id = order.order_id;
orderDetail.product_quantity = item.product_quantity;
orderDetail.product_no = item.product_no;
db.order_detail.Add(orderDetail);
try { db.SaveChanges(); }
catch (System.Data.Entity.Validation.DbEntityValidationException ex)
{
throw ex;
}
}
var clearCart = db.shopping_cart.Where(m => m.member_account == appClass.Account).ToList();
foreach (var item in clearCart)
{
var deleteItem = db.shopping_cart.Where(m => m.member_account == appClass.Account).FirstOrDefault();
db.shopping_cart.Remove(deleteItem);
db.SaveChanges();
}
return(RedirectToAction("OrderList"));
//return View();
}
public static void update_order_detail(order_detail od)
{
SqlCommand cmd = new SqlCommand("update OrderDetails set OrderDate=@OrderDate, ProductID=@ProductID, Volume=@Volume, Price=@Price where OrderNum=@OrderNum", DB.cnn());
SqlParameter p = new SqlParameter("@OrderDate", od.order_date); p.Direction = ParameterDirection.Input; cmd.Parameters.Add(p);
p = new SqlParameter("@ProductID", od.product_id); p.Direction = ParameterDirection.Input; cmd.Parameters.Add(p);
p = new SqlParameter("@Volume", od.volume); p.Direction = ParameterDirection.Input; cmd.Parameters.Add(p);
p = new SqlParameter("@Price", od.price); p.Direction = ParameterDirection.Input; cmd.Parameters.Add(p);
p = new SqlParameter("@OrderNum", od.order_num); p.Direction = ParameterDirection.Input; cmd.Parameters.Add(p);
//cmd.Prepare();
cmd.ExecuteNonQuery();
}
public ActionResult Edit([Bind(Include = "order_detail_id,order_id,game_id,amount")] order_detail order_detail)
{
if (ModelState.IsValid)
{
db.Entry(order_detail).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.game_id = new SelectList(db.games, "game_id", "title", order_detail.game_id);
ViewBag.order_id = new SelectList(db.orders, "order_id", "order_id", order_detail.order_id);
return(View(order_detail));
}
public bool Insert(order_detail orderDetail)
{
try
{
db.order_detail.Add(orderDetail);
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
// DELETE: odata/OrderDetails(5)
public async Task <IHttpActionResult> Delete([FromODataUri] int key)
{
order_detail order_detail = await db.order_detail.FindAsync(key);
if (order_detail == null)
{
return(NotFound());
}
db.order_detail.Remove(order_detail);
await db.SaveChangesAsync();
return(StatusCode(HttpStatusCode.NoContent));
}
// GET: order_detail/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
order_detail order_detail = db.order_detail.Find(id);
if (order_detail == null)
{
return(HttpNotFound());
}
return(View(order_detail));
}
public ActionResult pack(int?order_detail_id, int?product_id, int quintity)
{
farmarEntities1 db = new farmarEntities1();
product c = db.products.Where(a => a.productid == product_id).Select(b => b).SingleOrDefault();
c.unitstock -= quintity;
c.sale += quintity;
db.Entry(c).State = EntityState.Modified;
db.SaveChanges();
order_detail o = db.order_detail.Where(a => a.order_detail_id == order_detail_id).Select(b => b).SingleOrDefault();
o.status = "成功出貨";
db.SaveChanges();
return(RedirectToAction("Index", "Home", null));
}
// GET: order_detail/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
order_detail order_detail = db.order_detail.Find(id);
if (order_detail == null)
{
return(HttpNotFound());
}
ViewBag.order_id = new SelectList(db.orders, "order_id", "buy_Name", order_detail.order_id);
return(View(order_detail));
}
public static void add_order_detail(order_detail od)
{
try
{
SqlCommand cmd = new SqlCommand("insert into OrderDetails values (@OrderNum,@OrderDate,@ProductID,@Volume,@Price)", DB.cnn());
SqlParameter p = new SqlParameter("@OrderNum", od.order_num); p.Direction = ParameterDirection.Input; cmd.Parameters.Add(p);
p = new SqlParameter("@OrderDate", od.order_date); p.Direction = ParameterDirection.Input; cmd.Parameters.Add(p);
p = new SqlParameter("@ProductID", od.product_id); p.Direction = ParameterDirection.Input; cmd.Parameters.Add(p);
p = new SqlParameter("@Volume", od.volume); p.Direction = ParameterDirection.Input; cmd.Parameters.Add(p);
p = new SqlParameter("@Price", od.price); p.Direction = ParameterDirection.Input; cmd.Parameters.Add(p);
//cmd.Prepare();
cmd.ExecuteNonQuery();
}
catch (Exception e) {
Console.WriteLine(e.Message);
MessageBox.Show(e.Message);
}
}
public void checkoutCart(string user_id, book_order book_order)
{
db.book_order.Add(book_order);
db.SaveChanges();
int order_id = book_order.auto_id;
List <Cart> listCart = db.Carts.Where(c => c.user_id == user_id).ToList <Cart>();
for (int i = 0; i < listCart.Count; i++)
{
order_detail detail = new order_detail();
detail.order_id = order_id;
detail.book_id = listCart[i].book_id;
db.order_detail.Add(detail);
db.SaveChanges();
listCart[i].status = false;
updateCart(listCart[i]);
}
}
public async Task <IHttpActionResult> Patch([FromODataUri] int key, Delta <order_detail> patch)
{
var json = Newtonsoft.Json.JsonConvert.SerializeObject(patch);
_log.Info($"Model Object: {json}");
Validate(patch.GetEntity());
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
order_detail order_detail = await db.order_detail.FindAsync(key);
if (order_detail == null)
{
return(NotFound());
}
patch.Patch(order_detail);
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!order_detailExists(key))
{
return(NotFound());
}
else
{
throw;
}
}
return(Updated(order_detail));
}
private List<order_detail> GetOrderDetail(int ServiceProviderId)
{
List<order_detail> ReturnList = new List<order_detail>();
foreach (OrderDetail od in SyncClient.GetOrderDetail(GetFromDate, DateTimeNow, ServiceProviderId))
{
order_detail tmp = QueryOrderDetail(od.Id);
Boolean NewValue = false;
if (tmp == null)
{
tmp = new order_detail();
NewValue = true;
}
tmp.address_1 = od.Address1;
tmp.address_2 = od.Address2;
tmp.city = od.City;
tmp.company = od.Company;
tmp.country_id = od.CountryId;
tmp.createdAt = System.DateTime.Parse(od.CreateDat);
tmp.Id = od.Id;
tmp.phone_1 = od.Phone1;
tmp.phone_2 = od.Phone2;
tmp.tax_number = od.Taxnumber;
tmp.zip = od.Zip;
tmp.first_name = od.Firstname;
tmp.last_name = od.Lastname;
tmp.order_id = od.OrderId;
tmp.zone_id = od.ZoneId;
if (NewValue)
{
dbContext.Set<order_detail>().Add(tmp);
}
dbContext.SaveChanges();
ReturnList.Add(tmp);
}
return ReturnList;
}
public async Task <IActionResult> NewOrder(order_detail od)
{
var customer = new SelectList(await _context.customer.ToListAsync(), "customer_id", "firstname", od.order_List.customer_id);
var product = new SelectList(await _context.product.ToListAsync(), "product_id", "product_name", od.product_id);
using (var tran = _context.Database.BeginTransaction())
{
try
{
order_list ol = new order_list();
ol.order_id = od.order_id;
ol.customer_id = od.order_List.customer_id;
ol.status = od.order_List.status;
ol.order_date = System.DateTime.Now;
_context.Add(ol);
await _context.SaveChangesAsync();
_context.Add(od);
await _context.SaveChangesAsync();
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
}
tran.Dispose();
}
ViewData["customer"] = customer;
ViewData["product"] = product;
return(View());
}
public ActionResult Order(string name, string email, string phone, string address, string province, string district)
{
var objOrder = new order();
objOrder.order_name = name;
objOrder.order_email = email;
objOrder.order_phone = phone;
objOrder.order_address = address;
objOrder.order_province = province;
objOrder.order_district = district;
// objOrder.order_ward = ward;
objOrder.order_date = DateTime.Now;
// Get user infor
try
{
var orderId = new OrderADO().Insert(objOrder);
var cart = (List <CartModel>)Session[SessionConst.CART_SESSION];
var orderDetailADO = new OrderDetailADO();
decimal total = 0;
var orderDetail = new order_detail();
foreach (var item in cart)
{
orderDetail.product_id = item.Product.product_id;
orderDetail.order_id = orderId;
orderDetail.price = item.Product.price;
orderDetail.quantity = item.Quantity;
orderDetailADO.Insert(orderDetail);
total += (item.Product.price.GetValueOrDefault(0) * item.Quantity);
}
var productInfo = new product();
foreach (var item in cart)
{
productInfo.prod_code = item.Product.prod_code;
productInfo.product_name = item.Product.product_name;
productInfo.quantity = item.Product.quantity;
productInfo.price = item.Product.price;
}
string content = System.IO.File.ReadAllText(Server.MapPath("~/Contents/EmailTemplate/neworder.html"));
content = content.Replace("{{CustomerName}}", name);
content = content.Replace("{{CustomerPhone}}", phone);
content = content.Replace("{{CustomerEmail}}", email);
content = content.Replace("{{CustomerAddress}}", address);
content = content.Replace("{{CustomerProvince}}", province);
content = content.Replace("{{CustomerDistrict}}", district);
// content = content.Replace("{{CustomerWard}}", ward);
content = content.Replace("{{CustomerProdCode}}", productInfo.prod_code);
content = content.Replace("{{CustomerProdName}}", productInfo.product_name);
content = content.Replace("{{CustomerQuantity}}", productInfo.quantity.ToString());
content = content.Replace("{{CustomerPrice}}", productInfo.price.ToString());
content = content.Replace("{{CustomerTotal}}", total.ToString("N0"));
var toEmailAddress = ConfigurationManager.AppSettings["ToEmailAddress"].ToString();
new MailHelper().SendMail(email, "FashionShop - Xác nhận đơn hàng", content); // Send Email to Customer
new MailHelper().SendMail(toEmailAddress, "FashionShop - Đơn hàng mới", content); // Send Email to Admin
}
catch (Exception)
{
return(Redirect("/dat-hang-khong-thanh-cong"));
}
Session[SessionConst.CART_SESSION] = null;
return(Redirect("/dat-hang-thanh-cong"));
}
/// <summary>
/// Deprecated Method for adding a new object to the order_details EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToorder_details(order_detail order_detail)
{
base.AddObject("order_details", order_detail);
}
private void SaveLogInterface(POSAirPortClassesDataContext _posDB, OrderHeader order, order_session new_session_order)
{
// order_header db save
var new_order_header = new order_header();
new_order_header.session_id = new_session_order.id;
new_order_header.order_type = order.Flight.Terminal;
new_order_header.member_id = order.NewOrder.MemberID;
new_order_header.full_name = order.Billing.FirstName + " " + order.Billing.LastName;
new_order_header.passport_no = order.Billing.PassportNo;
new_order_header.country = order.Billing.CountryCode;
new_order_header.airport_code = order.Flight.AirportCode;
new_order_header.terminal_code = order.Flight.Terminal;
new_order_header.airline_code = order.Flight.AirlineCode;
new_order_header.flight_code = order.Flight.FlightCode;
new_order_header.flight_no = order.Flight.FlightCode;
//new_order_header.flight_
new_order_header.reference_1 = "";
new_order_header.reference_2 = "";
new_order_header.reference_3 = "";
new_order_header.remark = "";
new_order_header.create_date = DateTime.Now;
_omDB.order_headers.InsertOnSubmit(new_order_header);
_omDB.SubmitChanges();
// db save new order_detail and order_discount
foreach (var item in order.Items.Select((value, index) => new { Value = value, Index = index }))
{
order_detail new_item = new order_detail();
new_item.header_id = new_order_header.id;
new_item.line_no = item.Index + 1;
new_item.sub_order_type = "I";
new_item.article_code = item.Value.MaterialCode;
new_item.quantity = item.Value.Quantity;
new_item.selling_price = item.Value.SellingPrice;
new_item.total_amt = item.Value.Amount;
new_item.dis_rate = item.Value.DiscountRate;
new_item.dis_amt = item.Value.Discount;
new_item.dis_pro_code = item.Value.PromoCode;
new_item.sp_dis_amt = item.Value.SPDiscount;
new_item.sp_dis_rate = item.Value.SPDiscountRate;
new_item.sp_dis_pro_code = item.Value.SPPromoCode;
new_item.net_amt = item.Value.TotalNet;
new_item.reference_1 = "";
new_item.reference_2 = "";
new_item.reference_3 = "";
_omDB.order_details.InsertOnSubmit(new_item);
_omDB.SubmitChanges();
}
// new df_payment_onl
var master_paymath = _posDB.df_paymeths.ToList();
foreach (var payment in order.Payments.Select((value, index) => new { Value = value, Index = index }))
{
decimal amt_curr = 0;
var paymath = master_paymath.FirstOrDefault(x => x.method_code.Trim() == payment.Value.Code.Trim());
if (paymath != null)
{
if (paymath.check_voucher || paymath.is_cashcard)
{
amt_curr = 0;
}
else
{
amt_curr = payment.Value.Amount * 1;
}
}
order_payment new_payment = new order_payment();
new_payment.header_id = new_order_header.id;
new_payment.payment_type = payment.Value.Code;
new_payment.paymemt_agent = "";
new_payment.paymemt_session_id = "";
new_payment.paymemt_ref_no = "";
new_payment.payment_code = payment.Value.Code;
new_payment.paymemt_amt = payment.Value.Amount;
new_payment.paymemt_datetime = DateTime.Now;
_omDB.order_payments.InsertOnSubmit(new_payment);
_omDB.SubmitChanges();
}
}
public static bool CartPayment(cvmOrder model)
{
OrderNo = CreateNewOrderNo(model);
using (dbcon db = new dbcon())
{
var datas = db.carts
.Where(m => m.mno == UserAccount.UserNo)
.ToList();
if (datas != null)
{
//將同會員購買的所有品項加總 為什麼不用CartTotal??
int int_amount = datas.Sum(m => m.amount).GetValueOrDefault();
//加上稅金
decimal dec_tax = 0;
if (int_amount > 0)
{
dec_tax = Math.Round((decimal)(int_amount * 5 / 100), 0);
}
int int_total = int_amount + (int)dec_tax;
var data = db.order.Where(m => m.order_no == OrderNo).FirstOrDefault();
if (data != null)
{
data.amounts = int_amount;
data.taxs = (int)dec_tax;
data.totals = int_total;
}
foreach (var item in datas)
{
var stock_date_list = item.ptype_spec.Trim().Split(' ').ToList();
stock_date_list.RemoveAt(stock_date_list.Count - 1);
foreach (var d in stock_date_list)
{
DateTime date = Convert.ToDateTime(d);
var hasStock = db.product_typedetail_everydaystock.Count(e => e.ptype_no == item.ptype_no && e.stock_date == date && e.stock >= item.ptype_qty) > 0;
if (!hasStock)
{
return(false);
}
}
order_detail detail = new order_detail();
detail.order_no = OrderNo;
detail.pno = item.pno;
detail.pname = item.pname;
detail.ptype_no = item.ptype_no;
detail.ptype_name = item.ptype_name;
detail.vendor_no = Shop.GetVendorNoByProduct(item.pno);
detail.category_name = Shop.GetCategoryName(item.pno);
detail.ptype_spec = item.ptype_spec;
detail.qty = item.ptype_qty;
detail.price = item.ptype_price;
detail.amount = item.amount;
detail.remark = "";
db.order_detail.Add(detail);
db.carts.Remove(item);
}
db.SaveChanges();
}
}
return(true);
}
public ActionResult ProcessOrder(FormCollection frc)
{
List <Cart> lsCart = (List <Cart>)Session[strCart];
List <Cart> temp = (List <Cart>)Session["Cart"];
customer customer = new customer()
{
name = frc["cusName"],
surname = frc["cusSurname"],
Email = frc["cusMail"],
PhoneNumber = frc["cusPhone"],
address_line1 = frc["cusAddress1"],
address_line2 = frc["cusAddress2"],
postal_code = frc["cusPostal"]
};
string aspnetuserID = User.Identity.GetUserId();
decimal total = 0;
List <customer> custList = db.customers.Where(x => x.AspNetUsers_id == aspnetuserID).ToList();
var customerID = db.customers.Where(x => x.AspNetUsers_id == aspnetuserID);
if (custList.Count() > 0)
{
int cust = custList.First().customer_id;
foreach (Cart cart in lsCart)
{
total += cart.Quantity * cart.Product.price;
}
order order = new order()
{
customer_id = cust,
price = total,
date = DateTime.Now,
order_type_id = 3
};
db.orders.Add(order);
db.SaveChanges();
}
else if (custList.Count() == 0 && Request.IsAuthenticated)
{
return(RedirectToAction("../Account/User_details"));
}
else
{
db.customers.Add(customer);
db.SaveChanges();
List <customer> lsCust = db.customers.ToList();
int idCust = lsCust.Last().customer_id;
foreach (Cart cart in lsCart)
{
total += cart.Quantity * cart.Product.price;
}
order order = new order()
{
customer_id = idCust,
price = total,
date = DateTime.Now,
order_type_id = 3
};
db.orders.Add(order);
db.SaveChanges();
}
List <order> lsOrder = db.orders.ToList();
int idOrder = lsOrder.Last().order_id;
foreach (Cart cart in lsCart)
{
order_detail order_detail = new order_detail()
{
order_id = idOrder,
game_id = cart.Product.game_id,
amount = cart.Quantity
};
db.order_detail.Add(order_detail);
db.SaveChanges();
}
Session.Remove(strCart);
return(View("OrderSuccess"));
}