private void LoadData() { OVRDataBaseUtils.GetActiveInfo(m_RecordModule.DatabaseConnection, out m_iActiveSport, out m_iActiveDiscipline, out m_strActiveLanguage); ShowEventToGrid(); ShowEventRecordToGrid(); ShowRecordValuesToGrid(GetCurSelEventRecordID()); ShowRecordMembersToGrid(GetCurSelEventRecordID()); }
private void LoadData() { // Load Active Info OVRDataBaseUtils.GetActiveInfo(m_RegisterModule.DatabaseConnection, out m_iActiveSport, out m_iActiveDiscipline, out m_strActiveLanguage); m_iSportGroupType = GetGroupType(); //Register Tab RegisterInfoLoadData(); //Inscription Tab InscriptionLoadData(); }
private void OVRVenueListForm_Load(object sender, EventArgs e) { Localization(); if (sqlConnection.State == System.Data.ConnectionState.Closed) { sqlConnection.Open(); } int iActiveSport, iActiveDiscipline; string strLanguageCode; OVRDataBaseUtils.GetActiveInfo(sqlConnection, out iActiveDiscipline, out iActiveDiscipline, out strLanguageCode); #region DML Command Setup for Get Discipline Venues String strSQL; strSQL = String.Format(@" SELECT 'NONE' AS [Venue] UNION SELECT C.F_VenueCode + '('+ B.F_VenueLongName + ')' AS [Venue] FROM TD_Discipline_Venue AS A LEFT JOIN TC_Venue_Des AS B ON A.F_VenueID = B.F_VenueID LEFT JOIN TC_Venue AS C ON A.F_VenueID = C.F_VenueID WHERE B.F_LanguageCode = '{0}' AND A.F_DisciplineID = {1}" , strLanguageCode, iActiveDiscipline); SqlCommand cmd = new SqlCommand(strSQL, sqlConnection); #endregion SqlDataReader dr = null; try { dr = cmd.ExecuteReader(); OVRDataBaseUtils.FillDataGridView(dgvVenueList, dr, null, null); dr.Close(); } catch (System.Exception ex) { DevComponents.DotNetBar.MessageBoxEx.Show(ex.Message); if (dr != null && !dr.IsClosed) { dr.Close(); } } }
private void OVRFederationListForm_Load(object sender, EventArgs e) { OVRDataBaseUtils.GetActiveInfo(sqlConnection, out m_iActiveSportID, out m_iActiveDisciplineID, out m_strActiveLanguageCode); ResetFederationList(m_iActiveDisciplineID, m_strActiveLanguageCode, m_iGroupType); }