public void LoadUsers()
{
SqlConnection connection = new SqlConnection(MyProject.Properties.Settings.Default.Connection);
try
{
connection.Open();
}
catch (Exception ex)
{
connection = new SqlConnection(MyProject.Properties.Settings.Default.Connection);
connection.Open();
SqlCommand command = connection.CreateCommand();
using (FileStream fstream = File.OpenRead("SQLQuery2.sql"))
{
// преобразуем строку в байты
byte[] array = new byte[fstream.Length];
// считываем данные
fstream.Read(array, 0, array.Length);
// декодируем байты в строку
string textFromFile = Encoding.Default.GetString(array);
command.CommandText = textFromFile;
command.ExecuteNonQuery();
}
}
finally
{
string select = $"select * from PACIENT ";
SqlCommand command = new SqlCommand(select, connection);
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Admin pacients = new Admin(reader.GetInt32(0));
pacients.IDpacient = reader.GetInt32(0);
pacients.Name = reader.GetString(3);
pacients.Surname = reader.GetString(4);
if (reader.GetString(5).Equals("Man"))
pacients.Gender = Gender.Man;
else
pacients.Gender = Gender.Woman;
pacients.Email = reader.GetString(6);
PACIENT.Add(pacients);
}
}
connection.Close();
}
}
