// string connStr = "server=localhost;port=3306;database=mydb;user=root;password="******"server=k3xio06abqa902qt.cbetxkdyhwsb.us-east-1.rds.amazonaws.com;port=3306;database=aeacqkuf3fr8uq8t;user=ss7z1t6oys987shb;password=nw473umt2r9yu41d"; public async Task <bool> Actualizar(ClientsEntity actualizado) { var cmd = new MySqlCommand("UPDATE clients SET name = @name, lastName = @lastName, phone = @phone, email = @email WHERE id = @id"); cmd.Parameters.AddWithValue("@id", actualizado.id); cmd.Parameters.AddWithValue("@name", actualizado.name); cmd.Parameters.AddWithValue("@lastName", actualizado.lastName); cmd.Parameters.AddWithValue("@phone", actualizado.phone); cmd.Parameters.AddWithValue("@email", actualizado.email); using (var conn = new MySqlConnection(GetConnectionString())) { try { cmd.Connection = conn; await cmd.Connection.OpenAsync(); await cmd.ExecuteNonQueryAsync(); return(true); } catch (Exception ex) { throw ex; } // return false; } }
public async Task <bool> Guardar(ClientsEntity nuevo) { var cmd = new MySqlCommand("INSERT INTO clients (name, lastName, phone, email) VALUES (@name, @lastName, @phone, @email)"); cmd.Parameters.AddWithValue("@name", nuevo.name); cmd.Parameters.AddWithValue("@lastName", nuevo.lastName); cmd.Parameters.AddWithValue("@phone", nuevo.phone); cmd.Parameters.AddWithValue("@email", nuevo.email); using (var conn = new MySqlConnection(GetConnectionString())) { try { cmd.Connection = conn; await cmd.Connection.OpenAsync(); await cmd.ExecuteNonQueryAsync(); return(true); } catch (Exception ex) { throw ex; } } // return false; }
private static ClientsEntity ParseClient(MySqlDataReader reader) { var c = new ClientsEntity(); c.id = (int)(long)reader["id"]; c.name = (string)reader["name"]; c.lastName = (string)reader["lastName"]; c.phone = (string)reader["phone"]; c.email = (string)reader["email"]; return(c); }