public List <BaiViet> GetList(string TieuDe, string NgayDangMin, string NgayDangMax, byte ChuDeID, int LopHocID) { SqlConnection con = db.getConnection(); List <BaiViet> l_BaiViet = new List <BaiViet>(); try { SqlCommand cmd = new SqlCommand("BaiViet_timkiem"); cmd.Connection = con; con.Open(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@TieuDe", TieuDe)); cmd.Parameters.Add(new SqlParameter("@NgayDangMin", NgayDangMin)); cmd.Parameters.Add(new SqlParameter("@NgayDangMax", NgayDangMax)); cmd.Parameters.Add(new SqlParameter("@ChuDeID", ChuDeID)); cmd.Parameters.Add(new SqlParameter("@lophocid", LopHocID)); SqlDataReader reader = cmd.ExecuteReader(); SmartDataReader smartReader = new SmartDataReader(reader); while (smartReader.Read()) { BaiViet bv = new BaiViet(); bv.ID = smartReader.GetInt32("ID"); bv.TieuDe = smartReader.GetString("TieuDe"); bv.NgayDang = smartReader.GetString("NgayDang"); bv.LuotXem = smartReader.GetInt32("LuotXem"); bv.TenChuDe = smartReader.GetString("TenChuDe"); bv.URL = smartReader.GetString("URL"); bv.IP = smartReader.GetString("IP"); bv.LopHocID = smartReader.GetInt32("lophocid"); l_BaiViet.Add(bv); } smartReader.disposeReader(reader); } catch (Exception ex) { throw ex; } finally { db.closeConnection(con); } return(l_BaiViet); }
public BaiViet FindByID(int ID) { BaiViet bv = new BaiViet(); SqlConnection con = db.getConnection(); try { SqlCommand cmd = new SqlCommand("BaiViet_chitiet"); cmd.Connection = con; con.Open(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@ID", ID)); SqlDataReader reader = cmd.ExecuteReader(); SmartDataReader smartReader = new SmartDataReader(reader); while (smartReader.Read()) { bv.ID = smartReader.GetInt32("ID"); bv.TieuDe = smartReader.GetString("TieuDe"); bv.SoLuoc = smartReader.GetString("SoLuoc"); bv.NoiDung = smartReader.GetString("NoiDung"); bv.NgayDang = smartReader.GetString("NgayDang"); bv.IP = smartReader.GetString("IP"); bv.LuotXem = smartReader.GetInt32("LuotXem"); bv.TenChuDe = smartReader.GetString("TenChuDe"); bv.URL = smartReader.GetString("URL"); bv.ChuDeID = smartReader.GetByte("ChuDeID"); bv.AnhID = smartReader.GetInt32("AnhID"); bv.LopHocID = smartReader.GetInt32("lophocid"); } smartReader.disposeReader(reader); } catch (Exception ex) { throw ex; } finally { db.closeConnection(con); } return(bv); }
public List <BaiViet> GetPaginationList(short pageNum, short limitPerPage, byte ChuDeID, int LopHocID) { SqlConnection con = db.getConnection(); List <BaiViet> l_BaiViet = new List <BaiViet>(); try { SqlCommand cmd = new SqlCommand("BaiViet_timKiemPhanTrang"); cmd.Connection = con; con.Open(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Page", pageNum)); cmd.Parameters.Add(new SqlParameter("@Limit", limitPerPage)); cmd.Parameters.Add(new SqlParameter("@ChuDeID", ChuDeID)); cmd.Parameters.Add(new SqlParameter("@lophocid", LopHocID)); SqlDataReader reader = cmd.ExecuteReader(); SmartDataReader smartReader = new SmartDataReader(reader); while (smartReader.Read()) { BaiViet bv = new BaiViet(); bv.ID = smartReader.GetInt32("ID"); bv.TieuDe = smartReader.GetString("TieuDe"); bv.SoLuoc = smartReader.GetString("SoLuoc"); bv.URL = smartReader.GetString("URL"); bv.LopHocID = smartReader.GetInt32("lophocid"); l_BaiViet.Add(bv); } smartReader.disposeReader(reader); } catch (Exception ex) { throw ex; } finally { db.closeConnection(con); } return(l_BaiViet); }
public List <BaiViet> GetRecentList() { SqlConnection con = db.getConnection(); List <BaiViet> l_BaiViet = new List <BaiViet>(); try { SqlCommand cmd = new SqlCommand("BaiViet_timKiemGanNhat"); cmd.Connection = con; con.Open(); cmd.CommandType = CommandType.StoredProcedure; SqlDataReader reader = cmd.ExecuteReader(); SmartDataReader smartReader = new SmartDataReader(reader); while (smartReader.Read()) { BaiViet bv = new BaiViet(); bv.ID = smartReader.GetInt32("ID"); bv.TieuDe = smartReader.GetString("TieuDe"); bv.NgayDang = smartReader.GetString("NgayDang"); bv.SoLuoc = smartReader.GetString("SoLuoc"); bv.URL = smartReader.GetString("URL"); bv.LopHocID = smartReader.GetInt32("lophocid"); l_BaiViet.Add(bv); } smartReader.disposeReader(reader); } catch (Exception ex) { throw ex; } finally { db.closeConnection(con); } return(l_BaiViet); }