public List <TuKhoaTraVe> getTuKhoaPhuong(string tukhoa) { try { connect(); string query = "SELECT * FROM TUKHOAPHUONG"; adapter = new SqlDataAdapter(query, connection); DataSet dataset = new DataSet(); adapter.Fill(dataset); ArrayList ls = ConvertDataSetToArrayList(dataset); List <TuKhoaTraVe> arr = new List <TuKhoaTraVe>(); //List<int> dem = new List<int>(); foreach (Object o in ls) { TuKhoaTraVe tk = new TuKhoaTraVe(); TuKhoaPhuong tt = (TuKhoaPhuong)o; ApproximatString A = new ApproximatString(tt.TuKhoaPhuong1); int C = A.SoSanh(tukhoa); if (C != -1) { if (arr.Count == 0) { tk.ma = tt.MaPhuong; tk.saiso = C; tk.bang = 4; arr.Add(tk); } else { for (int i = 0; i < arr.Count; i++) { if (arr[i].saiso > C) { tk.ma = tt.MaPhuong; tk.saiso = C; tk.bang = 4; if (arr[i].ma != tt.MaPhuong) { arr.Insert(i, tk); } else { arr[i] = tk; } i = arr.Count; } } } } } disconnect(); return(arr); } catch (Exception e) { return(null); } }
public List <TuKhoaTraVe> getTuKhoaDichVu(string tukhoa) { try { connect(); string query = "SELECT * FROM TUKHOADICHVU"; adapter = new SqlDataAdapter(query, connection); DataSet dataset = new DataSet(); adapter.Fill(dataset); ArrayList ls = ConvertDataSetToArrayList(dataset); List <TuKhoaTraVe> arr = new List <TuKhoaTraVe>(); //List<int> dem = new List<int>(); foreach (Object o in ls) { TuKhoaDichVu tt = (TuKhoaDichVu)o; TuKhoaTraVe dv = new TuKhoaTraVe(); ApproximatString A = new ApproximatString(tt.TenTuKhoaDichVu); int C = A.SoSanh(tukhoa); if (C != -1) { if (arr.Count == 0) { dv.ma = tt.MaDichVu; dv.saiso = C; dv.bang = 1; arr.Add(dv); } else { for (int i = 0; i < arr.Count; i++) { if (arr[i].saiso > C) { dv.ma = tt.MaDichVu; dv.saiso = C; dv.bang = 1; if (arr[i].ma != dv.ma) { arr.Insert(i, dv); } else { arr[i] = dv; } i = arr.Count; } } } } } disconnect(); return(arr); } catch (Exception e) { return(null); } }