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 ActionResult Index()
{
JournalViewModel model = new JournalViewModel()
{
ListCams = new List <CameraHistory>()
};
List <Camera> cams;
using (JournalDbCobtext db = new JournalDbCobtext())
{
cams = db.Cameras.ToList();
}
foreach (var cam in cams)
{
model.ListCams.Add(new CameraHistory
{
Title = cam.Title,
Data = DataProvider.GetData(DateTime.Parse("2017-05-06"), cam.Id)
});
}
return(View(model));
}
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();
}
}
private Camera[] GetCams()
{
Camera[] cam = new Camera[0];
try
{
using (JournalDbCobtext db = new JournalDbCobtext())
{
cam = db.Cameras.ToArray();
}
}
catch (Exception e)
{
MessageBox.Show("При обращении к базе данных произошла ошибка: ", e.Message);
}
return(cam);
}
