public override int GetNextAvailablePayrollID()
        {
            int j    = 1000;
            var dc   = new Models.EmployeeDbModelEntities();
            var emps = dc.FW_Employees.Where(x => x.PayrollNumber >= 1000 && x.PayrollNumber < 1999).ToList();

            if (emps.Count > 0)
            {
                j = emps.Max(x => x.PayrollNumber);
            }

            return(j + 1);
        }
        public int GetNextAvailableEmployeeID()
        {
            int j    = StartEmployeeID;
            var dc   = new Models.EmployeeDbModelEntities( );
            var eIDs = dc.FW_Employees.Where(c => c.EmployeeNumber >= StartEmployeeID).OrderBy(x => x.EmployeeNumber).Select(
                x => x.EmployeeNumber).ToList();

            for (int i = StartEmployeeID; i <= 9900; i++)
            {
                if (!eIDs.Contains(i))
                {
                    j = i;
                    break;
                }
            }
            return(j);
        }