protected BaseTableAdapter GetGlossary(string name)
{
BaseTableAdapter table = null;
switch (name)
{
case "Address":
table = new AddressTableAdapter()
{
Connection = _conn
};
break;
case "Customer":
table = new Accounting.DAL.TableAdapters.CustomerTableAdapter.CustomerTableAdapter()
{
Connection = _conn
};
break;
case "Invalid":
table = new InvalidBenefitsCategoryTableAdapter()
{
Connection = _conn
};
break;
case "Register":
table = new RegisterTableAdapter()
{
Connection = _conn
};
break;
}
return(table);
}
public void Tables_InvalidBenefitsTables_Relationship_DeleteCascadTest()
{
ConnectionManager.SetConnection("Supervisor", "admin");
BaseTableAdapter tableAdapter = new GenderTableAdapter();
tableAdapter.Connection = ConnectionManager.Connection;
Tables tables = new Tables();
tableAdapter.Fill(tables.GenderDataTable);
tableAdapter = new ApppTprTableAdapter();
tableAdapter.Connection = ConnectionManager.Connection;
tableAdapter.Fill(tables.ApppDataTable);
tableAdapter = new CustomerTableAdapter();
tableAdapter.Connection = ConnectionManager.Connection;
tableAdapter.Fill(tables.CustomerDataTable);
tableAdapter = new BenefitsCategoryTableAdapter();
tableAdapter.Connection = ConnectionManager.Connection;
tableAdapter.Fill(tables.BenefitsDataTable);
tableAdapter = new ChiperReceptTableAdapter();
tableAdapter.Connection = ConnectionManager.Connection;
tableAdapter.Fill(tables.ChiperReceptDataTable);
tableAdapter = new DisabilityGroupTableAdapter();
tableAdapter.Connection = ConnectionManager.Connection;
tableAdapter.Fill(tables.DisabilityGroupDataTable);
tableAdapter = new InvalidTableAdapter();
tableAdapter.Connection = ConnectionManager.Connection;
tableAdapter.Fill(tables.InvalidDataTable);
tableAdapter = new InvalidBenefitsCategoryTableAdapter();
tableAdapter.Connection = ConnectionManager.Connection;
tableAdapter.Fill(tables.InvalidBenefitsDataTable);
int countRows = tables.InvalidBenefitsDataTable.Rows.Count;
bool isRow = false;
for (int i = 0; i < tables.InvalidBenefitsDataTable.Rows.Count; i++)
{
int invalidId = Int32.Parse(tables.InvalidBenefitsDataTable.Rows[tables.InvalidBenefitsDataTable.Rows.Count - 1]["InvID"].ToString());
Debug.WriteLine("InvID " + invalidId);
int customerId = -10;
for (int j = 0; j < tables.InvalidDataTable.Rows.Count; j++)
{
if (Int32.Parse(tables.InvalidDataTable.Rows[j][0].ToString()) == invalidId)
{
customerId = Int32.Parse(tables.InvalidDataTable.Rows[j]["CustomerID"].ToString());
isRow = true;
Debug.WriteLine("CustomerID " + customerId);
break;
}
}
if (isRow)
{
for (int z = 0; z < tables.CustomerDataTable.Rows.Count; z++)
{
if (Int32.Parse(tables.CustomerDataTable.Rows[z][0].ToString()) == customerId)
{
tables.CustomerDataTable.Rows[z].Delete();
break;
}
}
}
if (isRow)
{
break;
}
}
tableAdapter = new CustomerTableAdapter();
tableAdapter.Connection = ConnectionManager.Connection;
((UpdateBaseTableAdapter)tableAdapter).Update(tables.CustomerDataTable);
tables.InvalidBenefitsDataTable.Clear();
tableAdapter = new InvalidTableAdapter();
tableAdapter.Connection = ConnectionManager.Connection;
tableAdapter.Fill(tables.InvalidDataTable);
tableAdapter = new InvalidBenefitsCategoryTableAdapter();
tableAdapter.Connection = ConnectionManager.Connection;
tableAdapter.Fill(tables.InvalidBenefitsDataTable);
Assert.IsTrue(countRows - tables.InvalidBenefitsDataTable.Rows.Count >= 1);
}
