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