public List <DiaDiemDuLichDTO> TimKiemDiaDiemDuLich(string QuocGia, string Vung, string ThanhPho, int iPage, int numberItem)
{
connect();
SqlDataAdapter da = new SqlDataAdapter();
DataSet dataset = new DataSet();
List <DiaDiemDuLichDTO> ds = new List <DiaDiemDuLichDTO>();
command = new SqlCommand();
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "sp_TimKiemDiaDiemDuLich";
paramater = new SqlParameter("Start", SqlDbType.Int, 4);
paramater.Direction = ParameterDirection.Input;
paramater.Value = (iPage - 1) * numberItem;
command.Parameters.Add(paramater);
paramater = new SqlParameter("End", SqlDbType.Int, 4);
paramater.Direction = ParameterDirection.Input;
paramater.Value = iPage * numberItem;
command.Parameters.Add(paramater);
paramater = new SqlParameter("QuocGia", SqlDbType.NVarChar);
paramater.Direction = ParameterDirection.Input;
paramater.Value = QuocGia;
command.Parameters.Add(paramater);
paramater = new SqlParameter("Vung", SqlDbType.NVarChar);
paramater.Direction = ParameterDirection.Input;
if (Vung == null)
{
paramater.Value = "";
}
else
{
paramater.Value = Vung;
}
command.Parameters.Add(paramater);
paramater = new SqlParameter("ThanhPho", SqlDbType.NVarChar);
paramater.Direction = ParameterDirection.Input;
paramater.Value = ThanhPho;
command.Parameters.Add(paramater);
da.SelectCommand = command;
da.Fill(dataset);
DataTable dataTable = dataset.Tables[0];
int n = dataTable.Rows.Count;
for (int i = 0; i < n; i++)
{
DiaDiemDuLichDTO DiaDiemDuLichDTO = new DTO.DiaDiemDuLichDTO();
DiaDiemDuLichDTO = (DiaDiemDuLichDTO)GetDataFromDataRow(dataTable, i);
ds.Add(DiaDiemDuLichDTO);
}
disconnect();
return(ds);
}
public List <DiaDiemDuLichDTO> getDanhSachDiaDiemDuLich(int iPage, int numberItem)
{
connect();
SqlDataAdapter da = new SqlDataAdapter();
DataSet dataset = new DataSet();
List <DiaDiemDuLichDTO> ds = new List <DiaDiemDuLichDTO>();
command = new SqlCommand();
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "sp_DanhSachDiaDiemDuLichPhanTrang";
paramater = new SqlParameter("Start", SqlDbType.Int, 4);
paramater.Direction = ParameterDirection.Input;
paramater.Value = (iPage - 1) * numberItem;
command.Parameters.Add(paramater);
paramater = new SqlParameter("End", SqlDbType.Int, 4);
paramater.Direction = ParameterDirection.Input;
paramater.Value = iPage * numberItem;
command.Parameters.Add(paramater);
da.SelectCommand = command;
da.Fill(dataset);
DataTable dataTable = dataset.Tables[0];
int n = dataTable.Rows.Count;
for (int i = 0; i < n; i++)
{
DiaDiemDuLichDTO DiaDiemDuLichDTO = new DTO.DiaDiemDuLichDTO();
DiaDiemDuLichDTO = (DiaDiemDuLichDTO)GetDataFromDataRow(dataTable, i);
ds.Add(DiaDiemDuLichDTO);
}
disconnect();
return(ds);
}
