public OrderObjects PlaceOrder(OrderModify order) { List <Orders> _orders = new List <Orders>(); OrderMessages _message = new OrderMessages(); var _returnObject = orderRepository.OrdersModify(order); _orders = _returnObject._orders; return(new OrderObjects() { _orders = _orders, _orderMessages = _message }); }
public OrderObjects OrdersModify(OrderModify order) { List <Orders> _orders = new List <Orders>(); OrderMessages _message = new OrderMessages(); SqlCommand command = new SqlCommand(); DataSet ds = new DataSet(); try { command.CommandType = CommandType.StoredProcedure; command.Connection = new SqlConnection(ConnectionString); command.CommandText = "OrderModify"; command.Parameters.Add("@OrderId", SqlDbType.Int).Value = order.OrderId; command.Parameters.Add("@CustomerId", SqlDbType.Int).Value = order.CustomerId; command.Parameters.Add("@MenuItemId", SqlDbType.Int).Value = order.MenuItemId; command.Parameters.Add("@VAT", SqlDbType.Decimal).Value = order.VAT; command.Parameters.Add("@IsActive", SqlDbType.Bit).Value = order.IsActive; command.Parameters.Add("@CreateDate", SqlDbType.DateTime).Value = order.CreateDate; SqlDataAdapter da = new SqlDataAdapter(command); da.Fill(ds, "Orders"); da.Dispose(); if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { _orders.Add(new Orders( int.Parse(ds.Tables[0].Rows[0]["OrderId"].ToString()), int.Parse(ds.Tables[0].Rows[0]["CustomerId"].ToString()), ds.Tables[0].Rows[0]["FirstName"].ToString(), ds.Tables[0].Rows[0]["LastName"].ToString(), ds.Tables[0].Rows[0]["PhoneNumber"].ToString(), ds.Tables[0].Rows[0]["EmailAddress"].ToString(), Convert.ToDateTime(ds.Tables[0].Rows[0]["DateOfBirth"].ToString()), ds.Tables[0].Rows[0]["Country"].ToString(), int.Parse(ds.Tables[0].Rows[0]["MenuItemId"].ToString()), ds.Tables[0].Rows[0]["MenuItem"].ToString(), Convert.ToDecimal(ds.Tables[0].Rows[0]["Amount"].ToString()), Convert.ToDecimal(ds.Tables[0].Rows[0]["VAT"].ToString()), Convert.ToBoolean(ds.Tables[0].Rows[0]["IsActive"].ToString()), Convert.ToDateTime(ds.Tables[0].Rows[0]["CreateDate"].ToString()) )); } else { _message.ErrorMessage = "Orders could not be found."; } _message.ErrorMessage = "Orders found."; } else { _message.ErrorMessage = "Orders could not be found."; } } catch (Exception ex) { _message.ErrorMessage = _message.ErrorMessage + " - Exception: " + ex.Message.ToString(); } return(new OrderObjects() { _orders = _orders, _orderMessages = _message }); }