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); }
public static int GetMarketOrderId(int orderId) { return(ModulesRepository.ModuleExecuteScalar <int>( "Select MarketOrderId From Module.YaMarketOrder Where OrderId = @OrderId", CommandType.Text, new SqlParameter("@OrderId", orderId))); }