public List <TourDuLichDTO> getDanhSachTourDuLich(int MaDDDL)
{
connect();
SqlDataAdapter da = new SqlDataAdapter();
DataSet dataset = new DataSet();
List <TourDuLichDTO> ds = new List <TourDuLichDTO>();
command = new SqlCommand();
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "sp_DSTourDuLich_DiaDiemDuLich";
paramater = new SqlParameter("MaDDDL", SqlDbType.Int, 4);
paramater.Direction = ParameterDirection.Input;
paramater.Value = MaDDDL;
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++)
{
TourDuLichDTO TourDuLichDTO = new TourDuLichDTO();
TourDuLichDTO = (TourDuLichDTO)GetDataFromDataRow(dataTable, i);
ds.Add(TourDuLichDTO);
}
disconnect();
return(ds);
}
protected override object GetDataFromDataRow(System.Data.DataTable dt, int i)
{
TourDuLichDTO itemTour = new TourDuLichDTO();
try
{
itemTour.MaTour = Convert.ToInt32(dt.Rows[i]["MaTour"].ToString());
itemTour.TenTour = dt.Rows[i]["TenTour"].ToString();
itemTour.GiaTour = Convert.ToDouble(dt.Rows[i]["GiaTour"].ToString());
itemTour.LichTrinh = dt.Rows[i]["LichTrinh"].ToString();
itemTour.MaDDDL = Convert.ToInt32(dt.Rows[i]["MaDDDL"].ToString());
itemTour.ThoiGian = (DateTime)dt.Rows[i]["ThoiGian"];
}
catch (Exception ex)
{
}
return(itemTour);
}
