/// <summary>
/// Gets the Video in the database With a full join with all the manually specified tables in SP code
/// </summary>
public static Video GetVideoByWebVideoIDWithJoin(string WebVideoID)
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("HG_GetVideoByWebVideoIDWithJoin");
db.AddInParameter(dbCommand, "WebVideoID", DbType.String, WebVideoID);
List <Video> Videos = null;
//execute the stored procedure
using (IDataReader dr = db.ExecuteReader(dbCommand))
{
Videos = Video.PopulateObjectWithJoin(dr);
dr.Close();
}
// Create the object array from the datareader
if (Videos.Count > 0)
{
return(Videos[0]);
}
else
{
return(null);
}
//throw new Exception("There is no video with the WebvideoID " + WebVideoID);
}
//public static List<Video> GetVideosByMemberIDWithJoin(int MemberID, PrivacyType privacyFlag)
//{
// //PrivacyType privacyFlag = PrivacyType.Network;
// Database db = DatabaseFactory.CreateDatabase();
// DbCommand dbCommand = null;
// dbCommand = db.GetStoredProcCommand("HG_GetVideosByMemberIDWithJoin");
// db.AddInParameter(dbCommand, "MemberID", DbType.Int32, MemberID);
// db.AddInParameter(dbCommand, "PrivacyFlag", DbType.Int32, (int)privacyFlag);
// List<Video> Videos = null;
// //execute the stored procedure
// using (IDataReader dr = db.ExecuteReader(dbCommand))
// {
// Videos = Video.PopulateObjectWithJoin(dr);
// dr.Close();
// }
// // Create the object array from the datareader
// return Videos;
//}
public static List <Video> GetFavouriteVideosByMemberIDWithJoin(int MemberID)
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = null;
dbCommand = db.GetStoredProcCommand("HG_GetFavouriteVideosByMemberIDWithJoin");
db.AddInParameter(dbCommand, "MemberID", DbType.Int32, MemberID);
List <Video> Videos = null;
//execute the stored procedure
using (IDataReader dr = db.ExecuteReader(dbCommand))
{
Videos = Video.PopulateObjectWithJoin(dr);
dr.Close();
}
// Create the object array from the datareader
return(Videos);
}
public static List <Video> GetMemberVideosWithJoinOrdered(int MemberID, PrivacyType privacyFlag, string OrderByClause)
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = null;
dbCommand = db.GetStoredProcCommand("HG_GetMemberVideosWithJoinOrdered");
db.AddInParameter(dbCommand, "MemberID", DbType.Int32, MemberID);
db.AddInParameter(dbCommand, "PrivacyFlag", DbType.Int32, (int)privacyFlag);
db.AddInParameter(dbCommand, "OrderByClause", DbType.String, OrderByClause);
List <Video> Videos = null;
//execute the stored procedure
using (IDataReader dr = db.ExecuteReader(dbCommand))
{
Videos = Video.PopulateObjectWithJoin(dr);
dr.Close();
}
// Create the object array from the datareader
return(Videos);
}
