public static FitnessClassCollection GetCollection()
{
FitnessClassCollection tempList = null;
using (SqlConnection myConnection = new SqlConnection(AppConfiguration.ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("usp_GetFitnessClass", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.AddWithValue("@QueryId", SelectTypeEnum.GetCollection);
myConnection.Open();
using (SqlDataReader myReader = myCommand.ExecuteReader())
{
if (myReader.HasRows)
{
tempList = new FitnessClassCollection();
while (myReader.Read())
{
tempList.Add(FillDataRecord(myReader));
}
}
myReader.Close();
}
}
}
return(tempList);
}
private void BindFitnessClass()
{
FitnessClassCollection fitnessList = new FitnessClassCollection();
fitnessList = FitnessClassDAL.GetCollection();
rptFitnessClassList.DataSource = fitnessList;
rptFitnessClassList.DataBind();
}
private FitnessClassDTOCollection FitnessClassCollectionToDTO(FitnessClassCollection fitnessClassCollection)
{
FitnessClassDTOCollection tempList = new FitnessClassDTOCollection();
if (fitnessClassCollection != null)
{
foreach (FitnessClass item in fitnessClassCollection)
{
//Call a method to convert FitnessClass to FitnessClassDTO and add to collection
tempList.Add(this.FitnessClassItemToDTO(item));
}
}
return(tempList);
}
public FitnessClassDTOCollection GetFitnessClassesByInstructor(string instructorId)
{
FitnessClassCollection list = FitnessClassManager.GetCollection(instructorId.ToInt());
return(this.FitnessClassCollectionToDTO(list));
}
public FitnessClassDTOCollection GetFitnessClasses()
{
FitnessClassCollection fitnessClassList = FitnessClassManager.GetCollection();
return(this.FitnessClassCollectionToDTO(fitnessClassList));
}
