public Filter getFilterFromLocation(string LatLong)
{
//we have to check all filters and see if we can get the lat and long from them
Filter f = new Filter();
foreach (Filter id in GlobalHandlers.DatabaseHandler.getFilters())
{
string lat = LatLong.Split(Char.Parse(","))[0];
string longD = LatLong.Split(Char.Parse(","))[1];
f.Lat = lat;
f.Long = longD;
if (id.Lat.Contains(lat) && id.Long.Contains(longD))
{
return id;
}
}
return f;
}
public List<Filter> getFilters()
{
List<Filter> filterList = new List<Filter>();
if (MySqlConnection.State == System.Data.ConnectionState.Open)
{
try
{
MySqlCommand cmd = new MySqlCommand("SELECT * FROM `filters`", MySqlConnection);
using (MySqlDataReader reader = cmd.ExecuteReader())
{
if (!reader.HasRows)
{
cmd.Dispose();
reader.Close();
return filterList;
}
while (reader.Read())
{
string id = reader["id"].ToString();
string name = reader["filter_text"].ToString();
string longx = reader["long"].ToString();
string lat = reader["lat"].ToString();
Filter filter = new Filter();
filter.Id = id;
filter.Name = name;
filter.Long = longx;
filter.Lat = lat;
filterList.Add(filter);
}
reader.Close();
}
return filterList;
}
catch (MySqlException ecc)
{
GlobalHandlers.Debugger.write(ecc.ToString());
}
}
return filterList;
}
public Filter getDefaultFilter()
{
try
{
Filter toReturn = new Filter();
toReturn.Name = GlobalHandlers.DatabaseHandler.globalInformation.School_Name;
string latlong = GlobalHandlers.SettingHandler.Settings["default_filter"].ToString();
string[] splited = latlong.Split(Char.Parse(","));
toReturn.Lat = splited[0].Replace(" ", "");
toReturn.Long = splited[1].Replace(" ", "");
return toReturn;
}
catch (Exception ee)
{
GlobalHandlers.Debugger.write(ee.ToString());
return new Filter();
}
}
