public virtual ExpertContainer ExpertSelectAll() { TraceCallEnterEvent.Raise(); try { ExpertContainer result; DataSet entitySet = m_DataContext.ndihdExpertSelectAll(); result = new ExpertContainer(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 FillDatagridExp(DBGuid ExpertID) { try { string sSortColumn = "Name"; int nSelectedRow = -1; // Storing the previous sort order if (dtgExpert.DataSource != null) { sSortColumn = ((DataTable) dtgExpert.DataSource).DefaultView.Sort; } if (m_allDataExp == null) { // Retrieving Experts // Set filter Expert filter = new Expert(Guid.Empty); filter.FilterOnIsactive = DBInt.Null; filter.FilterOnIsactive = 1; filter.IsActive = true; // Retrieving data from BusinessServices IExpertService srv = ServiceFactory.GetExpertService(); m_allDataExp = srv.ExpertSelectFiltered(filter); // Retrieving ProgramParticipant DBGuid ProgramID = new DBGuid(new Guid(m_sCurrentID)); IProgramService srvP = ServiceFactory.GetProgramService(); ProgramParticipantContainer allDataPP = srvP.SelectChildrenByProgramParticipant(ProgramID); // Hide selected Expert items for (int i = 0; i < allDataPP.All.Count; i++) { DBGuid ExpertRef = ((ProgramParticipant) allDataPP.All.Items[i]).ExpertRef; Expert selected = (Expert) m_allDataExp[ExpertRef.ToString()]; if (selected != null) { m_allDataExp.Delete(selected); } } } // Fill expert grid DataTable dt = m_allDataExp.CurrentAsDatatable; dt.DefaultView.Sort = sSortColumn; dtgExpert.DataSource = dt; // Fill expert "detail" grid DataTable dtDetail = m_allDataExp.DeletedAsDatatable; dtDetail.DefaultView.Sort = sSortColumn; dtgExpertDetail.DataSource = dtDetail; // Locates the row specified by ID param if (!ExpertID.IsNull) { BindingManagerBase bm = dtgExpert.BindingContext[dtgExpert.DataSource, dtgExpert.DataMember]; int nPositionStart = bm.Position; DataRow dr; for (int i = 0; i < bm.Count; i++) { dr = ((DataRowView) bm.Current).Row; if (ExpertID.Value.Equals(dr["ID"])) { nSelectedRow = i; break; } bm.Position += 1; } bm.Position = nPositionStart; } // Makes the row selected if (nSelectedRow <= ((DataTable) dtgExpert.DataSource).DefaultView.Count && nSelectedRow > -1) { dtgExpert.Select(nSelectedRow); dtgExpert.CurrentRowIndex = nSelectedRow; } else if (((DataTable) dtgExpert.DataSource).DefaultView.Count != 0) { dtgExpert.Select(0); } // Enabling or disabling the buttons according to record count. // And is because of previous disable state. bool bIsEmptyGrid = (((DataTable) dtgExpert.DataSource).DefaultView.Count == 0); btnAddExpert.Enabled = ! bIsEmptyGrid; btnDetailExpert.Enabled = ! bIsEmptyGrid; bIsEmptyGrid = (((DataTable) dtgExpertDetail.DataSource).DefaultView.Count == 0); btnRemoveExpert.Enabled = ! bIsEmptyGrid; } catch (Exception ex) { // --- Log exception ExceptionManager.Publish(ex); // --- Display Exception ErrorHandler.DisplayError("Nem várt hiba lépett fel a szakember lista frissítése során.", ex); } }
public virtual ExpertContainer SelectChildrenByQualificationOfExpert(DBString IDVal) { TraceCallEnterEvent.Raise(); try { ExpertContainer result; DataSet entitySet = m_DataContext.ndihdQualificationOfExpertSelectBy(IDVal); result = new ExpertContainer(entitySet.Tables[0]); TraceCallReturnEvent.Raise(); return result; } catch (Exception ex) { ExceptionManager.Publish(ex); TraceCallReturnEvent.Raise(false); throw; } }