public void TestSetup() { precard_testObject = new Precard(); bussPrecard = new BPrecard(); groupPrecardTA.Insert("TestPrecardGroup", "TestGroup1"); DatasetGatewayWorkFlow.TA_PrecardGroupsDataTable groupTable; groupTable = groupPrecardTA.GetDataByName("TestGroup1"); ADOGroup.ID = Convert.ToDecimal(groupTable.Rows[0][0]); precardTA.Insert("TestPish1", true, ADOGroup.ID, true, false, false, "1001", false); precardTA.Insert("TestPish2", true, ADOGroup.ID, false, true, false, "1002", false); DatasetGatewayWorkFlow.TA_PrecardDataTable precardTable = new DatasetGatewayWorkFlow.TA_PrecardDataTable(); precardTable = precardTA.GetDataByName("TestPish1"); ADOPrecard1.ID = Convert.ToDecimal(precardTable.Rows[0][0]); ADOPrecard1.Name = "TestPish1"; ADOPrecard1.Active = true; ADOPrecard1.IsHourly = true; ADOPrecard1.Code = "1001"; ADOPrecard1.PrecardGroup = ADOGroup; precardTable = precardTA.GetDataByName("TestPish2"); ADOPrecard2.ID = Convert.ToDecimal(precardTable.Rows[0][0]); ADOPrecard2.Name = "TestPish2"; ADOPrecard2.Active = true; ADOPrecard2.IsDaily = true; ADOPrecard2.Code = "1002"; ADOPrecard2.PrecardGroup = ADOGroup; basicTA.Insert(ADOPrecard1.ID, ADOPerson1.ID, DateTime.Now, 0, false, true, false, false); subTA.Insert(ADOPrecard1.ID, null); }
public void TestSetup() { dutyPlace_testObject = new DutyPlace(); busDutyPlace = new BDutyPlace(); DatabaseGateway.TA_DutyPlaceDataTable dutyTable = dutyPlaceTA.GetRoot(); DatabaseGateway.TA_DutyPlaceRow dutyPlaceRow; if (dutyTable.Rows.Count == 0) { dutyPlaceTA.Insert("TestDutyPlaceRoot", "0-00Test", 0); dutyTable = dutyPlaceTA.GetRoot(); } dutyPlaceRow = dutyTable.Rows[0] as DatabaseGateway.TA_DutyPlaceRow; ADODutyPlaceRoot.ID = dutyPlaceRow.dutyPlc_ID; ADODutyPlaceRoot.CustomCode = dutyPlaceRow.dutyPlc_CustomCode; ADODutyPlaceRoot.Name = dutyPlaceRow.dutyPlc_Name; ADODutyPlaceRoot.ParentID = 0; dutyPlaceTA.Insert("TestDutyPlace1", "0-00Test1", ADODutyPlaceRoot.ID); dutyTable = dutyPlaceTA.GetDataByCustomCode("0-00Test1"); dutyPlaceRow = dutyTable.Rows[0] as DatabaseGateway.TA_DutyPlaceRow; ADODutyPlace1.ID = dutyPlaceRow.dutyPlc_ID; ADODutyPlace1.Name = dutyPlaceRow.dutyPlc_Name; ADODutyPlace1.CustomCode = dutyPlaceRow.dutyPlc_CustomCode; ADODutyPlace1.ParentID = dutyPlaceRow.dutyPlc_ParentID; dutyPlaceTA.Insert("TestDutyPlace2", "0-00Test2", ADODutyPlaceRoot.ID); dutyTable = dutyPlaceTA.GetDataByCustomCode("0-00Test2"); dutyPlaceRow = dutyTable.Rows[0] as DatabaseGateway.TA_DutyPlaceRow; ADODutyPlace2.ID = dutyPlaceRow.dutyPlc_ID; ADODutyPlace2.Name = dutyPlaceRow.dutyPlc_Name; ADODutyPlace2.CustomCode = dutyPlaceRow.dutyPlc_CustomCode; ADODutyPlace2.ParentID = dutyPlaceRow.dutyPlc_ParentID; DatasetGatewayWorkFlow.TA_PrecardGroupsDataTable precardTable = new DatasetGatewayWorkFlow.TA_PrecardGroupsDataTable(); precardGroupTA.FillByName(precardTable, PrecardGroupsName.leave.ToString()); ADOPrecardGroup1.ID = Convert.ToInt32(precardTable.Rows[0][0]); ADOPrecardGroup1.Name = "HourlyLeave"; precardTA.Insert("TestPrecard1", true, ADOPrecardGroup1.ID, true, false, true, "99999999", false); DatasetGatewayWorkFlow.TA_PrecardDataTable pTable = new DatasetGatewayWorkFlow.TA_PrecardDataTable(); pTable = precardTA.GetDataByName("TestPrecard1"); ADOPrecar1.ID = Convert.ToInt32(pTable.Rows[0][0]); ADOPrecar1.Name = "TestPrecard1"; requestTA.Insert(ADOPrecar1.ID, ADOPerson1.ID, new DateTime(2010, 5, 1), new DateTime(2010, 5, 1), 420, 600, "", DateTime.Now, ADOUser1.ID); DatasetGatewayWorkFlow.TA_RequestDataTable requestTable = new DatasetGatewayWorkFlow.TA_RequestDataTable(); requestTable = requestTA.GetDataByPersonId(ADOPerson1.ID); ADORequest1.ID = Convert.ToInt32(requestTable.Rows[0][0]); requestDetailTA.Insert(ADORequest1.ID, null, null, ADODutyPlace2.ID); }
public void TestSetup() { busDataAccess = new BDataAccess(); #region Shift shiftTA.Insert("ShiftTest", 1, 11, null, 100, false, false, false, "2", "0-00"); ADOShift = new Shift(); DatabaseGateway.TA_ShiftDataTable shiftTable = new DatabaseGateway.TA_ShiftDataTable(); shiftTA.FillByName(shiftTable, "ShiftTest"); ADOShift.ID = Convert.ToInt32(shiftTable.Rows[0]["shift_ID"]); ADOShift.Name = Convert.ToString(shiftTable.Rows[0]["shift_Name"]); ADOShift.Color = Convert.ToString(shiftTable.Rows[0]["shift_Color"]); ADOShift.CustomCode = Convert.ToString(shiftTable.Rows[0]["shift_CustomCode"]); dataAccessShiftTA.Insert(BUser.CurrentUser.ID, ADOShift.ID, false); ADODAShift.ID = (dataAccessShiftTA.GetByShiftId(BUser.CurrentUser.ID, ADOShift.ID).Rows[0] as DatabaseGateway.TA_DataAccessShiftRow).DataAccessShift_ID; #endregion #region WorkGroup workgrpTA.Insert("WorkGroupTest1", "0-1", 0); DatabaseGateway.TA_WorkGroupDataTable workGrouptable = new DatabaseGateway.TA_WorkGroupDataTable(); workgrpTA.FillByName(workGrouptable, "WorkGroupTest1"); ADOWorkGroup.ID = Convert.ToInt32(workGrouptable.Rows[0]["workgroup_ID"]); ADOWorkGroup.Name = Convert.ToString(workGrouptable.Rows[0]["workgroup_Name"]); ADOWorkGroup.CustomCode = Convert.ToString(workGrouptable.Rows[0]["workgroup_CustomCode"]); dataAccessWorkGroupTA.Insert(BUser.CurrentUser.ID, ADOWorkGroup.ID, false); ADODAWorkGroup.ID = (dataAccessWorkGroupTA.GetDataByWorkGroupId(ADOWorkGroup.ID, BUser.CurrentUser.ID).Rows[0] as DatabaseGateway.TA_DataAccessWorkGroupRow).DataAccessWorkGrp_ID; #endregion #region Precard groupPrecardTA.Insert("TestPrecardGroup", "TestGroup1"); DatasetGatewayWorkFlow.TA_PrecardGroupsDataTable groupTable; groupTable = groupPrecardTA.GetDataByName("TestGroup1"); ADOGroup.ID = Convert.ToDecimal(groupTable.Rows[0][0]); precardTA.Insert("TestPish2", true, ADOGroup.ID, false, true, false, "1002", false); DatasetGatewayWorkFlow.TA_PrecardDataTable precardTable = new DatasetGatewayWorkFlow.TA_PrecardDataTable(); precardTable = precardTA.GetDataByName("TestPish2"); ADOPrecard.ID = Convert.ToDecimal(precardTable.Rows[0][0]); dataAccessPrecardTA.Insert(BUser.CurrentUser.ID, ADOPrecard.ID, false); ADODAPrecard.ID = (dataAccessPrecardTA.GetDataByPrecardId(BUser.CurrentUser.ID, ADOPrecard.ID).Rows[0] as DatabaseGateway.TA_DataAccessPrecardRow).DataAccessPreCard_ID; #endregion #region Station dataAccessControlStationTA.Insert(BUser.CurrentUser.ID, ADOStaion1.ID, false); ADODACtrlStation.ID = (dataAccessControlStationTA.GetDataByControlIdId(BUser.CurrentUser.ID, ADOStaion1.ID).Rows[0] as DatabaseGateway.TA_DataAccessCtrlStationRow).DataAccessCtrlStation_ID; #endregion }
public void TestSetup() { accessGroup_testObject = new PrecardAccessGroup(); busAccessGroup = new BPrecardAccessGroup(); accessGroupTA.Insert("TestAccessGroup1"); DatasetGatewayWorkFlow.TA_PrecardAccessGroupDataTable accessTable = new DatasetGatewayWorkFlow.TA_PrecardAccessGroupDataTable(); accessTable = accessGroupTA.GetDataBy1("TestAccessGroup1"); ADOaccessGroup1.ID = Convert.ToDecimal(accessTable.Rows[0][0]); ADOaccessGroup1.Name = "TestAccessGroup1"; accessGroupTA.Insert("TestAccessGroup2"); accessTable = accessGroupTA.GetDataBy1("TestAccessGroup2"); ADOaccessGroup2.ID = Convert.ToDecimal(accessTable.Rows[0][0]); ADOaccessGroup2.Name = "TestAccessGroup2"; groupPrecardTA.Insert("TestPrecardGroup", "TestGroup1"); DatasetGatewayWorkFlow.TA_PrecardGroupsDataTable groupTable; groupTable = groupPrecardTA.GetDataByName("TestGroup1"); ADOGroup.ID = Convert.ToDecimal(groupTable.Rows[0][0]); precardTA.Insert("TestPish1", true, ADOGroup.ID, true, false, false, "1001", false); precardTA.Insert("TestPish2", true, ADOGroup.ID, false, true, false, "1002", false); precardTA.Insert("TestPish3", true, ADOGroup.ID, false, true, false, "1003", false); DatasetGatewayWorkFlow.TA_PrecardDataTable precardTable = new DatasetGatewayWorkFlow.TA_PrecardDataTable(); precardTable = precardTA.GetDataByName("TestPish1"); ADOPrecard1.ID = Convert.ToDecimal(precardTable.Rows[0][0]); ADOPrecard1.Name = "TestPish1"; ADOPrecard1.Active = true; ADOPrecard1.IsHourly = true; ADOPrecard1.Code = "1001"; precardTable = precardTA.GetDataByName("TestPish2"); ADOPrecard2.ID = Convert.ToDecimal(precardTable.Rows[0][0]); ADOPrecard2.Name = "TestPish2"; ADOPrecard2.Active = true; ADOPrecard2.IsDaily = true; ADOPrecard2.Code = "1002"; precardTable = precardTA.GetDataByName("TestPish3"); ADOPrecard3.ID = Convert.ToDecimal(precardTable.Rows[0][0]); ADOPrecard3.Name = "TestPish3"; ADOPrecard3.Active = true; ADOPrecard3.IsDaily = true; ADOPrecard3.Code = "1003"; accessDetailTA.Insert(ADOaccessGroup1.ID, ADOPrecard1.ID); accessDetailTA.Insert(ADOaccessGroup1.ID, ADOPrecard2.ID); accessDetailTA.Insert(ADOaccessGroup1.ID, ADOPrecard3.ID); flowTA.Insert(ADOaccessGroup2.ID, false, false, "TestMyFlow"); }
public void TestSetup() { busTraffic = new BTraffic(); basic_testObject = new BasicTraffic(); groupPrecardTA.Insert("TestPrecardGroup", "TestGroup1"); DatasetGatewayWorkFlow.TA_PrecardGroupsDataTable groupTable; groupTable = groupPrecardTA.GetDataByName("TestGroup1"); ADOGroup.ID = Convert.ToDecimal(groupTable.Rows[0][0]); precardTA.Insert("TestPish1", true, ADOGroup.ID, true, false, false, "1001", false); DatasetGatewayWorkFlow.TA_PrecardDataTable precardTable = new DatasetGatewayWorkFlow.TA_PrecardDataTable(); precardTable = precardTA.GetDataByName("TestPish1"); ADOPrecard1.ID = Convert.ToDecimal(precardTable.Rows[0][0]); basicTA.InsertQuery(ADOPrecard1.ID, ADOPerson1.ID, DateTime.Now, 100, false, true); DatabaseGateway.TA_BaseTrafficDataTable baseTable = basicTA.GetDataByPerson(ADOPerson1.ID); ADOBasic1.ID = Convert.ToDecimal(baseTable.Rows[0][0]); }
public void TestSetup() { #region precards DatasetGatewayWorkFlow.TA_PrecardGroupsDataTable precardTable = new DatasetGatewayWorkFlow.TA_PrecardGroupsDataTable(); precardGroupTA.FillByName(precardTable, PrecardGroupsName.leave.ToString()); ADOPrecardGroup1.ID = Convert.ToInt32(precardTable.Rows[0][0]); ADOPrecardGroup1.Name = "HourlyLeave"; precardGroupTA.FillByName(precardTable, PrecardGroupsName.duty.ToString()); ADOPrecardGroup2.ID = Convert.ToInt32(precardTable.Rows[0][0]); ADOPrecardGroup2.Name = "HourlyDuty"; precardGroupTA.FillByName(precardTable, PrecardGroupsName.leaveestelajy.ToString()); ADOPrecardGroup3.ID = Convert.ToInt32(precardTable.Rows[0][0]); ADOPrecardGroup3.Name = "Estelaji"; precardGroupTA.FillByName(precardTable, PrecardGroupsName.traffic.ToString()); ADOPrecardGroup4.ID = Convert.ToInt32(precardTable.Rows[0][0]); ADOPrecardGroup4.Name = "Traffic"; precardGroupTA.FillByName(precardTable, PrecardGroupsName.overwork.ToString()); ADOPrecardGroup5.ID = Convert.ToInt32(precardTable.Rows[0][0]); ADOPrecardGroup5.Name = "OwerWork"; precardTA.Insert("TestPrecard1", true, ADOPrecardGroup1.ID, true, false, true, "99999999", false); precardTA.Insert("TestPrecard4", true, ADOPrecardGroup1.ID, false, true, true, "99999999", false); precardTA.Insert("TestPrecard6", true, ADOPrecardGroup1.ID, false, true, true, "99999999", false); precardTA.Insert("TestPrecard7", true, ADOPrecardGroup2.ID, false, true, true, "99999999", false); precardTA.Insert("TestPrecard2", true, ADOPrecardGroup2.ID, true, false, true, "99999999", false); precardTA.Insert("TestPrecard3", true, ADOPrecardGroup3.ID, true, false, true, "99999999", false); precardTA.Insert("TestPrecard5", true, ADOPrecardGroup4.ID, true, false, true, "99999999", false); precardTA.Insert("TestPrecard8", true, ADOPrecardGroup5.ID, true, false, true, "99999999", false); DatasetGatewayWorkFlow.TA_PrecardDataTable pTable = new DatasetGatewayWorkFlow.TA_PrecardDataTable(); pTable = precardTA.GetDataByName("TestPrecard1"); ADOPrecardHourlyLeave1.ID = Convert.ToInt32(pTable.Rows[0][0]); ADOPrecardHourlyLeave1.Name = "TestPrecard1"; pTable = precardTA.GetDataByName("TestPrecard2"); ADOPrecardHourlyDuty1.ID = Convert.ToInt32(pTable.Rows[0][0]); ADOPrecardHourlyDuty1.Name = "TestPrecard2"; pTable = precardTA.GetDataByName("TestPrecard3"); ADOPrecardHourlyEstelji1.ID = Convert.ToInt32(pTable.Rows[0][0]); ADOPrecardHourlyEstelji1.Name = "TestPrecard3"; pTable = precardTA.GetDataByName("TestPrecard4"); ADOPrecardHourlyLeave2.ID = Convert.ToInt32(pTable.Rows[0][0]); ADOPrecardHourlyLeave2.Name = "TestPrecard4"; pTable = precardTA.GetDataByName("TestPrecard5"); ADOPrecardTraffic1.ID = Convert.ToInt32(pTable.Rows[0][0]); ADOPrecardTraffic1.Name = "TestPrecard6"; pTable = precardTA.GetDataByName("TestPrecard6"); ADOPrecardDailyLeave1.ID = Convert.ToInt32(pTable.Rows[0][0]); ADOPrecardDailyLeave1.Name = "TestPrecard7"; pTable = precardTA.GetDataByName("TestPrecard7"); ADOPrecardDailyDuty1.ID = Convert.ToInt32(pTable.Rows[0][0]); ADOPrecardDailyDuty1.Name = "TestPrecard7"; pTable = precardTA.GetDataByName("TestPrecard8"); ADOPrecardOverTime1.ID = Convert.ToInt32(pTable.Rows[0][0]); ADOPrecardOverTime1.Name = "TestPrecard8"; #endregion requestTA.Insert(ADOPrecardHourlyLeave1.ID, ADOPerson1.ID, new DateTime(2010, 5, 1), new DateTime(2010, 5, 1), 420, 600, "", DateTime.Now, ADOUser1.ID); requestTA.Insert(ADOPrecardHourlyLeave1.ID, ADOPerson1.ID, new DateTime(2010, 5, 1), new DateTime(2010, 5, 1), 900, 1020, "", DateTime.Now, ADOUser1.ID); requestTA.Insert(ADOPrecardTraffic1.ID, ADOPerson1.ID, new DateTime(2010, 5, 1), new DateTime(2010, 5, 1), 900, 1020, "", DateTime.Now, ADOUser1.ID); requestTA.Insert(ADOPrecardDailyLeave1.ID, ADOPerson1.ID, new DateTime(2010, 5, 2), new DateTime(2010, 5, 6), 0, 0, "", DateTime.Now, ADOUser1.ID); requestTA.Insert(ADOPrecardDailyDuty1.ID, ADOPerson1.ID, new DateTime(2010, 5, 7), new DateTime(2010, 5, 7), 0, 0, "", DateTime.Now, ADOUser1.ID); requestTA.Insert(ADOPrecardHourlyLeave1.ID, ADOPerson5.ID, new DateTime(2010, 5, 7), new DateTime(2010, 5, 7), 420, 600, "", DateTime.Now, ADOUser1.ID); requestTA.Insert(ADOPrecardHourlyLeave1.ID, ADOPerson5.ID, new DateTime(2010, 5, 7), new DateTime(2010, 5, 7), 800, 900, "", DateTime.Now, ADOUser1.ID); requestTA.Insert(ADOPrecardHourlyDuty1.ID, ADOPerson5.ID, new DateTime(2010, 5, 8), new DateTime(2010, 5, 8), 100, 300, "", DateTime.Now, ADOUser1.ID); DatasetGatewayWorkFlow.TA_RequestDataTable requestTable = new DatasetGatewayWorkFlow.TA_RequestDataTable(); requestTable = requestTA.GetDataByPersonId(ADOPerson1.ID); ADORequestHourlyLeave1.ID = Convert.ToInt32(requestTable.Rows[0][0]); ADORequestHourlyLeave2.ID = Convert.ToInt32(requestTable.Rows[1][0]); ADORequestTraffic1.ID = Convert.ToInt32(requestTable.Rows[2][0]); ADORequestDailyLeave1.ID = Convert.ToInt32(requestTable.Rows[3][0]); ADORequestDailyDuty1.ID = Convert.ToInt32(requestTable.Rows[4][0]); requestTable = requestTA.GetDataByPersonId(ADOPerson5.ID); ADORequestLeavePerson2_1.ID = Convert.ToInt32(requestTable.Rows[0][0]); ADORequestLeavePerson2_2.ID = Convert.ToInt32(requestTable.Rows[1][0]); ADORequestDutyPerson2_1.ID = Convert.ToInt32(requestTable.Rows[2][0]); #region Base Information doctorTA.Insert("TestDoctor1", "TestDoctorLastName1", "", "", ""); illnessTA.Insert("TestIllness1", ""); dutyPlcTA.Insert("TestDutyPlc1", "0-0", 0); DatasetGatewayWorkFlow.TA_DoctorDataTable doctorTable = doctorTA.GetDataByName("TestDoctorLastName1"); DatasetGatewayWorkFlow.TA_IllnessDataTable illnessTable = illnessTA.GetDataByName("TestIllness1"); DatasetGatewayWorkFlow.TA_DutyPlaceDataTable dutyPlaceTable = dutyPlcTA.GetDataByName("TestDutyPlc1"); ADODoctor1.ID = Convert.ToInt32(doctorTable.Rows[0][0]); ADODoctor1.FirstName = "TestDoctor1"; ADODoctor1.LastName = "TestDoctorLastName1"; ADOIllness1.ID = Convert.ToInt32(illnessTable.Rows[0][0]); ADOIllness1.Name = "TestIllness1"; ADODuty1.ID = Convert.ToInt32(dutyPlaceTable.Rows[0][0]); ADODuty1.Name = "TestDutyPlc1"; dutyPlcTA.Insert("TestDutyPlc2", "0-0", ADODuty1.ID); dutyPlaceTable = dutyPlcTA.GetDataByName("TestDutyPlc2"); ADODuty2.ID = Convert.ToInt32(dutyPlaceTable.Rows[0][0]); ADODuty2.Name = "TestDutyPlc2"; #endregion #region Manager Flow #region MAnager managerTA.Insert(ADOPerson1.ID, null); 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.Insert(ADOPerson3.ID, null); managetTable = new DatasetGatewayWorkFlow.TA_ManagerDataTable(); managerTA.FillByPersonID(managetTable, ADOPerson3.ID); ADOManager2.ID = Convert.ToInt32(managetTable.Rows[0]["MasterMng_ID"]); ADOManager2.Person = ADOPerson3; managerTA.Insert(ADOPerson4.ID, null); managetTable = new DatasetGatewayWorkFlow.TA_ManagerDataTable(); managerTA.FillByPersonID(managetTable, ADOPerson4.ID); ADOManager3.ID = Convert.ToInt32(managetTable.Rows[0]["MasterMng_ID"]); ADOManager3.Person = ADOPerson4; #endregion accessGroupTA.Insert("AccessGroup1_2"); DatasetGatewayWorkFlow.TA_PrecardAccessGroupDataTable accessTable = accessGroupTA.GetDataBy1("AccessGroup1_2"); ADOAccessGroup1.ID = Convert.ToInt32(accessTable.Rows[0][0]); ADOAccessGroup1.Name = "AccessGroup1_2"; flowTA.Insert(ADOAccessGroup1.ID, false, false, "FlowTest1"); DatasetGatewayWorkFlow.TA_FlowDataTable mangTAble = flowTA.GetDataByName("FlowTest1"); ADOFlow1.ID = Convert.ToInt32(mangTAble.Rows[0][0]); ADOFlow1.FlowName = "FlowTest1"; ADOFlow1.ActiveFlow = false; ADOFlow1.WorkFlow = false; flowTA.Insert(ADOAccessGroup1.ID, false, false, "FlowTest2"); mangTAble = flowTA.GetDataByName("FlowTest2"); ADOFlow2.ID = Convert.ToInt32(mangTAble.Rows[0][0]); ADOFlow2.FlowName = "FlowTest2"; ADOFlow2.ActiveFlow = true; ADOFlow2.WorkFlow = true; mangFlowTA.Insert(ADOManager1.ID, 1, ADOFlow1.ID, true); mangFlowTA.Insert(ADOManager2.ID, 1, ADOFlow2.ID, true); mangFlowTA.Insert(ADOManager3.ID, 1, ADOFlow2.ID, true); DatasetGatewayWorkFlow.TA_ManagerFlowDataTable nbgFlowTable = mangFlowTA.GetDataByFlowID(ADOFlow1.ID); ADOManagerFlow1.ID = Convert.ToInt32(nbgFlowTable.Rows[0]["mngrFlow_ID"]); ADOManagerFlow1.Level = Convert.ToInt32(nbgFlowTable.Rows[0]["mngrFlow_LEVEL"]); nbgFlowTable = mangFlowTA.GetDataByFlowID(ADOFlow2.ID); ADOManagerFlow2.ID = Convert.ToInt32(nbgFlowTable.Rows[0]["mngrFlow_ID"]); ADOManagerFlow2.Level = Convert.ToInt32(nbgFlowTable.Rows[0]["mngrFlow_LEVEL"]); ADOManagerFlow3.ID = Convert.ToInt32(nbgFlowTable.Rows[1]["mngrFlow_ID"]); ADOManagerFlow3.Level = Convert.ToInt32(nbgFlowTable.Rows[1]["mngrFlow_LEVEL"]); #endregion requestStatusTA.Insert(ADOManagerFlow1.ID, ADORequestHourlyLeave1.ID, true, false, "", DateTime.Now, false); requestStatusTA.Insert(ADOManagerFlow1.ID, ADORequestHourlyLeave2.ID, true, true, "", DateTime.Now, false); requestStatusTA.Insert(ADOManagerFlow1.ID, ADORequestDailyDuty1.ID, false, true, "", DateTime.Now, false); requestStatusTA.Insert(ADOManagerFlow1.ID, ADORequestDailyLeave1.ID, false, false, "", DateTime.Now, false); requestStatusTA.Insert(ADOManagerFlow1.ID, ADORequestTraffic1.ID, true, false, "", DateTime.Now, false); requestStatusTA.Insert(ADOManagerFlow2.ID, ADORequestLeavePerson2_1.ID, true, false, "", DateTime.Now, false); requestStatusTA.Insert(ADOManagerFlow3.ID, ADORequestLeavePerson2_1.ID, true, true, "", DateTime.Now, false); requestStatusTA.Insert(ADOManagerFlow3.ID, ADORequestLeavePerson2_2.ID, true, false, "", DateTime.Now, false); requestStatusTA.Insert(ADOManagerFlow3.ID, ADORequestLeavePerson2_2.ID, false, true, "", DateTime.Now, false); requestStatusTA.Insert(ADOManagerFlow3.ID, ADORequestDutyPerson2_1.ID, true, false, "", DateTime.Now, false); request_testObject = new Request(); busHourlyAbsenceRequest = new BRequest(ADOPerson1.ID); busDailyAbsenceRequest = new BRequest(ADOPerson1.ID); busTrafficRequest = new BRequest(ADOPerson1.ID); busOverTime = new BRequest(ADOPerson1.ID); busPersonelRequest = new BRequest(ADOPerson1.ID); }
public void TestSetup() { busflow = new BFlow(); flow_testObject = new Flow(); #region Flow Entry personTA.UpdateDepartmentId(ADODepartment1.ID, ADOPerson3.ID); personTA.UpdateDepartmentId(ADODepartment1.ID, ADOPerson4.ID); personTA.UpdateDepartmentId(ADODepartment2.ID, ADOPerson5.ID); personTA.UpdateDepartmentId(ADODepartment2.ID, ADOPerson6.ID); 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"]); managerTA.Insert(ADOPerson1.ID, null); managerTA.Insert(null, ADOOrgan.ID);//ADOPerson2 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; #region precards DatasetGatewayWorkFlow.TA_PrecardGroupsDataTable precardTable = new DatasetGatewayWorkFlow.TA_PrecardGroupsDataTable(); precardGroupTA.FillByName(precardTable, PrecardGroupsName.leave.ToString()); ADOPrecardGroup1.ID = Convert.ToInt32(precardTable.Rows[0][0]); ADOPrecardGroup1.Name = "HourlyLeave"; precardGroupTA.FillByName(precardTable, PrecardGroupsName.duty.ToString()); ADOPrecardGroup2.ID = Convert.ToInt32(precardTable.Rows[0][0]); ADOPrecardGroup2.Name = "HourlyDuty"; precardGroupTA.FillByName(precardTable, PrecardGroupsName.leaveestelajy.ToString()); ADOPrecardGroup3.ID = Convert.ToInt32(precardTable.Rows[0][0]); ADOPrecardGroup3.Name = "Estelaji"; precardGroupTA.FillByName(precardTable, PrecardGroupsName.traffic.ToString()); ADOPrecardGroup4.ID = Convert.ToInt32(precardTable.Rows[0][0]); ADOPrecardGroup4.Name = "Traffic"; precardGroupTA.FillByName(precardTable, PrecardGroupsName.overwork.ToString()); ADOPrecardGroup5.ID = Convert.ToInt32(precardTable.Rows[0][0]); ADOPrecardGroup5.Name = "OwerWork"; precardTA.Insert("TestPrecard1", true, ADOPrecardGroup1.ID, true, false, true, "99999999", false); precardTA.Insert("TestPrecard4", true, ADOPrecardGroup1.ID, false, true, true, "99999999", false); precardTA.Insert("TestPrecard6", true, ADOPrecardGroup1.ID, false, true, true, "99999999", false); precardTA.Insert("TestPrecard7", true, ADOPrecardGroup2.ID, false, true, true, "99999999", false); precardTA.Insert("TestPrecard2", true, ADOPrecardGroup2.ID, true, false, true, "99999999", false); precardTA.Insert("TestPrecard3", true, ADOPrecardGroup3.ID, true, false, true, "99999999", false); precardTA.Insert("TestPrecard5", true, ADOPrecardGroup4.ID, true, false, true, "99999999", false); precardTA.Insert("TestPrecard8", true, ADOPrecardGroup5.ID, true, false, true, "99999999", false); DatasetGatewayWorkFlow.TA_PrecardDataTable pTable = new DatasetGatewayWorkFlow.TA_PrecardDataTable(); pTable = precardTA.GetDataByName("TestPrecard1"); ADOPrecardHourlyLeave1.ID = Convert.ToInt32(pTable.Rows[0][0]); ADOPrecardHourlyLeave1.Name = "TestPrecard1"; pTable = precardTA.GetDataByName("TestPrecard2"); ADOPrecardHourlyDuty1.ID = Convert.ToInt32(pTable.Rows[0][0]); ADOPrecardHourlyDuty1.Name = "TestPrecard2"; pTable = precardTA.GetDataByName("TestPrecard3"); ADOPrecardHourlyEstelji1.ID = Convert.ToInt32(pTable.Rows[0][0]); ADOPrecardHourlyEstelji1.Name = "TestPrecard3"; pTable = precardTA.GetDataByName("TestPrecard4"); ADOPrecardHourlyLeave2.ID = Convert.ToInt32(pTable.Rows[0][0]); ADOPrecardHourlyLeave2.Name = "TestPrecard4"; pTable = precardTA.GetDataByName("TestPrecard5"); ADOPrecardTraffic1.ID = Convert.ToInt32(pTable.Rows[0][0]); ADOPrecardTraffic1.Name = "TestPrecard6"; pTable = precardTA.GetDataByName("TestPrecard6"); ADOPrecardDailyLeave1.ID = Convert.ToInt32(pTable.Rows[0][0]); ADOPrecardDailyLeave1.Name = "TestPrecard7"; pTable = precardTA.GetDataByName("TestPrecard7"); ADOPrecardDailyDuty1.ID = Convert.ToInt32(pTable.Rows[0][0]); ADOPrecardDailyDuty1.Name = "TestPrecard7"; pTable = precardTA.GetDataByName("TestPrecard8"); ADOPrecardOverTime1.ID = Convert.ToInt32(pTable.Rows[0][0]); ADOPrecardOverTime1.Name = "TestPrecard8"; #endregion 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"; accessGroupDtlTA.Insert(ADOAccessGroup1.ID, ADOPrecardHourlyDuty1.ID); accessGroupDtlTA.Insert(ADOAccessGroup1.ID, ADOPrecardHourlyLeave1.ID); accessGroupDtlTA.Insert(ADOAccessGroup1.ID, ADOPrecardHourlyLeave2.ID); accessGroupDtlTA.Insert(ADOAccessGroup2.ID, ADOPrecardDailyLeave1.ID); accessGroupDtlTA.Insert(ADOAccessGroup2.ID, ADOPrecardDailyDuty1.ID); flowTA.Insert(ADOAccessGroup1.ID, false, false, "FlowTest1"); flowTA.Insert(ADOAccessGroup2.ID, false, false, "FlowTest2"); DatasetGatewayWorkFlow.TA_FlowDataTable mangTAble = flowTA.GetDataByName("FlowTest1"); ADOFlow1.ID = Convert.ToInt32(mangTAble.Rows[0][0]); ADOFlow1.FlowName = "FlowTest1"; ADOFlow1.ActiveFlow = false; ADOFlow1.WorkFlow = false; mangTAble = flowTA.GetDataByName("FlowTest2"); ADOFlow2.ID = Convert.ToInt32(mangTAble.Rows[0][0]); ADOFlow2.FlowName = "FlowTest2"; ADOFlow2.ActiveFlow = false; ADOFlow2.WorkFlow = false; mangFlowTA.Insert(ADOManager1.ID, 1, ADOFlow1.ID, true); //مدیر اولیه mangFlowTA.Insert(ADOManager2.ID, 2, ADOFlow1.ID, true); //مدیر ثانویه mangFlowTA.Insert(ADOManager1.ID, 1, ADOFlow2.ID, true); //مدیر اولیه DatasetGatewayWorkFlow.TA_ManagerFlowDataTable nbgFlowTable = mangFlowTA.GetDataByFlowID(ADOFlow1.ID); ADOManagerFlow1.ID = Convert.ToInt32(nbgFlowTable.Rows[0]["mngrFlow_ID"]); ADOManagerFlow1.Level = Convert.ToInt32(nbgFlowTable.Rows[0]["mngrFlow_LEVEL"]); ADOManagerFlow2.ID = Convert.ToInt32(nbgFlowTable.Rows[1]["mngrFlow_ID"]); ADOManagerFlow2.Level = Convert.ToInt32(nbgFlowTable.Rows[1]["mngrFlow_LEVEL"]); nbgFlowTable = mangFlowTA.GetDataByFlowID(ADOFlow2.ID); ADOManagerFlow3.ID = Convert.ToInt32(nbgFlowTable.Rows[0]["mngrFlow_ID"]); ADOManagerFlow3.Level = Convert.ToInt32(nbgFlowTable.Rows[0]["mngrFlow_LEVEL"]); undermanagmentTA.Insert(ADOFlow1.ID, ADOPerson3.ID, ADODepartment1.ID, false, true); undermanagmentTA.Insert(ADOFlow1.ID, ADOPerson4.ID, ADODepartment1.ID, false, false); undermanagmentTA.Insert(ADOFlow2.ID, null, ADODepartment2.ID, true, true);//ADOPerson4,ADOPerson5 #endregion #region Request Entry requestTA.Insert(ADOPrecardHourlyLeave1.ID, ADOPerson3.ID, new DateTime(2010, 5, 1), new DateTime(2010, 5, 1), 420, 600, "", DateTime.Now, ADOUser1.ID); requestTA.Insert(ADOPrecardHourlyLeave1.ID, ADOPerson3.ID, new DateTime(2010, 5, 2), new DateTime(2010, 5, 2), 900, 1020, "", DateTime.Now, ADOUser1.ID); requestTA.Insert(ADOPrecardHourlyDuty1.ID, ADOPerson3.ID, new DateTime(2010, 5, 2), new DateTime(2010, 5, 2), 700, 800, "", DateTime.Now, ADOUser1.ID); requestTA.Insert(ADOPrecardTraffic1.ID, ADOPerson4.ID, new DateTime(2010, 5, 3), new DateTime(2010, 5, 3), 900, 1020, "", DateTime.Now, ADOUser1.ID); requestTA.Insert(ADOPrecardHourlyDuty1.ID, ADOPerson3.ID, new DateTime(2010, 5, 10), new DateTime(2010, 5, 10), 700, 800, "", DateTime.Now, ADOUser1.ID); requestTA.Insert(ADOPrecardHourlyDuty1.ID, ADOPerson3.ID, new DateTime(2010, 5, 10), new DateTime(2010, 5, 10), 1000, 1100, "", DateTime.Now, ADOUser1.ID); requestTA.Insert(ADOPrecardDailyLeave1.ID, ADOPerson5.ID, new DateTime(2010, 5, 4), new DateTime(2010, 5, 5), 0, 0, "", DateTime.Now, ADOUser1.ID); requestTA.Insert(ADOPrecardDailyDuty1.ID, ADOPerson6.ID, new DateTime(2010, 5, 6), new DateTime(2010, 5, 7), 0, 0, "", DateTime.Now, ADOUser1.ID); DatasetGatewayWorkFlow.TA_RequestDataTable requestTable = new DatasetGatewayWorkFlow.TA_RequestDataTable(); requestTable = requestTA.GetDataByPersonId(ADOPerson3.ID); ADORequestHourlyLeave1.ID = Convert.ToInt32(requestTable.Rows[0][0]); ADORequestHourlyLeave2.ID = Convert.ToInt32(requestTable.Rows[1][0]); ADORequestHourlyDuty1.ID = Convert.ToInt32(requestTable.Rows[2][0]); ADORequestHourlyDuty2.ID = Convert.ToInt32(requestTable.Rows[3][0]); ADORequestHourlyDuty2.FromDate = Convert.ToDateTime(requestTable.Rows[3]["request_fromdate"]); ADORequestHourlyDuty3.ID = Convert.ToInt32(requestTable.Rows[4][0]); requestTable = requestTA.GetDataByPersonId(ADOPerson4.ID); ADORequestTraffic1.ID = Convert.ToInt32(requestTable.Rows[0][0]); requestTable = requestTA.GetDataByPersonId(ADOPerson5.ID); ADORequestDailyLeave1.ID = Convert.ToInt32(requestTable.Rows[0][0]); ADORequestDailyLeave1.FromDate = Convert.ToDateTime(requestTable.Rows[0]["request_fromdate"]); requestTable = requestTA.GetDataByPersonId(ADOPerson6.ID); ADORequestDailyDuty1.ID = Convert.ToInt32(requestTable.Rows[0][0]); #region Request Status requestStatusTA.Insert(ADOManagerFlow1.ID, ADORequestHourlyDuty1.ID, false, true, "", DateTime.Now, false); requestStatusTA.Insert(ADOManagerFlow1.ID, ADORequestHourlyLeave2.ID, true, false, "", DateTime.Now, false); requestStatusTA.Insert(ADOManagerFlow2.ID, ADORequestHourlyLeave2.ID, true, true, "", DateTime.Now, false); requestStatusTA.Insert(ADOManagerFlow1.ID, ADORequestHourlyLeave1.ID, true, false, "", DateTime.Now, false); requestStatusTA.Insert(ADOManagerFlow2.ID, ADORequestHourlyLeave1.ID, false, true, "", DateTime.Now, false); requestStatusTA.Insert(ADOManagerFlow3.ID, ADORequestDailyDuty1.ID, true, true, "", DateTime.Now, false); requestStatusTA.Insert(ADOManagerFlow1.ID, ADORequestHourlyDuty2.ID, true, false, "", DateTime.Now, false); requestStatusTA.Insert(ADOManagerFlow1.ID, ADORequestHourlyDuty3.ID, true, false, "", DateTime.Now, false); //requestStatusTA.Insert(ADOManagerFlow1.ID, ADORequestTraffic1.ID, true, false, "", DateTime.Now, false); #endregion #endregion }
public void TestSetup() { managerTA.Insert(ADOPerson2.ID, null); managerTA.Insert(ADOPerson3.ID, null); DatasetGatewayWorkFlow.TA_ManagerDataTable managetTable = new DatasetGatewayWorkFlow.TA_ManagerDataTable(); managerTA.FillByPersonID(managetTable, ADOPerson2.ID); ADOManager1.ID = Convert.ToInt32(managetTable.Rows[0]["MasterMng_ID"]); ADOManager1.Person = ADOPerson2; managerTA.FillByPersonID(managetTable, ADOPerson3.ID); ADOManager2.ID = Convert.ToInt32(managetTable.Rows[0]["MasterMng_ID"]); ADOManager2.Person = ADOPerson3; #region Flow #region precards DatasetGatewayWorkFlow.TA_PrecardGroupsDataTable precardTable = new DatasetGatewayWorkFlow.TA_PrecardGroupsDataTable(); precardGroupTA.FillByName(precardTable, PrecardGroupsName.leave.ToString()); ADOPrecardGroup1.ID = Convert.ToInt32(precardTable.Rows[0][0]); ADOPrecardGroup1.Name = "HourlyLeave"; precardGroupTA.FillByName(precardTable, PrecardGroupsName.duty.ToString()); ADOPrecardGroup2.ID = Convert.ToInt32(precardTable.Rows[0][0]); ADOPrecardGroup2.Name = "HourlyDuty"; precardGroupTA.FillByName(precardTable, PrecardGroupsName.leaveestelajy.ToString()); ADOPrecardGroup3.ID = Convert.ToInt32(precardTable.Rows[0][0]); ADOPrecardGroup3.Name = "Estelaji"; precardGroupTA.FillByName(precardTable, PrecardGroupsName.traffic.ToString()); ADOPrecardGroup4.ID = Convert.ToInt32(precardTable.Rows[0][0]); ADOPrecardGroup4.Name = "Traffic"; precardGroupTA.FillByName(precardTable, PrecardGroupsName.overwork.ToString()); ADOPrecardGroup5.ID = Convert.ToInt32(precardTable.Rows[0][0]); ADOPrecardGroup5.Name = "OwerWork"; precardTA.Insert("TestPrecard1", true, ADOPrecardGroup1.ID, true, false, true, "99999999", false); precardTA.Insert("TestPrecard4", true, ADOPrecardGroup1.ID, false, true, true, "99999999", false); precardTA.Insert("TestPrecard6", true, ADOPrecardGroup1.ID, false, true, true, "99999999", false); precardTA.Insert("TestPrecard7", true, ADOPrecardGroup2.ID, false, true, true, "99999999", false); precardTA.Insert("TestPrecard2", true, ADOPrecardGroup2.ID, true, false, true, "99999999", false); precardTA.Insert("TestPrecard3", true, ADOPrecardGroup3.ID, true, false, true, "99999999", false); precardTA.Insert("TestPrecard5", true, ADOPrecardGroup4.ID, true, false, true, "99999999", false); precardTA.Insert("TestPrecard8", true, ADOPrecardGroup5.ID, true, false, true, "99999999", false); DatasetGatewayWorkFlow.TA_PrecardDataTable pTable = new DatasetGatewayWorkFlow.TA_PrecardDataTable(); pTable = precardTA.GetDataByName("TestPrecard1"); ADOPrecardHourlyLeave1.ID = Convert.ToInt32(pTable.Rows[0][0]); ADOPrecardHourlyLeave1.Name = "TestPrecard1"; pTable = precardTA.GetDataByName("TestPrecard2"); ADOPrecardHourlyDuty1.ID = Convert.ToInt32(pTable.Rows[0][0]); ADOPrecardHourlyDuty1.Name = "TestPrecard2"; pTable = precardTA.GetDataByName("TestPrecard3"); ADOPrecardHourlyEstelji1.ID = Convert.ToInt32(pTable.Rows[0][0]); ADOPrecardHourlyEstelji1.Name = "TestPrecard3"; pTable = precardTA.GetDataByName("TestPrecard4"); ADOPrecardHourlyLeave2.ID = Convert.ToInt32(pTable.Rows[0][0]); ADOPrecardHourlyLeave2.Name = "TestPrecard4"; pTable = precardTA.GetDataByName("TestPrecard5"); ADOPrecardTraffic1.ID = Convert.ToInt32(pTable.Rows[0][0]); ADOPrecardTraffic1.Name = "TestPrecard6"; pTable = precardTA.GetDataByName("TestPrecard6"); ADOPrecardDailyLeave1.ID = Convert.ToInt32(pTable.Rows[0][0]); ADOPrecardDailyLeave1.Name = "TestPrecard7"; pTable = precardTA.GetDataByName("TestPrecard7"); ADOPrecardDailyDuty1.ID = Convert.ToInt32(pTable.Rows[0][0]); ADOPrecardDailyDuty1.Name = "TestPrecard7"; pTable = precardTA.GetDataByName("TestPrecard8"); ADOPrecardOverTime1.ID = Convert.ToInt32(pTable.Rows[0][0]); ADOPrecardOverTime1.Name = "TestPrecard8"; #endregion 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"; accessGroupDtlTA.Insert(ADOAccessGroup1.ID, ADOPrecardHourlyDuty1.ID); accessGroupDtlTA.Insert(ADOAccessGroup1.ID, ADOPrecardHourlyLeave1.ID); accessGroupDtlTA.Insert(ADOAccessGroup1.ID, ADOPrecardHourlyLeave2.ID); accessGroupDtlTA.Insert(ADOAccessGroup2.ID, ADOPrecardDailyLeave1.ID); accessGroupDtlTA.Insert(ADOAccessGroup2.ID, ADOPrecardDailyDuty1.ID); flowTA.Insert(ADOAccessGroup1.ID, false, false, "FlowTest1"); flowTA.Insert(ADOAccessGroup2.ID, false, false, "FlowTest2"); DatasetGatewayWorkFlow.TA_FlowDataTable mangTAble = flowTA.GetDataByName("FlowTest1"); ADOFlow1.ID = Convert.ToInt32(mangTAble.Rows[0][0]); ADOFlow1.FlowName = "FlowTest1"; ADOFlow1.ActiveFlow = false; ADOFlow1.WorkFlow = false; mangTAble = flowTA.GetDataByName("FlowTest2"); ADOFlow2.ID = Convert.ToInt32(mangTAble.Rows[0][0]); ADOFlow2.FlowName = "FlowTest2"; ADOFlow2.ActiveFlow = false; ADOFlow2.WorkFlow = false; mangFlowTA.Insert(ADOManager1.ID, 1, ADOFlow1.ID, true); //مدیر اولیه mangFlowTA.Insert(ADOManager2.ID, 2, ADOFlow1.ID, true); //مدیر ثانویه mangFlowTA.Insert(ADOManager2.ID, 1, ADOFlow2.ID, true); //مدیر اولیه #endregion }
public void TestSetup() { #region precards DatasetGatewayWorkFlow.TA_PrecardGroupsDataTable precardTable = new DatasetGatewayWorkFlow.TA_PrecardGroupsDataTable(); precardGroupTA.FillByName(precardTable, PrecardGroupsName.overwork.ToString()); ADOPrecardGroup1.ID = Convert.ToInt32(precardTable.Rows[0][0]); ADOPrecardGroup1.Name = "OwerWork"; precardTA.Insert("TestPrecard1", true, ADOPrecardGroup1.ID, true, false, true, "99999999", false); DatasetGatewayWorkFlow.TA_PrecardDataTable pTable = new DatasetGatewayWorkFlow.TA_PrecardDataTable(); pTable = precardTA.GetDataByName("TestPrecard1"); ADOPrecardOverTime1.ID = Convert.ToInt32(pTable.Rows[0][0]); ADOPrecardOverTime1.Name = "TestPrecard1"; pTable = precardTA.GetDataByCode(126.ToString()); ADOPrecardDasturyOverTime.ID = Convert.ToInt32(pTable.Rows[0][0]); #endregion requestTA.Insert(ADOPrecardOverTime1.ID, ADOPerson1.ID, new DateTime(2010, 5, 1), new DateTime(2010, 5, 1), 420, 600, "", DateTime.Now, ADOUser1.ID); DatasetGatewayWorkFlow.TA_RequestDataTable requestTable = new DatasetGatewayWorkFlow.TA_RequestDataTable(); requestTable = requestTA.GetDataByPersonId(ADOPerson1.ID); ADORequestOvertime1.ID = Convert.ToInt32(requestTable.Rows[0][0]); #region Manager Flow managerTA.Insert(ADOPerson1.ID, null); 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; accessGroupTA.Insert("AccessGroup1_2"); DatasetGatewayWorkFlow.TA_PrecardAccessGroupDataTable accessTable = accessGroupTA.GetDataBy1("AccessGroup1_2"); ADOAccessGroup1.ID = Convert.ToInt32(accessTable.Rows[0][0]); ADOAccessGroup1.Name = "AccessGroup1_2"; 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(ADOManager1.ID, 1, ADOFlow1.ID, true); DatasetGatewayWorkFlow.TA_ManagerFlowDataTable nbgFlowTable = mangFlowTA.GetDataByFlowID(ADOFlow1.ID); ADOManagerFlow1.ID = Convert.ToInt32(nbgFlowTable.Rows[0]["mngrFlow_ID"]); ADOManagerFlow1.Level = Convert.ToInt32(nbgFlowTable.Rows[0]["mngrFlow_LEVEL"]); #endregion requestStatusTA.Insert(ADOManagerFlow1.ID, ADORequestOvertime1.ID, true, false, "", DateTime.Now, false); request_testObject = new Request(); busOverTime = new BRequest(ADOPerson1.ID); #region insert workgroup,shift BWorkgroup bworkGroup = new BWorkgroup(); ADOWorkGroup.CustomCode = "55-55"; ADOWorkGroup.Name = "ClanderWorkGroupTest"; bworkGroup.SaveChanges(ADOWorkGroup, UIActionType.ADD); assingWorkGrouTA.Insert(ADOWorkGroup.ID, ADOPerson1.ID, new DateTime(2000, 1, 1)); BShift bshift = new BShift(); ADOShift1.Name = "ClanderShiftTest1"; ADOShift1.Person = ADOPerson1; ADOShift1.Color = "0xff6512"; ADOShift1.ShiftType = ShiftTypesEnum.WORK; ADOShift1.CustomCode = "55-54"; bshift.SaveChanges(ADOShift1, UIActionType.ADD); ShiftPair pair1 = new ShiftPair(100, 200) { ShiftId = ADOShift1.ID }; ShiftPair pair2 = new ShiftPair(200, 400) { ShiftId = ADOShift1.ID }; bshift.SaveChangesShiftPair(pair1, UIActionType.ADD); bshift.SaveChangesShiftPair(pair2, UIActionType.ADD); ADOShift2.Name = "ClanderShiftTest2"; ADOShift2.Color = "0xbbccaa"; ADOShift2.Person = ADOPerson1; ADOShift2.ShiftType = ShiftTypesEnum.WORK; ADOShift2.CustomCode = "55-55"; bshift.SaveChanges(ADOShift2, UIActionType.ADD); #endregion #region date inti date1 = Utility.ToMildiDate("1390/5/1"); date2 = Utility.ToMildiDate("1390/5/2"); date3 = Utility.ToMildiDate("1390/5/3"); date4 = Utility.ToMildiDate("1390/5/5"); date5 = Utility.ToMildiDate("1390/5/6"); date6 = Utility.ToMildiDate("1390/5/7"); date7 = Utility.ToMildiDate("1390/5/9"); #endregion #region WorkGroup Detail wgdTA.Insert(ADOWorkGroup.ID, ADOShift1.ID, date1); wgdTA.Insert(ADOWorkGroup.ID, ADOShift1.ID, date2); wgdTA.Insert(ADOWorkGroup.ID, ADOShift1.ID, date3); wgdTA.Insert(ADOWorkGroup.ID, ADOShift1.ID, date4); wgdTA.Insert(ADOWorkGroup.ID, ADOShift1.ID, date5); wgdTA.Insert(ADOWorkGroup.ID, ADOShift2.ID, date6); wgdTA.Insert(ADOWorkGroup.ID, ADOShift2.ID, date7); #endregion ClearSession(); }
public void TestSetup() { base.UpdateCurrentUserPersonId(ADOPerson1.ID); busSentry = new BSentryPermits(); #region precards DatasetGatewayWorkFlow.TA_PrecardGroupsDataTable precardTable = new DatasetGatewayWorkFlow.TA_PrecardGroupsDataTable(); precardGroupTA.FillByName(precardTable, PrecardGroupsName.leave.ToString()); ADOPrecardGroup1.ID = Convert.ToInt32(precardTable.Rows[0][0]); ADOPrecardGroup1.Name = "HourlyLeave"; precardGroupTA.FillByName(precardTable, PrecardGroupsName.duty.ToString()); ADOPrecardGroup2.ID = Convert.ToInt32(precardTable.Rows[0][0]); ADOPrecardGroup2.Name = "HourlyDuty"; precardGroupTA.FillByName(precardTable, PrecardGroupsName.leaveestelajy.ToString()); ADOPrecardGroup3.ID = Convert.ToInt32(precardTable.Rows[0][0]); ADOPrecardGroup3.Name = "Estelaji"; precardGroupTA.FillByName(precardTable, PrecardGroupsName.traffic.ToString()); ADOPrecardGroup4.ID = Convert.ToInt32(precardTable.Rows[0][0]); ADOPrecardGroup4.Name = "Traffic"; precardGroupTA.FillByName(precardTable, PrecardGroupsName.overwork.ToString()); ADOPrecardGroup5.ID = Convert.ToInt32(precardTable.Rows[0][0]); ADOPrecardGroup5.Name = "OwerWork"; precardTA.Insert("TestPrecard1", true, ADOPrecardGroup1.ID, true, false, true, "99999999", false); precardTA.Insert("TestPrecard4", true, ADOPrecardGroup1.ID, true, false, true, "99999999", false); precardTA.Insert("TestPrecard6", true, ADOPrecardGroup1.ID, false, true, true, "99999999", false); precardTA.Insert("TestPrecard7", true, ADOPrecardGroup2.ID, false, true, true, "99999999", false); precardTA.Insert("TestPrecard2", true, ADOPrecardGroup2.ID, true, false, true, "99999999", false); precardTA.Insert("TestPrecard3", true, ADOPrecardGroup3.ID, true, false, true, "99999999", false); precardTA.Insert("TestPrecard5", true, ADOPrecardGroup4.ID, true, false, true, "99999999", false); precardTA.Insert("TestPrecard8", true, ADOPrecardGroup5.ID, true, false, true, "99999999", false); DatasetGatewayWorkFlow.TA_PrecardDataTable pTable = new DatasetGatewayWorkFlow.TA_PrecardDataTable(); pTable = precardTA.GetDataByName("TestPrecard1"); ADOPrecardHourlyLeave1.ID = Convert.ToInt32(pTable.Rows[0][0]); ADOPrecardHourlyLeave1.Name = "TestPrecard1"; pTable = precardTA.GetDataByName("TestPrecard2"); ADOPrecardHourlyDuty1.ID = Convert.ToInt32(pTable.Rows[0][0]); ADOPrecardHourlyDuty1.Name = "TestPrecard2"; pTable = precardTA.GetDataByName("TestPrecard3"); ADOPrecardHourlyEstelji1.ID = Convert.ToInt32(pTable.Rows[0][0]); ADOPrecardHourlyEstelji1.Name = "TestPrecard3"; pTable = precardTA.GetDataByName("TestPrecard4"); ADOPrecardHourlyLeave2.ID = Convert.ToInt32(pTable.Rows[0][0]); ADOPrecardHourlyLeave2.Name = "TestPrecard4"; pTable = precardTA.GetDataByName("TestPrecard5"); ADOPrecardTraffic1.ID = Convert.ToInt32(pTable.Rows[0][0]); ADOPrecardTraffic1.Name = "TestPrecard6"; pTable = precardTA.GetDataByName("TestPrecard6"); ADOPrecardDailyLeave1.ID = Convert.ToInt32(pTable.Rows[0][0]); ADOPrecardDailyLeave1.Name = "TestPrecard7"; pTable = precardTA.GetDataByName("TestPrecard7"); ADOPrecardDailyDuty1.ID = Convert.ToInt32(pTable.Rows[0][0]); ADOPrecardDailyDuty1.Name = "TestPrecard7"; pTable = precardTA.GetDataByName("TestPrecard8"); ADOPrecardOverTime1.ID = Convert.ToInt32(pTable.Rows[0][0]); ADOPrecardOverTime1.Name = "TestPrecard8"; #endregion #region Data Access personTA.UpdateDepartmentId(ADODepartment2.ID, ADOPerson1.ID); personTA.UpdateDepartmentId(ADODepartment2.ID, ADOPerson2.ID); personTA.UpdateDepartmentId(ADODepartment1.ID, ADOPerson3.ID); personTA.UpdateDepartmentId(ADODepartment1.ID, ADOPerson4.ID); personTA.UpdateDepartmentId(ADODepartment2.ID, ADOPerson5.ID); personTA.UpdateDepartmentId(ADODepartment2.ID, ADOPerson6.ID); personTA.UpdateControlStation(ADOStaion1.ID, ADOPerson2.ID); accessDepTA.DeleteByUSerId(BUser.CurrentUser.ID); accessDepTA.Insert(BUser.CurrentUser.ID, ADODepartment1.ID, false); //ADOPerson3,4 accessCtrlStationTA.Insert(BUser.CurrentUser.ID, ADOStaion1.ID, false); //ADOPerson2 accessPrecardTA.Insert(BUser.CurrentUser.ID, ADOPrecardTraffic1.ID, false); accessPrecardTA.Insert(BUser.CurrentUser.ID, ADOPrecardDailyLeave1.ID, false); accessPrecardTA.Insert(BUser.CurrentUser.ID, ADOPrecardHourlyLeave2.ID, false); #endregion permitTA.Insert(ADOPerson2.ID, new DateTime(2012, 5, 1), new DateTime(2012, 5, 1), true); permitTA.Insert(ADOPerson2.ID, new DateTime(2012, 5, 2), new DateTime(2012, 5, 1), true); DatabaseGateway2.TA_PermitDataTable permitTable = permitTA.GetDataByPersonId(ADOPerson2.ID); ADOPermit1.ID = (permitTable.Rows[0] as DatabaseGateway2.TA_PermitRow).Permit_ID; ADOPermit2.ID = (permitTable.Rows[1] as DatabaseGateway2.TA_PermitRow).Permit_ID; /*ADOPrecardHourlyLeave1 -->*/ permitPairTA.Insert(ADOPermit1.ID, null, ADOPrecardHourlyLeave1.ID, 100, 200, true, null, 0, false); /*ADOPrecardHourlyLeave2 -->*/ permitPairTA.Insert(ADOPermit1.ID, null, ADOPrecardHourlyLeave2.ID, 10, 20, true, null, 0, false); /*ADOPrecardTraffic1 -->*/ permitPairTA.Insert(ADOPermit1.ID, null, ADOPrecardTraffic1.ID, 500, 550, true, null, 0, false); /*ADOPrecardTraffic1 -->*/ permitPairTA.Insert(ADOPermit2.ID, null, ADOPrecardTraffic1.ID, 500, 550, true, null, 0, false); DatabaseGateway2.TA_PermitPairDataTable permitPairTable = permitPairTA.GetDataByPermitId(ADOPermit1.ID); ADOPermitPair1.ID = (permitPairTable.Rows[0] as DatabaseGateway2.TA_PermitPairRow).PermitPair_ID; ADOPermitPair1.Permit = ADOPermit1; ADOPermitPair2.ID = (permitPairTable.Rows[1] as DatabaseGateway2.TA_PermitPairRow).PermitPair_ID; ADOPermitPair2.Permit = ADOPermit1; ADOPermitPair3.ID = (permitPairTable.Rows[2] as DatabaseGateway2.TA_PermitPairRow).PermitPair_ID; ADOPermitPair3.Permit = ADOPermit1; permitPairTable = permitPairTA.GetDataByPermitId(ADOPermit2.ID); ADOPermitPair4.ID = (permitPairTable.Rows[0] as DatabaseGateway2.TA_PermitPairRow).PermitPair_ID; ADOPermitPair4.Permit = ADOPermit2; permitTA.Insert(ADOPerson3.ID, new DateTime(2012, 5, 1), new DateTime(2012, 5, 1), true); permitTable = permitTA.GetDataByPersonId(ADOPerson3.ID); ADOPermit3.ID = (permitTable.Rows[0] as DatabaseGateway2.TA_PermitRow).Permit_ID; /*ADOPrecardDailyLeave1 -->*/ permitPairTA.Insert(ADOPermit3.ID, null, ADOPrecardDailyLeave1.ID, null, null, true, null, 1, false); permitPairTable = permitPairTA.GetDataByPermitId(ADOPermit3.ID); ADOPermitPair5.ID = (permitPairTable.Rows[0] as DatabaseGateway2.TA_PermitPairRow).PermitPair_ID; ADOPermitPair5.Permit = ADOPermit3; }