private void Populate_Boat_Dropdown()
{
try
{
SqlConnection con = new SqlConnection(strCon);
if (con.State == System.Data.ConnectionState.Closed) //Make sure the connection is open.
{
con.Open();
}
//Create the command (Is it possible to simply write a function name here?)
SqlCommand cmd = new SqlCommand("EXEC uspGetBoats @UserId ", con);
//Define the variables in the SqlCommand
cmd.Parameters.AddWithValue("@UserId", Session["UserId"]);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count < 1)
{
DropDown_Boat.Items.Add(new ListItem("New Boat"));
Response.Write("<script>alert('No boats found');</script>");
}
else
{
DropDown_Boat.DataSource = dt;
DropDown_Boat.DataValueField = "BoatId";
DropDown_Boat.DataTextField = "BoatName";
}
DropDown_Boat.DataBind();
con.Close();
}
catch (Exception ex)
{
Response.Write("<script>alert('" + ex.Message + "');</script>");
throw;
}
}
private void Populate_User_Settings()
{
try
{
SqlConnection con = new SqlConnection(strCon);
if (con.State == System.Data.ConnectionState.Closed) //Make sure the connection is open.
{
con.Open();
}
//Create the command (Is it possible to simply write a function name here?)
SqlCommand cmd = new SqlCommand("EXEC uspGetUser @UserId ", con);
//Define the variables in the SqlCommand
cmd.Parameters.AddWithValue("@UserId", Session["UserId"]);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count < 1)
{
Response.Write("<script>alert('No User found');</script>");
}
else
{
TextBox_FirstName.Text = dt.Rows[0]["FirstName"].ToString();
TextBox_LastName.Text = dt.Rows[0]["LastName"].ToString();
TextBox_Email.Text = dt.Rows[0]["Email"].ToString();
}
DropDown_Boat.DataBind();
con.Close();
}
catch (Exception ex)
{
Response.Write("<script>alert('" + ex.Message + "');</script>");
throw;
}
}