public void GetByTicketId(int id)
{
JavaScriptSerializer json = new JavaScriptSerializer();
ParkingTicket getParkingTicket = null;
try {
using (SqlConnection connection = new SqlConnection(DBConnection.ConnectionString)) {
connection.Open();
SqlDataAdapter sda = new SqlDataAdapter("SELECT * FROM parking_ticket WHERE parking_ticket_id =" + id, connection);
sda.SelectCommand.CommandType = System.Data.CommandType.Text;
DataTable dTable = new DataTable();
sda.Fill(dTable);
getParkingTicket = new ParkingTicket()
{
parking_ticket_id = Convert.ToString(dTable.Rows[0]["parking_ticket_id"]),
car_licence_plate = Convert.ToString(dTable.Rows[0]["car_licence_plate"]),
ticket_valid = Convert.ToString(dTable.Rows[0]["ticket_valid"])
};
dTable.Clear();
connection.Close();
}
}
catch { }
var JSonData = new {
getParkingTicket = getParkingTicket
};
HttpContext.Current.Response.Write(json.Serialize(JSonData));
}
public void GetAllTickets()
{
JavaScriptSerializer json = new JavaScriptSerializer();
ParkingTicket[] getParkingTicket = null;
try {
using (SqlConnection connection = new SqlConnection(DBConnection.ConnectionString)) {
connection.Open();
SqlDataAdapter sda = new SqlDataAdapter("SELECT * FROM parking_ticket", connection);
sda.SelectCommand.CommandType = System.Data.CommandType.Text;
DataTable dTable = new DataTable();
sda.Fill(dTable);
getParkingTicket = new ParkingTicket[dTable.Rows.Count];
int brojac = 0;
for (int i = 0; i < dTable.Rows.Count; ++i)
{
getParkingTicket[brojac] = new ParkingTicket()
{
parking_ticket_id = Convert.ToString(dTable.Rows[i]["parking_ticket_id"]),
car_licence_plate = Convert.ToString(dTable.Rows[i]["car_licence_plate"]),
ticket_valid = Convert.ToString(dTable.Rows[i]["ticket_valid"])
};
++brojac;
}
dTable.Clear();
connection.Close();
}
}
catch { }
var JSonData = new {
getParkingTicket = getParkingTicket
};
HttpContext.Current.Response.Write(json.Serialize(JSonData));
}
private void displayTicket(ParkingTicket t)
{
output.WriteLine("TICKET:");
output.WriteLine($" Id: {t.Id}");
output.WriteLine($" Gate: {t.GateId}");
output.WriteLine($" Plate: {t.PlateNumber}");
output.WriteLine($" Date In: {t.DateIn:s}");
}
internal ParkingTicket GetParkingTicket(ParkingSpot parkingSpot)
{
var parkingTicket = new ParkingTicket {
Id = Guid.NewGuid(),
parkingSpot = parkingSpot,
EntryTime = DateTime.UtcNow
};
return(parkingTicket);
}
public bool IsTicketValid(ParkingTicket ticket)
{
if (ticket == null)
{
return(false);
}
Slot slot = parkingLot.slots.Single(s => s.Id == ticket.SlotNumber);
return(slot.Vehicle != null);
}
private bool CheckDimentions(ParkingTicket ticket, double height, double width, double length)
{
bool value = false;
if (height < ticket.MaxHeight && width < ticket.MaxWidth && length < ticket.MaxLength)
{
value = true;
}
return(value);
}
public void Print(ParkingTicket ticket, object args = null)
{
var r = new ViewAsPdf("RPT-01-ParkingTicket-In", ticket);
r.PageSize = Rotativa.Options.Size.A6;
r.PageOrientation = Rotativa.Options.Orientation.Portrait;
var fileName = ticket.Id + ".pdf";
var filePath = HttpContext.Current.Server.MapPath("~/App_Data/" + fileName);
var bytes = r.BuildPdf((ControllerContext)args);
System.IO.File.WriteAllBytes(filePath, bytes);
}
private ParkingTicket GetTicketTypeByString(string ticketType)
{
ParkingTicket parkingTicket = new ParkingTicket();
foreach (var ticket in ticketList)
{
if (ticket.ToString().ToLower() == ticketType.ToLower())
{
parkingTicket = ticket;
}
}
return(parkingTicket);
}
public void Should_Fetch_Return_Car_Given_Valid_Ticket()
{
// given
var parkingLot = new ParkingLot("ParkingLotOne");
var parkedCar = new Car("JA8888");
ParkingTicket parkingTicket = parkingLot.Park(parkedCar);
// when
var fetchedCar = parkingLot.Fetch(parkingTicket);
// then
Assert.IsType <Car>(fetchedCar);
Assert.Equal(parkedCar, fetchedCar);
}
public string ParkCar(ParkingTicket ticket)
{
if (_context.ParkingTickets.Any(x => x.CarPositionId == ticket.CarPositionId))
{
return("Position already taken");
}
_context.ParkingTickets.Add(ticket);
var carpos = _context.CarsPositions.FirstOrDefault(x => x.Id == ticket.CarPositionId);
carpos.Isused = true;
_context.SaveChanges();
return("car Parked successfully");
}
public ParkingTicketDTO ParkingTicketToParkingTicketDTO(ParkingTicket parkingTicket)
{
ParkingTicketDTO parkingTicketDTO = new ParkingTicketDTO();
if (parkingTicket != null)
{
parkingTicketDTO.LeavingTime = parkingTicket.LeavingTime;
parkingTicketDTO.TakingTime = parkingTicket.TakingTime;
}
//parkingTicketDTO.ParkingPlace = new ParkingPlaceMapper().ParkingPlaceToParkingPlaceDTO(parkingTicket.ParkingPlace);
//parkingTicketDTO.Car = new CarMapper().CarToCarDTO(parkingTicket.Car);
//parkingTicketDTO.Client = new ClientMapper().ClientToClientDTO(parkingTicket.Client);
return(parkingTicketDTO);
}
public void ParkVehicle()
{
VehicleType type = ReadVehicleType();
Slot slot = ChooseSlot(type);
if (slot != null)
{
Console.Write("Enter your vehicle number: ");
String vehicleNumber = Console.ReadLine();
Vehicle vehicle = CreateVehicle(slot.Type, vehicleNumber);
int ticketId = tickets.Count + 1;
ParkingTicket parkingTicket = new ParkingTicket(ticketId, slot.Id, vehicleNumber);
Console.WriteLine("Your vehicle is successfully parked.");
DisplayTicketDetails(parkingTicket);
tickets.Add(parkingTicket);
slot.SetVehicle(vehicle);
slot.ToggleAvailability();
}
}
public void GetAllExpired()
{
JavaScriptSerializer json = new JavaScriptSerializer();
ParkingTicket[] getParkingTickets = null;
DateTime trenutnoVreme = DateTime.Now;
try {
using (SqlConnection connection = new SqlConnection(DBConnection.ConnectionString)) {
connection.Open();
SqlDataAdapter sda = new SqlDataAdapter();
SqlCommand command = new SqlCommand();
command.Connection = connection;
command.CommandText = "SELECT * FROM parking_ticket WHERE ticket_valid < @ticket_valid";
command.Parameters.AddWithValue("@ticket_valid", trenutnoVreme);
command.CommandType = System.Data.CommandType.Text;
sda.SelectCommand = command;
DataTable dTable = new DataTable();
sda.Fill(dTable);
getParkingTickets = new ParkingTicket[dTable.Rows.Count];
int brojac = 0;
for (int i = 0; i < dTable.Rows.Count; ++i)
{
getParkingTickets[brojac] = new ParkingTicket()
{
parking_ticket_id = Convert.ToString(dTable.Rows[i]["parking_ticket_id"]),
car_licence_plate = Convert.ToString(dTable.Rows[i]["car_licence_plate"]),
ticket_valid = Convert.ToString(dTable.Rows[i]["ticket_valid"])
};
++brojac;
}
dTable.Clear();
connection.Close();
}
}
catch { }
var JSonData = new {
getParkingTickets = getParkingTickets
};
HttpContext.Current.Response.Write(json.Serialize(JSonData));
}
public void ShouldFetchACarUsingParkingTicket()
{
// given
Car car = new Car("CARA111");
// when
string positionErrorMessage, errorMessage;
ParkingLot parkingLot1 = new ParkingLot("A");
ParkingLot parkingLot2 = new ParkingLot("B");
List <ParkingLot> parkingLots = new List <ParkingLot>();
parkingLots.Add(parkingLot1);
parkingLots.Add(parkingLot2);
ParkingBoy parkingBoy = new ParkingBoy(parkingLots);
ParkingTicket parkingTicket = parkingBoy.ParkingCar(car, out positionErrorMessage);
Car actual = parkingBoy.FetchCar(parkingTicket, out errorMessage);
// then
Assert.Equal(car, actual);
}
public void ShouldGiveErrorMessageWhenTicketIsNull()
{
// given
Car car = new Car("CARA111");
// when
string errorMessage, positionErrorMessage;
ParkingLot parkingLot1 = new ParkingLot("A");
ParkingLot parkingLot2 = new ParkingLot("B");
List <ParkingLot> parkingLots = new List <ParkingLot>();
parkingLots.Add(parkingLot1);
parkingLots.Add(parkingLot2);
ParkingBoy parkingBoy = new ParkingBoy(parkingLots);
ParkingTicket parkingTicket = parkingBoy.ParkingCar(car, out positionErrorMessage);
Car actual = parkingBoy.FetchCar(null, out errorMessage);
// then
Assert.Equal("Please provide your parking ticket.", errorMessage);
}
public void Print(ParkingTicket ticket)
{
HasPrinted = true;
}
static DataBaseSimulation()
{
Car car1 = new Car {
Name = "BMW X5"
};
Car car2 = new Car {
Name = "Tesla Model S"
};
Car car3 = new Car {
Name = "Tesla Model 3"
};
Car car4 = new Car {
Name = "Tesla Model X"
};
Car car5 = new Car {
Name = "Mercedes AMG GT"
};
Car car6 = new Car {
Name = "Mercedes S class"
};
Car car7 = new Car {
Name = "BMW M3"
};
car1.Tickets = new List <ParkingTicket>();
car2.Tickets = new List <ParkingTicket>();
car3.Tickets = new List <ParkingTicket>();
car4.Tickets = new List <ParkingTicket>();
car5.Tickets = new List <ParkingTicket>();
car6.Tickets = new List <ParkingTicket>();
car7.Tickets = new List <ParkingTicket>();
Client client1 = new Client {
Name = "Tyler Durden"
};
Client client2 = new Client {
Name = "Thomas Anderson"
};
Client client3 = new Client {
Name = "Vincent Vega"
};
Client client4 = new Client {
Name = "Forrest Gump"
};
//client1.Tickets = new List<ParkingTicket>();
//client2.Tickets = new List<ParkingTicket>();
//client3.Tickets = new List<ParkingTicket>();
//client4.Tickets = new List<ParkingTicket>();
Parking parking1 = new Parking {
ParkingName = "Parking ONE"
};
Parking parking2 = new Parking {
ParkingName = "Parking TWO"
};
parking1.Places = new List <ParkingPlace>();
parking1.Tickets = new List <ParkingTicket>();
parking2.Places = new List <ParkingPlace>();
parking2.Tickets = new List <ParkingTicket>();
//not all
ParkingPlace parkingPlace1 = new ParkingPlace {
Number = 1
};
ParkingPlace parkingPlace2 = new ParkingPlace {
Number = 2
};
ParkingPlace parkingPlace3 = new ParkingPlace {
Number = 3
};
ParkingPlace parkingPlace4 = new ParkingPlace {
Number = 4
};
ParkingPlace parkingPlace5 = new ParkingPlace {
Number = 5
};
ParkingPlace parkingPlace6 = new ParkingPlace {
Number = 6
};
ParkingPlace parkingPlace7 = new ParkingPlace {
Number = 7
};
ParkingPlace parkingPlace8 = new ParkingPlace {
Number = 8
};
ParkingPlace parkingPlace9 = new ParkingPlace {
Number = 9
};
//not all
cars.AddRange(new List <Car> {
car1, car2, car3, car4, car5, car6, car7
});
clients.AddRange(new List <Client> {
client1, client2, client3, client4
});
parkings.AddRange(new List <Parking> {
parking1, parking2
});
parkingsPlaces.AddRange(new List <ParkingPlace> {
parkingPlace1, parkingPlace2, parkingPlace3, parkingPlace4, parkingPlace5, parkingPlace6, parkingPlace7, parkingPlace8, parkingPlace9
});
ParkingTicket parkingTicket1 = new ParkingTicket {
LeavingTime = new DateTime(2020, 5, 10), TakingTime = new DateTime(2020, 5, 13)
};
ParkingTicket parkingTicket2 = new ParkingTicket {
LeavingTime = new DateTime(2020, 5, 10), TakingTime = new DateTime(2020, 5, 13)
};
ParkingTicket parkingTicket3 = new ParkingTicket {
LeavingTime = new DateTime(2020, 5, 10), TakingTime = new DateTime(2020, 5, 13)
};
ParkingTicket parkingTicket4 = new ParkingTicket {
LeavingTime = new DateTime(2020, 5, 10), TakingTime = new DateTime(2020, 5, 13)
};
ParkingTicket parkingTicket5 = new ParkingTicket {
LeavingTime = new DateTime(2020, 5, 10), TakingTime = new DateTime(2020, 5, 13)
};
ParkingTicket parkingTicket6 = new ParkingTicket {
LeavingTime = new DateTime(2020, 5, 10), TakingTime = new DateTime(2020, 5, 13)
};
ParkingTicket parkingTicket7 = new ParkingTicket {
LeavingTime = new DateTime(2020, 5, 10), TakingTime = new DateTime(2020, 5, 13)
};
//ParkingTicket parkingTicket1 = new ParkingTicket { Car = cars[0], Client = clients[0], ParkingPlace = parkingsPlaces[0], LeavingTime = new DateTime(2020, 5, 10), TakingTime = new DateTime(2020, 5, 13) };
//ParkingTicket parkingTicket2 = new ParkingTicket { Car = cars[1], Client = clients[1], ParkingPlace = parkingsPlaces[1], LeavingTime = new DateTime(2020, 5, 10), TakingTime = new DateTime(2020, 5, 13) };
//ParkingTicket parkingTicket3 = new ParkingTicket { Car = cars[2], Client = clients[2], ParkingPlace = parkingsPlaces[2], LeavingTime = new DateTime(2020, 5, 10), TakingTime = new DateTime(2020, 5, 13) };
//ParkingTicket parkingTicket4 = new ParkingTicket { Car = cars[3], Client = clients[3], ParkingPlace = parkingsPlaces[3], LeavingTime = new DateTime(2020, 5, 10), TakingTime = new DateTime(2020, 5, 13) };
//ParkingTicket parkingTicket5 = new ParkingTicket { Car = cars[4], Client = clients[0], ParkingPlace = parkingsPlaces[4], LeavingTime = new DateTime(2020, 5, 10), TakingTime = new DateTime(2020, 5, 13) };
//ParkingTicket parkingTicket6 = new ParkingTicket { Car = cars[5], Client = clients[1], ParkingPlace = parkingsPlaces[5], LeavingTime = new DateTime(2020, 5, 10), TakingTime = new DateTime(2020, 5, 13) };
//ParkingTicket parkingTicket7 = new ParkingTicket { Car = cars[6], Client = clients[2], ParkingPlace = parkingsPlaces[6], LeavingTime = new DateTime(2020, 5, 10), TakingTime = new DateTime(2020, 5, 13) };
parkingTickets.AddRange(new List <ParkingTicket> {
parkingTicket1, parkingTicket2, parkingTicket3, parkingTicket4, parkingTicket5, parkingTicket6, parkingTicket7
});
car1.Tickets.Add(parkingTickets[0]);
car2.Tickets.Add(parkingTickets[1]);
car3.Tickets.Add(parkingTickets[2]);
car4.Tickets.Add(parkingTickets[3]);
car5.Tickets.Add(parkingTickets[4]);
car6.Tickets.Add(parkingTickets[5]);
car7.Tickets.Add(parkingTickets[6]);
//client1.Tickets.Add(parkingTickets[0]);
//client1.Tickets.Add(parkingTickets[4]);
//client2.Tickets.Add(parkingTickets[1]);
//client2.Tickets.Add(parkingTickets[5]);
//client3.Tickets.Add(parkingTickets[2]);
//client3.Tickets.Add(parkingTickets[6]);
//client4.Tickets.Add(parkingTickets[3]);
parking1.Places.AddRange(new List <ParkingPlace> {
parkingsPlaces[0], parkingsPlaces[1], parkingsPlaces[2], parkingsPlaces[3]
});
parking1.Tickets.AddRange(new List <ParkingTicket> {
parkingTickets[0], parkingTickets[1], parkingTickets[2], parkingTickets[3]
});
parking2.Places.AddRange(new List <ParkingPlace> {
parkingsPlaces[4], parkingsPlaces[5], parkingsPlaces[6], parkingsPlaces[7], parkingsPlaces[8]
});
parking2.Tickets.AddRange(new List <ParkingTicket> {
parkingTickets[4], parkingTickets[5], parkingTickets[6]
});
parkingPlace1.Ticket = parkingTickets[0];
parkingPlace2.Ticket = parkingTickets[1];
parkingPlace3.Ticket = parkingTickets[2];
parkingPlace4.Ticket = parkingTickets[3];
parkingPlace5.Ticket = parkingTickets[4];
parkingPlace6.Ticket = parkingTickets[5];
parkingPlace7.Ticket = parkingTickets[6];
}
public void FreeSpot(ParkingTicket parkingTicket) => parkingTicket.ParkingSpot.FreeSpot();
public void DisplayTicketDetails(ParkingTicket ticket)
{
Console.WriteLine("Your Ticket Id : " + ticket.Id + "\tVehicle NO : " + ticket.VehicleNumber + "\tSlot NO : " + ticket.SlotNumber + "\tInTime : " + ticket.InTime);
}
public static void Initialize(ParkingContext parkingContext)
{
ParkingContext context = parkingContext;
List <Car> cars = new List <Car>();
List <Client> clients = new List <Client>();
List <Parking> parkings = new List <Parking>();
List <ParkingPlace> parkingsPlaces = new List <ParkingPlace>();
List <ParkingTicket> parkingTickets = new List <ParkingTicket>();
Car car1 = new Car {
Name = "BMW X5",
//id = 1
};
Car car2 = new Car {
Name = "Tesla Model S",
//id=2
};
Car car3 = new Car {
Name = "Tesla Model 3",
//id=3
};
Car car4 = new Car {
Name = "Tesla Model X",
//id = 4
};
Car car5 = new Car {
Name = "Mercedes AMG GT",
//id=5
};
Car car6 = new Car {
Name = "Mercedes S class",
//id = 6
};
Car car7 = new Car
{
Name = "BMW M3",
//id = 7
};
car1.Tickets = new List <ParkingTicket>();
car2.Tickets = new List <ParkingTicket>();
car3.Tickets = new List <ParkingTicket>();
car4.Tickets = new List <ParkingTicket>();
car5.Tickets = new List <ParkingTicket>();
car6.Tickets = new List <ParkingTicket>();
car7.Tickets = new List <ParkingTicket>();
Client client1 = new Client {
Name = "Tyler Durden",
//id = 1
};
Client client2 = new Client {
Name = "Thomas Anderson", //id = 2
};
Client client3 = new Client {
Name = "Vincent Vega",
//id = 3
};
Client client4 = new Client {
Name = "Forrest Gump",
//id = 4
};
//client1.Tickets = new List<ParkingTicket>();
//client2.Tickets = new List<ParkingTicket>();
//client3.Tickets = new List<ParkingTicket>();
//client4.Tickets = new List<ParkingTicket>();
Parking parking1 = new Parking {
ParkingName = "Parking ONE",
//id = 1
};
Parking parking2 = new Parking {
ParkingName = "Parking TWO",
//id = 2
};
parking1.Places = new List <ParkingPlace>();
parking1.Tickets = new List <ParkingTicket>();
parking2.Places = new List <ParkingPlace>();
parking2.Tickets = new List <ParkingTicket>();
//not all
ParkingPlace parkingPlace1 = new ParkingPlace {
Number = 33,
//id = 1
};
ParkingPlace parkingPlace2 = new ParkingPlace {
Number = 12,
// id = 2
};
ParkingPlace parkingPlace3 = new ParkingPlace {
Number = 43,
//id = 3
};
ParkingPlace parkingPlace4 = new ParkingPlace {
Number = 11,
// id = 4
};
ParkingPlace parkingPlace5 = new ParkingPlace {
Number = 54,
// id = 5
};
ParkingPlace parkingPlace6 = new ParkingPlace {
Number = 32,
// id = 6
};
ParkingPlace parkingPlace7 = new ParkingPlace {
Number = 27,
// id = 7
};
ParkingPlace parkingPlace8 = new ParkingPlace {
Number = 50,
// id = 8
};
ParkingPlace parkingPlace9 = new ParkingPlace {
Number = 15,
//id = 9
};
//not all
cars.AddRange(new List <Car>
{
car1, car2, car3, car4, car5, car6, car7
});
clients.AddRange(new List <Client>
{
client1, client2, client3, client4
});
parkings.AddRange(new List <Parking>
{
parking1, parking2
});
parkingsPlaces.AddRange(new List <ParkingPlace>
{
parkingPlace1, parkingPlace2, parkingPlace3, parkingPlace4, parkingPlace5, parkingPlace6, parkingPlace7,
parkingPlace8, parkingPlace9
});
ParkingTicket parkingTicket1 = new ParkingTicket
{
LeavingTime = new DateTime(2020, 5, 10), TakingTime = new DateTime(2020, 5, 13),
//id = 1
};
ParkingTicket parkingTicket2 = new ParkingTicket
{
LeavingTime = new DateTime(2020, 5, 10), TakingTime = new DateTime(2020, 5, 13),
//id = 2
};
ParkingTicket parkingTicket3 = new ParkingTicket
{
LeavingTime = new DateTime(2020, 5, 10), TakingTime = new DateTime(2020, 5, 13),
//id = 3
};
ParkingTicket parkingTicket4 = new ParkingTicket
{
LeavingTime = new DateTime(2020, 5, 10), TakingTime = new DateTime(2020, 5, 13),
//id = 4
};
ParkingTicket parkingTicket5 = new ParkingTicket
{
LeavingTime = new DateTime(2020, 5, 10), TakingTime = new DateTime(2020, 5, 13),
// id = 5
};
ParkingTicket parkingTicket6 = new ParkingTicket
{
LeavingTime = new DateTime(2020, 5, 10), TakingTime = new DateTime(2020, 5, 13),
//id = 6
};
ParkingTicket parkingTicket7 = new ParkingTicket
{
LeavingTime = new DateTime(2020, 5, 10), TakingTime = new DateTime(2020, 5, 13),
//id = 7
};
//ParkingTicket parkingTicket1 = new ParkingTicket
//{
// Car = cars[0],
// Client = clients[0],
// ParkingPlace = parkingsPlaces[0],
// LeavingTime = new DateTime(2020, 5, 10),
// TakingTime = new DateTime(2020, 5, 13),
// id = 1
//};
//ParkingTicket parkingTicket2 = new ParkingTicket
//{
// Car = cars[1],
// Client = clients[1],
// ParkingPlace = parkingsPlaces[1],
// LeavingTime = new DateTime(2020, 5, 10),
// TakingTime = new DateTime(2020, 5, 13),
// id = 2
//};
//ParkingTicket parkingTicket3 = new ParkingTicket
//{
// Car = cars[2],
// Client = clients[2],
// ParkingPlace = parkingsPlaces[2],
// LeavingTime = new DateTime(2020, 5, 10),
// TakingTime = new DateTime(2020, 5, 13),
// id = 3
//};
//ParkingTicket parkingTicket4 = new ParkingTicket
//{
// Car = cars[3],
// Client = clients[3],
// ParkingPlace = parkingsPlaces[3],
// LeavingTime = new DateTime(2020, 5, 10),
// TakingTime = new DateTime(2020, 5, 13),
// id = 4
//};
//ParkingTicket parkingTicket5 = new ParkingTicket
//{
// Car = cars[4],
// Client = clients[0],
// ParkingPlace = parkingsPlaces[4],
// LeavingTime = new DateTime(2020, 5, 10),
// TakingTime = new DateTime(2020, 5, 13),
// id = 5
//};
//ParkingTicket parkingTicket6 = new ParkingTicket
//{
// Car = cars[5],
// Client = clients[1],
// ParkingPlace = parkingsPlaces[5],
// LeavingTime = new DateTime(2020, 5, 10),
// TakingTime = new DateTime(2020, 5, 13),
// id = 6
//};
//ParkingTicket parkingTicket7 = new ParkingTicket
//{
// Car = cars[6],
// Client = clients[2],
// ParkingPlace = parkingsPlaces[6],
// LeavingTime = new DateTime(2020, 5, 10),
// TakingTime = new DateTime(2020, 5, 13),
// id = 7
//};
parkingTickets.AddRange(new List <ParkingTicket>
{
parkingTicket1, parkingTicket2, parkingTicket3, parkingTicket4, parkingTicket5, parkingTicket6,
parkingTicket7
});
car1.Tickets.Add(parkingTickets[0]);
car2.Tickets.Add(parkingTickets[1]);
car3.Tickets.Add(parkingTickets[2]);
car4.Tickets.Add(parkingTickets[3]);
car5.Tickets.Add(parkingTickets[4]);
car6.Tickets.Add(parkingTickets[5]);
car7.Tickets.Add(parkingTickets[6]);
client1.Ticket = parkingTickets[0];
client2.Ticket = parkingTickets[1];
client3.Ticket = parkingTickets[1];
client4.Ticket = parkingTickets[1];
parking1.Places.AddRange(new List <ParkingPlace>
{
parkingsPlaces[0], parkingsPlaces[1], parkingsPlaces[2], parkingsPlaces[3]
});
parking1.Tickets.AddRange(new List <ParkingTicket>
{
parkingTickets[0], parkingTickets[1], parkingTickets[2], parkingTickets[3]
});
parking2.Places.AddRange(new List <ParkingPlace>
{
parkingsPlaces[4], parkingsPlaces[5], parkingsPlaces[6], parkingsPlaces[7], parkingsPlaces[8]
});
parking2.Tickets.AddRange(new List <ParkingTicket>
{
parkingTickets[4], parkingTickets[5], parkingTickets[6]
});
parkingPlace1.Ticket = parkingTickets[0];
parkingPlace2.Ticket = parkingTickets[1];
parkingPlace3.Ticket = parkingTickets[2];
parkingPlace4.Ticket = parkingTickets[3];
parkingPlace5.Ticket = parkingTickets[4];
parkingPlace6.Ticket = parkingTickets[5];
parkingPlace7.Ticket = parkingTickets[6];
foreach (var i in cars)
{
context.Cars.Add(i);
}
//if (context.Cars.Count()-1 > cars.Count)
//{
// var i = context.Cars.Count();
// return; // DB has been seeded
//}
context.SaveChanges();
foreach (var i in clients)
{
context.Clients.Add(i);
}
context.SaveChanges();
foreach (var i in parkings)
{
context.Parkings.Add(i);
}
context.SaveChanges();
foreach (var i in parkingsPlaces)
{
context.ParkingPlaces.Add(i);
}
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT parkingdb.dbo.ParkingPlaces ON;");
context.SaveChanges();
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT MyDB.Users OFF");
foreach (var i in parkingTickets)
{
context.ParkingTickets.Add(i);
}
context.SaveChanges();
}
public void Create(ParkingTicketDTO obj)
{
ParkingTicket ParkingTicket = mapper.ParkingTicketDTOToParkingTicket(obj);
ParkingTicketRepository.Create(ParkingTicket);
}
public void ReleaseParkingSpot(ParkingTicket parkingTicket)
{
throw new System.NotImplementedException();
}
public void Create(ParkingTicket obj)
{
//DataBaseSimulation.parkingTickets.Add(obj);
}
public void Update(ParkingTicket obj)
{
throw new System.NotImplementedException();
}
public void Print(ParkingTicket ticket, object args = null)
{
throw new NotImplementedException();
}
public void RegisterExit(ParkingTicket parkingTicket)
{
ParkingManager.FreeSpot(parkingTicket);
}
public void NewTicket(string licencePlate)
{
JavaScriptSerializer json = new JavaScriptSerializer();
ParkingTicket[] getParkingTicket = null;
DateTime trenutnoVreme = DateTime.Now;
DateTime ticketValid = new DateTime();
int parkingTicketId = 0;
try {
using (SqlConnection connection = new SqlConnection(DBConnection.ConnectionString)) {
// Pretraga da li vec postoji tiket sa zadatim tablicama i da li nije istekao
connection.Open();
SqlDataAdapter sda = new SqlDataAdapter();
using (SqlCommand command = new SqlCommand()) {
command.Connection = connection;
command.CommandText =
"SELECT * FROM parking_ticket WHERE car_licence_plate = @car_licence_plate " +
//"AND ticket_valid = (SELECT MAX(ticket_valid) FROM parking_ticket) " +
"AND ticket_valid > @ticket_valid";
command.Parameters.AddWithValue("@car_licence_plate", licencePlate);
command.Parameters.AddWithValue("@ticket_valid", trenutnoVreme);
command.CommandType = System.Data.CommandType.Text;
sda.SelectCommand = command;
}
DataTable dTable = new DataTable();
sda.Fill(dTable);
getParkingTicket = new ParkingTicket[dTable.Rows.Count];
int brojac = 0;
for (int i = 0; i < dTable.Rows.Count; ++i)
{
getParkingTicket[brojac] = new ParkingTicket()
{
parking_ticket_id = Convert.ToString(dTable.Rows[i]["parking_ticket_id"]),
car_licence_plate = Convert.ToString(dTable.Rows[i]["car_licence_plate"]),
ticket_valid = Convert.ToString(dTable.Rows[i]["ticket_valid"])
};
++brojac;
}
dTable.Clear();
connection.Close();
// Tiket sa zadatim tablicama ne postoji ili je istekao
if (getParkingTicket.Length == 0)
{
ticketValid = DateTime.Now.AddHours(1);
connection.Open();
using (SqlCommand command = new SqlCommand()) {
command.Connection = connection;
command.CommandText =
"INSERT INTO parking_ticket (car_licence_plate, ticket_valid) " +
"VALUES (@car_licence_plate, @ticket_valid)";
command.Parameters.AddWithValue("@car_licence_plate", licencePlate);
command.Parameters.AddWithValue("@ticket_valid", ticketValid);
command.ExecuteNonQuery();
}
connection.Close();
}
// Tiket sa zadatim tablicama postoji i nije istekao
else
{
parkingTicketId = Convert.ToInt32(getParkingTicket[getParkingTicket.Length - 1].parking_ticket_id);
ticketValid = Convert.ToDateTime(getParkingTicket[getParkingTicket.Length - 1].ticket_valid).AddHours(1);
connection.Open();
using (SqlCommand command = new SqlCommand()) {
command.Connection = connection;
command.CommandText =
"UPDATE parking_ticket SET ticket_valid = @ticket_valid WHERE parking_ticket_id = @parking_ticket_id";
command.Parameters.AddWithValue("@ticket_valid", ticketValid);
command.Parameters.AddWithValue("@parking_ticket_id", parkingTicketId);
command.ExecuteNonQuery();
}
connection.Close();
}
// Pretraga novog tiketa radi provere da li je pravilno upisan u bazu
connection.Open();
using (SqlCommand command = new SqlCommand()) {
command.Connection = connection;
command.CommandText =
"SELECT * FROM parking_ticket " +
"WHERE car_licence_plate = @car_licence_plate AND ticket_valid = @ticket_valid";
command.Parameters.AddWithValue("@car_licence_plate", licencePlate);
command.Parameters.AddWithValue("@ticket_valid", ticketValid);
command.CommandType = System.Data.CommandType.Text;
sda.SelectCommand = command;
}
sda.Fill(dTable);
getParkingTicket = new ParkingTicket[dTable.Rows.Count];
brojac = 0;
for (int i = 0; i < dTable.Rows.Count; ++i)
{
getParkingTicket[brojac] = new ParkingTicket()
{
parking_ticket_id = Convert.ToString(dTable.Rows[i]["parking_ticket_id"]),
car_licence_plate = Convert.ToString(dTable.Rows[i]["car_licence_plate"]),
ticket_valid = Convert.ToString(dTable.Rows[i]["ticket_valid"])
};
++brojac;
}
dTable.Clear();
connection.Close();
}
}
catch { }
var JSonData = new {
getParkingTicket = getParkingTicket
};
HttpContext.Current.Response.Write(json.Serialize(JSonData));
}
