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); } }
public List <TuKhoaTraVe> getTuKhoaTraVe() { List <TuKhoaTraVe> arr = new List <TuKhoaTraVe>(); TuKhoaTraVe TV = dvTV.Count == 0 ? null : dvTV[0]; TV = TV == null ? ddTV[0] : TV; TV = TV == null ? tdTV[0] : TV; TV = TV == null ? tpTV[0] : TV; TV = TV == null ? qhTV[0] : TV; TV = TV == null ? ttTV[0] : TV; bool flat = true; int t = TV.bang; do { //Dich Vu if (dvTV.Count != 0 && TV.saiso >= dvTV[0].saiso) { t = dvTV[0].bang; TV = dvTV[0]; } //Dia Diem if (ddTV.Count != 0 && TV.saiso >= ddTV[0].saiso) { t = ddTV[0].bang; TV = ddTV[0]; } //Duong if (tdTV.Count != 0 && TV.saiso >= tdTV[0].saiso) { t = tdTV[0].bang; TV = tdTV[0]; } //Phuong if (tpTV.Count != 0 && TV.saiso >= tpTV[0].saiso) { t = tpTV[0].bang; TV = tpTV[0]; } //Quan Huyen if (qhTV.Count != 0 && TV.saiso >= qhTV[0].saiso) { t = qhTV[0].bang; TV = qhTV[0]; } //Thanh Pho if (ttTV.Count != 0 && TV.saiso >= ttTV[0].saiso) { t = ttTV[0].bang; TV = ttTV[0]; } if (dem == 5) { if (dvTV.Count != 0) { arr.AddRange(dvTV.ToArray()); } if (ddTV.Count != 0) { arr.AddRange(ddTV.ToArray()); } if (tdTV.Count != 0) { arr.AddRange(tdTV.ToArray()); } if (tpTV.Count != 0) { arr.AddRange(tpTV.ToArray()); } if (qhTV.Count != 0) { arr.AddRange(qhTV.ToArray()); } if (ttTV.Count != 0) { arr.AddRange(ttTV.ToArray()); } break; } arr.Add(TV); switch (t) { case 1: dvTV.RemoveAt(0); TV = ddTV.Count != 0 ? ddTV[0] : tdTV.Count != 0? tdTV[0] : tpTV.Count != 0? tpTV[0] : qhTV.Count != 0 ? qhTV[0] : ttTV.Count != 0 ? ttTV[0] : dvTV[0]; if (dvTV.Count == 0) { dem++; } break; case 2: ddTV.RemoveAt(0); TV = tdTV.Count != 0 ? tdTV[0] : tpTV.Count != 0 ? tpTV[0] : qhTV.Count != 0 ? qhTV[0] : ttTV.Count != 0 ? ttTV[0] : dvTV.Count != 0? dvTV[0] : ddTV[0]; if (ddTV.Count == 0) { dem++; } break; case 3: tdTV.RemoveAt(0); TV = tpTV.Count != 0 ? tpTV[0] : qhTV.Count != 0 ? qhTV[0] : ttTV.Count != 0 ? ttTV[0] : dvTV.Count != 0 ? dvTV[0] : ddTV.Count != 0? ddTV[0] : tdTV[0]; if (tdTV.Count == 0) { dem++; } break; case 4: tpTV.RemoveAt(0); TV = qhTV.Count != 0 ? qhTV[0] : ttTV.Count != 0 ? ttTV[0] : dvTV.Count != 0 ? dvTV[0] : ddTV.Count != 0 ? ddTV[0] : tdTV.Count != 0? tdTV[0] : tpTV[0]; if (tpTV.Count == 0) { dem++; } break; case 5: qhTV.RemoveAt(0); TV = ttTV.Count != 0 ? ttTV[0] : dvTV.Count != 0 ? dvTV[0] : ddTV.Count != 0 ? ddTV[0] : tdTV.Count != 0 ? tdTV[0] : tpTV.Count != 0? tpTV[0] : qhTV[0]; if (qhTV.Count == 0) { dem++; } break; case 6: ttTV.RemoveAt(0); TV = dvTV.Count != 0 ? dvTV[0] : ddTV.Count != 0 ? ddTV[0] : tdTV.Count != 0 ? tdTV[0] : tpTV.Count != 0 ? tpTV[0] : qhTV.Count != 0? qhTV[0] : ttTV[0]; if (ttTV.Count == 0) { dem++; } break; } if (dvTV.Count == 0 && ddTV.Count == 0 && tdTV.Count == 0 && tpTV.Count == 0 && qhTV.Count == 0 && ttTV.Count == 0) { flat = false; } } while (flat); return(arr); }