//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>();
}