public Models.PromotionResultDo GetPromotionList(Models.PromotionCriteriaDo criteria)
{
Models.PromotionResultDo result = new Models.PromotionResultDo();
db.CreateCommand(new Utils.SQL.SQLCommandHandler((Utils.SQL.ASQLDbCommand command) =>
{
command.CommandText = "[dbo].[sp_Get_PromotionList]";
command.CommandType = System.Data.CommandType.StoredProcedure;
command.AddParameter(typeof(string), "PromotionTemplateID", criteria.PromotionTemplateID);
command.AddParameter(typeof(string), "PromotionNumber", criteria.PromotionNumber);
command.AddParameter(typeof(decimal), "PromotionValue", criteria.PromotionValue);
command.AddParameter(typeof(string), "BrandCode", criteria.BrandCode);
command.AddParameter(typeof(DateTime), "CreateDateFrom", criteria.CreateDateFrom);
command.AddParameter(typeof(DateTime), "CreateDateTo", criteria.CreateDateTo);
command.AddParameter(typeof(DateTime), "StartDate", criteria.StartDate);
command.AddParameter(typeof(DateTime), "EndDate", criteria.EndDate);
command.AddParameter(typeof(DateTime), "PrintDateFrom", criteria.PrintDateFrom);
command.AddParameter(typeof(DateTime), "PrintDateTo", criteria.PrintDateTo);
command.AddParameter(typeof(DateTime), "UsedDateFrom", criteria.UsedDateFrom);
command.AddParameter(typeof(DateTime), "UsedDateTo", criteria.UsedDateTo);
command.AddParameter(typeof(bool), "IsUsed", criteria.IsUsed);
command.AddParameter(typeof(bool), "IsExpired", criteria.IsExpired);
command.AddParameter(typeof(bool), "IsVoid", criteria.IsVoid);
command.AddParameter(typeof(bool), "IsActive", criteria.IsActive);
command.AddParameter(typeof(DateTime), "CurrentDate", criteria.CurrentDate);
Utils.SQL.ISQLDbParameter output = command.AddSearchParameter(criteria);
Utils.SQL.ISQLDbParameter ovoucher = command.AddOutputParameter(typeof(int), "TotalPromotion");
result.Rows = command.ToList <Models.PromotionFSDo>();
result.TotalRecordParameter(output);
}));
return(result);
}
public Models.PromotionResultDo GetPromotionTemplateList(Models.PromotionCriteriaDo criteria)
{
Models.PromotionResultDo result = new Models.PromotionResultDo();
db.CreateCommand(new Utils.SQL.SQLCommandHandler((Utils.SQL.ASQLDbCommand command) =>
{
command.CommandText = "[dbo].[sp_Get_PromotionTemplateList]";
command.CommandType = System.Data.CommandType.StoredProcedure;
command.AddParameter(typeof(string), "PromotionName", criteria.PromotionName);
command.AddParameter(typeof(string), "PromotionNumber", criteria.PromotionNumber);
command.AddParameter(typeof(decimal), "PromotionValue", criteria.PromotionValue);
command.AddParameter(typeof(string), "BrandCode", criteria.BrandCode);
command.AddParameter(typeof(DateTime), "CreateDateFrom", criteria.CreateDateFrom);
command.AddParameter(typeof(DateTime), "CreateDateTo", criteria.CreateDateTo);
command.AddParameter(typeof(DateTime), "StartDate", criteria.StartDate);
command.AddParameter(typeof(DateTime), "EndDate", criteria.EndDate);
command.AddParameter(typeof(DateTime), "PrintDateFrom", criteria.PrintDateFrom);
command.AddParameter(typeof(DateTime), "PrintDateTo", criteria.PrintDateTo);
command.AddParameter(typeof(DateTime), "UsedDateFrom", criteria.UsedDateFrom);
command.AddParameter(typeof(DateTime), "UsedDateTo", criteria.UsedDateTo);
command.AddParameter(typeof(bool), "IsUsed", criteria.IsUsed);
command.AddParameter(typeof(bool), "IsExpired", criteria.IsExpired);
command.AddParameter(typeof(bool), "IsVoid", criteria.IsVoid);
command.AddParameter(typeof(bool), "IsActive", criteria.IsActive);
command.AddParameter(typeof(DateTime), "CurrentDate", criteria.CurrentDate);
Utils.SQL.ISQLDbParameter output = command.AddSearchParameter(criteria);
Utils.SQL.ISQLDbParameter tpromotion = command.AddOutputParameter(typeof(int), "TotalPromotion");
Utils.SQL.ISQLDbParameter tfpromotion = command.AddOutputParameter(typeof(int), "TotalFilterPromotion");
System.Collections.IList[] dbls = command.ToList(typeof(Models.PromotionFSDo), typeof(Models.PromotionBrandDo));
if (dbls != null)
{
List <Models.PromotionFSDo> voucher = dbls[0] as List <Models.PromotionFSDo>;
List <Models.PromotionBrandDo> voucherbrand = dbls[1] as List <Models.PromotionBrandDo>;
if (voucher != null)
{
result.Rows = voucher;
if (voucherbrand != null)
{
foreach (Models.PromotionFSDo p in result.Rows)
{
p.Brands = voucherbrand.FindAll(x => x.PromotionTemplateID == p.PromotionTemplateID);
}
}
if (tpromotion != null)
{
result.TotalPromotion = (int)tpromotion.Value;
}
if (tfpromotion != null)
{
result.TotalFilterPromotion = (int)tfpromotion.Value;
}
result.TotalRecordParameter(output);
}
}
}));
return(result);
}