/// <summary>
/// Get ParkingList from Parking Table With specific Building Number and Level
/// </summary>
/// <param name="connStr"></param>
/// <param name="obj"></param>
/// <returns></returns>
public List <Parking> getParkingList(string connStr, Object obj)
{
ShowParking sp = (ShowParking)obj;
List <Parking> parkingList = new List <Parking>();
SqlConnection conn = new SqlConnection(connStr);
using (conn)
{
conn.Open();
string queryStr = "Select * From Parking Where (BuildingNumber=@BuildingNumber And ParkingLevel=@ParkingLevel) Order By AsielNo";
SqlCommand comm = new SqlCommand(queryStr, conn);
comm.Parameters.AddWithValue("@BuildingNumber", sp.Selectedbuilding);
comm.Parameters.AddWithValue("@ParkingLevel", sp.Selectedlevel);
using (SqlDataReader reader = comm.ExecuteReader())
{
while (reader.Read())
{
Parking p = new Parking();
p.ParkingNumber = reader.GetString(0);
p.Level = reader.GetInt32(reader.GetOrdinal("ParkingLevel")).ToString();
p.BuildingNumber = reader.GetInt32(reader.GetOrdinal("BuildingNumber")).ToString();
p.Asiel = reader.GetString(3);
p.Price = reader.GetInt32(4);
parkingList.Add(p);
}
}
conn.Close();
}
return(parkingList);
}
/// <summary>
/// Get the resrved Parkings From reservation Table which are not Expired
/// </summary>
/// <param name="conStr"></param>
/// <param name="sp"></param>
/// <returns></returns>
public List <ShowParking> getParkingFromReservation(string conStr, ShowParking sp)
{
List <ShowParking> ListOfReservedParking = new List <ShowParking>();
SqlConnection con = new SqlConnection(conStr);
using (con)
{
con.Open();
Boolean expired = true;
string querryStr = "Select DateIn,DateOut,TimeIn,TimeOut,ParkingID from Reservations Where IsExpired!=@expired And(BuildingNumber=@BuildingNumber And LevelNumber=@LevelNumber)";
SqlCommand comm = new SqlCommand(querryStr, con);
comm.Parameters.AddWithValue("@expired", expired);
comm.Parameters.AddWithValue("@BuildingNumber", sp.Selectedbuilding);
comm.Parameters.AddWithValue("@LevelNumber", sp.Selectedlevel);
using (SqlDataReader reader = comm.ExecuteReader()) {
while (reader.Read())
{
ShowParking p = new ShowParking();
p.DateIn = reader.GetDateTime(0);
p.DateOut = reader.GetDateTime(1);
p.TimeIn = reader.GetDateTime(2);
p.TimeOut = reader.GetDateTime(3);
p.ParkingID = reader.GetString(9);
ListOfReservedParking.Add(p);
}
}
}
return(ListOfReservedParking);
}