public async Task <IActionResult> OrderCancel(int OrderId)
{
CustomerOrderHeader CustomerOrderHeader = await _db.CustomerOrderHeader.FindAsync(OrderId);
CustomerOrderHeader.Status = SD.StatusCancelled;
await _db.SaveChangesAsync();
return(RedirectToAction("PrepareOrder", "CustomerOrder"));
}
public async Task <IActionResult> OrderDeliveryPost(int orderId)
{
CustomerOrderHeader CustomerOrderHeader = await _db.CustomerOrderHeader.FindAsync(orderId);
CustomerOrderHeader.Status = SD.StatusCompleted;
await _db.SaveChangesAsync();
return(RedirectToAction("OrderDelivery", "CustomerOrder"));
}
public void PostOrder(CustomerOrderHeaderDTO customerOrderDTO)
{
CustomerOrderHeader Order = null;
using (LcwDBEntities db = new LcwDBEntities())
{
var Data = (from d in db.CustomerOrderHeader
where d.OrderId == customerOrderDTO.OrderId
select d).FirstOrDefault();
int OrderId = 0;
if (Data != null)
{
Data.OrderAdress = customerOrderDTO.OrderAdress;
Data.Date_ = customerOrderDTO.Date_;
Data.OrderPrice = customerOrderDTO.OrderPrice;
Data.CustomerId = customerOrderDTO.CustomerId;
OrderId = customerOrderDTO.OrderId;
db.SaveChanges();
}
else
{
Order = new CustomerOrderHeader()
{
CustomerId = customerOrderDTO.CustomerId,
OrderAdress = customerOrderDTO.OrderAdress,
OrderPrice = customerOrderDTO.OrderPrice,
Date_ = customerOrderDTO.Date_
};
db.CustomerOrderHeader.Add(Order);
db.SaveChanges();
OrderId = Order.OrderId;
}
var DBList = (from r in db.CustomerOrder
where r.OrderId == customerOrderDTO.OrderId
select r).ToList();
var newRows = customerOrderDTO.CustomerOrder;
foreach (var iRow in newRows)
{
iRow.OrderId = OrderId;
}
// Güncelleme varmı ?
foreach (var iNewRow in newRows)
{
var data = DBList.Where(a => a.CustomerOrderId == iNewRow.CustomerOrderId).FirstOrDefault();
if (data != null)
{
data.Amount = iNewRow.Amount;
data.ProductId = iNewRow.ProductId;
data.Price = iNewRow.Price;
data.Description = iNewRow.Description;
data.Barcode = iNewRow.Barcode;
db.SaveChanges();
}
}
// Eklenen var mı ?
foreach (var iNewRow in newRows)
{
var data = DBList.Where(a => a.CustomerOrderId == iNewRow.CustomerOrderId).FirstOrDefault();
if (data == null)
{
db.CustomerOrder.Add(new CustomerOrder()
{
Amount = iNewRow.Amount,
Price = iNewRow.Price,
ProductId = iNewRow.ProductId,
OrderId = iNewRow.OrderId,
Description = iNewRow.Description,
Barcode = iNewRow.Barcode,
Guid = iNewRow.Guid
});
db.SaveChanges();
}
}
// Silinen var mı ?
foreach (var iDBRow in DBList)
{
var data = newRows.Where(a => a.CustomerOrderId == iDBRow.CustomerOrderId).FirstOrDefault();
if (data == null)
{
db.CustomerOrder.Remove(iDBRow);
db.SaveChanges();
}
}
}
}
