public int InsertNewsLinks(clsNews cs)
{
try
{
dataProvider.ExecuteNonQuery("usp_InsertNewsLinks", cs.NewsId, cs.SportsId, 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 InsertNews(clsNews cs)
{
try
{
dataProvider.ExecuteNonQuery("usp_InsertNews", cs.NewsLevelId, cs.NewsTitle, cs.NewsDesc, cs.NewsText, Convert.ToDateTime(cs.NewsDate), cs.NewsPicture, cs.NewsVideo, cs.ActiveFlagId, cs.ShowFlagId, cs.PortalID, cs.CreatedById, cs.ModifiedById, cs.NewsOtherVideoPath, cs.VideoType);
}
catch (Exception ex)
{
Exceptions.LogException(ex);
}
return(0);
}
public int UpdateNewsLinks(clsNews cs)
{
int i = 0;
try
{
dataProvider.ExecuteNonQuery("usp_UpdateNewsLinks", cs.NewsId, cs.SportsId, 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 UpdateNews(clsNews cs)
{
int i = 0;
try
{
dataProvider.ExecuteNonQuery("usp_UpdateNews", cs.NewsId, cs.NewsLevelId, cs.NewsTitle, cs.NewsDesc, cs.NewsText, Convert.ToDateTime(cs.NewsDate), cs.NewsPicture, cs.NewsVideo, cs.ActiveFlagId, cs.ShowFlagId, cs.PortalID, cs.ModifiedById, cs.NewsOtherVideoPath, cs.VideoType);
}
catch (Exception ex)
{
return(i);
}
return(i);
}
public DataTable GetOtherVideoPathByNewsID(clsNews cs)
{
using (DataTable dt = new DataTable())
{
try
{
using (IDataReader reader = dataProvider.ExecuteReader("usp_GetOtherVideoPathByNewsID", cs.NewsId))
{
dt.Load(reader);
return(dt);
}
}
catch (Exception ex)
{
Exceptions.LogException(ex);
}
return(dt);
}
}