public static List <EmployeeReportsTo> GetEmployeeReportsToListByFilter(string searchValue, int unassigned, int accountId) { List <EmployeeReportsTo> list = new List <EmployeeReportsTo>(); Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep"); string sqlCommand = "GetEmployeeReportsToListByFilter"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "@SearchValue", DbType.String, searchValue); db.AddInParameter(dbCommand, "@Unassigned", DbType.Int32, unassigned); db.AddInParameter(dbCommand, "@AccountId", DbType.Int32, accountId); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { EmployeeReportsTo employeeReportsTo = new EmployeeReportsTo(); employeeReportsTo.EmployeeNumber = dataReader["EmployeeNumber"].ToString(); employeeReportsTo.FirstName = dataReader["FirstName"].ToString(); employeeReportsTo.LastName = dataReader["LastName"].ToString(); employeeReportsTo.EmployeeId = Convert.ToInt32(dataReader["EmployeeId"]); employeeReportsTo.ReportsToId = Convert.ToInt32(dataReader["ReportsToId"]); employeeReportsTo.ReportsToEmployeeNumber = dataReader["ReportsToEmployeeNumber"].ToString(); employeeReportsTo.ReportsToFirstName = dataReader["ReportsToFirstName"].ToString(); employeeReportsTo.ReportsToLastName = dataReader["ReportsToLastName"].ToString(); list.Add(employeeReportsTo); } } return(list); }
public static List <EmployeeReportsTo> GetReportsToEmployeeListByEmployeeId(int employeeId) { List <EmployeeReportsTo> list = new List <EmployeeReportsTo>(); Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep"); string sqlCommand = "GetReportsToEmployeeListByEmployeeId"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "@EmployeeId", DbType.Int32, employeeId); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { EmployeeReportsTo employeeReportsTo = new EmployeeReportsTo(); employeeReportsTo.EmployeeNumber = dataReader["EmployeeNumber"].ToString(); employeeReportsTo.FirstName = dataReader["FirstName"].ToString(); employeeReportsTo.LastName = dataReader["LastName"].ToString(); employeeReportsTo.EmployeeId = Convert.ToInt32(dataReader["EmployeeId"]); employeeReportsTo.ReportsToId = Convert.ToInt32(dataReader["ReportsToId"]); employeeReportsTo.ReportsToEmployeeNumber = dataReader["ReportsToEmployeeNumber"].ToString(); employeeReportsTo.ReportsToFirstName = dataReader["ReportsToFirstName"].ToString(); employeeReportsTo.ReportsToLastName = dataReader["ReportsToLastName"].ToString(); list.Add(employeeReportsTo); } } return(list); }
public static EmployeeReportsTo GetEmployeeReportsToTOPByEmployeeId(int employeeId) { Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep"); string sqlCommand = "GetEmployeeReportsToTOPByEmployeeId"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "@EmployeeId", DbType.Int32, employeeId); db.AddOutParameter(dbCommand, "@ReportsToId", DbType.Int32, 4); db.ExecuteNonQuery(dbCommand); EmployeeReportsTo employeeReportsTo = new EmployeeReportsTo(); employeeReportsTo.EmployeeId = employeeId; employeeReportsTo.ReportsToId = Convert.ToInt32(db.GetParameterValue(dbCommand, "ReportsToId")); return(employeeReportsTo); }