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