public List <TuKhoaTraVe> getTuKhoaQuanHuyen(string tukhoa)
{
try
{
connect();
string query = "SELECT * FROM TUKHOAQUANHUYEN";
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();
TuKhoaQuanHuyen tt = (TuKhoaQuanHuyen)o;
ApproximatString A = new ApproximatString(tt.TuKhoaQuanHuyen1);
int C = A.SoSanh(tukhoa);
if (C != -1)
{
if (arr.Count == 0)
{
tk.ma = tt.MaQuanHuyen;
tk.saiso = C;
tk.bang = 5;
arr.Add(tk);
}
else
{
for (int i = 0; i < arr.Count; i++)
{
if (arr[i].saiso > C)
{
tk.ma = tt.MaQuanHuyen;
tk.saiso = C;
tk.bang = 5;
if (arr[i].ma != tt.MaQuanHuyen)
{
arr.Insert(i, tk);
}
else
{
arr[i] = tk;
}
i = arr.Count;
}
}
}
}
}
disconnect();
return(arr);
}
catch (Exception e)
{
return(null);
}
}
protected override object GetDataFromDataRow(DataTable dt, int i)
{
TuKhoaQuanHuyen tk = new TuKhoaQuanHuyen();
tk.MaTuKhoaQuanHuyen = dt.Rows[i].IsNull("MaTuKhoaQuanHuyen") == true ? 0 : (int)dt.Rows[i]["MaTuKhoaQuanHuyen"];
tk.TuKhoaQuanHuyen1 = dt.Rows[i]["TuKhoaQuanHuyen"].ToString();
tk.MaQuanHuyen = dt.Rows[i].IsNull("MaQuanHuyen") == true ? 0 : (int)dt.Rows[i]["MaQuanHuyen"];
return((object)tk);
}
public bool insertTuKhoaQuanHuyen(TuKhoaQuanHuyen tkq)
{
try
{
connect();
string insertCommand = "INSERT INTO TUKHOAQUANHUYEN VALUES( N'" +
tkq.TuKhoaQuanHuyen1 + "'," + tkq.MaQuanHuyen + ")";
executeNonQuery(insertCommand);
disconnect();
return(true);
}
catch (Exception e)
{
return(false);
}
}
public bool updateTuKhoaQuanHuyen(TuKhoaQuanHuyen tk)
{
try
{
connect();
string updateCommand = "UPDATE TUKHOAQUANHUYEN SET TuKhoaQuanHuyen = '" + tk.TuKhoaQuanHuyen1 +
"', MaQuanHuyen = " + tk.MaQuanHuyen + " WHERE MaTuKhoaQuanHuyen = " + tk.MaTuKhoaQuanHuyen;
executeNonQuery(updateCommand);
disconnect();
return(true);
}
catch (Exception e)
{
return(false);
}
}
