public int createOrder(Models.CreateOrderReq obj)
{
try
{
EFModels.NTECommerceDBContext context = new EFModels.NTECommerceDBContext();
var result = context.Orders
.FromSqlRaw($"EXEC CreateOrder {obj.CustomerId}, {obj.ItemId}, {obj.AddressId}, {obj.Quantity}")
.ToList();
return(result.FirstOrDefault().Id);
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <IActionResult> createOrder(Models.CreateOrderReq requestModel)
{
try
{
Helpers.Orders obj = new Helpers.Orders();
var data = obj.createOrder(requestModel);
return(Ok(data));
}
catch (Exception ex)
{
if (ex.Message.IndexOf("Exist") > -1)
{
return(BadRequest("Customer Doesn't Exist."));
}
else
{
return(BadRequest("Something went wrong."));
}
}
}
