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