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 static bool ExistsMessageContentForMessageContentAttachement(int messageContentID)
{
bool resual = false;
MessageContentAttachementCollection messageContentAttachementCollection = new MessageContentAttachementCollection();
messageContentAttachementCollection = MessageContentAttachementService.ExistsMessageContentForMessageContentAttachement(messageContentID);
if (messageContentAttachementCollection.Count > 0) resual = true;
return resual;
}
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);
}
}