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