public virtual MessageContentAttachementCollection GetMessageContentAttachementList(Int32 messageContentID, MessageContentAttachementColumns orderBy, string orderDirection, int page, int pageSize, out int totalRecords) { try { Database database = DatabaseFactory.CreateDatabase("CustommerServiceConnection"); DbCommand dbCommand = database.GetStoredProcCommand("spMessageContentAttachementGetListByMessageContentID"); database.AddInParameter(dbCommand, "@MessageContentID", DbType.Int32, messageContentID); database.AddInParameter(dbCommand, "@OrderBy", DbType.AnsiString, orderBy.ToString()); database.AddInParameter(dbCommand, "@OrderDirection", DbType.AnsiString, orderDirection.ToString()); database.AddInParameter(dbCommand, "@Page", DbType.Int32, page); database.AddInParameter(dbCommand, "@PageSize", DbType.Int32, pageSize); database.AddOutParameter(dbCommand, "@TotalRecords", DbType.Int32, 4); MessageContentAttachementCollection messageContentAttachementCollection = new MessageContentAttachementCollection(); using (IDataReader reader = database.ExecuteReader(dbCommand)) { while (reader.Read()) { MessageContentAttachement messageContentAttachement = CreateMessageContentAttachementFromReader(reader); messageContentAttachementCollection.Add(messageContentAttachement); } reader.Close(); } totalRecords = (int)database.GetParameterValue(dbCommand, "@TotalRecords"); return messageContentAttachementCollection; } catch (Exception ex) { // log this exception log4net.Util.LogLog.Error(ex.Message, ex); // wrap it and rethrow throw new ApplicationException(SR.DataAccessGetMessageContentAttachementListException, ex); } }
public virtual MessageContentAttachementCollection ExistsMessageContentForMessageContentAttachement(int messageContentId) { try { Database database = DatabaseFactory.CreateDatabase("CustommerServiceConnection"); DbCommand dbCommand = database.GetStoredProcCommand("spMessageContentForMessageContentAttachement"); database.AddInParameter(dbCommand, "@MessageContentID", DbType.Int32, messageContentId); MessageContentAttachementCollection messageContentAttachementCollection = new MessageContentAttachementCollection(); using (IDataReader reader = database.ExecuteReader(dbCommand)) { while (reader.Read()) { MessageContentAttachement messageContentAttachement = CreateMessageContentAttachementFromReader(reader); messageContentAttachementCollection.Add(messageContentAttachement); } reader.Close(); } return messageContentAttachementCollection; } catch (Exception ex) { // log this exception log4net.Util.LogLog.Error(ex.Message, ex); // wrap it and rethrow throw new ApplicationException(SR.DataAccessGetMessageContentAttachementListException, ex); } }