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; }