public void Copy_DependencyTest()
{
try
{
int count = groupTA.GetData().Rows.Count;
businessDateRange.CopyDateRangeGroup(ADOGroup.ID);
ClearSession();
DatabaseGateway.TA_CalculationRangeGroupDataTable groupTable = new DatabaseGateway.TA_CalculationRangeGroupDataTable();
groupTA.FillByGroupName(groupTable, " Copy Of " + ADOGroup.Name);
if (groupTable.Rows.Count == 1)
{
group_testObject.ID = Convert.ToDecimal(groupTable.Rows[0][0]);
group_testObject = businessDateRange.GetByID(group_testObject.ID);
Assert.AreEqual(group_testObject.DateRangeList.Count, 10);
ClearSession();
businessDateRange.SaveChanges(group_testObject, UIActionType.DELETE);
}
else
{
Assert.Fail("کپی پیدا نشد");
}
}
finally
{
groupTA.DeleteByName(" Copy Of " + ADOGroup.Name);
}
}
public void TestSetup()
{
assign_testObject = new PersonRangeAssignment();
bussAssign = new BAssignDateRange(SysLanguageResource.Parsi);
groupTA.Insert("RangeGroup1", "", 1);
DatabaseGateway.TA_CalculationRangeGroupDataTable groupTable = new DatabaseGateway.TA_CalculationRangeGroupDataTable();
groupTA.FillByGroupName(groupTable, "RangeGroup1");
ADOGroup1.ID = Convert.ToDecimal(groupTable.Rows[0]["CalcRangeGroup_ID"]);
ADOGroup1.Name = Convert.ToString(groupTable.Rows[0]["CalcRangeGroup_Name"]);
ADOGroup1.Description = Convert.ToString(groupTable.Rows[0]["CalcRangeGroup_Des"]);
assingTA.Insert(ADOPerson1.ID, ADOGroup1.ID, new DateTime(2010, 2, 14));
assingTA.Insert(ADOPerson1.ID, ADOGroup1.ID, new DateTime(2005, 5, 14));
assingTA.Insert(ADOPerson1.ID, ADOGroup1.ID, new DateTime(2007, 11, 5));
assingTA.Insert(ADOPerson1.ID, ADOGroup1.ID, new DateTime(2010, 9, 14));
assingTA.Insert(ADOPerson1.ID, ADOGroup1.ID, new DateTime(2012, 9, 14));
assingTA.Insert(ADOPerson1.ID, ADOGroup1.ID, new DateTime(2008, 3, 1));
DatabaseGateway.TA_PersonRangeAssignmentDataTable table = new DatabaseGateway.TA_PersonRangeAssignmentDataTable();
assingTA.FillByFilter(table, ADOPerson1.ID, ADOGroup1.ID);
ADOAssign.ID = (decimal)table.Rows[0]["PrsRangeAsg_ID"];
ADOAssign.FromDate = (DateTime)table.Rows[0]["PrsRangeAsg_FromDate"];
}
public void TestSetup()
{
busChnageInfo = new BChangeOrganicInfo();
person_testObject = new Person();
infoProxy = new OrganicInfoProxy();
errorList = new List <ChangeInfoErrorProxy>();
workgrpTA.Insert("WorkGroupTest1", "0-0", 0);
workgrpTA.Insert("WorkGroupTest2", "0-1", 0);
DatabaseGateway.TA_WorkGroupDataTable table = new DatabaseGateway.TA_WorkGroupDataTable();
DatabaseGateway.TA_CalculationRangeGroupDataTable dateRangeGroupTable = new DatabaseGateway.TA_CalculationRangeGroupDataTable();
DatabaseGateway.TA_RuleCategoryDataTable ruleTable = new DatabaseGateway.TA_RuleCategoryDataTable();
workgrpTA.FillByName(table, "WorkGroupTest1");
ADOWorkGroup1.ID = Convert.ToInt32(table.Rows[0]["workgroup_ID"]);
ADOWorkGroup1.Name = Convert.ToString(table.Rows[0]["workgroup_Name"]);
ADOWorkGroup1.CustomCode = Convert.ToString(table.Rows[0]["workgroup_CustomCode"]);
workgrpTA.FillByName(table, "WorkGroupTest2");
ADOWorkGroup2.ID = Convert.ToInt32(table.Rows[0]["workgroup_ID"]);
ADOWorkGroup2.Name = Convert.ToString(table.Rows[0]["workgroup_Name"]);
ADOWorkGroup2.CustomCode = Convert.ToString(table.Rows[0]["workgroup_CustomCode"]);
assignWorkGroupTA.Insert(ADOWorkGroup1.ID, ADOPerson1.ID, new DateTime(2011, 01, 01));
dateRangeGroupTA.Insert("RangeGroup1", "", 1);
dateRangeGroupTA.Insert("RangeGroup2", "", 1);
dateRangeGroupTA.FillByGroupName(dateRangeGroupTable, "RangeGroup1");
ADOGroup1.ID = Convert.ToDecimal(dateRangeGroupTable.Rows[0]["CalcRangeGroup_ID"]);
ADOGroup1.Name = Convert.ToString(dateRangeGroupTable.Rows[0]["CalcRangeGroup_Name"]);
ADOGroup1.Description = Convert.ToString(dateRangeGroupTable.Rows[0]["CalcRangeGroup_Des"]);
dateRangeGroupTA.FillByGroupName(dateRangeGroupTable, "RangeGroup2");
ADOGroup2.ID = Convert.ToDecimal(dateRangeGroupTable.Rows[0]["CalcRangeGroup_ID"]);
ADOGroup2.Name = Convert.ToString(dateRangeGroupTable.Rows[0]["CalcRangeGroup_Name"]);
ADOGroup2.Description = Convert.ToString(dateRangeGroupTable.Rows[0]["CalcRangeGroup_Des"]);
assinTA.Insert(ADOPerson1.ID, ADOGroup1.ID, new DateTime(2011, 01, 01));
ruleCatTA.Insert("RuleGroupTest1", "0000", false, "00-00test1");
ruleCatTA.Insert("RuleGroupTest2", "0000", false, "00-00test1");
ruleTable = ruleCatTA.GetDataByName("RuleGroupTest1");
ADORuleCat1.ID = (Decimal)ruleTable[0]["RuleCat_ID"];
ADORuleCat1.Name = (String)ruleTable[0]["RuleCat_Name"];
ruleTable = ruleCatTA.GetDataByName("RuleGroupTest2");
ADORuleCat2.ID = (Decimal)ruleTable[0]["RuleCat_ID"];
ADORuleCat2.Name = (String)ruleTable[0]["RuleCat_Name"];
ruleTA.Insert(0001, "", "", "", null, false, ADORuleCat1.ID, Utility.ToInteger(ruleTypeTA.GetData().Rows[0][0]), 0);
ruleTA.Insert(0001, "", "", "", null, false, ADORuleCat2.ID, Utility.ToInteger(ruleTypeTA.GetData().Rows[0][0]), 0);
prsRleCatAsgTA.Insert(ADOPerson1.ID, ADORuleCat2.ID, "2011/01/01", "2011/06/01", null);
}
public void TestSetup()
{
businessDateRange = new BDateRange();
dateRange_testObject = new CalculationDateRange();
group_testObject = new CalculationRangeGroup();
dateRangList_testObject = new List <CalculationDateRange>();
personTA.InsertQuery("0000", "ali", true, null);
int personId = Convert.ToInt32(personTA.GetDataByBarcode("0000")[0][0]);
groupTA.Insert("RangeGroup", "", 1);
DatabaseGateway.TA_CalculationRangeGroupDataTable groupTable = new DatabaseGateway.TA_CalculationRangeGroupDataTable();
groupTA.FillByGroupName(groupTable, "RangeGroup");
ADOGroup.ID = Convert.ToDecimal(groupTable.Rows[0]["CalcRangeGroup_ID"]);
ADOGroup.Name = Convert.ToString(groupTable.Rows[0]["CalcRangeGroup_Name"]);
ADOGroup.Description = Convert.ToString(groupTable.Rows[0]["CalcRangeGroup_Des"]);
assinTA.Insert(personId, ADOGroup.ID, DateTime.Now);
DatabaseGateway.TA_ConceptTemplateDataTable concepts = new DatabaseGateway.TA_ConceptTemplateDataTable();
concepts = conceptTA.GetDataRangly();
ADOConcept1.ID = Convert.ToDecimal(concepts.Rows[0]["concepttmp_ID"]);
ADOConcept2.ID = Convert.ToDecimal(concepts.Rows[1]["concepttmp_ID"]);
ADOConcept3.ID = Convert.ToDecimal(concepts.Rows[2]["concepttmp_ID"]);
dateRangeTA.Insert(ADOConcept1.ID, ADOGroup.ID, 15, 1, 14, 2, 1);
dateRangeTA.Insert(ADOConcept1.ID, ADOGroup.ID, 15, 2, 14, 3, 2);
dateRangeTA.Insert(ADOConcept1.ID, ADOGroup.ID, 15, 3, 14, 4, 3);
dateRangeTA.Insert(ADOConcept1.ID, ADOGroup.ID, 15, 4, 14, 5, 4);
dateRangeTA.Insert(ADOConcept1.ID, ADOGroup.ID, 15, 5, 14, 6, 5);
dateRangeTA.Insert(ADOConcept2.ID, ADOGroup.ID, 15, 1, 14, 2, 1);
dateRangeTA.Insert(ADOConcept2.ID, ADOGroup.ID, 15, 2, 14, 3, 2);
dateRangeTA.Insert(ADOConcept2.ID, ADOGroup.ID, 15, 3, 14, 4, 3);
dateRangeTA.Insert(ADOConcept2.ID, ADOGroup.ID, 15, 4, 14, 5, 4);
dateRangeTA.Insert(ADOConcept2.ID, ADOGroup.ID, 15, 5, 14, 6, 5);
DatabaseGateway.TA_CalculationDateRangeDataTable rangeTable = new DatabaseGateway.TA_CalculationDateRangeDataTable();
dateRangeTA.FillByGroup(rangeTable, ADOGroup.ID);
ADODateRange1.ID = Convert.ToDecimal(rangeTable.Rows[0]["CalcDateRange_ID"]);
ADODateRange2.ID = Convert.ToDecimal(rangeTable.Rows[1]["CalcDateRange_ID"]);
ADODateRange3.ID = Convert.ToDecimal(rangeTable.Rows[2]["CalcDateRange_ID"]);
ADODateRange4.ID = Convert.ToDecimal(rangeTable.Rows[3]["CalcDateRange_ID"]);
ADODateRange5.ID = Convert.ToDecimal(rangeTable.Rows[4]["CalcDateRange_ID"]);
dateRangList_testObject.Add(new CalculationDateRange()
{
FromDay = 1, FromMonth = 1, ToDay = 31, ToMonth = 1, Order = CalculationDateRangeOrder.Month1
});
dateRangList_testObject.Add(new CalculationDateRange()
{
FromDay = 1, FromMonth = 2, ToDay = 31, ToMonth = 2, Order = CalculationDateRangeOrder.Month2
});
dateRangList_testObject.Add(new CalculationDateRange()
{
FromDay = 1, FromMonth = 3, ToDay = 31, ToMonth = 3, Order = CalculationDateRangeOrder.Month3
});
dateRangList_testObject.Add(new CalculationDateRange()
{
FromDay = 1, FromMonth = 4, ToDay = 31, ToMonth = 4, Order = CalculationDateRangeOrder.Month4
});
dateRangList_testObject.Add(new CalculationDateRange()
{
FromDay = 1, FromMonth = 5, ToDay = 31, ToMonth = 5, Order = CalculationDateRangeOrder.Month5
});
dateRangList_testObject.Add(new CalculationDateRange()
{
FromDay = 1, FromMonth = 6, ToDay = 31, ToMonth = 6, Order = CalculationDateRangeOrder.Month6
});
dateRangList_testObject.Add(new CalculationDateRange()
{
FromDay = 1, FromMonth = 7, ToDay = 31, ToMonth = 7, Order = CalculationDateRangeOrder.Month7
});
dateRangList_testObject.Add(new CalculationDateRange()
{
FromDay = 1, FromMonth = 8, ToDay = 31, ToMonth = 8, Order = CalculationDateRangeOrder.Month8
});
dateRangList_testObject.Add(new CalculationDateRange()
{
FromDay = 1, FromMonth = 9, ToDay = 31, ToMonth = 9, Order = CalculationDateRangeOrder.Month9
});
dateRangList_testObject.Add(new CalculationDateRange()
{
FromDay = 1, FromMonth = 10, ToDay = 31, ToMonth = 10, Order = CalculationDateRangeOrder.Month10
});
dateRangList_testObject.Add(new CalculationDateRange()
{
FromDay = 1, FromMonth = 11, ToDay = 31, ToMonth = 11, Order = CalculationDateRangeOrder.Month11
});
dateRangList_testObject.Add(new CalculationDateRange()
{
FromDay = 1, FromMonth = 12, ToDay = 29, ToMonth = 12, Order = CalculationDateRangeOrder.Month12
});
}
public void TestSetup()
{
#region organization unit
DatabaseGateway.TA_OrganizationUnitDataTable organTable = new DatabaseGateway.TA_OrganizationUnitDataTable();
organTable = organTA.GetDataByParent();
ADOOrganRoot.ID = Convert.ToInt32(organTable.Rows[0]["organ_ID"]);
ADOOrganRoot.Name = Convert.ToString(organTable.Rows[0]["organ_Name"]);
ADOOrganRoot.CustomCode = Convert.ToString(organTable.Rows[0]["organ_CustomCode"]);
organTA.Insert("Level2_1", "2020_11", ADOPerson2.ID, ADOOrganRoot.ID, String.Format(",{0},", ADOOrganRoot.ID));
organTable = organTA.GetDataByCustomCode("2020_11");
ADOOrgan.ID = Convert.ToInt32(organTable.Rows[0]["organ_ID"]);
ADOOrgan.Name = Convert.ToString(organTable.Rows[0]["organ_Name"]);
ADOOrgan.CustomCode = Convert.ToString(organTable.Rows[0]["organ_CustomCode"]);
#endregion
#region managers
managerTA.Insert(ADOPerson1.ID, null);
DatasetGatewayWorkFlow.TA_ManagerDataTable masterTable = managerTA.GetDataByPersonID(ADOPerson1.ID);
ADOManager1.ID = Convert.ToInt32(masterTable.Rows[0]["MasterMng_ID"]);
ADOManager1.Person = ADOPerson1;
ADOManager1.OrganizationUnit = null;
managerTA.Insert(null, ADOOrgan.ID);
masterTable = managerTA.GetDataByOrganID(ADOOrgan.ID);
ADOManager2.ID = Convert.ToInt32(masterTable.Rows[0]["MasterMng_ID"]);
ADOManager2.Person = null;
ADOManager2.OrganizationUnit = ADOOrgan;
managerTA.Insert(ADOPerson3.ID, null);
masterTable = managerTA.GetDataByPersonID(ADOPerson3.ID);
ADOManager3.ID = Convert.ToInt32(masterTable.Rows[0]["MasterMng_ID"]);
ADOManager3.Person = ADOPerson3;
ADOManager3.OrganizationUnit = null;
#endregion
#region pishcart access group
precardAccessGroupTA.Insert("PrecardAccessGroupTest");
DatasetGatewayWorkFlow.TA_PrecardAccessGroupDataTable accessTable = precardAccessGroupTA.GetDataBy1("PrecardAccessGroupTest");
ADOaccessGroup.ID = Convert.ToInt32(accessTable.Rows[0]["accessGrp_ID"]);
ADOaccessGroup.Name = Convert.ToString(accessTable.Rows[0]["accessGrp_Name"]);
#endregion
#region Flow
flowTA.Insert(ADOaccessGroup.ID, false, false, "FlowTest1");
DatasetGatewayWorkFlow.TA_FlowDataTable flowTable = flowTA.GetDataByName("FlowTest1");
ADOFlow1.ID = Convert.ToInt32(flowTable.Rows[0]["flow_ID"]);
ADOFlow1.AccessGroup = ADOaccessGroup;
ADOFlow1.ActiveFlow = false;
ADOFlow1.WorkFlow = false;
ADOFlow1.FlowName = "FlowTest1";
flowTA.Insert(ADOaccessGroup.ID, false, false, "FlowTest2");
flowTable = flowTA.GetDataByName("FlowTest2");
ADOFlow2.ID = Convert.ToInt32(flowTable.Rows[0]["flow_ID"]);
ADOFlow2.AccessGroup = ADOaccessGroup;
ADOFlow2.ActiveFlow = false;
ADOFlow2.WorkFlow = false;
ADOFlow2.FlowName = "FlowTest2";
flowTA.Insert(ADOaccessGroup.ID, false, false, "FlowTest3");
flowTable = flowTA.GetDataByName("FlowTest3");
ADOFlow3.ID = Convert.ToInt32(flowTable.Rows[0]["flow_ID"]);
ADOFlow3.AccessGroup = ADOaccessGroup;
ADOFlow3.ActiveFlow = false;
ADOFlow3.WorkFlow = false;
ADOFlow3.FlowName = "FlowTest3";
#endregion
#region manager Flow
managerFlowTA.Insert(ADOManager1.ID, 1, ADOFlow1.ID, true);
managerFlowTA.Insert(ADOManager1.ID, 2, ADOFlow2.ID, true);
managerFlowTA.Insert(ADOManager3.ID, 2, ADOFlow3.ID, true);
#endregion
#region under managment
undermanagmentTA.Insert(ADOFlow1.ID, ADOPerson2.ID, ADODepartment1.ID, false, true);
undermanagmentTA.Insert(ADOFlow1.ID, ADOPerson5.ID, ADODepartment1.ID, false, true);
DatasetGatewayWorkFlow.TA_UnderManagmentDataTable underManagmentTable = new DatasetGatewayWorkFlow.TA_UnderManagmentDataTable();
underManagmentTable = undermanagmentTA.GetDataByManagmentID(ADOFlow1.ID);
ADOUnderManagment.ID = Convert.ToInt32(underManagmentTable.Rows[0]["underMng_ID"]);
ADOUnderManagment.Contains = true;
ADOUnderManagment.ContainInnerChilds = false;
ADOUnderManagment.Person = ADOPerson2;
ADOUnderManagment.Flow = ADOFlow1;
undermanagmentTA.Insert(ADOFlow2.ID, ADOPerson4.ID, ADODepartment1.ID, false, true);
undermanagmentTA.Insert(ADOFlow3.ID, ADOPerson5.ID, null, false, true);
#endregion
bussWorkTime = new BWorkedTime(ADOUser1.UserName);
#region date range init
businessDateRange = new BDateRange();
dateRange_testObject = new CalculationDateRange();
group_testObject = new CalculationRangeGroup();
dateRangList_testObject = new List <CalculationDateRange>();
groupTA.Insert("TestRangeGroup", "", 1);
DatabaseGateway.TA_CalculationRangeGroupDataTable groupTable = new DatabaseGateway.TA_CalculationRangeGroupDataTable();
groupTA.FillByGroupName(groupTable, "TestRangeGroup");
ADOGroup.ID = Convert.ToDecimal(groupTable.Rows[0]["CalcRangeGroup_ID"]);
ADOGroup.Name = Convert.ToString(groupTable.Rows[0]["CalcRangeGroup_Name"]);
ADOGroup.Description = Convert.ToString(groupTable.Rows[0]["CalcRangeGroup_Des"]);
assinTA.Insert(ADOPerson3.ID, ADOGroup.ID, Utility.ToMildiDate("1390/05/01"));
assinTA.Insert(ADOPerson4.ID, ADOGroup.ID, Utility.ToMildiDate("1389/01/01"));
DatabaseGateway.TA_ConceptTemplateDataTable concepts = new DatabaseGateway.TA_ConceptTemplateDataTable();
concepts = conceptTA.GetDataByyRanglyConceptsNotNullKeys();
ADOConcept1.ID = Convert.ToDecimal(concepts.Rows[0]["concepttmp_ID"]);
ADOConcept2.ID = Convert.ToDecimal(concepts.Rows[1]["concepttmp_ID"]);
ADOConcept3.ID = Convert.ToDecimal(concepts.Rows[2]["concepttmp_ID"]);
dateRangeTA.Insert(ADOConcept1.ID, ADOGroup.ID, 15, 1, 14, 2, 1);
dateRangeTA.Insert(ADOConcept1.ID, ADOGroup.ID, 15, 2, 14, 3, 2);
dateRangeTA.Insert(ADOConcept1.ID, ADOGroup.ID, 15, 3, 14, 4, 3);
dateRangeTA.Insert(ADOConcept1.ID, ADOGroup.ID, 15, 4, 14, 5, 4);
dateRangeTA.Insert(ADOConcept1.ID, ADOGroup.ID, 15, 5, 14, 6, 5);
dateRangeTA.Insert(ADOConcept1.ID, ADOGroup.ID, 15, 6, 14, 7, 6);
dateRangeTA.Insert(ADOConcept1.ID, ADOGroup.ID, 15, 7, 14, 8, 7);
dateRangeTA.Insert(ADOConcept1.ID, ADOGroup.ID, 15, 8, 14, 9, 8);
dateRangeTA.Insert(ADOConcept1.ID, ADOGroup.ID, 15, 9, 14, 10, 9);
dateRangeTA.Insert(ADOConcept1.ID, ADOGroup.ID, 15, 10, 14, 11, 10);
dateRangeTA.Insert(ADOConcept1.ID, ADOGroup.ID, 15, 11, 14, 12, 11);
dateRangeTA.Insert(ADOConcept1.ID, ADOGroup.ID, 15, 12, 14, 1, 12);
DatabaseGateway.TA_CalculationDateRangeDataTable rangeTable = new DatabaseGateway.TA_CalculationDateRangeDataTable();
dateRangeTA.FillByGroup(rangeTable, ADOGroup.ID);
ADODateRange1.ID = Convert.ToDecimal(rangeTable.Rows[0]["CalcDateRange_ID"]);
ADODateRange2.ID = Convert.ToDecimal(rangeTable.Rows[1]["CalcDateRange_ID"]);
dateRangList_testObject.Add(new CalculationDateRange()
{
FromDay = 1, FromMonth = 1, ToDay = 31, ToMonth = 1, Order = CalculationDateRangeOrder.Month1
});
dateRangList_testObject.Add(new CalculationDateRange()
{
FromDay = 1, FromMonth = 2, ToDay = 31, ToMonth = 2, Order = CalculationDateRangeOrder.Month2
});
dateRangList_testObject.Add(new CalculationDateRange()
{
FromDay = 1, FromMonth = 3, ToDay = 31, ToMonth = 3, Order = CalculationDateRangeOrder.Month3
});
dateRangList_testObject.Add(new CalculationDateRange()
{
FromDay = 1, FromMonth = 4, ToDay = 31, ToMonth = 4, Order = CalculationDateRangeOrder.Month4
});
dateRangList_testObject.Add(new CalculationDateRange()
{
FromDay = 1, FromMonth = 5, ToDay = 31, ToMonth = 5, Order = CalculationDateRangeOrder.Month5
});
dateRangList_testObject.Add(new CalculationDateRange()
{
FromDay = 1, FromMonth = 6, ToDay = 31, ToMonth = 6, Order = CalculationDateRangeOrder.Month6
});
dateRangList_testObject.Add(new CalculationDateRange()
{
FromDay = 1, FromMonth = 7, ToDay = 31, ToMonth = 7, Order = CalculationDateRangeOrder.Month7
});
dateRangList_testObject.Add(new CalculationDateRange()
{
FromDay = 1, FromMonth = 8, ToDay = 31, ToMonth = 8, Order = CalculationDateRangeOrder.Month8
});
dateRangList_testObject.Add(new CalculationDateRange()
{
FromDay = 1, FromMonth = 9, ToDay = 31, ToMonth = 9, Order = CalculationDateRangeOrder.Month9
});
dateRangList_testObject.Add(new CalculationDateRange()
{
FromDay = 1, FromMonth = 10, ToDay = 31, ToMonth = 10, Order = CalculationDateRangeOrder.Month10
});
dateRangList_testObject.Add(new CalculationDateRange()
{
FromDay = 1, FromMonth = 11, ToDay = 31, ToMonth = 11, Order = CalculationDateRangeOrder.Month11
});
dateRangList_testObject.Add(new CalculationDateRange()
{
FromDay = 1, FromMonth = 12, ToDay = 29, ToMonth = 12, Order = CalculationDateRangeOrder.Month12
});
#endregion
}
public void TestSetup()
{
return;
busPerson = new BPerson(SysLanguageResource.English, LocalLanguageResource.English);
searchTool = new BPerson();
person_testObject = new Person();
workgrpTA.Insert("WorkGroupTest1", "0-0", 0);
workgrpTA.Insert("WorkGroupTest2", "0-1", 0);
DatabaseGateway.TA_WorkGroupDataTable table = new DatabaseGateway.TA_WorkGroupDataTable();
workgrpTA.FillByName(table, "WorkGroupTest1");
ADOWorkGroup1.ID = Convert.ToInt32(table.Rows[0]["workgroup_ID"]);
ADOWorkGroup1.Name = Convert.ToString(table.Rows[0]["workgroup_Name"]);
ADOWorkGroup1.CustomCode = Convert.ToString(table.Rows[0]["workgroup_CustomCode"]);
workgrpTA.FillByName(table, "WorkGroupTest2");
ADOWorkGroup2.ID = Convert.ToInt32(table.Rows[0]["workgroup_ID"]);
ADOWorkGroup2.Name = Convert.ToString(table.Rows[0]["workgroup_Name"]);
ADOWorkGroup2.CustomCode = Convert.ToString(table.Rows[0]["workgroup_CustomCode"]);
assignWorkGroupTA.Insert(ADOWorkGroup1.ID, ADOPerson2.ID, new DateTime(2007, 4, 5));
assignWorkGroupTA.Insert(ADOWorkGroup1.ID, ADOPerson2.ID, new DateTime(2012, 5, 5));
assignWorkGroupTA.Insert(ADOWorkGroup2.ID, ADOPerson2.ID, new DateTime(2010, 11, 6));
assignWorkGroupTA.Insert(ADOWorkGroup1.ID, ADOPerson2.ID, new DateTime(2009, 6, 15));
assignWorkGroupTA.Insert(ADOWorkGroup1.ID, ADOPerson2.ID, new DateTime(2010, 8, 5));
groupTA.Insert("RangeGroup1", "", 1);
groupTA.Insert("RangeGroup2", "", 1);
DatabaseGateway.TA_CalculationRangeGroupDataTable groupTable = new DatabaseGateway.TA_CalculationRangeGroupDataTable();
groupTA.FillByGroupName(groupTable, "RangeGroup1");
ADOGroup1.ID = Convert.ToDecimal(groupTable.Rows[0]["CalcRangeGroup_ID"]);
ADOGroup1.Name = Convert.ToString(groupTable.Rows[0]["CalcRangeGroup_Name"]);
ADOGroup1.Description = Convert.ToString(groupTable.Rows[0]["CalcRangeGroup_Des"]);
groupTA.FillByGroupName(groupTable, "RangeGroup2");
ADOGroup2.ID = Convert.ToDecimal(groupTable.Rows[0]["CalcRangeGroup_ID"]);
ADOGroup2.Name = Convert.ToString(groupTable.Rows[0]["CalcRangeGroup_Name"]);
ADOGroup2.Description = Convert.ToString(groupTable.Rows[0]["CalcRangeGroup_Des"]);
assinTA.Insert(ADOPerson2.ID, ADOGroup1.ID, new DateTime(2010, 2, 14));
assinTA.Insert(ADOPerson2.ID, ADOGroup1.ID, new DateTime(2005, 5, 14));
assinTA.Insert(ADOPerson2.ID, ADOGroup1.ID, new DateTime(2007, 11, 5));
assinTA.Insert(ADOPerson2.ID, ADOGroup2.ID, new DateTime(2010, 9, 14));
assinTA.Insert(ADOPerson2.ID, ADOGroup1.ID, new DateTime(2012, 9, 14));
assinTA.Insert(ADOPerson2.ID, ADOGroup1.ID, new DateTime(2008, 3, 1));
ruleCatTA.Insert("RuleGroupTest1", "0000", false, "00-00test1");
ruleCatTA.Insert("RuleGroupTest2", "0000", false, "00-00test1");
DatabaseGateway.TA_RuleCategoryDataTable ruleTable = ruleCatTA.GetDataByName("RuleGroupTest1");
ADORuleCat1.ID = (Decimal)ruleTable[0]["RuleCat_ID"];
ADORuleCat1.Name = (String)ruleTable[0]["RuleCat_Name"];
ruleTable = ruleCatTA.GetDataByName("RuleGroupTest2");
ADORuleCat2.ID = (Decimal)ruleTable[0]["RuleCat_ID"];
ADORuleCat2.Name = (String)ruleTable[0]["RuleCat_Name"];
prsRleCatAsgTA.Insert(ADOPerson2.ID, ADORuleCat1.ID, "2005/05/15", "2007/05/08", null);
prsRleCatAsgTA.Insert(ADOPerson2.ID, ADORuleCat1.ID, "2008/01/01", "2010/01/01", null);
prsRleCatAsgTA.Insert(ADOPerson2.ID, ADORuleCat1.ID, "2010/01/02", "2010/12/01", null);
prsRleCatAsgTA.Insert(ADOPerson2.ID, ADORuleCat1.ID, "2010/12/02", "2011/03/01", null);
prsRleCatAsgTA.Insert(ADOPerson2.ID, ADORuleCat2.ID, "2011/03/02", "2015/03/01", null);
validationGroupTA.InsertQuery("TestGroup00");
DatabaseGateway.TA_UIValidationGroupDataTable uiValGroupTable = validationGroupTA.GetDataByName("TestGroup00");
ADOUIValidationGroup1.ID = (uiValGroupTable.Rows[0] as DatabaseGateway.TA_UIValidationGroupRow).UIValGrp_ID;
}
public void TestSetup()
{
searchTool = new BPerson();
bPerson = new BPerson();
person_testObject = new Person();
#region Workgroup
workgrpTA.Insert("WorkGroupTest1", "0-0", 0);
workgrpTA.Insert("WorkGroupTest2", "0-1", 0);
DatabaseGateway.TA_WorkGroupDataTable table = new DatabaseGateway.TA_WorkGroupDataTable();
workgrpTA.FillByName(table, "WorkGroupTest1");
ADOWorkGroup1.ID = Convert.ToInt32(table.Rows[0]["workgroup_ID"]);
ADOWorkGroup1.Name = Convert.ToString(table.Rows[0]["workgroup_Name"]);
ADOWorkGroup1.CustomCode = Convert.ToString(table.Rows[0]["workgroup_CustomCode"]);
workgrpTA.FillByName(table, "WorkGroupTest2");
ADOWorkGroup2.ID = Convert.ToInt32(table.Rows[0]["workgroup_ID"]);
ADOWorkGroup2.Name = Convert.ToString(table.Rows[0]["workgroup_Name"]);
ADOWorkGroup2.CustomCode = Convert.ToString(table.Rows[0]["workgroup_CustomCode"]);
assignWorkGroupTA.Insert(ADOWorkGroup1.ID, ADOPerson1.ID, new DateTime(2007, 4, 5));
assignWorkGroupTA.Insert(ADOWorkGroup1.ID, ADOPerson2.ID, new DateTime(2007, 4, 5));
assignWorkGroupTA.Insert(ADOWorkGroup1.ID, ADOPerson2.ID, new DateTime(2012, 5, 5));
assignWorkGroupTA.Insert(ADOWorkGroup2.ID, ADOPerson2.ID, new DateTime(2010, 11, 6));
assignWorkGroupTA.Insert(ADOWorkGroup1.ID, ADOPerson2.ID, new DateTime(2009, 6, 15));
assignWorkGroupTA.Insert(ADOWorkGroup1.ID, ADOPerson2.ID, new DateTime(2010, 8, 5));
#endregion
#region Calculation DateRange
groupTA.Insert("RangeGroup1", "", 1);
groupTA.Insert("RangeGroup2", "", 1);
DatabaseGateway.TA_CalculationRangeGroupDataTable groupTable = new DatabaseGateway.TA_CalculationRangeGroupDataTable();
groupTA.FillByGroupName(groupTable, "RangeGroup1");
ADOGroup1.ID = Convert.ToDecimal(groupTable.Rows[0]["CalcRangeGroup_ID"]);
ADOGroup1.Name = Convert.ToString(groupTable.Rows[0]["CalcRangeGroup_Name"]);
ADOGroup1.Description = Convert.ToString(groupTable.Rows[0]["CalcRangeGroup_Des"]);
groupTA.FillByGroupName(groupTable, "RangeGroup2");
ADOGroup2.ID = Convert.ToDecimal(groupTable.Rows[0]["CalcRangeGroup_ID"]);
ADOGroup2.Name = Convert.ToString(groupTable.Rows[0]["CalcRangeGroup_Name"]);
ADOGroup2.Description = Convert.ToString(groupTable.Rows[0]["CalcRangeGroup_Des"]);
assinTA.Insert(ADOPerson1.ID, ADOGroup1.ID, new DateTime(2010, 2, 14));
assinTA.Insert(ADOPerson2.ID, ADOGroup1.ID, new DateTime(2010, 2, 14));
assinTA.Insert(ADOPerson2.ID, ADOGroup1.ID, new DateTime(2005, 5, 14));
assinTA.Insert(ADOPerson2.ID, ADOGroup1.ID, new DateTime(2007, 11, 5));
assinTA.Insert(ADOPerson2.ID, ADOGroup2.ID, new DateTime(2010, 9, 14));
assinTA.Insert(ADOPerson2.ID, ADOGroup1.ID, new DateTime(2012, 9, 14));
assinTA.Insert(ADOPerson2.ID, ADOGroup1.ID, new DateTime(2008, 3, 1));
#endregion
#region RuleGroup
ruleCatTA.Insert("RuleGroupTest1", "0000", false, "00-00test1");
ruleCatTA.Insert("RuleGroupTest2", "0000", false, "00-00test1");
DatabaseGateway.TA_RuleCategoryDataTable ruleTable = ruleCatTA.GetDataByName("RuleGroupTest1");
ADORuleCat1.ID = (Decimal)ruleTable[0]["RuleCat_ID"];
ADORuleCat1.Name = (String)ruleTable[0]["RuleCat_Name"];
ruleTable = ruleCatTA.GetDataByName("RuleGroupTest2");
ADORuleCat2.ID = (Decimal)ruleTable[0]["RuleCat_ID"];
ADORuleCat2.Name = (String)ruleTable[0]["RuleCat_Name"];
prsRleCatAsgTA.Insert(ADOPerson1.ID, ADORuleCat1.ID, "2005/05/15", "2007/05/08", null);
prsRleCatAsgTA.Insert(ADOPerson2.ID, ADORuleCat1.ID, "2005/05/15", "2007/05/08", null);
prsRleCatAsgTA.Insert(ADOPerson2.ID, ADORuleCat1.ID, "2008/01/01", "2010/01/01", null);
prsRleCatAsgTA.Insert(ADOPerson2.ID, ADORuleCat1.ID, "2010/01/01", "2010/12/01", null);
prsRleCatAsgTA.Insert(ADOPerson2.ID, ADORuleCat1.ID, "2010/12/01", "2011/03/01", null);
prsRleCatAsgTA.Insert(ADOPerson2.ID, ADORuleCat2.ID, "2011/03/02", "2015/03/01", null);
#endregion
#region OrganizationUnit
DatabaseGateway.TA_OrganizationUnitDataTable organtable = organTA.GetDataByParent();
ADOOrganParent.ID = Convert.ToInt32(organtable.Rows[0]["organ_ID"]);
ADOOrganParent.CustomCode = Convert.ToString(organtable.Rows[0]["organ_CustomCode"]);
organTA.Insert("TestLevel2_1", "0-1", ADOPerson2.ID, ADOOrganParent.ID, String.Format(",{0},", ADOOrganParent.ID));
organtable = organTA.GetDataByCustomCode("0-1");
ADOOrgan.ID = Convert.ToInt32(organtable.Rows[0]["organ_ID"]);
ADOOrgan.ParentID = Convert.ToInt32(organtable.Rows[0]["organ_ParentID"]);
ADOOrgan.Name = Convert.ToString(organtable.Rows[0]["organ_Name"]);
ADOOrgan.CustomCode = Convert.ToString(organtable.Rows[0]["organ_CustomCode"]);
ADOOrgan.PersonID = Convert.ToInt32(organtable.Rows[0]["organ_PersonID"]);
#endregion
#region Manager
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;
#endregion
}
