public void Tables_CustomerInvalidTables_RelationshipTest()
{
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);
Assert.IsTrue(tables.InvalidDataTable.Rows.Count > 1);
}
public void Tables_CustomerInvalidTables_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);
int countRows = tables.InvalidDataTable.Rows.Count;
int customerId = Int32.Parse(tables.InvalidDataTable.Rows[tables.InvalidDataTable.Rows.Count - 1]["CustomerID"].ToString());
for (int i = 0; i < tables.CustomerDataTable.Rows.Count; i++)
{
if (Int32.Parse(tables.CustomerDataTable.Rows[i][0].ToString()) == customerId)
{
tables.CustomerDataTable.Rows[i].Delete();
break;
}
}
tableAdapter = new CustomerTableAdapter();
tableAdapter.Connection = ConnectionManager.Connection;
((UpdateBaseTableAdapter)tableAdapter).Update(tables.CustomerDataTable);
tableAdapter = new InvalidTableAdapter();
tableAdapter.Connection = ConnectionManager.Connection;
tableAdapter.Fill(tables.InvalidDataTable);
Assert.IsTrue(countRows - tables.InvalidDataTable.Rows.Count >= 1);
}
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);
}