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