public static EApplication GetByName(EApplication _pdata, DBEngine DatabaseEngine) { SqlDataReader oReader = null; try { //Fill the request's parameters SqlParameter[] p_sqlParams = RegisterSqlParameter(_pdata); //Call the request oReader = DatabaseEngine.ExecuteReader(CommandType.StoredProcedure, CCstDatabase.SP_Application_GetByName, p_sqlParams); //If there is a result (not null) if (oReader != null) { while (oReader.Read()) { //Read the data and convert the SqlDataReader in the waiting object return(ReadData(oReader)); } } return(null); } catch (Exception e) { throw e; } finally { if (oReader != null && !oReader.IsClosed) { oReader.Close(); } } }
public static ECollectionLoggerType GetList() { SqlDataReader oReader = null; try { //Initialize the return object ECollectionLoggerType oCollData = new ECollectionLoggerType(); //Call the request using (DBEngine DBInstance = CCstData.GetInstance("").DatabaseEngine) { oReader = DBInstance.ExecuteReader(CommandType.StoredProcedure, CCstDatabase.SP_LoggerType_GetList); } //If there is a result (not null) if (oReader != null) { while (oReader.Read()) { ELoggerType oData = new ELoggerType(); //Read the data and convert the SqlDataReader in the waiting object oData = ReadData(oReader); //Add the data to the return list oCollData.Add(oData); } } return(oCollData); } catch (Exception e) { throw e; } finally { if (oReader != null && !oReader.IsClosed) { oReader.Close(); } } }