public void InsertPurchaseRestrictionSetting(Domain.PurchaseLimitationGroup setting)
{
using (var dbOperator = new DbOperator(Provider, ConnectionString)){
string sql = InsertPurchaseLimitationGroup(setting, dbOperator);
dbOperator.ExecuteNonQuery(sql);
}
}
public void UpdatePurchaseRestrictionSetting(Domain.PurchaseLimitationGroup setting)
{
string sql = @"DELETE FROM Rebate
FROM dbo.T_PurchaseLimitationGroup LimitationGroup
INNER JOIN dbo.T_PurchaseLimitation Limitation ON Limitation.LimitationGroupId = LimitationGroup.Id
INNER JOIN dbo.T_PurchaseLimitationRebate Rebate ON Limitation.Id = Rebate.LimitationId
WHERE IncomeGroupId= @CurrentIncomeGroupId;
DELETE FROM Limitation
FROM dbo.T_PurchaseLimitationGroup LimitationGroup
INNER JOIN dbo.T_PurchaseLimitation Limitation ON Limitation.LimitationGroupId = LimitationGroup.Id
WHERE IncomeGroupId= @CurrentIncomeGroupId;
DELETE FROM dbo.T_PurchaseLimitationGroup WHERE IncomeGroupId=@CurrentIncomeGroupId;";
using (var dbOperator = new DbOperator(Provider, ConnectionString))
{
dbOperator.AddParameter("CurrentIncomeGroupId", setting.IncomeGroupId);
sql += InsertPurchaseLimitationGroup(setting, dbOperator);
dbOperator.ExecuteNonQuery(sql);
}
}
