/// <summary>
/// Loads the specified Promotion id.
/// </summary>
/// <param name="PromotionId">The Promotion id.</param>
internal void Load(int PromotionId, Guid customerId, int orderGroupId)
{
DataCommand cmd = MarketingDataHelper.CreateDataCommand();
cmd.CommandText = String.Format("ecf_mktg_PromotionUsage");
cmd.Parameters = new DataParameters();
cmd.Parameters.Add(new DataParameter("ApplicationId", MarketingConfiguration.Instance.ApplicationId, DataParameterType.UniqueIdentifier));
cmd.Parameters.Add(new DataParameter("PromotionId", PromotionId, DataParameterType.Int));
if (customerId == Guid.Empty)
{
cmd.Parameters.Add(new DataParameter("CustomerId", DataParameterType.UniqueIdentifier));
}
else
{
cmd.Parameters.Add(new DataParameter("CustomerId", customerId, DataParameterType.UniqueIdentifier));
}
cmd.Parameters.Add(new DataParameter("OrderGroupId", orderGroupId, DataParameterType.Int));
cmd.DataSet = this.CurrentDto;
cmd.TableMapping = Mapping;
DataService.LoadDataSet(cmd);
}
/// <summary>
/// Updates the Segment.
/// </summary>
internal void Save()
{
DataCommand cmd = MarketingDataHelper.CreateDataCommand();
using (TransactionScope scope = new TransactionScope())
{
DataHelper.SaveDataSetSimple(MarketingContext.MetaDataContext, cmd, CurrentDto, "Segment", "SegmentMember", "SegmentCondition");
scope.Complete();
}
}
/// <summary>
/// Updates the Promotion.
/// </summary>
internal void Save()
{
DataCommand cmd = MarketingDataHelper.CreateDataCommand();
using (TransactionScope scope = new TransactionScope())
{
DataHelper.SaveDataSetSimple(MarketingContext.MetaDataContext, cmd, CurrentDto, "PromotionUsage");
scope.Complete();
}
}
/// <summary>
/// Updates the Campaign.
/// </summary>
internal void Save()
{
// TODO: Check if user is allowed to perform this operation
DataCommand cmd = MarketingDataHelper.CreateDataCommand();
using (TransactionScope scope = new TransactionScope())
{
DataHelper.SaveDataSetSimple(MarketingContext.MetaDataContext, cmd, CurrentDto, "Campaign", "CampaignSegment");
scope.Complete();
}
}
/// <summary>
/// Loads the specified Campaign id.
/// </summary>
/// <param name="CampaignId">The Campaign id.</param>
internal void Load(int CampaignId)
{
DataCommand cmd = MarketingDataHelper.CreateDataCommand();
cmd.CommandText = String.Format("ecf_mktg_Campaign");
cmd.Parameters = new DataParameters();
cmd.Parameters.Add(new DataParameter("ApplicationId", MarketingConfiguration.Instance.ApplicationId, DataParameterType.UniqueIdentifier));
cmd.Parameters.Add(new DataParameter("CampaignId", CampaignId, DataParameterType.Int));
cmd.DataSet = this.CurrentDto;
cmd.TableMapping = Mapping;
DataService.LoadDataSet(cmd);
}
/// <summary>
/// Loads the by category.
/// </summary>
/// <param name="category">The category.</param>
internal void LoadByCategory(string category)
{
DataCommand cmd = MarketingDataHelper.CreateDataCommand();
cmd.CommandText = String.Format("ecf_mktg_Expression_Category");
cmd.Parameters = new DataParameters();
cmd.Parameters.Add(new DataParameter("ApplicationId", MarketingConfiguration.Instance.ApplicationId, DataParameterType.UniqueIdentifier));
cmd.Parameters.Add(new DataParameter("Category", category, DataParameterType.NVarChar, 50));
cmd.DataSet = this.CurrentDto;
cmd.TableMapping = Mapping;
DataService.LoadDataSet(cmd);
}
/// <summary>
/// Loads the promotion using the specified datetime.
/// </summary>
/// <param name="datetime">The datetime in UTC format.</param>
internal void Load(DateTime datetime)
{
DataCommand cmd = MarketingDataHelper.CreateDataCommand();
cmd.CommandText = String.Format("ecf_mktg_PromotionByDate");
cmd.Parameters = new DataParameters();
cmd.Parameters.Add(new DataParameter("ApplicationId", MarketingConfiguration.Instance.ApplicationId, DataParameterType.UniqueIdentifier));
cmd.Parameters.Add(new DataParameter("DateTime", datetime, DataParameterType.DateTime));
cmd.DataSet = this.CurrentDto;
cmd.TableMapping = Mapping;
DataService.LoadDataSet(cmd);
}
/// <summary>
/// Loads the statistics table. Pass Guid.Empty for customer id to load non customer specific statistics (gloabl).
/// </summary>
/// <param name="customerId">The customer id.</param>
/// <returns></returns>
internal DataTable LoadStatistics(Guid customerId)
{
DataCommand cmd = MarketingDataHelper.CreateDataCommand();
cmd.CommandText = String.Format("ecf_mktg_PromotionUsageStatistics");
cmd.Parameters = new DataParameters();
cmd.Parameters.Add(new DataParameter("ApplicationId", MarketingConfiguration.Instance.ApplicationId, DataParameterType.UniqueIdentifier));
if (customerId == Guid.Empty)
{
cmd.Parameters.Add(new DataParameter("CustomerId", DataParameterType.UniqueIdentifier));
}
else
{
cmd.Parameters.Add(new DataParameter("CustomerId", customerId, DataParameterType.UniqueIdentifier));
}
return(DataService.LoadTable(cmd));
}