public List <WayPoints> AllWayPointsGetInfo(int MapSelection)
{
string MapDefinition;
MapDefinition = "1";
MapDefinition = MapSelection.ToString();
string mystring = "" + (char)34;
MapDefinition = MapDefinition.Replace(mystring, "");
mystring = "" + (char)47;
MapDefinition = MapDefinition.Replace(mystring, "");
mystring = "" + (char)92;
MapDefinition = MapDefinition.Replace(mystring, "");
//MapDefinition = "1";
List <WayPoints> SelectionItemsinfo = new List <WayPoints>();
DataSet ds = new DataSet();
int iMapDefinition = Convert.ToInt32(MapDefinition);
string ConnectionString = ReturnConnectionString();
using (SqlConnection con = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
string SqlCommandText = "[WebSite].[AllWayPointsGetInfo]";
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = SqlCommandText;
cmd.Parameters.AddWithValue("@MapDefinition", iMapDefinition);
cmd.Connection = con;
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds, "SelectionItems");
}
}
}
if (ds != null)
{
if (ds.Tables.Count > 0)
{
if (ds.Tables["SelectionItems"].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables["SelectionItems"].Rows)
{
SelectionItemsinfo.Add(new WayPoints
{
WayPointID = Convert.ToInt32(dr["WayPointsID"]),
WayPointName = dr["WayPointName"].ToString(),
Latitude = Convert.ToDouble(dr["Latitude"]),
Longitude = Convert.ToDouble(dr["Longitude"]),
FishingText = dr["FishingText"].ToString(),
BestWindText = dr["BestWindText"].ToString(),
TypeOfFishingText = dr["TypeOfFishingText"].ToString(),
});
}
}
}
}
return(SelectionItemsinfo);
}
