public int GetCount()
{
using (AGV_ProjectEntities entities = new AGV_ProjectEntities())
{
return(entities.Set <T>().Count());
}
}
public List <T> GetAll()
{
using (AGV_ProjectEntities entities = new AGV_ProjectEntities())
{
return(entities.Set <T>().ToList());
}
}
public List <S> Select <S>(Expression <Func <T, S> > selector)
{
using (AGV_ProjectEntities entities = new AGV_ProjectEntities())
{
return(entities.Set <T>().Select(selector).ToList());
}
}
public void Delete(T entity)
{
using (AGV_ProjectEntities entities = new AGV_ProjectEntities())
{
entities.Entry(entity).State = EntityState.Deleted;
entities.SaveChanges();
}
}
public void Insert(T entity)
{
using (AGV_ProjectEntities entities = new AGV_ProjectEntities())
{
entities.Set <T>().Add(entity);
entities.SaveChanges();
}
}
public bool CheckENum(string Enum)
{
using (AGV_ProjectEntities context = new AGV_ProjectEntities())
{
var query = from x in context.Regists
where x.EmployeeNum.Equals(Enum)
select x;
return(query.Any());
}
}
public Regist CheckEmployeeInfo(string ENum, string pw, string EName)
{
using (AGV_ProjectEntities context = new AGV_ProjectEntities())
{
var query = from x in context.Regists
where
x.EmployeeNum.Equals(ENum) && x.Password.Equals(pw) && x.OperatorName.Equals(EName)
select x;
var list = query.ToList();
return(list.FirstOrDefault());
}
}
