public bool Exists(ConnectedPair item) { using (var db = new DataBaseContext()) { return(db.ConnectedPairs.Any(x => x.AltCoin == item.AltCoin && x.MainCoin == item.MainCoin)); } }
public ConnectedPair Create(ConnectedPair item) { using (var db = new DataBaseContext()) { ConnectedPair result = null; if (!Exists(item)) { result = db.ConnectedPairs.Add(item).Entity; } db.SaveChanges(); return(result); } }
public ConnectedPair Update(ConnectedPair item) { using (var db = new DataBaseContext()) { var result = db.ConnectedPairs.FirstOrDefault(x => x.MainCoin == item.MainCoin && x.AltCoin == item.AltCoin); if (result != null) { result.MainCoin = item.MainCoin; result.AltCoin = item.AltCoin; result.Active = item.Active; } db.SaveChanges(); return(result); } }