public void UpdateProvisioningTableInstance()
{
using (SqlConnection conn = _provisionningRuleManager.GetConnection())
using (SqlTransaction sqlTransac = conn.BeginTransaction())
{
ProvisionTable pT = ProvisionTable.GetInstance(_user);
try
{
_provisionningRuleManager.DeleteAllProvisioningRules(sqlTransac);
int i = 1;
foreach (ProvisioningRate pR in pT.ProvisioningRates)
{
pR.Number = i;
_provisionningRuleManager.AddProvisioningRate(pR, sqlTransac);
i++;
}
sqlTransac.Commit();
}
catch (Exception ex)
{
sqlTransac.Rollback();
throw ex;
}
}
}
public void TestDeleteProvisionningRules()
{
ProvisioningRuleManager provisioningRuleManager = (ProvisioningRuleManager)container["ProvisioningRuleManager"];
SqlTransaction transaction = provisioningRuleManager.GetConnection().BeginTransaction();
provisioningRuleManager.DeleteAllProvisioningRules(transaction);
transaction.Commit();
List <ProvisioningRate> list = provisioningRuleManager.SelectAllProvisioningRates();
Assert.AreEqual(0, list.Count);
}