public Search Select(string sqlCount, string sql)
{
String _connectionString =
"Server=ol_svr_custom;" +
"Host=localhost;" +
"Service=turbo;" +
"Database=registration;" +
"User ID=informix;" +
"Password=123456;" +
"Client Locale=ru_ru.CP1251;" +
"Database Locale=ru_ru.915;" +
"Max Pool Size=500;" +
"Pooling=True;" +
"Protocol=olsoctcp;" +
"Connection Lifetime=1200;" +
"Connection Timeout=1;";
try
{
IfxConnection _Connection = new IfxConnection()
{
ConnectionString = _connectionString
};
_Connection.Open();
try
{
Search _Search = new Search
{
Total = "0",
ListCitizen = new List <Citizen>()
};
IfxCommand _command = new IfxCommand
{
Connection = _Connection,
CommandText = sqlCount
};
IfxDataReader _dataReader = _command.ExecuteReader();
while (_dataReader.Read())
{
_Search.Total = _dataReader.GetString(0);
}
_dataReader.Close();
_command.CommandText = sql;
_dataReader = _command.ExecuteReader();
while (_dataReader.Read())
{
if (!_dataReader.IsDBNull(0))
{
Citizen citizen = new Citizen();
citizen.Id = _dataReader.GetString(0);
citizen.LastName = _dataReader.GetString(1);
citizen.FirstName = _dataReader.GetString(2);
citizen.MiddleName = _dataReader.GetString(3);
string dt = _dataReader.GetString(4);
if (dt.Length == 10)
{
citizen.DateOfBirth = _dataReader.GetDateTime(4).ToString("d");
}
_Search.ListCitizen.Add(citizen);
}
}
if (_dataReader != null)
{
_dataReader.Close();
}
if (_Connection != null)
{
_Connection.Close();
}
return(_Search);
}
catch
{
return(null);
}
}
catch
{
return(null);
}
}