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);
}
