/// <summary>
/// Loads the by customer and order group id.
/// </summary>
/// <param name="CustomerId">The customer id.</param>
/// <param name="OrderGroupId">The order group id.</param>
/// <returns></returns>
public static PurchaseOrder LoadByCustomerAndOrderGroupId(Guid CustomerId, int OrderGroupId)
{
Guid searchGuid = Guid.NewGuid();
DataCommand cmd = OrderDataHelper.CreateTranDataCommand();
cmd.CommandText = String.Format("ecf_Search_{0}_CustomerAndOrderGroupId", OrderContext.Current.PurchaseOrderMetaClass.Name);
cmd.Parameters = new DataParameters();
cmd.Parameters.Add(new DataParameter("ApplicationId", OrderConfiguration.Instance.ApplicationId, DataParameterType.UniqueIdentifier));
cmd.Parameters.Add(new DataParameter("SearchSetId", searchGuid, DataParameterType.UniqueIdentifier));
cmd.Parameters.Add(new DataParameter("CustomerId", CustomerId, DataParameterType.UniqueIdentifier));
cmd.Parameters.Add(new DataParameter("OrderGroupId", OrderGroupId, DataParameterType.Int));
// Might be good idea to signal if there are results at all
DataService.Run(cmd);
// Load results and return them back
MetaStorageCollectionBase <PurchaseOrder> orders = LoadSearchResults(searchGuid);
if (orders.Count > 0)
{
return(orders[0]);
}
return(null);
}
/// <summary>
/// Returns 0 if no patches were installed.
/// </summary>
/// <param name="major"></param>
/// <param name="minor"></param>
/// <param name="patch"></param>
/// <param name="installDate"></param>
/// <returns></returns>
public static int GetOrderSystemVersion(out int major, out int minor, out int patch, out DateTime installDate)
{
int retval = 0;
major = 0;
minor = 0;
patch = 0;
installDate = DateTime.MinValue;
DataCommand command = OrderDataHelper.CreateConfigDataCommand();
command.CommandText = "GetOrderSchemaVersionNumber";
DataResult result = DataService.LoadDataSet(command);
if (result.DataSet != null)
{
if (result.DataSet.Tables.Count > 0 && result.DataSet.Tables[0].Rows.Count > 0)
{
DataRow row = result.DataSet.Tables[0].Rows[0];
major = (int)row["Major"];
minor = (int)row["Minor"];
patch = (int)row["Patch"];
installDate = (DateTime)row["InstallDate"];
}
}
return(retval);
}
/// <summary>
/// Loads cat by name and customer id.
/// </summary>
/// <param name="CustomerId">The customer id.</param>
/// <param name="Name">The name.</param>
/// <returns></returns>
public static Cart LoadByCustomerAndName(Guid CustomerId, string Name)
{
Guid searchGuid = Guid.NewGuid();
DataCommand cmd = OrderDataHelper.CreateTranDataCommand();
cmd.CommandText = String.Format("ecf_Search_{0}_CustomerAndName", OrderContext.Current.ShoppingCartMetaClass.Name);
cmd.Parameters = new DataParameters();
cmd.Parameters.Add(new DataParameter("ApplicationId", OrderConfiguration.Instance.ApplicationId, DataParameterType.UniqueIdentifier));
cmd.Parameters.Add(new DataParameter("SearchSetId", searchGuid, DataParameterType.UniqueIdentifier));
cmd.Parameters.Add(new DataParameter("CustomerId", CustomerId, DataParameterType.UniqueIdentifier));
cmd.Parameters.Add(new DataParameter("Name", Name, DataParameterType.NVarChar));
cmd.Parameters[2].Size = 64;
// Might be good idea to signal if there are results at all
DataService.Run(cmd);
// Load results and return them back
MetaStorageCollectionBase <Cart> carts = LoadSearchResults(searchGuid);
if (carts.Count > 0)
{
return(carts[0]);
}
return(null);
}
/// <summary>
/// Loads the search results.
/// </summary>
/// <param name="SearchGuid">The search GUID.</param>
/// <returns></returns>
private static MetaStorageCollectionBase <PurchaseOrder> LoadSearchResults(Guid SearchGuid)
{
DataCommand cmd = OrderDataHelper.CreateTranDataCommand();
cmd.CommandText = String.Format("ecf_Search_{0}", OrderContext.Current.PurchaseOrderMetaClass.Name);
cmd.Parameters = new DataParameters();
cmd.Parameters.Add(new DataParameter("SearchSetId", SearchGuid, DataParameterType.UniqueIdentifier));
// Might be good idea to signal if there are results at all
DataResult result = DataService.LoadDataSet(cmd);
MetaStorageCollectionBase <PurchaseOrder> orders = new MetaStorageCollectionBase <PurchaseOrder>();
PopulateCollection <PurchaseOrder>(OrderContext.Current.PurchaseOrderClassInfo, orders, result.DataSet);
return(orders);
}
/// <summary>
/// Loads the Payment Plan by customer.
/// </summary>
/// <param name="CustomerId">The customer id.</param>
/// <returns></returns>
public static MetaStorageCollectionBase <PaymentPlan> LoadByCustomer(Guid CustomerId)
{
Guid searchGuid = Guid.NewGuid();
DataCommand cmd = OrderDataHelper.CreateTranDataCommand();
cmd.CommandText = String.Format("ecf_Search_{0}_Customer", OrderContext.Current.PaymentPlanMetaClass.Name);
cmd.Parameters = new DataParameters();
cmd.Parameters.Add(new DataParameter("ApplicationId", OrderConfiguration.Instance.ApplicationId, DataParameterType.UniqueIdentifier));
cmd.Parameters.Add(new DataParameter("SearchSetId", searchGuid, DataParameterType.UniqueIdentifier));
cmd.Parameters.Add(new DataParameter("CustomerId", CustomerId, DataParameterType.UniqueIdentifier));
// Might be good idea to signal if there are results at all
DataService.Run(cmd);
// Load results and return them back
return(LoadSearchResults(searchGuid));
}
