Beispiel #1
0
        public async Task <int> UpdateUserInformation(User entity)
        {
            var sql    = "UPDATE users SET name = @Name, surname = @Surname,position_id= @PositionId, role_id = @RoleId WHERE user_id = @UserId";
            var result = await _mySqlRepository.ExecuteAsync(sql, entity);

            return(result);
        }
        public async Task <int> UpdateClientInformation(Client entity)
        {
            var sql    = "UPDATE clients SET client_name = @ClientName, client_middleName = @ClientMiddleName, client_surname = @ClientSurname,client_address = @ClientAddress, client_phoneNumber = @ClientPhoneNumber WHERE client_id= @ClientId";
            var result = await _mySqlRepository.ExecuteAsync(sql, entity);

            return(result);
        }