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