public List<BookingHistoryByCat> PopulateDropDownlist()
{
List<BookingHistoryByCat> categoryList=new List<BookingHistoryByCat>();
SqlConnection connection =new SqlConnection(connectionString);
string query = "Select distinct Category From Facilities";
SqlCommand command=new SqlCommand(query,connection);
SqlDataReader reader;
connection.Open();
reader = command.ExecuteReader();
BookingHistoryByCat category = new BookingHistoryByCat();
category.Category = "Select";
categoryList.Add(category);
while (reader.Read())
{
category=new BookingHistoryByCat();
category.Category = reader["Category"].ToString();
categoryList.Add(category);
}
connection.Close();
return categoryList;
}
public List<BookingHistoryByCat> PopulateGridviewByAll()
{
List<BookingHistoryByCat> categoryList = new List<BookingHistoryByCat>();
SqlConnection connection = new SqlConnection(connectionString);
string query = string.Format("select BookDate,Category,CatName,ASubject,OrgName,StartDate," +
"EndDate,TimeSlot " +
"from Booking_Det");
SqlCommand command = new SqlCommand(query, connection);
SqlDataReader reader;
connection.Open();
reader = command.ExecuteReader();
while (reader.Read())
{
BookingHistoryByCat category = new BookingHistoryByCat();
category.BookingDate = reader.GetValue(0).ToString();
category.Category = reader.GetValue(1).ToString();
category.CatName = reader.GetValue(2).ToString();
category.Subject = reader.GetValue(3).ToString();
category.StartDate = reader.GetValue(4).ToString();
category.EndDate = reader.GetValue(5).ToString();
category.TimeSlot = reader.GetValue(6).ToString();
categoryList.Add(category);
}
connection.Close();
return categoryList;
}