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); }