public async Task <IActionResult> PostToOrderDetails([FromODataUri] int keyOrderID, [FromBody] OrderDetail orderdetail)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (orderdetail == null)
{
return(BadRequest());
}
var repository = new OrderDetailsRepository(_context);
try
{
await repository.Insert(orderdetail);
repository.Save();
return(Created(orderdetail));
}
catch (Exception e)
{
return(BadRequest(new
{
message = e.Message.Replace('{', '(').Replace('}', ')')
}));
}
}
public async Task <ActionResult> Create([FromBody] OrderDetail orderDetail)
{
if (ModelState.IsValid)
{
if (orderDetail == null)
{
return(BadRequest());
}
var repository = new OrderDetailsRepository(_context);
try
{
await repository.Insert(orderDetail);
repository.Save();
return(NoContent());
}
catch (Exception e)
{
return(BadRequest(new
{
message = e.Message.Replace('{', '(').Replace('}', ')')
}));
}
}
return(BadRequest(new
{
message = "ModelState is not valid"
}));
}
public async Task Insert(OrderDetail item)
{
using (var context = new NorthwindDbContext(_options))
{
var repository = new OrderDetailsRepository(context);
await repository.Insert(item);
repository.Save();
}
}
public async Task Insert(OrderDetail item)
{
using (var context = new NorthwindDbContext(_options))
{
try
{
var repository = new OrderDetailsRepository(context);
await repository.Insert(item);
repository.Save();
}
catch (Exception e)
{
throw new GridException("DETSRV-01", e);
}
}
}
public JsonResult Index(OrderViewModel objOrderViewModel)
{
OrderRepository orderRepository = new OrderRepository();
var order = new Order();
order.OrderDate = DateTime.Now;
order.CustomerId = objOrderViewModel.CustomerId;
order.FinalTotal = objOrderViewModel.FinalTotal;
order.OrderNumber = string.Format("{0:ddmmyyyyhhmmss}", DateTime.Now);
order.PaymentTypeId = objOrderViewModel.PaymentTypeId;
orderRepository.Insert(order);
int OrderId = order.ID;
foreach (var item in objOrderViewModel.ListOfOrderDetailsViewModel)
{
OrderDetailsRepository orderDetailsRepository = new OrderDetailsRepository();
var OrderDetails = new OrderDetail();
OrderDetails.OrderId = OrderId;
OrderDetails.Quantity = item.Quantity;
OrderDetails.ItemId = item.ItemId;
OrderDetails.UnitPrice = item.UnitPrice;
OrderDetails.Discount = item.Discount;
OrderDetails.Total = item.Total;
orderDetailsRepository.Insert(OrderDetails);
TransactionRepository transactionRepository = new TransactionRepository();
Transaction transaction = new Transaction();
transaction.ItemId = item.ItemId;
transaction.Quantity = item.Quantity;
transaction.TransactionDate = DateTime.Now;
transaction.TypeId = 2;
transactionRepository.Insert(transaction);
}
return(Json("Order has been Successfully placed", JsonRequestBehavior.AllowGet));
}
public OrderDetail Insert(OrderDetail Order)
{
_orderRepository.Insert(Order);
return(Order);
}