private BusinessManager()
{
this.montlyClientBO = new ClientBO();
this.collaboratorBO = new CollaboratorBO();
this.localManagerBO = new LocalManagerBO();
this.globalManagerBO = new GlobalManagerBO();
this.parkingBO = new ParkingBO();
this.parkingSpaceBO = new ParkingSpaceBO();
this.priceBO = new PriceBO();
this.addressBO = new AddressBO();
this.tagBO = new TagBO();
this.plateBO = new PlateBO();
this.usageRecordsBO = new UsageRecordBO();
}
public static ParkingList GetBuldings()
{
ParkingList lst = new ParkingList();
using (SqlConnection Conn = new SqlConnection("server=SURESHJALAJA-PC;database=Parking;uid=sa;password=suresh;"))
{
using (SqlCommand Cmd = new SqlCommand(Constants.Proc.USP_GET_BUILDINGS, Conn))
{
Cmd.CommandType = CommandType.StoredProcedure;
Conn.Open();
using (SqlDataReader dr = Cmd.ExecuteReader())
{
while (dr.Read())
{
ParkingBO Obj = new ParkingBO();
Obj.BuildingId = Convert.ToInt32(dr["BuildingID"]);
Obj.BuildingName = Convert.ToString(dr["BuildingName"]);
lst.Add(Obj);
}
}
}
}
return lst;
}
public static ParkingList GetParkingSlotsByLevelID(int levelID)
{
ParkingList lst = new ParkingList();
using (SqlConnection Conn = new SqlConnection("server=SURESHJALAJA-PC;database=Parking;uid=sa;password=suresh;"))
{
using (SqlCommand Cmd = new SqlCommand(Constants.Proc.USP_GET_PARKINGSLOTSBYLEVELID, Conn))
{
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.Parameters.Add("@LevelID", SqlDbType.Int).Value = levelID;
Conn.Open();
using (SqlDataReader dr = Cmd.ExecuteReader())
{
while (dr.Read())
{
ParkingBO Obj = new ParkingBO();
Obj.ParkingID = Convert.ToInt32(dr["ParkingID"]);
Obj.ParkingName = Convert.ToString(dr["ParkingName"]);
Obj.LevelID = Convert.ToInt32(dr["LevelID"]);
lst.Add(Obj);
}
}
}
}
return lst;
}
