private Camp GetCamp(string campId)
{
using (SqlConnection conn = new SqlConnection(Config.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = PROCEDURE_GET_CAMP;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@c_id", campId);
conn.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (!reader.HasRows)
{
// throw exception
}
var camps = new List <Camp>();
while (reader.Read())
{
Camp camp = new Camp();
camp.Id = Convert.ToInt32(reader["Id"].ToString());
camp.CampName = reader["CampName"].ToString();
camp.CampLocation = reader["CampLocation"].ToString();
CampMaster campMaster = new CampMaster();
campMaster.FirstName = reader["FirstName"].ToString();
campMaster.LastName = reader["LastName"].ToString();
campMaster.Email = reader["Email"].ToString();
camp.CampMaster = campMaster;
camps.Add(camp);
}
return(camps.FirstOrDefault());
}
}
}
/// <summary>
/// Gets the list of camps for the registration page.
/// </summary>
/// <returns>A list of camps.</returns>
public IList <Camp> GetCamps()
{
using (SqlConnection conn = new SqlConnection(Config.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = PROCEDURE_GET_CAMPS;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = conn;
conn.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (!reader.HasRows)
{
// throw exception
}
var camps = new List <Camp>();
while (reader.Read())
{
Camp camp = new Camp();
camp.Id = Convert.ToInt32(reader["Id"].ToString());
camp.CampName = reader["CampName"].ToString();
camp.CampLocation = reader["CampLocation"].ToString();
CampMaster campMaster = new CampMaster();
campMaster.FirstName = reader["FirstName"].ToString();
campMaster.LastName = reader["LastName"].ToString();
campMaster.CharacterName = reader["CharacterName"].ToString();
camp.CampMaster = campMaster;
camps.Add(camp);
}
return(camps);
}
}
}
