public string[] UpdateCalculationRange_MasterCalculationRangePage(string state, string SelectedCalculationRangeID) { this.InitializeCulture(); string[] retMessage = new string[4]; try { AttackDefender.CSRFDefender(this.Page); decimal CalculationRangeID = 0; decimal selectedCalculationRangeID = decimal.Parse(this.StringBuilder.CreateString(SelectedCalculationRangeID), CultureInfo.InvariantCulture); UIActionType uam = (UIActionType)Enum.Parse(typeof(UIActionType), this.StringBuilder.CreateString(state).ToUpper()); CalculationRangeGroup calculationRange = new CalculationRangeGroup(); calculationRange.ID = selectedCalculationRangeID; switch (uam) { case UIActionType.DELETE: if (selectedCalculationRangeID == 0) { retMessage = this.exceptionHandler.HandleException(this.Page, ExceptionTypes.UIValidationExceptions, new Exception(GetLocalResourceObject("NoCalculationRangeSelectedforDelete").ToString()), retMessage); return(retMessage); } CalculationRangeID = this.CalculationRangeBusiness.DeleteDateRange(calculationRange); break; } retMessage[0] = GetLocalResourceObject("RetSuccessType").ToString(); string SuccessMessageBody = string.Empty; switch (uam) { case UIActionType.DELETE: SuccessMessageBody = GetLocalResourceObject("DeleteComplete").ToString(); break; default: break; } retMessage[1] = SuccessMessageBody; retMessage[2] = "success"; retMessage[3] = CalculationRangeID.ToString(); return(retMessage); } catch (UIValidationExceptions ex) { retMessage = this.exceptionHandler.HandleException(this.Page, ExceptionTypes.UIValidationExceptions, ex, retMessage); return(retMessage); } catch (UIBaseException ex) { retMessage = this.exceptionHandler.HandleException(this.Page, ExceptionTypes.UIBaseException, ex, retMessage); return(retMessage); } catch (Exception ex) { retMessage = this.exceptionHandler.HandleException(this.Page, ExceptionTypes.Exception, ex, retMessage); return(retMessage); } }
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 Insert_IndexBeforeAndNextYearTest() { group_testObject.Name = "Group Test 2"; group_testObject.DateRangeList = new List <CalculationDateRange>(); dateRangList_testObject[0].FromMonth = 12; dateRangList_testObject[0].FromDay = 15; dateRangList_testObject[0].ToMonth = 1; dateRangList_testObject[0].ToDay = 14; dateRangList_testObject[11].FromMonth = 12; dateRangList_testObject[11].FromDay = 15; dateRangList_testObject[11].ToMonth = 1; dateRangList_testObject[11].ToDay = 14; businessDateRange.InsertDateRange(group_testObject, defaultDateRanges, dateRangList_testObject, new List <decimal>() { ADOConcept1.ID, ADOConcept2.ID, ADOConcept3.ID }); ClearSession(); CalculationRangeGroup group = businessDateRange.GetByID(group_testObject.ID); CalculationDateRange range = group.DateRangeList.Where(x => x.Order == CalculationDateRangeOrder.Month1).First(); Assert.AreEqual(11215, range.FromIndex); //12/15 Assert.AreEqual(20114, range.ToIndex); //01/14 range = group.DateRangeList.Where(x => x.Order == CalculationDateRangeOrder.Month12).First(); Assert.AreEqual(21215, range.FromIndex); //12/15 Assert.AreEqual(30114, range.ToIndex); //01/14 }
public IList <CalculationDateRange> GetCalculationDateRanges(CalculationRangeGroup calculationGroup, IList <SecondaryConcept> concepts) { IList <CalculationDateRange> list = base.NHibernateSession.CreateCriteria(typeof(CalculationDateRange)) .Add(Expression.Eq("RangeGroup", calculationGroup)) .Add(Expression.In("Concept", concepts.ToArray())) .List <CalculationDateRange>(); return(list); }
public void Update_Test() { group_testObject.ID = ADOGroup.ID; group_testObject.Name = ADOGroup.Name; businessDateRange.UpdateDateRange(group_testObject, dateRangList_testObject, new List <decimal>() { ADOConcept1.ID }); ClearSession(); group_testObject = new CalculationRangeGroup(); group_testObject = businessDateRange.GetByID(ADOGroup.ID); Assert.AreEqual(group_testObject.DateRangeList.Where(x => x.Order == dateRangList_testObject[0].Order && x.Concept.ID == ADOConcept1.ID).FirstOrDefault().FromDay, dateRangList_testObject[0].FromDay); Assert.AreEqual(10, group_testObject.DateRangeList.Count); }
public void Insert_MultiConceptCountTest() { group_testObject.Name = "Group Test 2"; group_testObject.DateRangeList = new List <CalculationDateRange>(); businessDateRange.InsertDateRange(group_testObject, defaultDateRanges, dateRangList_testObject, new List <decimal>() { ADOConcept1.ID, ADOConcept2.ID, ADOConcept3.ID }); ClearSession(); CalculationRangeGroup group = businessDateRange.GetByID(group_testObject.ID); int conceptCount = conceptTA.GetDataRangly().Rows.Count; Assert.AreEqual(conceptCount * 12, group.DateRangeList.Count); }
public void Insert_IndexTest() { group_testObject.Name = "Group Test 2"; group_testObject.DateRangeList = new List <CalculationDateRange>(); businessDateRange.InsertDateRange(group_testObject, defaultDateRanges, dateRangList_testObject, new List <decimal>() { ADOConcept1.ID, ADOConcept2.ID, ADOConcept3.ID }); ClearSession(); CalculationRangeGroup group = businessDateRange.GetByID(group_testObject.ID); CalculationDateRange range = group.DateRangeList.Where(x => x.Order == CalculationDateRangeOrder.Month1).First(); Assert.AreEqual(20101, range.FromIndex); //01/01 Assert.AreEqual(20131, range.ToIndex); //01/31 range = group.DateRangeList.Where(x => x.Order == CalculationDateRangeOrder.Month12).First(); Assert.AreEqual(21201, range.FromIndex); //12/01 Assert.AreEqual(21229, range.ToIndex); //12/29 }
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 GetRanges_Test() { group_testObject = businessDateRange.GetByID(ADOGroup.ID); Assert.AreEqual(group_testObject.DateRangeList.Count, 10); }
public string[] UpdatePersonnelSingleDateFeature_PersonnelSingleDateFeaturesPage(string caller, string state, string SelectedPersonnelSingleDateFeatureID, string PersonnelID, string SingleDateFeatureID, string SingleDateFeatureName, string FromDate, string PersonnelState) { this.InitializeCulture(); string[] retMessage = new string[5]; Caller PersonnelSingleDateFeatureCaller = (Caller)Enum.Parse(typeof(Caller), this.StringBuilder.CreateString(caller)); decimal PersonnelSingleDateFeatureID = 0; decimal selectedPersonnelSingleDateFeatureID = decimal.Parse(this.StringBuilder.CreateString(SelectedPersonnelSingleDateFeatureID), CultureInfo.InvariantCulture); decimal personnelID = decimal.Parse(this.StringBuilder.CreateString(PersonnelID), CultureInfo.InvariantCulture); decimal singleDateFeatureID = decimal.Parse(this.StringBuilder.CreateString(SingleDateFeatureID), CultureInfo.InvariantCulture); SingleDateFeatureName = this.StringBuilder.CreateString(SingleDateFeatureName); UIActionType personnelState = (UIActionType)Enum.Parse(typeof(UIActionType), this.StringBuilder.CreateString(PersonnelState).ToUpper()); FromDate = this.StringBuilder.CreateString(FromDate); string CurrentActiveSingleDateFeatureName = string.Empty; string NoItemSelectedforEditMessage = string.Empty; string NoItemSelectedforDeleteMessage = string.Empty; switch (PersonnelSingleDateFeatureCaller) { case Caller.WorkGroups: NoItemSelectedforEditMessage = this.GetLocalResourceObject("NoWorkGroupPersonnelSingleDateFeatureselectedforEdit").ToString(); NoItemSelectedforDeleteMessage = this.GetLocalResourceObject("NoWorkGroupPersonnelSingleDateFeatureselectedforDelete").ToString(); break; case Caller.CalculationRangesGroups: NoItemSelectedforEditMessage = this.GetLocalResourceObject("NoCalculationRangePersonnelSingleDateFeatureselectedforEdit").ToString(); NoItemSelectedforDeleteMessage = this.GetLocalResourceObject("NoCalculationRangePersonnelSingleDateFeatureselectedforDelete").ToString(); break; } UIActionType uam = UIActionType.ADD; try { AttackDefender.CSRFDefender(this.Page); switch (this.StringBuilder.CreateString(state)) { case "Add": uam = UIActionType.ADD; break; case "Edit": uam = UIActionType.EDIT; if (selectedPersonnelSingleDateFeatureID == 0) { retMessage = this.exceptionHandler.HandleException(this.Page, ExceptionTypes.UIValidationExceptions, new Exception(NoItemSelectedforEditMessage), retMessage); return(retMessage); } break; case "Delete": uam = UIActionType.DELETE; if (selectedPersonnelSingleDateFeatureID == 0) { retMessage = this.exceptionHandler.HandleException(this.Page, ExceptionTypes.UIValidationExceptions, new Exception(NoItemSelectedforDeleteMessage), retMessage); return(retMessage); } break; default: break; } switch (PersonnelSingleDateFeatureCaller) { case Caller.WorkGroups: AssignWorkGroup personnelWorkGroup = new AssignWorkGroup(); personnelWorkGroup.ID = selectedPersonnelSingleDateFeatureID; personnelWorkGroup.Person = new Person { ID = personnelID }; if (uam != UIActionType.DELETE) { Person person = new Person(); person.ID = personnelID; personnelWorkGroup.Person = person; WorkGroup workGroup = new WorkGroup(); workGroup.ID = singleDateFeatureID; workGroup.Name = SingleDateFeatureName; personnelWorkGroup.WorkGroup = workGroup; personnelWorkGroup.UIFromDate = FromDate; } switch (personnelState) { case UIActionType.ADD: switch (uam) { case UIActionType.ADD: PersonnelSingleDateFeatureID = this.bAssignWorkGroup.InsertAssignWorkGroup_onPersonnelInsert(personnelWorkGroup, uam); CurrentActiveSingleDateFeatureName = this.PersonBusiness.GetCurrentActiveWorkGroup(personnelID); break; case UIActionType.EDIT: PersonnelSingleDateFeatureID = this.bAssignWorkGroup.UpdateAssignWorkGroup_onPersonnelInsert(personnelWorkGroup, uam); CurrentActiveSingleDateFeatureName = this.PersonBusiness.GetCurrentActiveWorkGroup(personnelID); break; case UIActionType.DELETE: PersonnelSingleDateFeatureID = this.bAssignWorkGroup.DeleteAssignWorkGroup_onPersonnelInsert(personnelWorkGroup, uam); CurrentActiveSingleDateFeatureName = this.PersonBusiness.GetCurrentActiveWorkGroup(personnelID); break; } break; case UIActionType.EDIT: switch (uam) { case UIActionType.ADD: PersonnelSingleDateFeatureID = this.bAssignWorkGroup.InsertAssignWorkGroup_onPersonnelUpdate(personnelWorkGroup, uam); CurrentActiveSingleDateFeatureName = this.PersonBusiness.GetCurrentActiveWorkGroup(personnelID); break; case UIActionType.EDIT: PersonnelSingleDateFeatureID = this.bAssignWorkGroup.UpdateAssignWorkGroup_onPersonnelUpdate(personnelWorkGroup, uam); CurrentActiveSingleDateFeatureName = this.PersonBusiness.GetCurrentActiveWorkGroup(personnelID); break; case UIActionType.DELETE: PersonnelSingleDateFeatureID = this.bAssignWorkGroup.DeleteAssignWorkGroup_onPersonnelUpdate(personnelWorkGroup, uam); CurrentActiveSingleDateFeatureName = this.PersonBusiness.GetCurrentActiveWorkGroup(personnelID); break; } break; } // PersonnelSingleDateFeatureID = this.PersonnelWorkGroupBusiness.SaveChanges(personnelWorkGroup, uam); break; case Caller.CalculationRangesGroups: PersonRangeAssignment PersonnelCalculationRange = new PersonRangeAssignment(); PersonnelCalculationRange.ID = selectedPersonnelSingleDateFeatureID; PersonnelCalculationRange.Person = new Person { ID = personnelID }; if (uam != UIActionType.DELETE) { Person person = new Person(); person.ID = personnelID; PersonnelCalculationRange.Person = person; CalculationRangeGroup calculationRangeGroup = new CalculationRangeGroup(); calculationRangeGroup.ID = singleDateFeatureID; calculationRangeGroup.Name = SingleDateFeatureName; PersonnelCalculationRange.CalcDateRangeGroup = calculationRangeGroup; PersonnelCalculationRange.UIFromDate = FromDate; } switch (personnelState) { case UIActionType.ADD: switch (uam) { case UIActionType.ADD: PersonnelSingleDateFeatureID = this.bCalculationRangeBusiness.InsertAssignDateRange_onPersonnelInsert(PersonnelCalculationRange, uam); CurrentActiveSingleDateFeatureName = this.PersonBusiness.GetCurrentActiveDateRange(personnelID); break; case UIActionType.EDIT: PersonnelSingleDateFeatureID = this.bCalculationRangeBusiness.UpdateAssignDateRange_onPersonnelInsert(PersonnelCalculationRange, uam); CurrentActiveSingleDateFeatureName = this.PersonBusiness.GetCurrentActiveDateRange(personnelID); break; case UIActionType.DELETE: PersonnelSingleDateFeatureID = this.bCalculationRangeBusiness.DeleteAssignDateRange_onPersonnelInsert(PersonnelCalculationRange, uam); CurrentActiveSingleDateFeatureName = this.PersonBusiness.GetCurrentActiveDateRange(personnelID); break; } break; case UIActionType.EDIT: switch (uam) { case UIActionType.ADD: PersonnelSingleDateFeatureID = this.bCalculationRangeBusiness.InsertAssignDateRange_onPersonnelUpdate(PersonnelCalculationRange, uam); CurrentActiveSingleDateFeatureName = this.PersonBusiness.GetCurrentActiveDateRange(personnelID); break; case UIActionType.EDIT: PersonnelSingleDateFeatureID = this.bCalculationRangeBusiness.UpdateAssignDateRange_onPersonnelUpdate(PersonnelCalculationRange, uam); CurrentActiveSingleDateFeatureName = this.PersonBusiness.GetCurrentActiveDateRange(personnelID); break; case UIActionType.DELETE: PersonnelSingleDateFeatureID = this.bCalculationRangeBusiness.DeleteAssignDateRange_onPersonnelUpdate(PersonnelCalculationRange, uam); CurrentActiveSingleDateFeatureName = this.PersonBusiness.GetCurrentActiveDateRange(personnelID); break; } break; } //PersonnelSingleDateFeatureID = this.PersonnelCalculationRangeBusiness.SaveChanges(PersonnelCalculationRange, uam); //CurrentActiveSingleDateFeatureName = this.PersonBusiness.GetCurrentActiveDateRange(personnelID); break; } retMessage[0] = GetLocalResourceObject("RetSuccessType").ToString(); string SuccessMessageBody = string.Empty; switch (uam) { case UIActionType.ADD: SuccessMessageBody = GetLocalResourceObject("AddComplete").ToString(); break; case UIActionType.EDIT: SuccessMessageBody = GetLocalResourceObject("EditComplete").ToString(); break; case UIActionType.DELETE: SuccessMessageBody = GetLocalResourceObject("DeleteComplete").ToString(); break; default: break; } retMessage[1] = SuccessMessageBody; retMessage[2] = "success"; retMessage[3] = PersonnelSingleDateFeatureID.ToString(); retMessage[4] = CurrentActiveSingleDateFeatureName; return(retMessage); } catch (UIValidationExceptions ex) { retMessage = this.exceptionHandler.HandleException(this.Page, ExceptionTypes.UIValidationExceptions, ex, retMessage); return(retMessage); } catch (UIBaseException ex) { retMessage = this.exceptionHandler.HandleException(this.Page, ExceptionTypes.UIBaseException, ex, retMessage); return(retMessage); } catch (Exception ex) { retMessage = this.exceptionHandler.HandleException(this.Page, ExceptionTypes.Exception, ex, retMessage); return(retMessage); } }
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 string[] UpdateCaculationRange_CalculationRangePage(string state, string SelectedCalculationRangeID, string CalculationRangeName, string CalculationRangeDescription, string ConceptsList, string DefaultCalculationRangesList, string CalculationRangesList) { this.InitializeCulture(); string[] retMessage = new string[4]; try { decimal CalculationRangeID = 0; UIActionType uam = (UIActionType)Enum.Parse(typeof(UIActionType), this.StringBuilder.CreateString(state).ToUpper()); SelectedCalculationRangeID = this.StringBuilder.CreateString(SelectedCalculationRangeID); CalculationRangeName = this.StringBuilder.CreateString(CalculationRangeName); CalculationRangeDescription = this.StringBuilder.CreateString(CalculationRangeDescription); ConceptsList = this.StringBuilder.CreateString(ConceptsList); DefaultCalculationRangesList = this.StringBuilder.CreateString(DefaultCalculationRangesList); CalculationRangesList = this.StringBuilder.CreateString(CalculationRangesList); decimal selectedCalculationRangeID = decimal.Parse(SelectedCalculationRangeID); retMessage[0] = GetLocalResourceObject("RetSuccessType").ToString(); string SuccessMessageBody = string.Empty; CalculationRangeGroup calculationRange = new CalculationRangeGroup(); calculationRange.ID = selectedCalculationRangeID; calculationRange.Name = CalculationRangeName; calculationRange.Description = CalculationRangeDescription; List <CalculationDateRange> DefaultCalculationDateRanges = this.CreateCalculationRangesList_CalculationRange(DefaultCalculationRangesList); List <CalculationDateRange> CalculationDateRanges = this.CreateCalculationRangesList_CalculationRange(CalculationRangesList); List <decimal> Concepts = this.CreateConceptsList_CalculationRange(ConceptsList); switch (uam) { case UIActionType.ADD: CalculationRangeID = this.CalculationRangeBusiness.InsertDateRange(calculationRange, DefaultCalculationDateRanges, CalculationDateRanges, Concepts); SuccessMessageBody = GetLocalResourceObject("AddComplete").ToString(); break; case UIActionType.EDIT: if (selectedCalculationRangeID == 0) { retMessage = this.exceptionHandler.HandleException(this.Page, ExceptionTypes.Exception, new Exception(GetLocalResourceObject("NoCalculationRangeSelectedforEdit").ToString()), retMessage); return(retMessage); } CalculationRangeID = this.CalculationRangeBusiness.UpdateDateRange(calculationRange, CalculationDateRanges, Concepts); SuccessMessageBody = GetLocalResourceObject("EditComplete").ToString(); break; } retMessage[1] = SuccessMessageBody; retMessage[2] = "success"; retMessage[3] = CalculationRangeID.ToString(); return(retMessage); } catch (UIValidationExceptions ex) { retMessage = this.exceptionHandler.HandleException(this.Page, ExceptionTypes.UIValidationExceptions, ex, retMessage); return(retMessage); } catch (UIBaseException ex) { retMessage = this.exceptionHandler.HandleException(this.Page, ExceptionTypes.UIBaseException, ex, retMessage); return(retMessage); } catch (Exception ex) { retMessage = this.exceptionHandler.HandleException(this.Page, ExceptionTypes.Exception, ex, retMessage); return(retMessage); } }