public static bool InsertStream(TStream stream)
{
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["SQL Server"].ConnectionString);
SqlCommand cmd = new SqlCommand("createNewStream", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@StreamName", SqlDbType.VarChar).Value = stream.StreamName;
cmd.Parameters.Add("@StreamPoints", SqlDbType.Int).Value = stream.StreamRank;
cmd.Parameters.Add("@StreamIsBanned", SqlDbType.Bit).Value = stream.StreamIsBanned;
try
{
cn.Open();
cmd.ExecuteNonQuery();
}
catch (Exception exc)
{
exc.ToString();
}
finally
{
cn.Close();
}
return(false);
}
private void DisplayPopularStreams()
{
App_Code.TStream streams = new App_Code.TStream();
DataTable dt = App_Code.TStream.getPopularStreams();
btnStream1.Text = dt.Rows[0]["StreamName"].ToString();
btnStream2.Text = dt.Rows[1]["StreamName"].ToString();
btnStream3.Text = dt.Rows[2]["StreamName"].ToString();
btnStream4.Text = dt.Rows[3]["StreamName"].ToString();
btnStream5.Text = dt.Rows[4]["StreamName"].ToString();
btnStream6.Text = dt.Rows[5]["StreamName"].ToString();
selectedStream = btnStream1.Text;
hfStreamName.Value = selectedStream;
}
public static bool UpdateStreamInfo(TStream stream)
{
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["SQL Server"].ConnectionString);
SqlCommand cmd = new SqlCommand("updateStreamByStreamID", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@StreamID", SqlDbType.Int).Value = stream.StreamID;
cmd.Parameters.Add("@StreamName", SqlDbType.VarChar).Value = stream.StreamName;
cmd.Parameters.Add("@StreamPoints", SqlDbType.Int).Value = stream.StreamRank;
cmd.Parameters.Add("@StreamIsBanned", SqlDbType.Bit).Value = stream.StreamIsBanned;
// Open the database connection and execute the command
try
{
//opens connection to database, most failures happen here
//check connection string for proper settings
cn.Open();
//data adapter object is trasport link between data source and
//execute the non-query stored procedure
cmd.ExecuteNonQuery();
//id = Convert.ToInt32(cmd.Parameters["@BattleID"].Value);
}
catch (Exception exc)
{
//just put here to make debugging easier, can look at error directly
exc.ToString();
}
finally
{
//must always close connections
cn.Close();
}
bool isUpdated = false;
return(isUpdated);
}