public virtual OrganisationContainer SelectChildrenByFormOfOrganisation(DBString IDVal) { TraceCallEnterEvent.Raise(); try { OrganisationContainer result; DataSet entitySet = m_DataContext.ndihdFormOfOrganisationSelectBy(IDVal); result = new OrganisationContainer(entitySet.Tables[0]); TraceCallReturnEvent.Raise(); return result; } catch (Exception ex) { ExceptionManager.Publish(ex); TraceCallReturnEvent.Raise(false); throw; } }
/// <summary> /// Fill datagrid with data /// </summary> private void FillDatagridOrg(DBGuid OrganisationID) { try { string sSortColumn = "Name"; int nSelectedRow = -1; // Storing the previous sort order if (dtgOrg.DataSource != null) { sSortColumn = ((DataTable) dtgOrg.DataSource).DefaultView.Sort; } if (m_allDataOrg == null) { // Retrieving Organisations // Set filter Organisation filter = new Organisation(Guid.Empty); filter.FilterOnIsactive = DBInt.Null; filter.FilterOnIsactive = 1; filter.IsActive = true; // Retrieving data from BusinessServices IOrganisationService srv = ServiceFactory.GetOrganisationService(); m_allDataOrg = srv.OrganisationSelectFiltered(filter); // Retrieving ProgramPartners DBGuid ProgramID = new DBGuid(new Guid(m_sCurrentID)); IProgramService srvP = ServiceFactory.GetProgramService(); ProgramPartnerContainer allDataP = srvP.SelectChildrenByPartnerProgram(ProgramID); // Hide selected Organisation items for (int i = 0; i < allDataP.All.Count; i++) { DBGuid OrganisationRef = ((ProgramPartner) allDataP.All.Items[i]).OrganisationRef; Organisation selected = (Organisation) m_allDataOrg[OrganisationRef.ToString()]; if (selected != null) { m_allDataOrg.Delete(selected); } } } // Fill organisation grid DataTable dt = m_allDataOrg.CurrentAsDatatable; dt.DefaultView.Sort = sSortColumn; dtgOrg.DataSource = dt; // Fill organisation "detail" grid DataTable dtDetail = m_allDataOrg.DeletedAsDatatable; dtDetail.DefaultView.Sort = sSortColumn; dtgOrgDetail.DataSource = dtDetail; // Locates the row specified by ID param if (!OrganisationID.IsNull) { BindingManagerBase bm = dtgOrg.BindingContext[dtgOrg.DataSource, dtgOrg.DataMember]; int nPositionStart = bm.Position; DataRow dr; for (int i = 0; i < bm.Count; i++) { dr = ((DataRowView) bm.Current).Row; if (OrganisationID.Value.Equals(dr["ID"])) { nSelectedRow = i; break; } bm.Position += 1; } bm.Position = nPositionStart; } // Makes the row selected if (nSelectedRow <= ((DataTable) dtgOrg.DataSource).DefaultView.Count && nSelectedRow > -1) { dtgOrg.Select(nSelectedRow); dtgOrg.CurrentRowIndex = nSelectedRow; } else if (((DataTable) dtgOrg.DataSource).DefaultView.Count != 0) { dtgOrg.Select(0); } // Enabling or disabling the buttons according to record count. // And is because of previous disable state. bool bIsEmptyGrid = (((DataTable) dtgOrg.DataSource).DefaultView.Count == 0); btnAddOrganisation.Enabled = ! bIsEmptyGrid; btnDetailOrganisation.Enabled = ! bIsEmptyGrid; bIsEmptyGrid = (((DataTable) dtgOrgDetail.DataSource).DefaultView.Count == 0); btnRemoveOrganisation.Enabled = ! bIsEmptyGrid; } catch (Exception ex) { // --- Log exception ExceptionManager.Publish(ex); // --- Display Exception ErrorHandler.DisplayError("Nem várt hiba lépett fel a szervezet lista frissítése során.", ex); } }
public OrganisationContainer OrganisationSelectFiltered(Organisation filter) { TraceCallEnterEvent.Raise(); try { DBInt ActivityPrevention = DBInt.Null; if (filter.ActivityPrevention) ActivityPrevention = 1; DBInt ActivityResearch = DBInt.Null; if (filter.ActivityResearch) ActivityResearch = 1; DBInt ActivityRehabilitation = DBInt.Null; if (filter.ActivityRehabilitation) ActivityRehabilitation = 1; DBInt ActivityOther = DBInt.Null; if (filter.ActivityOther) ActivityOther = 1; DBInt ActivityCoord = DBInt.Null; if (filter.FilterOnIsKef != DBInt.Null) ActivityCoord = filter.FilterOnIsKef; OrganisationContainer result; DataSet entitySet = m_DataContext.ndihdOrganisationSelectFiltered( filter.Name, filter.RegionRef, filter.OrganisationFormRef, ActivityPrevention, ActivityResearch, ActivityRehabilitation, ActivityOther, filter.FilterOnIsactive, filter.FilterOnIsKef, filter.ValidationState); result = new OrganisationContainer(entitySet.Tables[0]); TraceCallReturnEvent.Raise(); return result; } catch (Exception ex) { ExceptionManager.Publish(ex); TraceCallReturnEvent.Raise(false); throw; } }
public OrganisationContainer OrganisationSelectKefListFilteredByRegCode(string RegCode, bool IsActive, bool ActivityCoord, bool IsKef) { TraceCallEnterEvent.Raise(); try { OrganisationContainer result; DataSet entitySet = m_DataContext.ndihdOrganisationSelectKefListFilteredByRegCode(RegCode, IsActive, IsKef); result = new OrganisationContainer(entitySet.Tables[0]); TraceCallReturnEvent.Raise(); return result; } catch (Exception ex) { ExceptionManager.Publish(ex); TraceCallReturnEvent.Raise(false); throw; } }
public virtual OrganisationContainer OrganisationSelectAll() { TraceCallEnterEvent.Raise(); try { OrganisationContainer result; DataSet entitySet = m_DataContext.ndihdOrganisationSelectAll(); result = new OrganisationContainer(entitySet.Tables[0]); TraceCallReturnEvent.Raise(); return result; } catch (Exception ex) { ExceptionManager.Publish(ex); TraceCallReturnEvent.Raise(false); throw; } }