public BaseForm(SqlConnection cn, string competitionTitle, String baseResourceFile = "ClimbingCompetition.ListHeaderStrings")
: this(baseResourceFile)
{
this.cTitle = competitionTitle;
if (cn == null || cn.ConnectionString == "")
{
cr = SpeedRules.DefaultAll;
return;
}
con = new SqlConnection(cn.ConnectionString);
try { con.Open(); }
catch (Exception ex) { MessageBox.Show("Невозможно открыть соединение:\r\n" + ex.Message); }
try
{
cr = SortingClass.GetCompRules(this.cn, false);
bool leaveTrains = SettingsForm.GetLeaveTrains(this.cn);
if (leaveTrains)
{
cr = cr | SpeedRules.InternationalRules;
}
else
{
cr = cr & (~SpeedRules.InternationalRules);
}
}
catch (Exception ex)
{
cr = SpeedRules.DefaultAll;
MessageBox.Show("Невозможно определить правила проведения соревнований:\r\n"
+ ex.Message + "\r\nБудут использоваться российские правила");
}
}
public static bool SetCompRules(SpeedRules value, SqlConnection cn, SqlTransaction tran = null)
{
SqlConnection cnToUse = (tran == null) ? cn : tran.Connection;
SortingClass.CheckColumn("CompetitionData", "SpeedRulesGeneral", "INT NOT NULL DEFAULT " +
((int)SpeedRules.DefaultAll).ToString(), cnToUse, tran);
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = cnToUse;
cmd.Transaction = tran;
cmd.CommandText = String.Format("UPDATE CompetitionData SET SpeedRulesGeneral = {0}", ((int)value));
cmd.ExecuteNonQuery();
return(true);
}
}
public static void SetSpeedRules(SpeedRules value, SqlConnection cn, SqlTransaction tran = null)
{
SortingClass.SetCompRules(value, cn, tran);
}
