public void DropDownChange(VehicleDetails svDetails) { _dbLayerObj = new DALayer(); ParkingBookingHistory pbhObj = new ParkingBookingHistory(); pbhObj = _dbLayerObj.VehicleCheckOut(svDetails); DriverName = pbhObj.VehicleDetails.DriverName; ParkingTime = (DateTime.Now - pbhObj.TimeIn).Duration(); TimeOut = DateTime.Now; Timein = pbhObj.TimeIn; ParkingSlot = pbhObj.ParkingSpace.SlotName; VehicleType = pbhObj.VehicleDetails.VehicleType.VehicleTypeName; }
public void CheckOutVehicle() { if (svDetails != null) { _dbLayerObj = new DALayer(); ParkingBookingHistory pbhObj = new ParkingBookingHistory(); pbhObj = _dbLayerObj.VehicleCheckOut(svDetails); if (ParkingTime.Hours == 0 && svDetails.VehicleTypeID == 1) { Message = "Total Parking Fee is 20 \n" + "Parking Slot : " + ParkingSlot + " is Available"; pbhObj.TotalParkingFee = 20; } else if (ParkingTime.Hours == 0 && svDetails.VehicleTypeID == 2) { Message = "Total Parking Fee is 40 \n" + "Parking Slot : " + ParkingSlot + " is Available"; pbhObj.TotalParkingFee = 40; } else if (ParkingTime.Hours == 1 && svDetails.VehicleTypeID == 1) { Message = "Total Parking Fee is 40 \n" + "Parking Slot : " + ParkingSlot + " is Available"; pbhObj.TotalParkingFee = 40; } else if (ParkingTime.Hours == 1 && svDetails.VehicleTypeID == 2) { Message = "Total Parking Fee is 50 \n" + "Parking Slot : " + ParkingSlot + " is Available"; pbhObj.TotalParkingFee = 50; } else if (ParkingTime.Hours > 1 && svDetails.VehicleTypeID == 1) { Message = "Total Parking Fee is 60 \n" + "Parking Slot : " + ParkingSlot + " is Available"; pbhObj.TotalParkingFee = 60; } else if (ParkingTime.Hours > 1 && svDetails.VehicleTypeID == 2) { Message = "Total Parking Fee is 70 \n" + "Parking Slot : " + ParkingSlot + " is Available"; pbhObj.TotalParkingFee = 70; } pbhObj.TimeOut = TimeOut; pbhObj.OccupancyTime = ParkingTime.ToString(); _dbLayerObj.CheckOutVehicle(pbhObj); } else { Message = "Please Select the Vehicle Number From Dropdown"; } }
public void AssignParkingSpace(VehicleType SVType) { if (SVType != null && DriverName != null && VehicleNumber != null) { VehicleDetails vDetailsObj = new VehicleDetails(); ParkingBookingHistory pObj = new ParkingBookingHistory(); vDetailsObj.DriverName = DriverName; vDetailsObj.VehicleNumber = VehicleNumber; vDetailsObj.VehicleTypeID = SVType.VehicleTypeID; pObj = _dbLayerObj.CreateParkingHistory(vDetailsObj); Message = "Parking Space Assigned is : " + pObj.SlotName; } else { Message = "All Fields are compulsory"; } }
public void CheckOutVehicle(ParkingBookingHistory Obj) { ConnectionString = ConfigurationManager.AppSettings["ConnectionString"]; conn = new SqlConnection(ConnectionString); conn.Open(); string Updatequery = "Update ParkingSpaces set AvailabilityStatus = @AvailabilityStatus where ParkingSpaceID = @ParkingSpaceID"; SqlCommand Updatecmd = new SqlCommand(Updatequery, conn); Updatecmd.Parameters.AddWithValue("@AvailabilityStatus", AvailabilityStatus.Available.ToString()); Updatecmd.Parameters.AddWithValue("@ParkingSpaceID", Obj.ParkingSpaceID); Updatecmd.ExecuteNonQuery(); string Updatequery1 = "Update ParkingBookingHistories set Status = @Status, TimeOut = @TimeOut,OccupancyTime = @OccupancyTime, TotalParkingFee = @TotalParkingFee where BookingID = @BookingID"; SqlCommand Updatecmd1 = new SqlCommand(Updatequery1, conn); Updatecmd1.Parameters.AddWithValue("@Status", Status.Closed.ToString()); Updatecmd1.Parameters.AddWithValue("@TimeOut", Obj.TimeOut); Updatecmd1.Parameters.AddWithValue("@OccupancyTime", Obj.OccupancyTime); Updatecmd1.Parameters.AddWithValue("@TotalParkingFee", Obj.TotalParkingFee); Updatecmd1.Parameters.AddWithValue("@BookingID", Obj.BookingID); Updatecmd1.ExecuteNonQuery(); conn.Close(); }
public ParkingBookingHistory CreateParkingHistory(VehicleDetails vDetailsObj) { ParkingBookingHistory pobj = new ParkingBookingHistory(); VehicleDetails vDetails = new VehicleDetails(); ParkingSpace pSpace = new ParkingSpace(); vDetails = AssignNewParkingSpace(vDetailsObj); if (vDetails.VehicleTypeID == 1) { pSpace = FindNewParkingSpace(1, 0); } else { pSpace = FindNewParkingSpace(3, 4); } if (pSpace != null) { pobj.Status = Status.Open.ToString(); pobj.ParkingSpaceID = pSpace.ParkingSpaceID; pobj.VehicleDetailsID = vDetails.VehicleDetailsID; pobj.TimeIn = DateTime.Now; pobj.TimeOut = DateTime.Now; pobj.TotalParkingFee = 0; pobj.SlotName = pSpace.SlotName; ConnectionString = ConfigurationManager.AppSettings["ConnectionString"]; conn = new SqlConnection(ConnectionString); conn.Open(); string query = @"Insert into ParkingBookingHistories (Status,ParkingSpaceID,VehicleDetailsID,TimeIn,TimeOut,OccupancyTime,TotalParkingFee,SlotName) values (@Status,@ParkingSpaceID,@VehicleDetailsID,@TimeIn,@TimeOut,@OccupancyTime,@TotalParkingFee,@SlotName) select SCOPE_IDENTITY()"; SqlCommand cmd = new SqlCommand(query, conn); cmd.Parameters.AddWithValue("@Status", pobj.Status); cmd.Parameters.AddWithValue("@ParkingSpaceID", pobj.ParkingSpaceID); cmd.Parameters.AddWithValue("@VehicleDetailsID", pobj.VehicleDetailsID); cmd.Parameters.AddWithValue("@TimeIn", pobj.TimeIn); cmd.Parameters.AddWithValue("@TimeOut", pobj.TimeOut); cmd.Parameters.AddWithValue("@OccupancyTime", ""); cmd.Parameters.AddWithValue("@TotalParkingFee", pobj.TotalParkingFee); cmd.Parameters.AddWithValue("@SlotName", pSpace.SlotName); pobj.BookingID = Convert.ToInt32(cmd.ExecuteScalar()); if (pobj.BookingID > 0) { ConnectionString = ConfigurationManager.AppSettings["ConnectionString"]; conn = new SqlConnection(ConnectionString); conn.Open(); string Updatequery = "Update ParkingSpaces set AvailabilityStatus = @AvailabilityStatus where ParkingSpaceID = @ParkingSpaceID"; SqlCommand Updatecmd = new SqlCommand(Updatequery, conn); Updatecmd.Parameters.AddWithValue("@AvailabilityStatus", AvailabilityStatus.Occupied.ToString()); Updatecmd.Parameters.AddWithValue("@ParkingSpaceID", pSpace.ParkingSpaceID); Updatecmd.ExecuteNonQuery(); conn.Close(); } return(pobj); } else { return(null); } }