public Admin Authorize(string login, string password)
{
var passwordHash = Decripting.GetMD5Hash(password);
var sql = @"SELECT * FROM admin WHERE login = @Login AND Password = @passwordHash";
using (var conn = new SqlConnection(ConnectionString))
{
var admin = conn.Query <Admin>(sql, new { login, passwordHash }).FirstOrDefault();
return(admin);
}
}
public bool Register(Client client)
{
if (IsValidUser(client) && !IsExistUser(client))
{
var sql = @"INSERT INTO Client(fio, login, password)
VALUES(@Fio, @Login, @Password)";
client.Password = Decripting.GetMD5Hash(client.Password);
using (var conn = new SqlConnection(ConnectionString))
{
var status = conn.Execute(sql, new { client.Fio, client.Login, client.Password });
return(status == 1 ? true : false);
}
}
return(false);
}
