public async Task <bool> UploadData()
{
bool isUpdate = false;
//Выгрузка записей
isUpdate = await UploadEntry();
//Выгрузка пациентов
isUpdate = await UploadPatient();
if (connect.IsConnect())
{
//Выгрузка связи Тип услуги-Услуги-Специалист
string selectServiceQuery = "SELECT * FROM type_service;";
using (MySqlCommand command = new MySqlCommand(selectServiceQuery, connect.GetConnect))
{
using (DbDataReader reader = await command.ExecuteReaderAsync())
{
if (reader.HasRows)
{
isUpdate = true;
while (await reader.ReadAsync())
{
GetTypeService.Add(new TypeService()
{
Lable = reader.GetString(1),
GetServiceOfDoctor = GetDoctorOfService(await reader.GetFieldValueAsync <uint>(0))
});
}
}
reader.Close();
}
}
connect.Close();
}
return(isUpdate);
}
public async Task Auth(string login, string pwd)
{
if (connect.IsConnect())
{
string authQuery = "SELECT id_user, id_group FROM accounts " +
"WHERE login = @login AND pwd = @pwd LIMIT 1;";
using (MySqlCommand command = new MySqlCommand(authQuery, connect.GetConnect))
{
command.Parameters.AddWithValue("@login", login); //логин
command.Parameters.AddWithValue("@pwd", GetHash(MD5.Create(), pwd)); //пароль
using (System.Data.Common.DbDataReader reader = await command.ExecuteReaderAsync())
{
if (reader.HasRows)
{
while (await reader.ReadAsync())
{
HashID = Encoding.UTF8.GetBytes(reader.GetString(0)); //перевод хэша в массив битов
idGroup = await reader.GetFieldValueAsync <uint>(1);
}
reader.Close();
}
else
{
AuthoStatysEvent("Неправильный логин или пароль");
}
}
}
if (idGroup.Equals(1122)) //Регистратор
{
string selectRegistratorQuery = "SELECT id, fio FROM registrator " +
"WHERE id_user = @idUser";
using (MySqlCommand command = new MySqlCommand(selectRegistratorQuery, connect.GetConnect))
{
string id = Encoding.UTF8.GetString(HashID); //перевод массива битов в хэш
command.Parameters.AddWithValue("@idUser", id);
using (System.Data.Common.DbDataReader reader = await command.ExecuteReaderAsync())
{
if (reader.HasRows)
{
while (await reader.ReadAsync())
{
GetEmployees = new Registrator()
{
Id = await reader.GetFieldValueAsync <uint>(0),
Fio = reader.GetString(1)
};
}
reader.Close();
}
}
}
GetGroup = Group.Registrator;
}
else if (idGroup.Equals(2211)) //Доктор
{
string selectRegistratorQuery = "SELECT id, fio FROM doctor WHERE id_user = @idUser";
using (MySqlCommand command = new MySqlCommand(selectRegistratorQuery, connect.GetConnect))
{
string id = Encoding.UTF8.GetString(HashID); //перевод массива битов в хэш
command.Parameters.AddWithValue("@idUser", id);
using (System.Data.Common.DbDataReader reader = await command.ExecuteReaderAsync())
{
if (reader.HasRows)
{
while (await reader.ReadAsync())
{
GetEmployees = new Doctor()
{
Id = await reader.GetFieldValueAsync <uint>(0),
Fio = reader.GetString(1)
};
}
reader.Close();
}
}
}
GetGroup = Group.Doctor;
}
connect.Close();
}
}