public List <PhanHoi> GetList(string IP, string HienThi)
{
SqlConnection con = db.getConnection();
List <PhanHoi> l_PhanHoi = new List <PhanHoi>();
try
{
SqlCommand cmd = new SqlCommand("PhanHoi_timkiem");
cmd.Connection = con;
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@IP", IP));
cmd.Parameters.Add(new SqlParameter("@HienThi", HienThi));
SqlDataReader reader = cmd.ExecuteReader();
SmartDataReader smartReader = new SmartDataReader(reader);
while (smartReader.Read())
{
PhanHoi ph = new PhanHoi();
ph.ID = smartReader.GetInt32("ID");
ph.HoTen = smartReader.GetString("HoTen");
ph.Tuoi = smartReader.GetByte("Tuoi");
ph.DiaChi = smartReader.GetString("DiaChi");
ph.TieuDe = smartReader.GetString("TieuDe");
ph.NoiDung = smartReader.GetString("NoiDung");
ph.HienThi = smartReader.GetBoolean("HienThi");
ph.IP = smartReader.GetString("IP");
ph.NgayDang = smartReader.GetString("NgayDang");
l_PhanHoi.Add(ph);
}
smartReader.disposeReader(reader);
}
catch (Exception ex)
{
throw ex;
}
finally
{
db.closeConnection(con);
}
return(l_PhanHoi);
}
public PhanHoi FindByID(int ID)
{
PhanHoi ph = new PhanHoi();
SqlConnection con = db.getConnection();
try
{
SqlCommand cmd = new SqlCommand("PhanHoi_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())
{
ph.ID = smartReader.GetInt32("ID");
ph.HoTen = smartReader.GetString("HoTen");
ph.Tuoi = smartReader.GetByte("Tuoi");
ph.DiaChi = smartReader.GetString("DiaChi");
ph.TieuDe = smartReader.GetString("TieuDe");
ph.NoiDung = smartReader.GetString("NoiDung");
ph.HienThi = smartReader.GetBoolean("HienThi");
ph.IP = smartReader.GetString("IP");
ph.NgayDang = smartReader.GetString("NgayDang");
}
smartReader.disposeReader(reader);
}
catch (Exception ex)
{
throw ex;
}
finally
{
db.closeConnection(con);
}
return(ph);
}