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