//Override any generic method for your own custom implemention, add new repository methods to the IOperatorRepository.cs file public string GetOperatorIdByOperatorName(string user) { string _UserId = ""; using (_context) { ObjectSet <Operator> authorSet = _context.CreateObjectSet <Operator>(); ObjectQuery <Operator> q = authorSet.Where("it.UserName == @UserName", new ObjectParameter("UserName", user)); ObjectResult <Operator> a = q.Execute(MergeOption.OverwriteChanges); IEnumerator <Operator> e = a.GetEnumerator(); while (e.MoveNext()) { Operator item = e.Current; _UserId = item.ID.ToString() + "-" + item.UserName; } return(_UserId.ToString()); } }
//Override any generic method for your own custom implemention, add new repository methods to the IPanelRepository.cs file public List <Panel> GetPanelsByControlUnitID(int id) { List <Panel> _panels = new List <Panel>(); if (id > -1) { using (this._context) { ObjectSet <Panel> authorSet = _context.CreateObjectSet <Panel>(); ObjectQuery <Panel> q = authorSet.Where("it.ControlUnitID == @ControlUnitID && it.IsActive == true", new ObjectParameter("ControlUnitID", id)); ObjectResult <Panel> a = q.Execute(MergeOption.OverwriteChanges); IEnumerator <Panel> e = a.GetEnumerator(); while (e.MoveNext()) { Panel item = e.Current; _panels.Add(item); } } } return(_panels); }
protected Repository(SnifferConfigDBEntities context) { _entities = context.CreateObjectSet <TEntity>(); }