public Order PlaceOrder(Order order)
{
var orderTable = new Order();
if (order != null)
{
orderTable.OrderDate = DateTime.Now;
orderTable.CustomerId = order.CustomerId;
orderTable.AddressId = order.AddressId;
orderTable.Amount = order.Amount;
_db.Orders.Add(orderTable);
_db.SaveChanges();
if (order != null)
{
var getOrderId = _db.Orders.Where(cId => cId.CustomerId == order.CustomerId).Select(oId => oId.Id).LastOrDefault();
var detailRow = _db.Details.Where(cId => cId.CustomerId == order.CustomerId).Select(oId => oId.OrderId).ToList();
using (MajesticDbContext db = new MajesticDbContext())
{
db.Details.Where(x => x.CustomerId == order.CustomerId).ToList().ForEach(x =>
{
x.OrderId = getOrderId;
});
db.SaveChanges();
}
if (order != null)
{
_db.Database.ExecuteSqlCommand("TRUNCATE TABLE [Carts]");
_db.SaveChanges();
}
//for (int i = 0; i < _db.Details.Count(); i++)
//{
// detailRow.Add(getOrderId);
//}
//_db.SaveChanges();
}
}
return(orderTable);
}
