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