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 Insert(string SponsorName, int ConferenceId, string SponsorType, string SponsorImage) { SponsorsDAC sponsorsComponent = new SponsorsDAC(); int SponsorId = 0; return(sponsorsComponent.InsertNewSponsors(ref SponsorId, SponsorName, ConferenceId, SponsorType, SponsorImage)); }
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); }
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 int UpdateDataset(System.Data.DataSet dataset) { SponsorsDAC sponsorscomponent = new SponsorsDAC(); return(sponsorscomponent.UpdateDataset(dataset)); }
public void Delete(int Original_SponsorId) { SponsorsDAC sponsorsComponent = new SponsorsDAC(); sponsorsComponent.DeleteSponsors(Original_SponsorId); }
public bool Update(string SponsorName, int ConferenceId, string SponsorType, string SponsorImage, int Original_SponsorId) { SponsorsDAC sponsorsComponent = new SponsorsDAC(); return(sponsorsComponent.UpdateSponsors(SponsorName, ConferenceId, SponsorType, SponsorImage, Original_SponsorId)); }
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)); }