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
}
