// POST: api/Order
public Response Post([FromBody] dynamic Orderdetails)
{
int UserId = Orderdetails.UserId;
int ProductId = Orderdetails.ProductId;
string OrderDetails = Orderdetails.OrderDetails.ToString();
T_OrderDetails details = new T_OrderDetails();
details.UserId = UserId;
details.ProductId = ProductId;
details.OrderDate = DateTime.Now;
details.Quantity = OrderDetails;
dalobject.T_OrderDetails.Add(details);
try
{
dalobject.SaveChanges();
response.Data = details;
response.Error = null;
response.Status = "Success";
return(response);
}
catch (Exception ex)
{
response.Data = null;
response.Error = ex;
response.Status = "Fail";
return(response);
}
}
T_OrderDetails IOrder.InsertOrderDetails(T_OrderDetails orderDet)
{
try
{
return(iorder.InsertOrderDetails(orderDet));
}
catch (Exception)
{
return(null);
}
}
public async Task <HttpResponseMessage> AddOrderDetails(T_OrderDetails order)
{
T_OrderDetails result = new T_OrderDetails();
try
{
await Task.Run(() =>
{
result = iorder.InsertOrderDetails(order);
});
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
T_OrderDetails IOrderDA.InsertOrderDetails(T_OrderDetails orderDet)
{
DataTable dt = new DataTable();
T_OrderDetails ord = new T_OrderDetails();
if (connString.State == ConnectionState.Closed)
{
connString.Open();
}
cmd = new SqlCommand("uspInsertOrderDetails", connString);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@OrderId", orderDet.OrderId);
cmd.Parameters.AddWithValue("@ProductId", orderDet.ProductId);
cmd.Parameters.AddWithValue("@Quantity", orderDet.Quantity);
cmd.Parameters.AddWithValue("@TotalPrice", orderDet.TotalPrice);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(dt);
sda.Dispose();
connString.Close();
ord = ExtensionMethods.ConvertToListOf <T_OrderDetails>(dt).FirstOrDefault();
return(ord);
}
