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);
}
