public int InsertVideoLinks(clsVideos cs)
{
try
{
dataProvider.ExecuteNonQuery("usp_InsertVideoLinks", cs.VideoId, cs.SportId, cs.CountryId, cs.SeasonId, cs.CompetitionId, cs.ClubId, cs.ClubOwnersId, cs.ClubMemberId, cs.TeamId, cs.TeamMemberId, cs.SponsorId, cs.EventId, cs.PlayerId);
}
catch (Exception ex)
{
Exceptions.LogException(ex);
}
return(0);
}
public int InsertVideo(clsVideos cs)
{
try
{
dataProvider.ExecuteNonQuery("usp_InsertVideo", cs.VideoLevelId, cs.VideoTitle, cs.VideoDesc, Convert.ToDateTime(cs.VideoDate), cs.VideoType, cs.VideoYouTubeFile, cs.VideoOtherFile, cs.ActiveFlagId, cs.ShowFlagId, cs.PortalID, cs.CreatedById, cs.ModifiedById);
}
catch (Exception ex)
{
Exceptions.LogException(ex);
}
return(0);
}
public int UpdateVideoLinks(clsVideos cs)
{
int i = 0;
try
{
dataProvider.ExecuteNonQuery("usp_UpdateVideoLinks", cs.VideoId, cs.SportId, cs.CountryId, cs.SeasonId, cs.CompetitionId, cs.ClubId, cs.ClubOwnersId, cs.ClubMemberId, cs.TeamId, cs.TeamMemberId, cs.SponsorId, cs.EventId, cs.PlayerId);
}
catch (Exception ex)
{
return(i);
}
return(i);
}
public int UpdateVideo(clsVideos cs)
{
int i = 0;
try
{
dataProvider.ExecuteNonQuery("usp_UpdateVideo", cs.VideoId, cs.VideoLevelId, cs.VideoTitle, cs.VideoDesc, Convert.ToDateTime(cs.VideoDate), cs.VideoType, cs.VideoYouTubeFile, cs.VideoOtherFile, cs.ActiveFlagId, cs.ShowFlagId, cs.PortalID, cs.ModifiedById);
}
catch (Exception ex)
{
return(i);
}
return(i);
}
public DataTable GetOtherVideoPathByVideoID(clsVideos cs)
{
using (DataTable dt = new DataTable())
{
try
{
using (IDataReader reader = dataProvider.ExecuteReader("usp_GetOtherVideoPathByVideoID", cs.VideoId))
{
dt.Load(reader);
return(dt);
}
}
catch (Exception ex)
{
Exceptions.LogException(ex);
}
return(dt);
}
}