public bool Insert(Lookups lookups) { int autonumber = 0; LookupsDAC lookupsComponent = new LookupsDAC(); bool endedSuccessfuly = lookupsComponent.InsertNewLookups( ref autonumber, lookups.LookupName, lookups.LookupFriendlyName); if(endedSuccessfuly) { lookups.LookupId = autonumber; } return endedSuccessfuly; }
public Lookups GetByID(int _lookupId) { LookupsDAC _lookupsComponent = new LookupsDAC(); IDataReader reader = _lookupsComponent.GetByIDLookups(_lookupId); Lookups _lookups = null; while(reader.Read()) { _lookups = new Lookups(); if(reader["LookupId"] != DBNull.Value) _lookups.LookupId = Convert.ToInt32(reader["LookupId"]); if(reader["LookupName"] != DBNull.Value) _lookups.LookupName = Convert.ToString(reader["LookupName"]); if(reader["LookupFriendlyName"] != DBNull.Value) _lookups.LookupFriendlyName = Convert.ToString(reader["LookupFriendlyName"]); _lookups.NewRecord = false; } reader.Close(); return _lookups; }
public List<Lookups> GetAll() { LookupsDAC _lookupsComponent = new LookupsDAC(); IDataReader reader = _lookupsComponent.GetAllLookups().CreateDataReader(); List<Lookups> _lookupsList = new List<Lookups>(); while(reader.Read()) { if(_lookupsList == null) _lookupsList = new List<Lookups>(); Lookups _lookups = new Lookups(); if(reader["LookupId"] != DBNull.Value) _lookups.LookupId = Convert.ToInt32(reader["LookupId"]); if(reader["LookupName"] != DBNull.Value) _lookups.LookupName = Convert.ToString(reader["LookupName"]); if(reader["LookupFriendlyName"] != DBNull.Value) _lookups.LookupFriendlyName = Convert.ToString(reader["LookupFriendlyName"]); _lookups.NewRecord = false; _lookupsList.Add(_lookups); } reader.Close(); return _lookupsList; }
public bool Update(Lookups lookups ,int old_lookupId) { LookupsDAC lookupsComponent = new LookupsDAC(); return lookupsComponent.UpdateLookups( lookups.LookupName, lookups.LookupFriendlyName, old_lookupId); }