public async Task <IActionResult> UpdateOrder([FromBody] EditOrders model, Guid CompanyId) { var url = $"{IDPSettings.Current.LunchAppUrl}OrderTrans/UpdateOrders/{model.Id}/{CompanyId}"; var results = await _services.PutAsync <string>(url, model); return(new JsonResult(results)); }
/// <summary> /// /// </summary> public static EditOrders GetOrderByOrderId(int orderId,string userId) { //DB Connection goes here EditOrders _PremiumServicesListing = new EditOrders(); // Create the Database object, using the default database service. The // default database service is determined through configuration. Database db = DatabaseFactory.CreateDatabase(); string sqlCommand = "GetOrdesrByUserIdOrderId"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); // Retrieve products from the specified category. db.AddInParameter(dbCommand, "UserId", DbType.String, userId); // Retrieve products from the specified category. db.AddInParameter(dbCommand, "OrderId", DbType.Int32, orderId); // DataSet that will hold the returned results DataSet commentaryDataSet = null; commentaryDataSet = db.ExecuteDataSet(dbCommand); // Note: connection was closed by ExecuteDataSet method call EditOrders _editUser = new EditOrders(); foreach (DataRow dr in commentaryDataSet.Tables[0].Rows) { _editUser.UserId = dr["UserId"].ToString(); _editUser.OrderReferenceId = dr["UniqueOrderId"].ToString(); _editUser.MonthsOfSubscription = dr["NoOfMonthsSubscriptionDesc"].ToString(); _editUser.PaymentDate = DateTime.Parse(dr["PaymentDate"].ToString()); _editUser.SubscriptionStartDate = DateTime.Parse(dr["subscriptionStartDate"].ToString()); _editUser.SubscriptionEndDate = DateTime.Parse(dr["subscriptionEndDate"].ToString()); _editUser.VendorReferenceId = dr["VendorReferenceId"].ToString(); } return _editUser; }