Exemple #1
0
        public int Update(LikedRepositoryEntity likedRepository)
        {
            using var db = Connection;

            var query = @"UPDATE likedRepository
                            SET nome = @Nome
                            WHERE liked_Repository = @LikedRepository AND status = 1;";

            return(db.ExecuteScalar(query, new
            {
                likedRepository.IdRepositorio,
            }));
        }
Exemple #2
0
        public int Insert(LikedRepositoryEntity likedRepository)
        {
            using var db = Connection;

            var query = @"INSERT INTO usuario
                            (nome)
                            values( 
                            @Nome)
                            RETURNING id_usuario";

            return(db.ExecuteScalar <int>(query, new
            {
                likedRepository.NomeRepositorio,
            }));
        }