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); }