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