public static void Update(BuyInTimeProductModel action)
{
ModulesRepository.ModuleExecuteNonQuery(
"Update [Module].[" + ModuleName + "] " +
"Set ProductId=@ProductId, DateStart=@DateStart, DateExpired=@DateExpired, DiscountInTime=@DiscountInTime, ActionText=@ActionText, ShowMode=@ShowMode, IsRepeat=@IsRepeat, DaysRepeat=@DaysRepeat, Picture=@Picture, SortOrder=@SortOrder " +
"Where Id=@Id",
CommandType.Text,
new SqlParameter("@Id", action.Id),
new SqlParameter("@ProductId", action.ProductId),
new SqlParameter("@DateStart", action.DateStart),
new SqlParameter("@DateExpired", action.DateExpired),
new SqlParameter("@DiscountInTime", action.DiscountInTime),
new SqlParameter("@ActionText", action.ActionText),
new SqlParameter("@ShowMode", action.ShowMode),
new SqlParameter("@IsRepeat", action.IsRepeat),
new SqlParameter("@DaysRepeat", action.DaysRepeat),
new SqlParameter("@Picture", action.Picture ?? (object)DBNull.Value),
new SqlParameter("@SortOrder", action.SortOrder));
CacheManager.RemoveByPattern(CacheKey);
}
public static void Add(BuyInTimeProductModel action)
{
action.Id = ModulesRepository.ModuleExecuteScalar <int>(
"Insert Into [Module].[" + ModuleName + "]" +
" (ProductId,DateStart,DateExpired,DiscountInTime,ActionText,ShowMode,IsRepeat,DaysRepeat,Picture,SortOrder) " +
"Values (@ProductId,@DateStart,@DateExpired,@DiscountInTime,@ActionText,@ShowMode,@IsRepeat,@DaysRepeat,@Picture,@SortOrder); " +
"Select scope_identity();",
CommandType.Text,
new SqlParameter("@ProductId", action.ProductId),
new SqlParameter("@DateStart", action.DateStart),
new SqlParameter("@DateExpired", action.DateExpired),
new SqlParameter("@DiscountInTime", action.DiscountInTime),
new SqlParameter("@ActionText", action.ActionText),
new SqlParameter("@ShowMode", action.ShowMode),
new SqlParameter("@IsRepeat", action.IsRepeat),
new SqlParameter("@DaysRepeat", action.DaysRepeat),
new SqlParameter("@Picture", action.Picture ?? (object)DBNull.Value),
new SqlParameter("@SortOrder", action.SortOrder));
CacheManager.RemoveByPattern(CacheKey);
}
