public ParkingYard [] GetParkingYards()
{
List <ParkingYard> YardList = new List <ParkingYard>();
using (Con = new SqlConnection(GC.ConnectionString))
{
if (Con.State == ConnectionState.Closed)
{
Con.Open();
}
Query = "Select * from Park p left join Park_Location pl on p.ID=pl.Park_ID left join Park_spaces on pl.park_id=park_spaces.park_id";
using (Com = new SqlCommand(Query, Con))
{
Reader = Com.ExecuteReader();
while (Reader.Read())
{
ParkingYard Yard = new ParkingYard();
Yard.id = Convert.ToInt32(Reader["ID"].ToString());
Yard.Name = Reader["Name"].ToString();
Yard.Reference = Reader["placeref"].ToString();
Yard.Place_ID = Reader["placeid"].ToString();
Yard.Image = Reader["Image"].ToString();
//Get Yard Location
ParkingYard.YardLocation yardlocation = new ParkingYard.YardLocation();
if (Reader["L_ID"] != DBNull.Value)
{
yardlocation.id = Convert.ToInt32(Reader["L_ID"].ToString());
}
if (Reader["Long"] != DBNull.Value)
{
yardlocation.Longitude = Convert.ToDouble(Reader["Long"].ToString());
}
if (Reader["Lat"] != DBNull.Value)
{
yardlocation.Latitude = Convert.ToDouble(Reader["Lat"].ToString());
}
if (Reader["Vicinity"] != DBNull.Value)
{
yardlocation.Name = Reader["Vicinity"].ToString();
}
Yard.Location = yardlocation;
//Get Yard Spaces
ParkingYard.YardSpaces yardspaces = new ParkingYard.YardSpaces();
if (Reader["Space_id"] != DBNull.Value)
{
yardspaces.Space_ID = Convert.ToInt32(Reader["Space_id"].ToString());
}
if (Reader["SpaceCount"] != DBNull.Value)
{
yardspaces.Count = Convert.ToInt32(Reader["SpaceCount"].ToString());
}
if (Reader["UsedSpace"] != DBNull.Value)
{
yardspaces.UsedSpaces = Convert.ToInt32(Reader["UsedSpace"].ToString());
}
Yard.Spaces = yardspaces;
YardList.Add(Yard);
}
Com.Dispose();
}
Con.Close();
}
return(YardList.ToArray());
}
public ParkingYard GetParkingYard(int ParkID)
{
ParkingYard Yard = new ParkingYard();
using (Con = new MySqlConnection(GC.ConnectionString))
{
if (Con.State == ConnectionState.Closed)
{
Con.Open();
}
Query = "Select * from Parks left join park_geometry on Parks.ID=park_geometry.Park_ID left join Park_spaces on park_geometry.park_id=park_spaces.park_id where Parks.ID='" + ParkID + "'";
using (Com = new MySqlCommand(Query, Con))
{
Reader = Com.ExecuteReader();
while (Reader.Read())
{
Yard.id = Convert.ToInt32(Reader["ID"].ToString());
Yard.Name = Reader["Name"].ToString();
Yard.Reference = Reader["Reference"].ToString();
Yard.Place_ID = Reader["Place_ID"].ToString();
Yard.Image = Reader["Image"].ToString();
//Get Yard Location
ParkingYard.YardLocation yardlocation = new ParkingYard.YardLocation();
if (Reader["L_ID"] != DBNull.Value)
{
yardlocation.id = Convert.ToInt32(Reader["L_ID"].ToString());
}
if (Reader["Longitude"] != DBNull.Value)
{
yardlocation.Longitude = Convert.ToDouble(Reader["Longitude"].ToString());
}
if (Reader["Latitude"] != DBNull.Value)
{
yardlocation.Latitude = Convert.ToDouble(Reader["Latitude"].ToString());
}
if (Reader["Vicinity"] != DBNull.Value)
{
yardlocation.Name = Reader["Vicinity"].ToString();
}
Yard.Location = yardlocation;
//Get Yard Spaces
ParkingYard.YardSpaces yardspaces = new ParkingYard.YardSpaces();
if (Reader["Space_id"] != DBNull.Value)
{
yardspaces.Space_ID = Convert.ToInt32(Reader["Space_id"].ToString());
}
if (Reader["Space_Count"] != DBNull.Value)
{
yardspaces.Count = Convert.ToInt32(Reader["Space_Count"].ToString());
}
if (Reader["Used"] != DBNull.Value)
{
yardspaces.UsedSpaces = Convert.ToInt32(Reader["Used"].ToString());
}
Yard.Spaces = yardspaces;
}
Com.Dispose();
}
Con.Close();
}
return(Yard);
}
