static public HREntities getEntity() { if (ob == null) { ob = new HREntities(); ob.Configuration.ProxyCreationEnabled = false; } return(ob); }
// =================================Entity===============================// public bool CheckID(Employees employeesId) { using (HREntities db = new HREntities()) { if (db.Staffs.Any(p => p.ID == employeesId.ID)) { return(true); } return(false); } }
public Staff InsertInfor(Employees employinfor) { using (HREntities db = new HREntities()) { Staff employee = new Staff(); employee.ID = employinfor.ID; employee.Name = employinfor.Name; employee.Department = employinfor.Department; employee.Salary = en.Encrypt(employinfor.Salary); db.Staffs.Add(employee); db.SaveChanges(); return(employee); } }
public List <Employees> GetAllInfor() { List <Employees> employeesList = new List <Employees>(); using (HREntities db = new HREntities()) { var staff = db.Staffs.ToList(); foreach (var item in staff) { employeesList.Add(new Employees { ID = item.ID, Name = item.Name, Department = item.Department, Salary = de.Decrypt(item.Salary) }); } } return(employeesList); }