public static CustomCollection <Boss> SelectAllEmployeeBosses()
{
// Execute SQL Command
SqlCommand sqlCmd = new SqlCommand();
DatabaseUtility.SetCommandType(sqlCmd, CommandType.StoredProcedure, SP_CUSTOM_EMPLOYEES_GETALLEMPLOYEEBOSSES);
GenerateCollectionFromReader test = new GenerateCollectionFromReader(GenerateBossCollectionFromReader);
CustomCollection <Boss> objCollection = ((CustomCollection <Boss>)DatabaseUtility.ExecuteReaderCmd(sqlCmd, test));
return(objCollection);
}
public static Boss GetEmployeeBossByEmployeeId(int employeeId)
{
if (employeeId < GetIdMinValue)
{
throw (new ArgumentOutOfRangeException("employeeId"));
}
// Execute SQL Command
SqlCommand sqlCmd = new SqlCommand();
DatabaseUtility.AddParameterToSqlCmd(sqlCmd, "@employeeId", SqlDbType.Int, 0, ParameterDirection.Input, employeeId);
DatabaseUtility.SetCommandType(sqlCmd, CommandType.StoredProcedure, SP_CUSTOM_EMPLOYEES_GETEMPLOYEEBOSSBYEMPLOYEEID);
GenerateCollectionFromReader test = new GenerateCollectionFromReader(GenerateBossCollectionFromReader);
CustomCollection <Boss> objCollection = ((CustomCollection <Boss>)DatabaseUtility.ExecuteReaderCmd(sqlCmd, test));
if (objCollection.Count > 0)
{
return(objCollection[0]);
}
else
{
return(null);
}
}