private void Init(ActivityConfig.ACSeriesRow acsr) { this.SuspendLayout(); //flowLayoutPanel1.Controls.Clear(); if (myRF != null) { myRF.Dispose(); } myRF = null; MyACE = new ACEngine(FM); MyACE.myAcSeries = acsr; MyACE.myActivityCode = acsr.ActivityCodeRow; MyACE.DoRelFields(); MyACE.DoStep(ACEngine.Step.RelatedFields0, true); MyACE.DoStep(ACEngine.Step.RelatedFields1, true); MyACE.DoStep(ACEngine.Step.RelatedFields2, true); MyACE.DoStep(ACEngine.Step.RelatedFields3, true); MyACE.DoStep(ACEngine.Step.RelatedFields4, true); MyACE.DoStep(ACEngine.Step.RelatedFields5, true); MyACE.DoStep(ACEngine.Step.RelatedFields6, true); BuildForm(acsr); if (first) { foreach (DataView dv in MyACE.relTables.Values) { DataTable dt = dv.Table; dt.ColumnChanged += new DataColumnChangeEventHandler(dt_ColumnChanged); atLogic.ObjectBE obe = FM.GetBEFromTable(dt); obe.OnUpdate += new atLogic.UpdateEventHandler(ucSSTCase_OnUpdate); } first = false; } this.ResumeLayout(); }
private void AddExtensionToFileFormatTable(string ext, docDB.FileFormatDataTable ffTable) { if (obe == null) { obe = AtMng.GetCodeTableBE("FileFormat"); obe.Load(); } CodesDB.FileFormatRow ffRow = (CodesDB.FileFormatRow)obe.Add(null); ffRow.AllowEdit = false; ffRow.AllowPreview = false; ffRow.AllowSearch = true; ffRow.AllowUpload = true; ffRow.FileDescEng = "Lotus Notes Import"; ffRow.FileDescFre = "Lotus Notes Import"; ffRow.FileFormat = ext; ffRow.IsBinary = false; ffRow.EndEdit(); atLogic.BusinessProcess bp = AtMng.GetBP(); bp.AddForUpdate(obe); bp.Update(); ffTable.ImportRow(ffRow); }
public atLogic.ObjectBE GetMenu() { if (myMenu == null) { myMenu = new MenuBE(this); } return(myMenu); }
private void UnhookEvents() { foreach (DataView dv in MyACE.relTables.Values) { DataTable dt = dv.Table; dt.ColumnChanged -= new DataColumnChangeEventHandler(dt_ColumnChanged); atLogic.ObjectBE obe = FM.GetBEFromTable(dt); obe.OnUpdate -= new atLogic.UpdateEventHandler(ucSSTCase_OnUpdate); } }
public atLogic.ObjectBE GetACMajor() { if (myACMajor == null) { if (myatMng.AppMan.UseService) { myACMajor = GetObjectBE(null, DB.ACMajor); } else { myACMajor = this.GetObjectBE(myatMng.DALMngr.GetACMajor(), DB.ACMajor); } } return(myACMajor); }
public void CacheDataGet(DataTable dt, string name) { DataTable dt1 = dt.Clone(); // dt1.ReadXml(GetHashFilename(RemoveIllegalChar(name))); DecryptDTAes(GetHashFilename(RemoveIllegalChar(name)), dt1); atLogic.ObjectBE obe = null; if (dt.ExtendedProperties.ContainsKey("BE")) { obe = (ObjectBE)dt.ExtendedProperties["BE"]; obe.Fill(dt1); obe.myDT.AcceptChanges(); } else { dt.Merge(dt1); dt.AcceptChanges(); } }
public void LoadRoot(atriumManager atmng, int programId) { //load root if (UIHelper.AtMng.AppMan.Language.ToUpper() == "FRE") { SelectedIssueLangText = "IssueNameFre"; } myFM = atmng.GetFile(); //selectedIssue = myFM.CurrentFile; if (programId == 0) { LoadRootX(atmng, 0); } else { // load roots based on program issue atLogic.ObjectBE obe = atmng.GetCodeTableBE("ProgramIssue"); if (obe.myDT.Rows.Count == 0) { obe.Load(); } CodesDB.ProgramIssueDataTable pidt = (CodesDB.ProgramIssueDataTable)obe.myDT; foreach (CodesDB.ProgramIssueRow pir in pidt) { if (pir.ProgramId == programId) { LoadRootX(atmng, pir.IssueId); } } } tvIssues.ExpandAll(); }
private void ApplyTribunalMemberFilter() { // code to apply filter criteria to memmebrs list if (CurrentRow() != null) { grexAppealsReadyForAssignment.DropDowns["ddMemberListAssignmentFilter"].ApplyFilter(null); // clear filter GridEXFilterCondition filtTribunalMember = new GridEXFilterCondition(); if (this.chkLanguage.Checked) // add language filter { if (CurrentRow().FileLanguageCode == "F") { filtTribunalMember.AddCondition(new GridEXFilterCondition(grexAppealsReadyForAssignment.DropDowns["ddMemberListAssignmentFilter"].Columns["CanHearFre"], ConditionOperator.Equal, true)); } else if (CurrentRow().FileLanguageCode == "E") { filtTribunalMember.AddCondition(new GridEXFilterCondition(grexAppealsReadyForAssignment.DropDowns["ddMemberListAssignmentFilter"].Columns["CanHearEng"], ConditionOperator.Equal, true)); } else { filtTribunalMember.AddCondition(new GridEXFilterCondition(grexAppealsReadyForAssignment.DropDowns["ddMemberListAssignmentFilter"].Columns["CanHearFre"], ConditionOperator.Equal, true)); filtTribunalMember.AddCondition(new GridEXFilterCondition(grexAppealsReadyForAssignment.DropDowns["ddMemberListAssignmentFilter"].Columns["CanHearEng"], ConditionOperator.Equal, true)); } } if (this.chkTraining.Checked) // add training filter { // charter condition if (CurrentRow().IsCharter) { filtTribunalMember.AddCondition(new GridEXFilterCondition(grexAppealsReadyForAssignment.DropDowns["ddMemberListAssignmentFilter"].Columns["TrainedCharter"], ConditionOperator.Equal, true)); } // program & benefit condition if (!CurrentRow().IsAccountIdNull()) { atLogic.ObjectBE obe = myAtMng.GetCodeTableBE("AccountType"); if (obe.myDT.Rows.Count == 0) { obe.Load(); } CodesDB.AccountTypeDataTable atdt = (CodesDB.AccountTypeDataTable)obe.myDT; CodesDB.AccountTypeRow atr = atdt.FindByAccountTypeId(CurrentRow().AccountId); string trainedByProgramColumn = ""; switch (atr.ProgramID) { case 3: // EI trainedByProgramColumn = "TrainedEI"; break; case 8: // CPP trainedByProgramColumn = "TrainedCPP"; break; case 9: // OAS trainedByProgramColumn = "TrainedOAS"; break; } if (trainedByProgramColumn != "") { filtTribunalMember.AddCondition(new GridEXFilterCondition(grexAppealsReadyForAssignment.DropDowns["ddMemberListAssignmentFilter"].Columns[trainedByProgramColumn], ConditionOperator.Equal, true)); } } } if (this.chkLocation.Checked) // add location filter { var memberId = new List <int>(); if (!CurrentRow().IsOfficeIdNull()) { int selectedSCOfficeId = CurrentRow().OfficeId; // get service centre latitude and longitude lmDatasets.MemberManagement.OfficeSCListRow scr = myMemMng.DB.OfficeSCList.FindByOfficeId(selectedSCOfficeId);// myAtMng.OfficeMng.GetServiceCentre().Load(selectedSCOfficeId); if (!scr.IsLatitudeNull() && !scr.IsLongitudeNull()) { // get member postal code double distance; maxDistance = (int)maxDistanceEditBox.Value; foreach (MemberManagement.MemberListAssignmentFilterRow mlafr in mListAssignmentFilter) { if (!mlafr.IsLatitudeNull()) { distance = myAtMng.GetPostalCodeLocation().CalculateDistance((double)mlafr.Latitude, (double)mlafr.Longitude, (double)scr.Latitude, (double)scr.Longitude); if (distance >= 0 && distance <= maxDistance) { memberId.Add(mlafr.OfficerId); } } } } } if (memberId.Count == 0) { memberId.Add(-1); } GridEXFilterCondition filtLocation = new GridEXFilterCondition(); foreach (int memID in memberId) { if (filtLocation.Conditions.Count == 0) { filtLocation.AddCondition(new GridEXFilterCondition(grexAppealsReadyForAssignment.DropDowns["ddMemberListAssignmentFilter"].Columns["OfficerId"], ConditionOperator.Equal, memID)); } else { filtLocation.AddCondition(LogicalOperator.Or, new GridEXFilterCondition(grexAppealsReadyForAssignment.DropDowns["ddMemberListAssignmentFilter"].Columns["OfficerId"], ConditionOperator.Equal, memID)); } } filtTribunalMember.AddCondition(filtLocation); } // apply filter only if conditions exist if (filtTribunalMember.Conditions.Count > 0) { grexAppealsReadyForAssignment.DropDowns["ddMemberListAssignmentFilter"].ApplyFilter(filtTribunalMember); } } }
private void gridEX1_RowDoubleClick(object sender, RowActionEventArgs e) { try { uiPanel2.Closed = true; if (gridEX1.GetRow().RowType == RowType.Record) { string TblName; DataRow dr = (DataRow)((DataRowView)gridEX1.GetRow().DataRow).Row; TblName = (string)dr["TableName"]; uiPanel1.Text = TblName; for (int i = cGridEX.RootTable.Columns.Count - 1; i >= 0; i--) { cGridEX.RootTable.Columns.Remove(cGridEX.RootTable.Columns[i]); } obe = AtMng.GetCodeTableBE(TblName); obe.Load(); cGridEX.DataSource = obe.myDT; int y = 0; for (int i = 0; obe.myDT.Columns.Count > i; i++) { if ((obe.myDT.Columns[i].ColumnName == "entryUser") || (obe.myDT.Columns[i].ColumnName == "entryDate") || (obe.myDT.Columns[i].ColumnName == "updateUser") || (obe.myDT.Columns[i].ColumnName == "updateDate") || (obe.myDT.Columns[i].ColumnName == "ts")) { } else { if (cGridEX.RootTable.Columns.Count > i) { } else { cGridEX.RootTable.Columns.Add(); } cGridEX.RootTable.Columns[y].DataMember = obe.myDT.Columns[i].ColumnName; cGridEX.RootTable.Columns[y].Key = obe.myDT.Columns[i].ColumnName; cGridEX.RootTable.Columns[y].AutoSizeMode = ColumnAutoSizeMode.AllCellsAndHeader; if (obe.myDT.Columns[i].DataType == System.Type.GetType("System.Boolean")) { cGridEX.RootTable.Columns[y].ColumnType = ColumnType.CheckBox; cGridEX.RootTable.Columns[y].EditType = EditType.CheckBox; } if (TblName == "AccountType") { switch (i) { case 1: cGridEX.RootTable.Columns[y].Caption = "Code"; break; case 2: cGridEX.RootTable.Columns[y].Caption = "Desc Eng"; break; case 3: cGridEX.RootTable.Columns[y].Caption = "Desc Fre"; break; default: cGridEX.RootTable.Columns[y].Caption = obe.myDT.Columns[i].ColumnName; break; } } else { cGridEX.RootTable.Columns[y].Caption = obe.myDT.Columns[i].ColumnName; if (obe.myDT.Columns[i].ColumnName == "WFBGColor") { cGridEX.RootTable.Columns[y].Selectable = false; uiPanel2.Closed = false; cGridEX.RootTable.Columns.Add("BGColor"); } } y++; } } cGridEX.RootTable.SortKeys.Add(cGridEX.RootTable.Columns[0], Janus.Windows.GridEX.SortOrder.Ascending); if (cGridEX.RootTable.Columns.Contains("Obsolete")) { Janus.Windows.GridEX.GridEXFormatCondition gfc2 = new GridEXFormatCondition(cGridEX.RootTable.Columns["Obsolete"], ConditionOperator.Equal, true); Janus.Windows.GridEX.GridEXFormatStyle gfs2 = new GridEXFormatStyle(); gfs2.FontStrikeout = TriState.True; gfc2.FormatStyle = gfs2; cGridEX.RootTable.FormatConditions.Add(gfc2); } if (cGridEX.RootTable.Columns.Contains("ReadOnly")) { Janus.Windows.GridEX.GridEXFormatCondition gfc = new GridEXFormatCondition(cGridEX.RootTable.Columns["ReadOnly"], ConditionOperator.Equal, true); Janus.Windows.GridEX.GridEXFormatStyle gfs = new GridEXFormatStyle(); gfs.BackColor = Color.Gainsboro; gfs.ForeColor = SystemColors.ControlDarkDark; gfc.FormatStyle = gfs; cGridEX.RootTable.FormatConditions.Add(gfc); } cGridEX.AutoSizeColumns(); } } catch (Exception x) { UIHelper.HandleUIException(x); } }