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 Insert( string LookupName, string LookupFriendlyName) { LookupsDAC lookupsComponent = new LookupsDAC(); int LookupId = 0; return lookupsComponent.InsertNewLookups( ref LookupId, LookupName, LookupFriendlyName); }
public void Delete(int Original_LookupId) { LookupsDAC lookupsComponent = new LookupsDAC(); lookupsComponent.DeleteLookups(Original_LookupId); }
public int UpdateDataset(System.Data.DataSet dataset) { LookupsDAC lookupscomponent = new LookupsDAC(); return lookupscomponent.UpdateDataset(dataset); }
public bool Update( string LookupName, string LookupFriendlyName, int Original_LookupId) { LookupsDAC lookupsComponent = new LookupsDAC(); return lookupsComponent.UpdateLookups( LookupName, LookupFriendlyName, Original_LookupId); }
public bool Update(Lookups lookups ,int old_lookupId) { LookupsDAC lookupsComponent = new LookupsDAC(); return lookupsComponent.UpdateLookups( lookups.LookupName, lookups.LookupFriendlyName, old_lookupId); }