public Parkinglots Add(Parkinglots parkinglots) { try { string insertString = "insert into Parkinglots (isin, day, ParkingTime) values (@isin, @day, @ParkingTime);"; using (SqlConnection conn = new SqlConnection(Secrets.ConnectionString)) { conn.Open(); using (SqlCommand command = new SqlCommand(insertString, conn)) { GuardedAssign(command, "@isin", parkinglots.isin); GuardedAssign(command, "@day", parkinglots.day); GuardedAssign(command, "@ParkingTime", parkinglots.ParkingTime); int rowsAffected = command.ExecuteNonQuery(); return(parkinglots); } } } catch (Exception) { throw; } }
public void AddTest() { Parkinglots parkinglots = new Parkinglots { isin = 1, day = DateTime.Today }; Parkinglots test = manager.Add(parkinglots); Assert.AreEqual(parkinglots.isin, test.isin); Assert.AreEqual(parkinglots.day, test.day); int count = controller.Getbyday(2021, 05, 14); Assert.AreEqual(count, controller.Getbyday(2021, 05, 14)); }
public ActionResult <Parkinglots> Post([FromBody] Parkinglots value) { try { Parkinglots parkinglots = manager.Add(value); string uri = Url.RouteUrl(RouteData.Values) + "/" + parkinglots.id; return(Created(uri, parkinglots)); } catch (ParkinglotsException ex) { return(BadRequest(ex.Message)); } }
/// <summary> /// Denne metode modtager oplysninger fra vores raspberry pi /// </summary> public void ReciverData() { // bestemmer hvilken port programmet skal modtager oplysninger // laver ip adresse om til en string IPAddress ip = IPAddress.Parse("127.0.0.1"); // her bliver afgjort hvilken ip adresse den modtager fra // og bestemt hvilken port den modtager i. IPEndPoint RemoteIPEndpoint = new IPEndPoint(ip, 9999); try { Car car = new Car(); Parkinglots parkinglots = new Parkinglots(); // laver de modtaget oplysninger om byte array Byte[] recivedBytes = udpServer.Receive(ref RemoteIPEndpoint); Console.WriteLine("modtaget"); // laver oplysninng om fra byte til string string recivedData = Encoding.ASCII.GetString(recivedBytes); // splidt oplysning op i hver deres felt af et string array string[] data = recivedData.Split(" "); // ligger oplysninger hen modellens properties car.Color = data[0]; car.LicensePlate = data[3]; // laver det om til tal fra string inden bliver lagt over i properties parkinglots.isin = Int32.Parse(data[1]); parkinglots.day = DateTime.Parse(data[2]); parkinglots.ParkingTime = Int32.Parse(data[4]); Console.WriteLine(car.Color + " " + parkinglots.isin + " " + parkinglots.day + " " + car.LicensePlate + " " + parkinglots.ParkingTime); Car c = Consumer.PostToCar <Car, Car>("https://3semester-denroedegruppe.azurewebsites.net/api/cars", car).Result; Parkinglots p = Consumer.PostToparkinglot <Parkinglots, Parkinglots>("https://3semester-denroedegruppe.azurewebsites.net/api/parkinglots", parkinglots).Result; } catch (Exception e) { Console.WriteLine(e.ToString()); } }
private Parkinglots ReadParkinglots(SqlDataReader reader) { int id = reader.GetInt32(0); int isin = reader.GetInt32(1); int parkingTime = reader.GetInt32(3); DateTime day = GuardedGet <DateTime>(reader, 2); Parkinglots parkinglots = new Parkinglots { id = id, isin = isin, day = day, ParkingTime = parkingTime }; return(parkinglots); }
public IEnumerable <Parkinglots> GetAll() { string SelectString = "select * from Parkinglots"; using (SqlConnection conn = new SqlConnection(Secrets.ConnectionString)) { conn.Open(); using (SqlCommand command = new SqlCommand(SelectString, conn)) { using (SqlDataReader reader = command.ExecuteReader()) { List <Parkinglots> List = new List <Parkinglots>(); while (reader.Read()) { Parkinglots parkinglots = ReadParkinglots(reader); List.Add(parkinglots); } return(List); } } } }
public void StartTest() { parkinglots = new Parkinglots(); controller = new ParkinglotsController(); manager = new ParkinglotsManager(); }