public int InsertSponsorSports(clsSponsor cs)
{
try
{
dataProvider.ExecuteNonQuery("usp_InsertSponsorSports", cs.SponsorId, cs.SportsId, cs.EventId, cs.SeasonId, cs.CompetitionId, cs.ClubId, cs.ClubOwnersId, cs.ClubMemberId, cs.TeamId, cs.TeamMemberId, cs.PlayerId);
}
catch (Exception ex)
{
Exceptions.LogException(ex);
}
return(0);
}
public int InsertSponsor(clsSponsor cs)
{
try
{
dataProvider.ExecuteNonQuery("usp_InsertSponsor", cs.SponsorLevelId, cs.SponsorTypeId, cs.SponsorName, cs.SponsorAbbr, cs.SponsorDesc, cs.SponsorLogoName, cs.SponsorLogoFile, Convert.ToDateTime(cs.SponsorStartDate), Convert.ToDateTime(cs.SponsorEndDate), cs.SponsorAmt, cs.ActiveFlagId, cs.ShowFlagId, cs.PortalID, cs.CreatedById, cs.ModifiedById);
}
catch (Exception ex)
{
Exceptions.LogException(ex);
}
return(0);
}
public int UpdateSponsorSport(clsSponsor cs)
{
int i = 0;
try
{
//CompReg.CreatedBy,
dataProvider.ExecuteNonQuery("usp_UpdateSponsorSport", cs.SponsorId, cs.SportsId, cs.EventId, cs.SeasonId, cs.CompetitionId, cs.ClubId, cs.ClubOwnersId, cs.ClubMemberId, cs.TeamId, cs.TeamMemberId, cs.PlayerId);
}
catch (Exception ex)
{
return(i);
}
return(i);
}
public int UpdateSponsor(clsSponsor cs)
{
int i = 0;
try
{
//CompReg.CreatedBy,
dataProvider.ExecuteNonQuery("usp_UpdateSponsor", cs.SponsorId, cs.SponsorLevelId, cs.SponsorTypeId, cs.SponsorName, cs.SponsorAbbr, cs.SponsorDesc, cs.SponsorLogoName, cs.SponsorLogoFile, Convert.ToDateTime(cs.SponsorStartDate), Convert.ToDateTime(cs.SponsorEndDate), cs.SponsorAmt, cs.ActiveFlagId, cs.ShowFlagId, cs.PortalID, cs.ModifiedById);
}
catch (Exception ex)
{
return(i);
}
return(i);
}
public DataTable GetSponsorLogoBySponsorID(clsSponsor cs)
{
using (DataTable dt = new DataTable())
{
try
{
using (IDataReader reader = dataProvider.ExecuteReader("usp_GetSponsorLogoBySponsorID", cs.SponsorId))
{
dt.Load(reader);
return(dt);
}
}
catch (Exception ex)
{
Exceptions.LogException(ex);
}
return(dt);
}
}