public Models.UpdatePromotionResultDo CreatePromotionTemplate(Models.PromotionDo entity)
{
Models.UpdatePromotionResultDo result = new Models.UpdatePromotionResultDo();
db.CreateCommand(new Utils.SQL.SQLCommandHandler((Utils.SQL.ASQLDbCommand command) =>
{
command.CommandText = "[dbo].[sp_Create_PromotionTemplate]";
command.CommandType = System.Data.CommandType.StoredProcedure;
command.AddParameter(typeof(string), "NameLC", entity.PromotionName);
command.AddParameter(typeof(string), "NameEN", entity.PromotionName);
command.AddParameter(typeof(string), "PromotionType", entity.PromotionType);
command.AddParameter(typeof(int), "Qty", entity.Qty);
command.AddParameter(typeof(bool), "FlagActivate", entity.FlagActivate);
command.AddParameter(typeof(DateTime), "StartDate", entity.StartDate);
command.AddParameter(typeof(DateTime), "EndDate", entity.EndDate);
string brandXml = Utils.ConvertUtil.ConvertToXml_Store <Models.PromotionBrandDo>(entity.Brands);
command.AddParameter(typeof(string), "BrandXML", brandXml);
command.AddParameter(typeof(string), "DiscountFor", entity.DiscountFor);
command.AddParameter(typeof(string), "DiscountType", entity.DiscountType);
command.AddParameter(typeof(decimal), "CashValue", entity.CashValue);
command.AddParameter(typeof(DateTime), "CreateDate", entity.CreateDate);
command.AddParameter(typeof(string), "CreateUser", entity.CreateUser);
result.Promotion = command.ToList <Models.PromotionDo>()[0];
}));
return(result);
}
public Models.PromotionDo GetPromotionTemplate(Models.PromotionCriteriaDo criteria)
{
Models.PromotionDo result = null;
db.CreateCommand(new Utils.SQL.SQLCommandHandler((Utils.SQL.ASQLDbCommand command) =>
{
command.CommandText = "[dbo].[sp_Get_PromotionTemplate]";
command.CommandType = System.Data.CommandType.StoredProcedure;
command.AddParameter(typeof(int), "PromotionTemplateID", criteria.PromotionTemplateID);
System.Collections.IList[] dbls = command.ToList(
typeof(Models.PromotionDo), typeof(Models.PromotionBrandDo));
if (dbls != null)
{
List <Models.PromotionDo> dbvs = dbls[0] as List <Models.PromotionDo>;
List <Models.PromotionBrandDo> dbvbs = dbls[1] as List <Models.PromotionBrandDo>;
if (dbvs != null)
{
if (dbvs.Count > 0)
{
result = dbvs[0];
result.Brands = dbvbs;
}
}
}
}));
return(result);
}
public Models.PromotionDo UpdatePromotionTemplate(Models.PromotionDo entity)
{
Models.PromotionDo result = null;
db.CreateCommand(new Utils.SQL.SQLCommandHandler((Utils.SQL.ASQLDbCommand command) =>
{
command.CommandText = "[dbo].[sp_Update_PromotionTemplate]";
command.CommandType = System.Data.CommandType.StoredProcedure;
command.AddParameter(typeof(int), "PromotionTemplateID", entity.PromotionTemplateID);
command.AddParameter(typeof(string), "NameLC", entity.NameLC);
command.AddParameter(typeof(string), "NameEN", entity.NameLC);
command.AddParameter(typeof(string), "PromotionType", entity.PromotionType);
command.AddParameter(typeof(int), "Qty", entity.Qty);
command.AddParameter(typeof(DateTime), "StartDate", entity.StartDate);
command.AddParameter(typeof(DateTime), "EndDate", entity.EndDate);
command.AddParameter(typeof(bool), "FlagActivate", entity.FlagActivate);
string brandXml = Utils.ConvertUtil.ConvertToXml_Store <Models.PromotionBrandDo>(entity.Brands);
command.AddParameter(typeof(string), "BrandXML", brandXml);
command.AddParameter(typeof(string), "DiscountFor", entity.DiscountFor);
command.AddParameter(typeof(string), "DiscountType", entity.DiscountType);
command.AddParameter(typeof(decimal), "CashValue", entity.CashValue);
command.AddParameter(typeof(DateTime), "UpdateDate", entity.UpdateDate);
command.AddParameter(typeof(string), "UpdateUser", entity.UpdateUser);
System.Collections.IList[] dbls = command.ToList(
typeof(Models.PromotionDo), typeof(Models.PromotionBrandDo));
if (dbls != null)
{
List <Models.PromotionDo> dbps = dbls[0] as List <Models.PromotionDo>;
List <Models.PromotionBrandDo> dbvbs = dbls[1] as List <Models.PromotionBrandDo>;
if (dbps != null)
{
if (dbps.Count > 0)
{
result = dbps[0];
result.Brands = dbvbs;
}
}
}
}));
return(result);
}
public void UpdateStatusPromotion(Models.PromotionDo entity)
{
db.CreateCommand(new Utils.SQL.SQLCommandHandler((Utils.SQL.ASQLDbCommand command) =>
{
command.CommandText = "[dbo].[sp_Update_Status_Promotion]";
command.CommandType = System.Data.CommandType.StoredProcedure;
command.AddParameter(typeof(int), "PromotionTemplateID", entity.PromotionTemplateID);
string promotionXml = Utils.ConvertUtil.ConvertToXml_Store <Models.PromotionAtivateDo>(entity.Promotions);
command.AddParameter(typeof(string), "PromotionXML", promotionXml);
command.AddParameter(typeof(string), "TypeStatus", entity.TypeStatus);
command.AddParameter(typeof(DateTime), "UpdateDate", entity.UpdateDate);
command.AddParameter(typeof(string), "UpdateUser", entity.UpdateUser);
command.ExecuteScalar();
}));
}
public void GeneratePromotion(Models.PromotionDo entity)
{
db.CreateCommand(new Utils.SQL.SQLCommandHandler((Utils.SQL.ASQLDbCommand command) =>
{
command.CommandText = "[dbo].[sp_Generate_Promotion]";
command.CommandType = System.Data.CommandType.StoredProcedure;
command.AddParameter(typeof(int), "PromotionTemplateID", entity.PromotionTemplateID);
command.AddParameter(typeof(string), "PromotionType", entity.PromotionType);
command.AddParameter(typeof(int), "Qty", entity.Qty);
command.AddParameter(typeof(DateTime), "StartDate", entity.StartDate);
command.AddParameter(typeof(DateTime), "EndDate", entity.EndDate);
command.AddParameter(typeof(bool), "FlagActivate", entity.FlagActivate);
command.AddParameter(typeof(DateTime), "CreateDate", entity.CreateDate);
command.AddParameter(typeof(string), "CreateUser", entity.CreateUser);
command.ExecuteScalar();
}));
}
