public IEnumerable <EnvIssue> GetEnvIssue()
{
var issues = new List <EnvIssue>();
var connString = "Host=localhost;Username=postgres;Password=admin;Database=postgres";
var connection = new NpgsqlConnection(connString);
connection.Open();
var i = 0;
using (var cmd = new NpgsqlCommand("SELECT * FROM environmental_issues", connection))
{
using (var reader = cmd.ExecuteReader())
while (reader.Read())
{
var t = new EnvIssue()
{
Id = i,
Rating = reader.GetDouble(4),
Issue = (Issue)Convert.ToInt32(reader.GetString(0)),
Position = new LatLng()
{
Lat = reader.GetDouble(1),
Lng = reader.GetDouble(2)
}
};
i++;
issues.Add(t);
}
}
return(issues);
}
public static EnvIssue[] GetEnvIssues(float lat, float lng)
{
var issue = new EnvIssue();
issue.Position = WannSee;
issue.Rating = 3;
issue.Issue = Issue.Trash;
var issue2 = new EnvIssue()
{
Position = WannSee2,
Rating = 1,
Issue = Issue.Shit
};
//issue2.Position.Lat += 0.1 ;
var list = new List <EnvIssue>();
list.Add(issue);
list.Add(issue2);
return(list.ToArray());
}
