/// <summary>
/// Populates the media with view count.
/// </summary>
/// <param name="reader">The reader.</param>
/// <returns></returns>
private static MediaWithViewCount PopulateMediaWithViewCount(INullableReader reader)
{
MediaWithViewCount media = new MediaWithViewCount
{
MediaId = reader.GetInt32("MediaId"),
CreateDate = reader.GetDateTime("CreateDate"),
Title = reader.GetString("Title"),
Description = reader.GetString("Description"),
Month = reader.GetNullableInt32("MediaMonth"),
Year = reader.GetNullableInt32("MediaYear"),
Day = reader.GetNullableInt32("MediaDay"),
ViewCount = reader.GetInt32("ViewCount"),
Owner = new Owner
{
UserId = reader.GetInt32("UserId"),
Username = reader.GetString("Username"),
FirstName = reader.GetString("FirstName"),
LastName = reader.GetString("LastName"),
},
Status = reader.GetString("Status").ParseEnum <MediaStatus>(),
Tags = reader.GetString("Tags"),
CommentCount = reader.GetInt32("CommentCount")
};
return(media);
}
/// <summary>
/// Populates the media with view count.
/// </summary>
/// <param name="reader">The reader.</param>
/// <returns></returns>
private static MediaWithViewCount PopulateMediaWithViewCount(INullableReader reader)
{
MediaWithViewCount media = new MediaWithViewCount
{
MediaId = reader.GetInt32("MediaId"),
CreateDate = reader.GetDateTime("CreateDate"),
Title = reader.GetString("Title"),
Description = reader.GetString("Description"),
Month = reader.GetNullableInt32("MediaMonth"),
Year = reader.GetNullableInt32("MediaYear"),
Day = reader.GetNullableInt32("MediaDay"),
ViewCount = reader.GetInt32("ViewCount"),
Owner = new Owner
{
UserId = reader.GetInt32("UserId"),
Username = reader.GetString("Username"),
FirstName = reader.GetString("FirstName"),
LastName = reader.GetString("LastName"),
},
Status = reader.GetString("Status").ParseEnum<MediaStatus>(),
Tags = reader.GetString("Tags"),
CommentCount = reader.GetInt32("CommentCount")
};
return media;
}
/// <summary>
/// Populates the statistic.
/// </summary>
/// <param name="reader">The reader.</param>
/// <returns></returns>
private static Statistic PopulateStatistic(INullableReader reader)
{
Statistic statistic = new Statistic {
Count = reader.GetInt32("Count"), Name = reader.GetString("Name")
};
return(statistic);
}
/// <summary>
/// Populates the specified reader.
/// </summary>
/// <param name="reader">The reader.</param>
/// <returns></returns>
private static AlphabetPage Populate(INullableReader reader)
{
AlphabetPage alphabetPage = new AlphabetPage
{
Letter = reader.GetString("PageIndex"),
MediaCount = reader.GetInt32("MediaCountInLetter")
};
return alphabetPage;
}
/// <summary>
/// Populates the specified reader.
/// </summary>
/// <param name="reader">The reader.</param>
/// <returns></returns>
private static AlphabetPage Populate(INullableReader reader)
{
AlphabetPage alphabetPage = new AlphabetPage
{
Letter = reader.GetString("PageIndex"),
MediaCount = reader.GetInt32("MediaCountInLetter")
};
return(alphabetPage);
}
/// <summary>
/// Populates the member.
/// </summary>
/// <param name="reader">The reader.</param>
/// <returns></returns>
public Member PopulateMember(INullableReader reader)
{
Member member = new Member
{
Media = database.AutoPopulate<Media>(reader),
User = UserRepository.Populate(reader)
};
_hydrationService.Populate(new List<Media> { member.Media });
return member;
}
/// <summary>
/// Populates the specified reader.
/// </summary>
/// <param name="reader">The reader.</param>
/// <returns></returns>
private static UploaderMedia Populate(INullableReader reader)
{
UploaderMedia media = new UploaderMedia
{
Id = reader.GetInt32("MediaId"),
UploadStatus = reader.GetString("UploadStatus").ParseEnum<MediaUploadState>(),
UserId = reader.GetInt32("UserId")
};
return media;
}
/// <summary>
/// Populates the specified reader.
/// </summary>
/// <param name="reader">The reader.</param>
/// <returns></returns>
private static UploaderMedia Populate(INullableReader reader)
{
UploaderMedia media = new UploaderMedia
{
Id = reader.GetInt32("MediaId"),
UploadStatus = reader.GetString("UploadStatus").ParseEnum <MediaUploadState>(),
UserId = reader.GetInt32("UserId")
};
return(media);
}
/// <summary>
/// Populates the specified reader.
/// </summary>
/// <param name="reader">The reader.</param>
/// <returns></returns>
internal static Tag Populate(INullableReader reader)
{
Tag tag = new Tag(reader.GetString("TagName"))
{
Id = reader.GetInt32("TagId"),
Count = reader.GetInt32("TagCount"),
Description = reader.GetNullableString("Description") ?? string.Empty
};
return(tag);
}
/// <summary>
/// Populates the specified reader.
/// </summary>
/// <param name="reader">The reader.</param>
/// <returns></returns>
private static MediaQueue Populate(INullableReader reader)
{
MediaQueue queue = new MediaQueue
{
Id = reader.GetInt64("MediaQueueId"),
MediaId = reader.GetInt32("MediaId"),
Filename = reader.GetString("Filename"),
MediaBytes = (byte[])reader.GetValue("MediaBytes")
};
return(queue);
}
/// <summary>
/// Populates the member.
/// </summary>
/// <param name="reader">The reader.</param>
/// <returns></returns>
public Member PopulateMember(INullableReader reader)
{
Member member = new Member
{
Media = database.AutoPopulate <Media>(reader),
User = UserRepository.Populate(reader)
};
_hydrationService.Populate(new List <Media> {
member.Media
});
return(member);
}
/// <summary>
/// Populates the specified reader.
/// </summary>
/// <param name="reader">The reader.</param>
/// <returns></returns>
internal static User Populate(INullableReader reader)
{
User user = new User
{
Id = reader.GetInt32("UserId"),
FirstName = reader.GetString("FirstName"),
LastName = reader.GetString("LastName"),
Password = reader.GetString("Password"),
Email = reader.GetString("Email"),
DisplayName = reader.GetString("DisplayName"),
Deleted = reader.GetBoolean("Deleted"),
Username = reader.GetString("Username"),
AccountStatus = reader.GetString("AccountStatus").ParseEnum <AccountStatus>(),
Settings = new UserSettings
{
EnableReceivingOfEmails = reader.GetBoolean("EnableReceivingOfEmails"),
WebViewMaxHeight = reader.GetInt16("WebViewMaxHeight"),
WebViewMaxWidth = reader.GetInt16("WebViewMaxWidth")
}
};
return(user);
}
/// <summary>
/// Populates the remaining count.
/// </summary>
/// <param name="reader">The reader.</param>
/// <returns></returns>
private static byte PopulateRemainingCount(INullableReader reader)
{
return((byte)reader.GetInt32("RemainingInvitations"));
}
/// <summary>
/// Populates the remaining count.
/// </summary>
/// <param name="reader">The reader.</param>
/// <returns></returns>
private static byte PopulateRemainingCount(INullableReader reader)
{
return (byte)reader.GetInt32("RemainingInvitations");
}
/// <summary>
/// Populates the statistic.
/// </summary>
/// <param name="reader">The reader.</param>
/// <returns></returns>
private static Statistic PopulateStatistic(INullableReader reader)
{
Statistic statistic = new Statistic {Count = reader.GetInt32("Count"), Name = reader.GetString("Name")};
return statistic;
}
/// <summary>
/// Populates the specified reader.
/// </summary>
/// <param name="reader">The reader.</param>
/// <returns></returns>
internal static Tag Populate(INullableReader reader)
{
Tag tag = new Tag(reader.GetString("TagName"))
{
Id = reader.GetInt32("TagId"),
Count = reader.GetInt32("TagCount"),
Description = reader.GetNullableString("Description") ?? string.Empty
};
return tag;
}
/// <summary>
/// Populates the specified reader.
/// </summary>
/// <param name="reader">The reader.</param>
/// <returns></returns>
internal static User Populate(INullableReader reader)
{
User user = new User
{
Id = reader.GetInt32("UserId"),
FirstName = reader.GetString("FirstName"),
LastName = reader.GetString("LastName"),
Password = reader.GetString("Password"),
Email = reader.GetString("Email"),
DisplayName = reader.GetString("DisplayName"),
Deleted = reader.GetBoolean("Deleted"),
Username = reader.GetString("Username"),
AccountStatus = reader.GetString("AccountStatus").ParseEnum<AccountStatus>(),
Settings = new UserSettings
{
EnableReceivingOfEmails = reader.GetBoolean("EnableReceivingOfEmails"),
WebViewMaxHeight = reader.GetInt16("WebViewMaxHeight"),
WebViewMaxWidth = reader.GetInt16("WebViewMaxWidth")
}
};
return user;
}
/// <summary>
/// Populates the specified reader.
/// </summary>
/// <param name="reader">The reader.</param>
/// <returns></returns>
private static MediaQueue Populate(INullableReader reader)
{
MediaQueue queue = new MediaQueue
{
Id = reader.GetInt64("MediaQueueId"),
MediaId = reader.GetInt32("MediaId"),
Filename = reader.GetString("Filename"),
MediaBytes = (byte[]) reader.GetValue("MediaBytes")
};
return queue;
}
