public Users BuscarUserByID(int id) { using (var conn = MysqlConnection.GetMySqlConnection(true, true, true)) { const long ticks = 553440000000; const int Id = 426; var cliente = conn.Query <Users>("SELECT * FROM usuario where idUsuario = @idUsuario;", new { idUsuario = id }).Single(); return(cliente); } }
public Users BuscarUserByName(string username) { try { using (var conn = MysqlConnection.GetMySqlConnection(true, true, true)) { const long ticks = 553440000000; const int Id = 426; var cliente = conn.Query <Users>("SELECT * FROM usuario where UserName = @UserName;", new { UserName = username }).Single(); return(cliente); } } catch (Exception ex) { return(null); } }
public ulong CreateUser(string username, string password, string domicilio, string passwordHash) { // INSERT INTO usuario (UserName, Password, Domicilio) VALUES('other', 'test', 'conocido'); string sql = @" INSERT INTO usuario (UserName, Password, Domicilio,PasswordHash) VALUES(@UserName, @Password,@Domicilio,@PasswordHash); SELECT CAST(LAST_INSERT_ID() AS UNSIGNED INTEGER);"; // ulong id = 0; using (var connection = MysqlConnection.GetMySqlConnection(true, true, true)) { var id_ = connection.Query <ulong>(sql, new { UserName = username, Password = password, Domicilio = domicilio, PasswordHash = passwordHash }).Single(); id = id_; } return(id); // }
public int UpdateUser(string username, string password, string domicilio, string passwordHash, int idusuario) { // INSERT INTO usuario (UserName, Password, Domicilio) VALUES('other', 'test', 'conocido'); string sql = @" UPDATE usuario SET UserName=@UserName, Password=@Password, Domicilio=@Domicilio, PasswordHash=@PasswordHash WHERE idUsuario=@idUsuario; "; // int id = 0; using (var connection = MysqlConnection.GetMySqlConnection(true, true, true)) { var id_ = connection.Execute(sql, new { UserName = username, Password = password, Domicilio = domicilio, PasswordHash = passwordHash, idUsuario = idusuario }); id = id_; } return(id); // }