public IHttpActionResult DeleteOrderRow(OrderRow obj) { DataTable dt = new DataTable(); try { nwindConn.Open(); SqlDataAdapter Adapter = new SqlDataAdapter("EXECUTE Store.[sp_DeleteOrderRow] @RowIdentity", nwindConn); Adapter.SelectCommand.Parameters.AddWithValue("@RowIdentity", obj.RowIdentity); Adapter.SelectCommand.CommandTimeout = 30; Adapter.Fill(dt); nwindConn.Close(); if (dt == null) { return(NotFound()); } return(Ok(dt)); // return dt; } catch (Exception ex) { dt = ConstructError("C#-19", ex); return(Ok(dt)); } }
public IHttpActionResult SetRating(OrderRow obj) { DataTable dt = new DataTable(); try { nwindConn.Open(); SqlDataAdapter Adapter = new SqlDataAdapter("EXECUTE Store.[sp_SetRating] @CustomerIdentity,@ProductIdentity,@Score,@Comments", nwindConn); Adapter.SelectCommand.Parameters.AddWithValue("@CustomerIdentity", obj.CustomerIdentity); Adapter.SelectCommand.Parameters.AddWithValue("@ProductIdentity", obj.ProductIdentity); Adapter.SelectCommand.Parameters.AddWithValue("@Score", obj.Score); if (obj.Comments == null) { obj.Comments = ""; } Adapter.SelectCommand.Parameters.AddWithValue("@Comments", obj.Comments); Adapter.SelectCommand.CommandTimeout = 30; Adapter.Fill(dt); nwindConn.Close(); if (dt == null) { return(NotFound()); } return(Ok(dt)); // return dt; } catch (Exception ex) { dt = ConstructError("C#-13", ex); return(Ok(dt)); } }
public IHttpActionResult GetOrderRows(OrderRow obj) { DataTable dt = new DataTable(); try { nwindConn.Open(); SqlDataAdapter Adapter = new SqlDataAdapter("EXECUTE Store.[sp_GetOrderRows]", nwindConn); Adapter.SelectCommand.CommandTimeout = 30; Adapter.Fill(dt); nwindConn.Close(); if (dt == null) { return(NotFound()); } return(Ok(dt)); // return dt; } catch (Exception ex) { dt = ConstructError("C#-17", ex); return(Ok(dt)); } }
public OrderRow CreateShoe(string OrderIdentity, string ProductIdentity, string Productname, string Price, string Discount)//, string Color, string Size, string ImageURL, string Gender) { OrderRow row = new OrderRow(); row.OrderIdentity = OrderIdentity; row.ProductIdentity = ProductIdentity; row.Productname = Productname; row.Price = Price; row.Discount = Discount; //shoe.Color = Color; //shoe.Size = Size; //shoe.ImageURL = ImageURL; //shoe.Gender = Gender; return(row); }
public IHttpActionResult UpdateOrderRow(OrderRow obj) { DataTable dt = new DataTable(); try { nwindConn.Open(); SqlDataAdapter Adapter = new SqlDataAdapter("EXECUTE Store.[sp_UpdateOrderRow] @OrderIdentity,@RowIdentity,@StatusIdentity,@Price,@Discount,@Quantity ", nwindConn); // Adapter.SelectCommand.Parameters.AddWithValue("@ResturantId", obj.ResturantId); Adapter.SelectCommand.Parameters.AddWithValue("@OrderIdentity", obj.OrderIdentity); Adapter.SelectCommand.Parameters.AddWithValue("@RowIdentity", obj.RowIdentity); Adapter.SelectCommand.Parameters.AddWithValue("@StatusIdentity", obj.StatusIdentity); Adapter.SelectCommand.Parameters.AddWithValue("@Price", obj.Price); if (obj.Discount == null) { obj.Discount = "0"; } Adapter.SelectCommand.Parameters.AddWithValue("@Discount", obj.Discount); Adapter.SelectCommand.Parameters.AddWithValue("@Quantity", obj.Quantity); //Adapter.SelectCommand.Parameters.AddWithValue("@RowIdentity", obj.RowIdentity); // Adapter.SelectCommand.Parameters.AddWithValue("@Quantity", obj.ResturantId); Adapter.SelectCommand.CommandTimeout = 30; Adapter.Fill(dt); nwindConn.Close(); if (dt == null) { return(NotFound()); } return(Ok(dt)); // return dt; } catch (Exception ex) { dt = ConstructError("C#-18", ex); return(Ok(dt)); } }