public void TestSetup()
{
grid_testObject = new MonthlyOperationGridClientSettings();
userTA.InsertQuery(ADOPerson1.ID, "TestADOPerson6");
DatabaseGateway.TA_SecurityUserDataTable userTable = userTable = userTA.GetDataByUserName("TestADOPerson6");
ADOUser6.ID = Convert.ToInt32(userTable.Rows[0]["user_ID"]);
ADOUser6.UserName = "******";
DatabaseGateway.TA_LanguagesDataTable langTable = langTA.GetData();
ADOLAnguage1.ID = Convert.ToInt32(langTable.Rows[0][0]);
ADOLAnguage2.ID = Convert.ToInt32(langTable.Rows[1][0]);
userSettingTA.Insert(ADOUser1.ID, ADOLAnguage1.ID, null);
userSettingTA.Insert(ADOUser2.ID, ADOLAnguage2.ID, null);
DatabaseGateway.TA_UserSettingsDataTable userSetTanle = new DatabaseGateway.TA_UserSettingsDataTable();
userSetTanle = userSettingTA.GetDataByUsername(ADOUser1.UserName);
ADOUserSet1.ID = Convert.ToInt32(userSetTanle.Rows[0][0]);
userSetTanle = userSettingTA.GetDataByUsername(ADOUser2.UserName);
ADOUserSet2.ID = Convert.ToInt32(userSetTanle.Rows[0][0]);
gridTA.Insert(ADOUserSet1.ID, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true);
busGridSettings = new BGridMonthlyOperationClientSettings(ADOUser1.UserName);
DatasetGatewayWorkFlow.TA_GridMonthlyOperationGridClientSettingsDataTable table = new DatasetGatewayWorkFlow.TA_GridMonthlyOperationGridClientSettingsDataTable();
table = gridTA.GetDataByUsername(ADOUser1.UserName);
ADOgrid1.ID = Convert.ToInt32(table.Rows[0][0]);
}
public void TestSetup()
{
busUserSettings = new BUserSettings();
email_testObject = new EmailSettings();
userTA.InsertQuery(ADOPerson1.ID, "TestADOPerson6");
DatabaseGateway.TA_SecurityUserDataTable userTable = userTable = userTA.GetDataByUserName("TestADOPerson6");
ADOUser6.ID = Convert.ToInt32(userTable.Rows[0]["user_ID"]);
ADOUser6.UserName = "******";
DatabaseGateway.TA_LanguagesDataTable langTable = langTA.GetData();
ADOLAnguage1.ID = Convert.ToInt32(langTable.Rows[0][0]);
ADOLAnguage2.ID = Convert.ToInt32(langTable.Rows[1][0]);
userSettingTA.Insert(ADOUser1.ID, ADOLAnguage1.ID, null);
userSettingTA.Insert(ADOUser2.ID, ADOLAnguage2.ID, null);
DatabaseGateway.TA_UserSettingsDataTable userSetTanle = userSettingTA.GetDataByUsername(ADOUser1.UserName);
ADOUserSet1.ID = Convert.ToInt32(userSetTanle.Rows[0][0]);
userSetTanle = userSettingTA.GetDataByUsername(ADOUser2.UserName);
ADOUserSet2.ID = Convert.ToInt32(userSetTanle.Rows[0][0]);
emailTA.Insert(ADOUserSet1.ID, true, true, 1, 420, 0, ADOUserSet1.ID);
DatabaseGateway2.TA_EmailSettingsDataTable table = new DatabaseGateway2.TA_EmailSettingsDataTable();
table = emailTA.GetDataByUserName(ADOUser1.UserName);
ADOEmailSetting1.ID = Convert.ToInt32(table.Rows[0][0]);
smsTA.Insert(ADOUserSet1.ID, true, true, 1, 420, 0, ADOUserSet1.ID);
ADOSMSSetting1.ID = ADOUserSet1.ID;
}
public void TestSetup()
{
manager_testObject = new Manager();
busManager = new BManager();
userTA.InsertQuery(ADOPerson1.ID, "TestADOPerson1");
userTA.InsertQuery(ADOPerson3.ID, "TestADOPerson3");
DatabaseGateway.TA_SecurityUserDataTable userTable = new DatabaseGateway.TA_SecurityUserDataTable();
userTable = userTA.GetDataByUserName("TestADOPerson1");
ADOUser1.ID = Convert.ToInt32(userTable.Rows[0]["user_ID"]);
ADOUser1.UserName = "******";
userTable = userTA.GetDataByUserName("TestADOPerson3");
ADOUser2.ID = Convert.ToInt32(userTable.Rows[0]["user_ID"]);
ADOUser2.UserName = "******";
DatabaseGateway.TA_OrganizationUnitDataTable table = organTA.GetDataByParent();
ADOOrganParent.ID = Convert.ToInt32(table.Rows[0]["organ_ID"]);
ADOOrganParent.CustomCode = Convert.ToString(table.Rows[0]["organ_CustomCode"]);
organTA.Insert("TestLevel2_1", "0-1", ADOPerson2.ID, ADOOrganParent.ID, String.Format(",{0},", ADOOrganParent.ID));
table = organTA.GetDataByCustomCode("0-1");
ADOOrgan.ID = Convert.ToInt32(table.Rows[0]["organ_ID"]);
ADOOrgan.ParentID = Convert.ToInt32(table.Rows[0]["organ_ParentID"]);
ADOOrgan.Name = Convert.ToString(table.Rows[0]["organ_Name"]);
ADOOrgan.CustomCode = Convert.ToString(table.Rows[0]["organ_CustomCode"]);
ADOOrgan.PersonID = Convert.ToInt32(table.Rows[0]["organ_PersonID"]);
organTA.Insert("TestLevel2_2", "0-2", ADOPerson1.ID, ADOOrganParent.ID, String.Format(",{0},", ADOOrganParent.ID));
table = organTA.GetDataByCustomCode("0-2");
ADOOrgan2.ID = Convert.ToInt32(table.Rows[0]["organ_ID"]);
ADOOrgan2.ParentID = Convert.ToInt32(table.Rows[0]["organ_ParentID"]);
ADOOrgan2.Name = Convert.ToString(table.Rows[0]["organ_Name"]);
ADOOrgan2.CustomCode = Convert.ToString(table.Rows[0]["organ_CustomCode"]);
ADOOrgan2.PersonID = Convert.ToInt32(table.Rows[0]["organ_PersonID"]);
organTA.Insert("TestLevel2_3", "0-3", ADOPerson3.ID, ADOOrganParent.ID, String.Format(",{0},", ADOOrganParent.ID));
table = organTA.GetDataByCustomCode("0-3");
ADOOrgan3.ID = Convert.ToInt32(table.Rows[0]["organ_ID"]);
ADOOrgan3.ParentID = Convert.ToInt32(table.Rows[0]["organ_ParentID"]);
ADOOrgan3.Name = Convert.ToString(table.Rows[0]["organ_Name"]);
ADOOrgan3.CustomCode = Convert.ToString(table.Rows[0]["organ_CustomCode"]);
ADOOrgan3.PersonID = Convert.ToInt32(table.Rows[0]["organ_PersonID"]);
managerTA.Insert(ADOPerson1.ID, null);
managerTA.Insert(null, ADOOrgan.ID);
DatasetGatewayWorkFlow.TA_ManagerDataTable managetTable = new DatasetGatewayWorkFlow.TA_ManagerDataTable();
managerTA.FillByPersonID(managetTable, ADOPerson1.ID);
ADOManager1.ID = Convert.ToInt32(managetTable.Rows[0]["MasterMng_ID"]);
ADOManager1.Person = ADOPerson1;
managerTA.FillByOrganID(managetTable, ADOOrgan.ID);
ADOManager2.ID = Convert.ToInt32(managetTable.Rows[0]["MasterMng_ID"]);
ADOManager2.OrganizationUnit = ADOOrgan;
accessGroupTA.Insert("AccessGroup1_2");
accessGroupTA.Insert("AccessGroup1_3");
DatasetGatewayWorkFlow.TA_PrecardAccessGroupDataTable accessTable = accessGroupTA.GetDataBy1("AccessGroup1_2");
ADOAccessGroup1.ID = Convert.ToInt32(accessTable.Rows[0][0]);
ADOAccessGroup1.Name = "AccessGroup1_2";
accessTable = accessGroupTA.GetDataBy1("AccessGroup1_3");
ADOAccessGroup2.ID = Convert.ToInt32(accessTable.Rows[0][0]);
ADOAccessGroup2.Name = "AccessGroup1_3";
flowTA.Insert(ADOAccessGroup1.ID, false, false, "FlowTest");
DatasetGatewayWorkFlow.TA_FlowDataTable mangTAble = flowTA.GetDataByName("FlowTest");
ADOFlow1.ID = Convert.ToInt32(mangTAble.Rows[0][0]);
ADOFlow1.FlowName = "FlowTest";
ADOFlow1.ActiveFlow = false;
ADOFlow1.WorkFlow = false;
mangFlowTA.Insert(ADOManager2.ID, 1, ADOFlow1.ID, true);
mangFlowTA.Insert(ADOManager1.ID, 2, ADOFlow1.ID, true);
undermanagmentTA.Insert(ADOFlow1.ID, ADOPerson3.ID, ADODepartment1.ID, false, true);
undermanagmentTA.Insert(ADOFlow1.ID, ADOPerson5.ID, ADODepartment2.ID, false, false);
dataAccessMngTA.Insert(BUser.CurrentUser.ID, ADOManager1.ID, false);
dataAccessMngTA.Insert(BUser.CurrentUser.ID, ADOManager2.ID, false);
}
