public void AddToDB(string target, DateTime date, int price)
{
date = new DateTime(date.Year, date.Month, date.Day, date.Hour, date.Minute, date.Second, date.Kind);
var user = _db.Users.Where(u => u.UserName == target).FirstOrDefault();
string uid = user.Id;//[*]
var did = user.OBD_Id;
var test = new ParkingOrder
{
DeviceId = did,//target.deviceid
UserId = uid,
PowerOff = date,
Price = price
};
Debug.WriteLine(test);
_db.ParkingOrders.Add(test);
try
{
_db.SaveChanges();
}
catch (Exception e)
{
_log.Error(e);
}
}
public static void AddSingleOrderToDatabase(ParkingOrder order)
{
Console.WriteLine("\nAdd order to database");
var context = new ParkingContext();
context.ParkingOrders.Add(order);
Console.WriteLine("Press a key to save to database");
Console.ReadKey();
// DONE: Save change in database
context.SaveChanges();
Console.WriteLine("\nOrder saved to database");
}
