public static void InitCameras() { SettingsManager sm; try { string path = ConfigurationManager.AppSettings["PathToSettingsXML"]; sm = new SettingsManager(path); sm.LoadConfig(); } catch (Exception ex) { throw ex; } using (JournalDbCobtext db = new JournalDbCobtext()) { // *** Нужно не удалять, а обновлять в случае необходимости *** foreach (var set in sm.SettingsList) { db.Cameras.Add(new Camera() { Title = set.Title, Source = "http://" + sm.Ip_vlc + ":" + set.Port_vlc }); } db.SaveChanges(); Console.WriteLine("Cameras updated"); } }
public static void SaveToDatabase(DetectingEventArgs e) { using (JournalDbCobtext db = new JournalDbCobtext()) { db.Logs.Add(new Log() { AverageMotions = e.AverageMotions, TimeStart = e.TimeStart, TimeFinish = e.TimeFinish, TotalCount = e.TotalCount, Camera = db.Cameras.Where(x => x.Source == e.DataSource).SingleOrDefault() }); db.SaveChanges(); } }