bool AddSession(string strDate)
{
try
{
System.Data.SqlClient.SqlConnection con = m_sqlCon;
if (con.State != ConnectionState.Open)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("Proc_Schedule_AddSession", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@DisciplineID", SqlDbType.Int, 4, ParameterDirection.Input, true, 0, 0, "@DisciplineID", DataRowVersion.Current, m_strDisciplineID));
cmd.Parameters.Add(new SqlParameter("@SessionDate", SqlDbType.Char, 10, ParameterDirection.Input, true, 0, 0, "@SessionDate", DataRowVersion.Current, strDate));
cmd.Parameters.Add(new SqlParameter("@SessionNumber", SqlDbType.Int, 4, ParameterDirection.Input, true, 0, 0, "@SessionNumber", DataRowVersion.Current, DBNull.Value));
cmd.Parameters.Add(new SqlParameter("@SessionTime", SqlDbType.Char, 10, ParameterDirection.Input, true, 0, 0, "@SessionTime", DataRowVersion.Current, DBNull.Value));
cmd.Parameters.Add(new SqlParameter("@SessionEndTime", SqlDbType.Char, 10, ParameterDirection.Input, true, 0, 0, "@SessionEndTime", DataRowVersion.Current, DBNull.Value));
cmd.Parameters.Add(new SqlParameter("@SeesionTypeID", SqlDbType.Int, 4, ParameterDirection.Input, true, 0, 0, "@SeesionTypeID", DataRowVersion.Current, DBNull.Value));
SqlParameter cmdParameterResult = new SqlParameter("@Result", SqlDbType.Int, 4, ParameterDirection.Output, true, 0, 0, "", DataRowVersion.Current, 0);
cmd.Parameters.Add(cmdParameterResult);
cmd.UpdatedRowSource = UpdateRowSource.None;
cmd.ExecuteNonQuery();
if (cmdParameterResult.Value != null && (Int32)cmdParameterResult.Value > 0)
{
if (module != null)
{
int iDisciplineID = Convert.ToInt32(m_strDisciplineID);
int iSessionID = Convert.ToInt32(cmdParameterResult.Value);
module.DataChangedNotify(OVRDataChangedType.emSessionAdd, iDisciplineID, -1, -1, -1, iSessionID, null);
}
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
DevComponents.DotNetBar.MessageBoxEx.Show(ex.Message);
return(false);
}
}
int AddDate(string strDate)
{
try
{
System.Data.SqlClient.SqlConnection con = m_sqlCon;
if (con.State != ConnectionState.Open)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("Proc_Schedule_AddDisciplineDate", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@DisciplineID", SqlDbType.Int, 4, ParameterDirection.Input, true, 0, 0, "@DisciplineID", DataRowVersion.Current, m_strDisciplineID));
cmd.Parameters.Add(new SqlParameter("@DateOrder", SqlDbType.Int, 4, ParameterDirection.Input, true, 0, 0, "@DateOrder", DataRowVersion.Current, DBNull.Value));
cmd.Parameters.Add(new SqlParameter("@Date", SqlDbType.NVarChar, 50, ParameterDirection.Input, true, 0, 0, "@Date", DataRowVersion.Current, strDate));
cmd.Parameters.Add(new SqlParameter("@DateLongDescription", SqlDbType.NVarChar, 100, ParameterDirection.Input, true, 0, 0, "@DateLongDescription", DataRowVersion.Current, DBNull.Value));
cmd.Parameters.Add(new SqlParameter("@DateShortDescription", SqlDbType.NVarChar, 50, ParameterDirection.Input, true, 0, 0, "@DateShortDescription", DataRowVersion.Current, DBNull.Value));
cmd.Parameters.Add(new SqlParameter("@DateComment", SqlDbType.NVarChar, 100, ParameterDirection.Input, true, 0, 0, "@DateComment", DataRowVersion.Current, DBNull.Value));
cmd.Parameters.Add(new SqlParameter("@LanguageCode", SqlDbType.Char, 3, ParameterDirection.Input, true, 0, 0, "@LanguageCode", DataRowVersion.Current, m_strLanguageCode));
SqlParameter cmdParameterResult = new SqlParameter("@Result", SqlDbType.Int, 4, ParameterDirection.Output, true, 0, 0, "", DataRowVersion.Current, 0);
cmd.Parameters.Add(cmdParameterResult);
cmd.UpdatedRowSource = UpdateRowSource.None;
cmd.ExecuteNonQuery();
if (cmdParameterResult.Value != null && (Int32)cmdParameterResult.Value > 0)
{
if (module != null)
{
int iDisciplineID = Convert.ToInt32(m_strDisciplineID);
int iDateID = Convert.ToInt32(cmdParameterResult.Value);
module.DataChangedNotify(OVRDataChangedType.emDateAdd, iDisciplineID, -1, -1, -1, iDateID, null);
}
}
return(int.Parse(cmdParameterResult.Value.ToString()));
}
catch (Exception ex)
{
DevComponents.DotNetBar.MessageBoxEx.Show(ex.Message);
return(0);
}
}
private bool EditCompetitionPosition()
{
bool bResult = false;
try
{
Int32 iOperateResult;
SqlCommand oneSqlCommand = new SqlCommand();
oneSqlCommand.Connection = m_DatabaseConnection;
oneSqlCommand.CommandText = "proc_EditCompetitionPosition";
oneSqlCommand.CommandType = CommandType.StoredProcedure;
SqlParameter cmdParameter0 = new SqlParameter(
"@MatchID", SqlDbType.Int, 4,
ParameterDirection.Input, true, 0, 0, "",
DataRowVersion.Current, m_iMatchID);
oneSqlCommand.Parameters.Add(cmdParameter0);
SqlParameter cmdParameter2 = new SqlParameter(
"@CompetitionPosition", SqlDbType.Int, 4,
ParameterDirection.Input, true, 0, 0, "",
DataRowVersion.Current, m_iCompetitionPosition);
oneSqlCommand.Parameters.Add(cmdParameter2);
SqlParameter cmdParameter3 = new SqlParameter(
"@CompetitionPositionDes1", SqlDbType.Int, 4,
ParameterDirection.Input, true, 0, 0, "",
DataRowVersion.Current, ConvertStrToInt(TextPositionDes1.Text));
oneSqlCommand.Parameters.Add(cmdParameter3);
SqlParameter cmdParameter4 = new SqlParameter(
"@CompetitionPositionDes2", SqlDbType.Int, 4,
ParameterDirection.Input, true, 0, 0, "",
DataRowVersion.Current, ConvertStrToInt(TextPositionDes2.Text));
oneSqlCommand.Parameters.Add(cmdParameter4);
SqlParameter cmdParameter5 = new SqlParameter(
"@RegisterID", SqlDbType.Int, 4,
ParameterDirection.Input, true, 0, 0, "",
DataRowVersion.Current, ConvertStrToInt(CmbCompetitor.SelectedValue.ToString()));
oneSqlCommand.Parameters.Add(cmdParameter5);
SqlParameter cmdParameter6 = new SqlParameter(
"@PositionSourceDes", SqlDbType.NVarChar, 100,
ParameterDirection.Input, true, 0, 0, "",
DataRowVersion.Current, TextPositionSourceDes.Text);
oneSqlCommand.Parameters.Add(cmdParameter6);
SqlParameter cmdParameter7 = new SqlParameter(
"@StartPhaseID", SqlDbType.Int, 4,
ParameterDirection.Input, true, 0, 0, "",
DataRowVersion.Current, ConvertStrToInt(CmbStartPhase.SelectedValue.ToString()));
oneSqlCommand.Parameters.Add(cmdParameter7);
SqlParameter cmdParameter8 = new SqlParameter(
"@StartPhasePosition", SqlDbType.Int, 4,
ParameterDirection.Input, true, 0, 0, "",
DataRowVersion.Current, ConvertStrToInt(TextPhasePosition.Text));
oneSqlCommand.Parameters.Add(cmdParameter8);
SqlParameter cmdParameter9 = new SqlParameter(
"@SourcePhaseID", SqlDbType.Int, 4,
ParameterDirection.Input, true, 0, 0, "",
DataRowVersion.Current, ConvertStrToInt(CmbSourcePhase.SelectedValue.ToString()));
oneSqlCommand.Parameters.Add(cmdParameter9);
SqlParameter cmdParameter10 = new SqlParameter(
"@PhaseRank", SqlDbType.Int, 4,
ParameterDirection.Input, true, 0, 0, "",
DataRowVersion.Current, ConvertStrToInt(TextPhaseRank.Text));
oneSqlCommand.Parameters.Add(cmdParameter10);
SqlParameter cmdParameter11 = new SqlParameter(
"@SourceMatchID", SqlDbType.Int, 4,
ParameterDirection.Input, true, 0, 0, "",
DataRowVersion.Current, ConvertStrToInt(CmbSourceMatch.SelectedValue.ToString()));
oneSqlCommand.Parameters.Add(cmdParameter11);
SqlParameter cmdParameter12 = new SqlParameter(
"@MatchRank", SqlDbType.Int, 4,
ParameterDirection.Input, true, 0, 0, "",
DataRowVersion.Current, ConvertStrToInt(TextMatchRank.Text));
oneSqlCommand.Parameters.Add(cmdParameter12);
SqlParameter cmdParameter13 = new SqlParameter(
"@HistoryMatchID", SqlDbType.Int, 4,
ParameterDirection.Input, true, 0, 0, "",
DataRowVersion.Current, ConvertStrToInt(CmbHistoryMatch.SelectedValue.ToString()));
oneSqlCommand.Parameters.Add(cmdParameter13);
SqlParameter cmdParameter14 = new SqlParameter(
"@HistoryMatchRank", SqlDbType.Int, 4,
ParameterDirection.Input, true, 0, 0, "",
DataRowVersion.Current, ConvertStrToInt(TextHistoryMatchRank.Text));
oneSqlCommand.Parameters.Add(cmdParameter14);
SqlParameter cmdParameter15 = new SqlParameter(
"@HistoryLevel", SqlDbType.Int, 4,
ParameterDirection.Input, true, 0, 0, "",
DataRowVersion.Current, ConvertStrToInt(TextHistoryLevel.Text));
oneSqlCommand.Parameters.Add(cmdParameter15);
SqlParameter cmdParameter16 = new SqlParameter(
"@languageCode", SqlDbType.Char, 3,
ParameterDirection.Input, true, 0, 0, "",
DataRowVersion.Current, m_strLanguageCode);
oneSqlCommand.Parameters.Add(cmdParameter16);
SqlParameter cmdParameter17 = new SqlParameter(
"@PositionSourceType", SqlDbType.Int, 4,
ParameterDirection.Input, true, 0, 0, "",
DataRowVersion.Current, m_iPositionSourceType);
oneSqlCommand.Parameters.Add(cmdParameter17);
SqlParameter cmdParameter18 = new SqlParameter(
"@SouceProgressDes", SqlDbType.NVarChar, 100,
ParameterDirection.Input, true, 0, 0, "",
DataRowVersion.Current, TextSourceProgress.Text.ToString());
oneSqlCommand.Parameters.Add(cmdParameter18);
SqlParameter cmdParameter19 = new SqlParameter(
"@ProgressDes", SqlDbType.NVarChar, 100,
ParameterDirection.Input, true, 0, 0, "",
DataRowVersion.Current, TextProgress.Text.ToString());
oneSqlCommand.Parameters.Add(cmdParameter19);
SqlParameter cmdParameterResult = new SqlParameter(
"@Result", SqlDbType.Int, 4,
ParameterDirection.Output, true, 0, 0, "",
DataRowVersion.Current, 0);
oneSqlCommand.Parameters.Add(cmdParameterResult);
if (m_DatabaseConnection.State == System.Data.ConnectionState.Closed)
{
m_DatabaseConnection.Open();
}
if (oneSqlCommand.ExecuteNonQuery() != 0)
{
iOperateResult = (Int32)cmdParameterResult.Value;
switch (iOperateResult)
{
case 0:
DevComponents.DotNetBar.MessageBoxEx.Show(LocalizationRecourceManager.GetString(m_strSectionName, "MsgEditCompetitionPosition1"));
bResult = false;
break;
case -1:
DevComponents.DotNetBar.MessageBoxEx.Show(LocalizationRecourceManager.GetString(m_strSectionName, "MsgEditCompetitionPosition2"));
bResult = false;
break;
default: //其余的需要为修改成功!
if (m_Module != null)
{
m_Module.DataChangedNotify(OVRDataChangedType.emMatchCompetitor, -1, -1, -1, m_iMatchID, m_iCompetitionPosition, null);
}
m_bEditCompetitionPosition = true;
bResult = true;
break;
}
}
}
catch (Exception ex)
{
DevComponents.DotNetBar.MessageBoxEx.Show(ex.Message);
}
return(bResult);
}
private void AddDisciplineVenue(int iDisciplineID, int iVenueID)
{
if (sqlConnection.State == System.Data.ConnectionState.Closed)
{
sqlConnection.Open();
}
try
{
#region DML Command Setup for Add RegisterMember
SqlCommand cmd = new SqlCommand("Proc_AddVenueIntoDiscipline", sqlConnection);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter cmdParameter1 = new SqlParameter(
"@DisciplineID", SqlDbType.Int, 4,
ParameterDirection.Input, false, 0, 0, "@DisciplineID",
DataRowVersion.Current, iDisciplineID);
SqlParameter cmdParameter2 = new SqlParameter(
"@VenueID", SqlDbType.Int, 4,
ParameterDirection.Input, false, 0, 0, "@VenueID",
DataRowVersion.Default, iVenueID);
SqlParameter cmdParameterResult = new SqlParameter(
"@Result", SqlDbType.Int, 4,
ParameterDirection.Output, false, 0, 0, "@Result",
DataRowVersion.Default, DBNull.Value);
cmd.Parameters.Add(cmdParameter1);
cmd.Parameters.Add(cmdParameter2);
cmd.Parameters.Add(cmdParameterResult);
cmd.UpdatedRowSource = UpdateRowSource.OutputParameters;
#endregion
cmd.ExecuteNonQuery();
int nRetValue = (int)cmd.Parameters["@Result"].Value;
string strPromotion;
switch (nRetValue)
{
case 0:
strPromotion = LocalizationRecourceManager.GetString(this.Name, "AddDisVenue_Failed");
DevComponents.DotNetBar.MessageBoxEx.Show(strPromotion);
break;
case -1:
strPromotion = LocalizationRecourceManager.GetString(this.Name, "AddDisVenue_FailedForDis");
DevComponents.DotNetBar.MessageBoxEx.Show(strPromotion);
break;
case -2:
strPromotion = LocalizationRecourceManager.GetString(this.Name, "AddDisVenue_FailedForVenue");
DevComponents.DotNetBar.MessageBoxEx.Show(strPromotion);
break;
case -3:
strPromotion = LocalizationRecourceManager.GetString(this.Name, "AddDisVenue_FailedForExists");
DevComponents.DotNetBar.MessageBoxEx.Show(strPromotion);
break;
default:
if (module != null)
{
module.DataChangedNotify(OVRDataChangedType.emVenueAdd, iDisciplineID, -1, -1, -1, iVenueID, null);
}
break;
}
}
catch (System.Exception e)
{
DevComponents.DotNetBar.MessageBoxEx.Show(e.Message);
}
}