public int InsertPictureLinks(clsPictures cs)
{
try
{
dataProvider.ExecuteNonQuery("usp_InsertPictureLinks", cs.PictureId, 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 InsertPicture(clsPictures cs)
{
try
{
dataProvider.ExecuteNonQuery("usp_InsertPicture", cs.PictureLevelId, cs.PictureTitle, cs.PictureDesc, Convert.ToDateTime(cs.PictureDate), cs.PictureFile, cs.ActiveFlagId, cs.ShowFlagId, cs.PortalID, cs.CreatedById, cs.ModifiedById);
}
catch (Exception ex)
{
Exceptions.LogException(ex);
}
return(0);
}
public int UpdatePictureLinks(clsPictures cs)
{
int i = 0;
try
{
dataProvider.ExecuteNonQuery("usp_UpdatePictureLinks", cs.PictureId, 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 UpdatePicture(clsPictures cs)
{
int i = 0;
try
{
dataProvider.ExecuteNonQuery("usp_UpdatePicture", cs.PictureId, cs.PictureLevelId, cs.PictureTitle, cs.PictureDesc, Convert.ToDateTime(cs.PictureDate), cs.PictureFile, cs.ActiveFlagId, cs.ShowFlagId, cs.PortalID, cs.ModifiedById);
}
catch (Exception ex)
{
return(i);
}
return(i);
}
public DataTable GetPictureLogoByPictureID(clsPictures cs)
{
using (DataTable dt = new DataTable())
{
try
{
using (IDataReader reader = dataProvider.ExecuteReader("usp_GetPictureLogoByPictureID", cs.PictureId))
{
dt.Load(reader);
return(dt);
}
}
catch (Exception ex)
{
Exceptions.LogException(ex);
}
return(dt);
}
}