private static bool GetBooleanParam(SqlConnection cn, SqlTransaction tran, string columnName, bool defaultValue) { string def; if (defaultValue) { def = "1"; } else { def = "0"; } if (!SortingClass.CheckColumn("CompetitionData", columnName, "BIT NOT NULL DEFAULT " + def, cn, tran)) { return(defaultValue); } SqlCommand cmd = new SqlCommand(); cmd.Connection = cn; cmd.Transaction = tran; cmd.CommandText = "SELECT " + columnName + " FROM CompetitionData(NOLOCK)"; try { return(Convert.ToBoolean(cmd.ExecuteScalar())); } catch { cmd.CommandText = "UPDATE CompetitionData SET " + columnName + " = " + def; cmd.ExecuteNonQuery(); return(defaultValue); } }
//protected override void GetFormDataKeys(out string typeName, out string hostName) //{ // String sTypeName; // base.GetFormDataKeys(out sTypeName, out hostName); // typeName = String.Format("{0}.{1}", sTypeName, list_id); // if (typeName.Length > BaseForm.FORM_CLASS_FIELD_LENGTH) // typeName = typeName.Substring(0, BaseForm.FORM_CLASS_FIELD_LENGTH); //} protected string GetListOwner() { if (cn == null || cn.ConnectionString.Length < 1) { return(""); } try { if (cn.State != ConnectionState.Open) { cn.Open(); } SortingClass.CheckColumn("lists", "IsLocked", "VARCHAR(255) NULL", cn); SqlCommand cmd = new SqlCommand(); cmd.Connection = cn; cmd.CommandText = "SELECT IsLocked FROM lists WHERE iid=" + listID.ToString(); object oTmp = cmd.ExecuteScalar(); if (oTmp == null || oTmp == DBNull.Value) { return(""); } return(oTmp.ToString()); } catch { return(""); } }
public static void CheckGlobalIDColumns(SqlConnection cn) { SortingClass.CheckColumn("Participants", "global_climber_id", "NVARCHAR(50) NULL", cn); SortingClass.CheckColumn("Participants", "global_app_id", "NVARCHAR(50) NULL", cn); SortingClass.CheckColumn("Groups", "global_group_id", "NVARCHAR(50) NULL", cn); SortingClass.CheckColumn("Teams", "global_team_id", "NVARCHAR(50) NULL", cn); }
public static SpeedSystemType GetCurrentSystem(SqlConnection cn) { if (!SortingClass.CheckColumn("CompetitionData", "SpeedType", "VARCHAR(3) NOT NULL DEFAULT '" + SpeedSystemType.EKB.ToString() + "'", cn)) { return(SpeedSystemType.EKB); } SqlCommand cmd = new SqlCommand(); cmd.Connection = cn; cmd.CommandText = "SELECT SpeedType FROM CompetitionData(NOLOCK)"; string str = cmd.ExecuteScalar().ToString(); try { #if FULL return((SpeedSystemType)Enum.Parse(typeof(SpeedSystemType), str, true)); #else SpeedSystemType st = (SpeedSystemType)Enum.Parse(typeof(SpeedSystemType), str, true); if (st == SpeedSystemType.IVN) { throw new Exception(); } return(st); #endif } catch { cmd.CommandText = "UPDATE CompetitionData SET SpeedType = '" + SpeedSystemType.EKB.ToString() + "'"; cmd.ExecuteNonQuery(); return(SpeedSystemType.EKB); } }
public static void SetFlashShowMode(FlashShowMode val, SqlConnection cn) { SortingClass.CheckColumn("CompetitionData", "FlashShowMode", "VARCHAR(3) NOT NULL DEFAULT '" + FlashShowMode.NOT.ToString() + "'", cn); SqlCommand cmd = new SqlCommand(); cmd.Connection = cn; cmd.CommandText = "UPDATE CompetitionData SET FlashShowMode='" + val.ToString() + "'"; cmd.ExecuteNonQuery(); }
public static void SetAutoNum(AutoNum val, SqlConnection cn) { SortingClass.CheckColumn("CompetitionData", "AutoNum", "VARCHAR(3) NOT NULL DEFAULT '" + AutoNum.GRP.ToString() + "'", cn); SqlCommand cmd = new SqlCommand(); cmd.Connection = cn; cmd.CommandText = "UPDATE CompetitionData SET AutoNum='" + val.ToString() + "'"; cmd.ExecuteNonQuery(); }
private static void SetIntParam(SqlConnection cn, SqlTransaction tran, string columnName, int val, int defaultValue) { SortingClass.CheckColumn("CompetitionData", columnName, "INT NOT NULL DEFAULT " + defaultValue.ToString(), cn, tran); SqlCommand cmd = new SqlCommand(); cmd.Connection = cn; cmd.Transaction = tran; cmd.CommandText = "UPDATE CompetitionData SET " + columnName + "=" + val.ToString(); cmd.ExecuteNonQuery(); }
public OnlineBroadcast(/*string remoteConn,*/ SqlConnection localBaseCon, MainForm parent) : base(localBaseCon, parent.competitionTitle, null) { InitializeComponent(); this.parent = parent; //this.cn = cn; //XmlClientWrapper wrapper; //compForService = StaticClass.ParseServString(remoteConn, out wrapper); //if (wrapper != null) //{ // client = wrapper.CreateClient(cn); // compForService = wrapper.CompetitionId; // remoteConnection = null; //} //else if (compForService == null) // remoteConnection = new SqlConnection(remoteConn); //else // remoteConn = null; ////if (this.cn.State != ConnectionState.Open) //// this.cn.Open(); SortingClass.CheckColumn("Participants", "changed", "BIT NOT NULL DEFAULT 1", this.cn); SortingClass.CheckColumn("lists", "changed", "BIT NOT NULL DEFAULT 1", this.cn); SortingClass.CheckColumn("routeResults", "changed", "BIT NOT NULL DEFAULT 1", this.cn); SortingClass.CheckColumn("speedResults", "changed", "BIT NOT NULL DEFAULT 1", this.cn); SortingClass.CheckColumn("boulderResults", "changed", "BIT NOT NULL DEFAULT 1", this.cn); StaticClass.CheckChangedTriggers(this.cn); da = new SqlDataAdapter(new SqlCommand( "SELECT l.iid AS [№],l.style AS Вид,g.name AS Группа,l.round AS Раунд, " + "l.routeNumber AS [Число трасс], " + "l.online AS [Доступ на сайте],l.allowView AS [Прямая трансляция], g.iid gr_id " + "FROM lists l(NOLOCK) INNER JOIN groups g(NOLOCK) ON l.group_id=g.iid " + #if FULL " WHERE l.style IN ('Трудность','Скорость','Боулдеринг') " + #else " WHERE l.style = 'Скорость' " + #endif "ORDER BY " + "l.iid DESC", this.cn)); try { da.Fill(dt); } catch { } dg.DataSource = dt; dg.Columns["gr_id"].Visible = false; da.UpdateCommand = new SqlCommand("UPDATE lists SET online=@onl WHERE iid=@iid", this.cn); da.UpdateCommand.Parameters.Add("@onl", SqlDbType.Bit, 1, "Доступ на сайте"); da.UpdateCommand.Parameters.Add("@iid", SqlDbType.Int, 4, "№"); try { dg.Columns["Прямая трансляция"].ReadOnly = true; } catch { } #if !DEBUG cbLoadJudges.Visible = false; #endif }
public static SpeedRules GetCompRules(SqlConnection cn, SqlTransaction tran = null) { SqlConnection cnToUse = (tran == null ? cn : tran.Connection); SortingClass.CheckColumn("CompetitionData", "SpeedRulesGeneral", String.Format("INT NOT NULL DEFAULT {0}", (int)SpeedRules.DefaultAll), cnToUse, tran); using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = cnToUse; cmd.Transaction = tran; cmd.CommandText = "SELECT SpeedRulesGeneral FROM CompetitionData(NOLOCK)"; return(GetEnumValueFromObject <SpeedRules, int>(cmd.ExecuteScalar(), SpeedRules.DefaultAll)); } }
public static void SetCurrentSystem(SpeedSystemType val, SqlConnection cn) { SortingClass.CheckColumn("CompetitionData", "SpeedType", "VARCHAR(3) NOT NULL DEFAULT '" + SpeedSystemType.EKB.ToString() + "'", cn); SqlCommand cmd = new SqlCommand(); cmd.Connection = cn; #if FULL cmd.CommandText = "UPDATE CompetitionData SET SpeedType='" + val.ToString() + "'"; #else SpeedSystemType sVal = (val == SpeedSystemType.IVN) ? SpeedSystemType.EKB : val; cmd.CommandText = "UPDATE CompetitionData SET SpeedType='" + sVal.ToString() + "'"; #endif cmd.ExecuteNonQuery(); }
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); } }
private static void SetStringParam(SqlConnection cn, SqlTransaction tran, string columnName, string val, string defaultValue = null) { SortingClass.CheckColumn("CompetitionData", columnName, "VARCHAR(4096) DEFAULT " + (defaultValue == null ? "NULL" : "'" + defaultValue + "'"), cn, tran); SqlCommand cmd = new SqlCommand(); cmd.Connection = cn; cmd.Transaction = tran; cmd.CommandText = "UPDATE CompetitionData SET " + columnName + " = @val"; cmd.Parameters.Add("@val", SqlDbType.VarChar, 4096); if (val == null) { cmd.Parameters[0].Value = DBNull.Value; } else { cmd.Parameters[0].Value = val; } cmd.ExecuteNonQuery(); }
private static void SetBooleanParam(bool val, SqlConnection cn, string columnName, bool defaultValue) { string def; if (defaultValue) { def = "1"; } else { def = "0"; } SortingClass.CheckColumn("CompetitionData", columnName, "BIT NOT NULL DEFAULT " + def, cn); SqlCommand cmd = new SqlCommand("UPDATE CompetitionData SET " + columnName + " = @s", cn); cmd.Parameters.Add("@s", SqlDbType.Bit); cmd.Parameters[0].Value = val; cmd.ExecuteNonQuery(); }
public static FlashShowMode GetFlashShowMode(SqlConnection cn, SqlTransaction tran) { if (!SortingClass.CheckColumn("CompetitionData", "FlashShowMode", "VARCHAR(3) NOT NULL DEFAULT '" + FlashShowMode.NOT.ToString() + "'", cn, tran)) { return(FlashShowMode.NOT); } SqlCommand cmd = new SqlCommand(); cmd.Connection = cn; cmd.Transaction = tran; cmd.CommandText = "SELECT FlashShowMode FROM CompetitionData(NOLOCK)"; string str = cmd.ExecuteScalar().ToString(); try { return((FlashShowMode)Enum.Parse(typeof(FlashShowMode), str, true)); } catch { cmd.CommandText = "UPDATE CompetitionData SET FlashShowMode = '" + FlashShowMode.NOT.ToString() + "'"; cmd.ExecuteNonQuery(); return(FlashShowMode.NOT); } }
public static AutoNum GetAutoNum(SqlConnection cn, SqlTransaction tran) { if (!SortingClass.CheckColumn("CompetitionData", "AutoNum", "VARCHAR(3) NOT NULL DEFAULT '" + AutoNum.GRP.ToString() + "'", cn, tran)) { return(AutoNum.GRP); } SqlCommand cmd = new SqlCommand(); cmd.Connection = cn; cmd.Transaction = tran; cmd.CommandText = "SELECT AutoNum FROM CompetitionData(NOLOCK)"; string str = cmd.ExecuteScalar().ToString(); try { return((AutoNum)Enum.Parse(typeof(AutoNum), str, true)); } catch { cmd.CommandText = "UPDATE CompetitionData SET AutoNum = '" + AutoNum.GRP + "'"; cmd.ExecuteNonQuery(); return(AutoNum.GRP); } }
private static string GetStringParam(SqlConnection cn, SqlTransaction tran, string columnName, string defaultValue) { if (!SortingClass.CheckColumn("CompetitionData", columnName, "VARCHAR(4096) DEFAULT " + (defaultValue == null ? "NULL" : "'" + defaultValue + "'"), cn, tran)) { return(defaultValue); } SqlCommand cmd = new SqlCommand(); cmd.Connection = cn; cmd.Transaction = tran; cmd.CommandText = "SELECT " + columnName + " FROM CompetitionData"; object oTmp = cmd.ExecuteScalar(); if (oTmp == null || oTmp == DBNull.Value) { return(String.Empty); } else { return(oTmp.ToString()); } }
protected void SetLock(bool setLock) { if (cn == null || cn.ConnectionString.Length < 1) { return; } try { if (listID < 1 || listID == EMPTY_LIST) { return; } SortingClass.CheckColumn("lists", "IsLocked", "VARCHAR(255) NULL", cn); SqlCommand cmd = new SqlCommand(); cmd.Connection = cn; cmd.CommandText = "UPDATE lists SET IsLocked = " + (setLock ? "'" + HostName + "'" : "NULL") + " WHERE iid = " + listID.ToString(); cmd.ExecuteNonQuery(); this.lockSet = setLock; } catch { } }
private SecurityOperations(SqlConnection _cn, bool show, bool newCn) { if (newCn) { this.ownConnection = true; this.cn = new SqlConnection(_cn.ConnectionString); this.cn.Open(); } else { this.ownConnection = false; this.cn = _cn; } SortingClass.CheckColumn("CompetitionData", "signature", "image null", cn); SortingClass.CheckColumn("CompetitionData", "opwd", "image null", cn); SortingClass.CheckColumn("CompetitionData", "touse", "smallint not null default 0", cn); if (show) { InitializeComponent(); } }
//public static bool GetUseBestSpeed(SqlConnection cn, SqlTransaction tran = null) //{ // return GetBooleanParam(cn, tran, "BestSpeed", false); //} //public static void SetUseBestSpeed(bool val, SqlConnection cn) //{ // SetBooleanParam(val, cn, "BestSpeed", false); //} //public static bool GetUseBestQf(SqlConnection cn) //{ // return GetUseBestQf(cn, null); //} //public static bool GetUseBestQf(SqlConnection cn, SqlTransaction tran) //{ // return GetBooleanParam(cn, tran, "UseBestQf", false); //} //public static void SetUseBestQf(bool val, SqlConnection cn) //{ // SetBooleanParam(val, cn, "UseBestQf", false); //} private static int GetIntParam(SqlConnection cn, SqlTransaction tran, string columnName, int defaultValue) { if (!SortingClass.CheckColumn("CompetitionData", columnName, "INT NOT NULL DEFAULT " + defaultValue.ToString(), cn, tran)) { return(defaultValue); } SqlCommand cmd = new SqlCommand(); cmd.Connection = cn; cmd.Transaction = tran; cmd.CommandText = "SELECT " + columnName + " FROM CompetitionData"; object oTmp = cmd.ExecuteScalar(); if (oTmp == null || oTmp == DBNull.Value) { cmd.CommandText = "UPDATE CompetitionData SET " + columnName + "=" + defaultValue.ToString(); cmd.ExecuteNonQuery(); return(defaultValue); } else { return(Convert.ToInt32(oTmp)); } }
public SelectTeamType(SqlConnection baseCon, int list_id, string competitionTitle) : base(baseCon, competitionTitle) { // // Required for Windows Form Designer support // InitializeComponent(); rbGroup.Checked = true; this.list_id = list_id; //this.cn = cn; //if (this.cn.State != System.Data.ConnectionState.Open) // cn.Open(); SqlCommand cmd = new SqlCommand("SELECT style FROM lists(NOLOCK) WHERE iid = " + list_id.ToString(), cn); style = cmd.ExecuteScalar().ToString(); switch (style) { case "��������� - ��": this.tRes.lead = true; this.tRes.speed = this.tRes.boulder = false; break; case "��������� - �": this.tRes.boulder = true; this.tRes.speed = this.tRes.lead = false; break; case "��������� - ��": this.tRes.speed = true; this.tRes.boulder = this.tRes.lead = false; break; #if !FULL case "���������": goto case "��������� - ��"; #endif default: cmd.CommandText = "SELECT COUNT(*) FROM lists(NOLOCK) WHERE style = '���������' AND round = '�������� ��������'"; tRes.lead = (Convert.ToInt32(cmd.ExecuteScalar()) > 0); cmd.CommandText = "SELECT COUNT(*) FROM lists(NOLOCK) WHERE style = '��������' AND round = '�������� ��������'"; tRes.speed = (Convert.ToInt32(cmd.ExecuteScalar()) > 0); cmd.CommandText = "SELECT COUNT(*) FROM lists(NOLOCK) WHERE style = '����������' AND round = '�������� ��������'"; tRes.boulder = (Convert.ToInt32(cmd.ExecuteScalar()) > 0); break; } double coef2ndTeam = 1.0; try { SortingClass.CheckColumn("lists_hdr2", "coef2ndTeam", "FLOAT NOT NULL DEFAULT 1.0", cn); cmd.CommandText = "SELECT use_group, male, female, coef2ndTeam FROM lists_hdr2(NOLOCK) WHERE list_id = " + list_id.ToString(); using (SqlDataReader rdr = cmd.ExecuteReader()) { if (rdr.Read()) { bool b = Convert.ToBoolean(rdr[0]); rbGroup.Checked = b; radioButton1.Checked = !b; int nMale = Convert.ToInt32(rdr[1]); if (b) { nM.Text = nMale.ToString(); nF.Text = rdr[2].ToString(); } else { nG.Text = nMale.ToString(); } coef2ndTeam = Convert.ToDouble(rdr["coef2ndTeam"]); } } } catch { try { cmd.CommandText = "CREATE TABLE [dbo].[lists_hdr2] (" + " [list_id] [int] NOT NULL ," + " [use_group] [bit] NOT NULL ," + " [male] [int] NOT NULL ," + " [female] [int] NULL ," + " [coef2ndTeam] FLOAT NOT NULL DEFAULT 1.0," + " CONSTRAINT [PK_lists_hdr2] PRIMARY KEY CLUSTERED " + " (" + " [list_id]"+ " ) ON [PRIMARY] ," + " CONSTRAINT [FK_lists_hdr2_lists] FOREIGN KEY " + " (" + " [list_id]"+ " ) REFERENCES [dbo].[lists] (" + " [iid]"+ " ) ON DELETE CASCADE ON UPDATE CASCADE" + ")"; cmd.ExecuteNonQuery(); } catch { } } tRes.Qf2nd = coef2ndTeam; tbCoef.Text = coef2ndTeam.ToString("0.0#"); // // TODO: Add any constructor code after InitializeComponent call // }