private void ExportParentChildInfo()
{
SMSSyncBAL bal = new SMSSyncBAL();
try
{
bal.Connect_SBP();
bal.Connect_SMS();
bal.TruncateTable_SMSSyncExport_AccountGrouping_Info_UITransApplied();
SqlDataReader dr_AccountGrouping = bal.GetIPO_AccountGrouping_Info_UITransApplied();
bal.InsertTable_SMSSyncExport_AccountGrouping_Info_UITransApplied(dr_AccountGrouping);
bal.Commit_SBP();
bal.Commit_SMS();
}
catch (Exception ex)
{
bal.Rollback_SBP();
bal.Rollback_SMS();
}
finally
{
bal.CloseConnection_SBP();
bal.CloseConnection_SMS();
}
}
private void button7_Click(object sender, EventArgs e)
{
try
{
SMSSyncBAL bal = new SMSSyncBAL();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
