コード例 #1
0
 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);
 }
コード例 #2
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);
 }
コード例 #3
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);
        }
コード例 #4
0
        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);
        }
コード例 #5
0
 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);
     }
 }