private List <DanhSachXeModel> getdanhSachXeModels(string kw) { tongSoXe = 0; List <DanhSachXeModel> danhSachXeModels = new List <DanhSachXeModel>(); conn.Open(); string sql = "select * from Xe where tenXe like '%" + kw + "%'"; SqlCommand cmd = new SqlCommand(sql, conn); using (DbDataReader reader = cmd.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { int maXe = Convert.ToInt32(reader.GetValue(0)); int bienSo = Convert.ToInt32(reader.GetValue(1)); string tenXe = reader.GetString(2); string imageUrl; try { imageUrl = link + reader.GetString(3); } catch (Exception ex) { imageUrl = ""; } bool trangThai = Convert.ToBoolean(reader.GetValue(4)); DanhSachXeModel temp = new DanhSachXeModel(maXe, bienSo, tenXe, imageUrl, trangThai); danhSachXeModels.Add(temp); tongSoXe++; } } } conn.Close(); return(danhSachXeModels); }
public ThueXe(DanhSachXeModel model) { InitializeComponent(); md = model; }