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 HistoryGraph GetGraph() { var history = new HistoryGraph(); lock (_lockObj) { using (var context = new ScadaDbContext()) { var pump1list = context.History.Where(x => x.Mrid == "Flow_AM1").ToList(); pump1list.Skip(Math.Max(0, pump1list.Count() - 30)).ToList().ForEach(x => { history.Pump1.XAxe.Add(DateTime.Parse(x.TimeStamp)); history.Pump1.YAxe.Add(x.Value); }); var pump2list = context.History.Where(x => x.Mrid == "Flow_AM2").ToList(); pump2list.Skip(Math.Max(0, pump2list.Count() - 30)).ToList().ForEach(x => { history.Pump2.XAxe.Add(DateTime.Parse(x.TimeStamp)); history.Pump2.YAxe.Add(x.Value); }); var pump3list = context.History.Where(x => x.Mrid == "Flow_AM3").ToList(); pump3list.Skip(Math.Max(0, pump3list.Count() - 30)).ToList().ForEach(x => { history.Pump3.XAxe.Add(DateTime.Parse(x.TimeStamp)); history.Pump3.YAxe.Add(x.Value); }); var fluidlist = context.History.Where(x => x.Mrid == "FluidLevel_Tank").ToList(); fluidlist.Skip(Math.Max(0, fluidlist.Count() - 30)).ToList().ForEach(x => { history.FluidLevel.XAxe.Add(DateTime.Parse(x.TimeStamp)); history.FluidLevel.YAxe.Add(x.Value); }); } } return(history); }
public void Add(HistoryDbModel model) { lock (_lockObj) { using (var context = new ScadaDbContext()) { context.History.Add(model); context.SaveChanges(); } } }
public List <DomDbModel> GetAll() { List <DomDbModel> models = new List <DomDbModel>(); lock (_lockObject) { using (var context = new ScadaDbContext()) { models = context.Dom.ToList(); } } return(models); }
public List <HistoryDbModel> GetAll() { List <HistoryDbModel> list; lock (_lockObj) { using (var context = new ScadaDbContext()) { list = context.History.ToList().Take(100).ToList(); } } return(list); }
public List <HistoryDbModel> GetByTimestamp(DateTime timestamp) { string strTimeStamp = timestamp.ToString(); List <HistoryDbModel> list; lock (_lockObj) { using (var context = new ScadaDbContext()) { list = context.History.Where(dbm => dbm.TimeStamp == strTimeStamp).ToList(); } } return(list); }
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 Set(List <BasePoint> points) { using (var ctx = new ScadaDbContext()) { ctx.Database.ExecuteSqlCommand("TRUNCATE TABLE PointDbModels"); ctx.SaveChanges(); } _context = new ScadaDbContext(); var converter = new ReplicationConverter(); var convertedPoints = converter.ConvertForDb(points); foreach (var item in convertedPoints) { _context.ReplicationData.Add(item); } _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 List <HistoryDbModel> GetInInverval(DateTime from, DateTime to) { List <HistoryDbModel> allModels; List <HistoryDbModel> filterModels; lock (_lockObj) { using (var context = new ScadaDbContext()) { allModels = context.History.ToList(); filterModels = new List <HistoryDbModel>(); foreach (HistoryDbModel model in allModels) { if (DateTime.Parse(model.TimeStamp) >= from && DateTime.Parse(model.TimeStamp) <= to) { filterModels.Add(model); } } } } return(filterModels); }
public DomRepository(ScadaDbContext context) { _context = context; }
public DomRepository(ScadaDbContext context) { _context = context; _lockObject = new object(); }
public HistoryRepository(ScadaDbContext context) { _context = context; }
public ReplicationRepository(ScadaDbContext context) { _context = context; }
public HistoryRepository(ScadaDbContext context) { _context = context; _lockObj = new object(); }