// 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); }