public void Add(List <DomDbModel> list)
{
foreach (var model in list)
{
DomDbModel m = _context.Dom.FirstOrDefault(d => d.Mrid == model.Mrid);
if (m == null)
{
_context.Dom.Add(model);
}
}
_context.SaveChanges();
}
public void Set(List <BasePoint> points)
{
_context.Database.ExecuteSqlCommand("TRUNCATE TABLE PointDbModels");
_context.SaveChanges();
var converter = new ReplicationConverter();
var convertedPoints = converter.ConvertForDb(points);
foreach (var item in convertedPoints)
{
_context.ReplicationData.Add(item);
}
_context.SaveChanges();
}
public void AddOrUpdateRange(List <DomDbModel> list)
{
lock (_lockObject)
{
using (var context = new ScadaDbContext())
{
foreach (var model in list)
{
DomDbModel m = context.Dom.FirstOrDefault(d => !String.IsNullOrEmpty(d.Mrid) && d.Mrid == model.Mrid);
if (m == null)
{
context.Dom.Add(model);
}
else
{
m.ManipulationConut++;
m.TimeStamp = DateTime.Now.ToString();
context.Entry(m).State = System.Data.Entity.EntityState.Modified;
}
}
context.SaveChanges();
}
}
}
public void Add(HistoryDbModel model)
{
lock (_lockObj)
{
using (var context = new ScadaDbContext())
{
context.History.Add(model);
context.SaveChanges();
}
}
}
public void AddRange(List <HistoryDbModel> list)
{
lock (_lockObj)
{
using (var context = new ScadaDbContext())
{
foreach (var model in list)
{
context.History.Add(model);
}
context.SaveChanges();
}
}
}
public void Add(List <DomDbModel> list)
{
lock (_lockObject)
{
using (var context = new ScadaDbContext())
{
foreach (var model in list)
{
DomDbModel m = context.Dom.FirstOrDefault(d => d.Mrid == model.Mrid);
if (m == null)
{
context.Dom.Add(model);
}
}
context.SaveChanges();
}
}
}
public void UpdateSingle(DomDbModel model)
{
lock (_lockObject)
{
using (var context = new ScadaDbContext())
{
DomDbModel m = context.Dom.FirstOrDefault(d => !String.IsNullOrEmpty(d.Mrid) && d.Mrid == model.Mrid);
if (m != null)
{
m.ManipulationConut++;
m.TimeStamp = DateTime.Now.ToString();
context.Entry(m).State = System.Data.Entity.EntityState.Modified;
}
context.SaveChanges();
}
}
}
public void Add(HistoryDbModel model)
{
_context.History.Add(model);
_context.SaveChanges();
}