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