public List <TopSach> layDanhSachTop10Sach(DateTime start, DateTime end) { List <TopSach> dsSach = new List <TopSach>(); openConnection(); SqlCommand command = new SqlCommand(); command.CommandType = CommandType.StoredProcedure; command.CommandText = "PROC_TOP10TL"; command.Parameters.Add("@START", SqlDbType.Date).Value = start; command.Parameters.Add("@END", SqlDbType.Date).Value = end; command.Connection = conn; SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { string ten = reader.GetString(0); string tenTLoai = reader.GetString(1); int sl = reader.GetInt32(2); string ghiChu = reader.GetString(3); TopSach topSach = new TopSach(ten, tenTLoai, sl, ghiChu); dsSach.Add(topSach); } reader.Close(); return(dsSach); }
public List <TopSach> layDanhSachTop10Sach() { List <TopSach> dsSach = new List <TopSach>(); openConnection(); SqlCommand command = new SqlCommand(); command.CommandType = CommandType.StoredProcedure; command.CommandText = "PROC_TOP10"; command.Connection = conn; SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { string ten = reader.GetString(0); string tenTLoai = reader.GetString(1); int sl = reader.GetInt32(2); string ghiChu = reader.GetString(3); TopSach topSach = new TopSach(ten, tenTLoai, sl, ghiChu); dsSach.Add(topSach); } reader.Close(); return(dsSach); }