public LookupDetails GetLookup(SqlDataReader _dtr, IList<LookupDetails> colobj) { //LookupDetails obj = colobj.Where(t => t.ID == Convert.ToInt32(_dtr["LOOKUP_ID"].ToString())).SingleOrDefault(); LookupDetails obj = null; if (null == obj) { obj = new LookupDetails(); colobj.Add(obj); } return obj; }
private void GetEntityFromReaderLookup(SqlDataReader _dtr, LookupDetails obj) { int columnIndex = 0; columnIndex = _dtr.GetOrdinal("LOOKUP_ID"); if (!_dtr.IsDBNull(columnIndex)) { obj.ID = _dtr.GetInt32((columnIndex)); } columnIndex = _dtr.GetOrdinal("NAME"); if (!_dtr.IsDBNull(columnIndex)) { obj.Name = _dtr.GetString((columnIndex)); } }
public IList<LookupDetails> GetAllCountries() { LookupDetails obj = null; IList<LookupDetails> colobj = null; _connection.ConnectionString = _ConnectionString; _command.Connection = _connection; _command.CommandType = CommandType.Text; _command.CommandText = "select NAME,LOOKUP_ID from dbo.LOOKUP_DETAILS where LOOKUP_ID=1 Order by Name"; _connection.Open(); try { using (_dtreader = _command.ExecuteReader()) { if (_dtreader != null && _dtreader.HasRows) { obj = new LookupDetails(); colobj = new List<LookupDetails>(); while (_dtreader.Read()) { obj = GetLookup(_dtreader, colobj); GetEntityFromReaderLookup(_dtreader, obj); } } } } catch (Exception ex) { throw ex; } finally { _dtreader.Close(); _connection.Close(); } return colobj; }