public List<Sponsors> GetAllByConferenceId(string ConferenceId)
{
SponsorsDAC _sponsorsComponent = new SponsorsDAC();
if (string.IsNullOrEmpty(ConferenceId))
ConferenceId = "0";
IDataReader reader = _sponsorsComponent.GetAllSponsors(" ConferenceId = " + ConferenceId).CreateDataReader();
List<Sponsors> _sponsorsList = new List<Sponsors>();
while (reader.Read())
{
if (_sponsorsList == null)
_sponsorsList = new List<Sponsors>();
Sponsors _sponsors = new Sponsors();
if (reader["SponsorId"] != DBNull.Value)
_sponsors.SponsorId = Convert.ToInt32(reader["SponsorId"]);
if (reader["SponsorName"] != DBNull.Value)
_sponsors.SponsorName = Convert.ToString(reader["SponsorName"]);
if (reader["ConferenceId"] != DBNull.Value)
_sponsors.ConferenceId = Convert.ToInt32(reader["ConferenceId"]);
if (reader["SponsorType"] != DBNull.Value)
_sponsors.SponsorType = Convert.ToString(reader["SponsorType"]);
if (reader["SponsorImage"] != DBNull.Value)
_sponsors.SponsorImage = Convert.ToString(reader["SponsorImage"]);
_sponsors.NewRecord = false;
_sponsorsList.Add(_sponsors);
} reader.Close();
return _sponsorsList;
}
public Sponsors GetByID(int _sponsorId)
{
SponsorsDAC _sponsorsComponent = new SponsorsDAC();
IDataReader reader = _sponsorsComponent.GetByIDSponsors(_sponsorId);
Sponsors _sponsors = null;
while(reader.Read())
{
_sponsors = new Sponsors();
if(reader["SponsorId"] != DBNull.Value)
_sponsors.SponsorId = Convert.ToInt32(reader["SponsorId"]);
if(reader["SponsorName"] != DBNull.Value)
_sponsors.SponsorName = Convert.ToString(reader["SponsorName"]);
if(reader["ConferenceId"] != DBNull.Value)
_sponsors.ConferenceId = Convert.ToInt32(reader["ConferenceId"]);
if(reader["SponsorType"] != DBNull.Value)
_sponsors.SponsorType = Convert.ToString(reader["SponsorType"]);
if(reader["SponsorImage"] != DBNull.Value)
_sponsors.SponsorImage = Convert.ToString(reader["SponsorImage"]);
_sponsors.NewRecord = false; } reader.Close();
return _sponsors;
}
public bool Update(Sponsors sponsors ,int old_sponsorId)
{
SponsorsDAC sponsorsComponent = new SponsorsDAC();
return sponsorsComponent.UpdateSponsors( sponsors.SponsorName, sponsors.ConferenceId, sponsors.SponsorType, sponsors.SponsorImage, old_sponsorId);
}
public bool Insert(Sponsors sponsors)
{
int autonumber = 0;
SponsorsDAC sponsorsComponent = new SponsorsDAC();
bool endedSuccessfuly = sponsorsComponent.InsertNewSponsors( ref autonumber, sponsors.SponsorName, sponsors.ConferenceId, sponsors.SponsorType, sponsors.SponsorImage);
if(endedSuccessfuly)
{
sponsors.SponsorId = autonumber;
}
return endedSuccessfuly;
}
