Notchu
Notchu
PostsComments
CC#
Created by Notchu on 3/27/2025 in #help
Need Help With Understanding EF Core and DI in specific case
Hi! Im working on an CRUD WEB API with asp.net how should I pass database context to the subservice? Currently I have a controller that calls service method to get something and return it. FilmController receive request to save film and provides data to DataService& But I need to check if Actors are already in database and if no than I have to create one and save it to db. Here is code for better understanding. 
    public async Task<ServiceResult<FilmData>> UpdateFilm(FilmDTO filmDto, Guid id)
    {
        var film = new FilmData(filmDto);
        
        var filmResult = await GetFilmById(id, true);

        if (!filmResult.Success)
        {
            return ServiceResult<FilmData>.Fail(filmResult.ErrorCode, filmResult.Error!);
        }
        
        var entity = filmResult.Data!;
        
        entity.Title = film.Title;
        
        entity.ReleaseDate = film.ReleaseDate;
        
        entity.Budget = film.Budget;

        entity.Actors.Clear();

        var actorTitles = film.Actors.Select(x => x.Name).Distinct().ToList();
        
        var allActors = await _actorResolver.GetOrCreateActorsAsync(actorTitles);
        
        foreach (var actor in allActors.Values)
        {
            entity.Actors.Add(actor);
        }
        
        try
        {
            await _csvContext.SaveChangesAsync();
        }
        catch (Exception e)
        {
            return ServiceResult<FilmData>.Fail(ServiceErrorCodes.SaveFailed, e.Message);
        }
        
        return ServiceResult<FilmData>.Ok(entity);

    }
    public async Task<ServiceResult<FilmData>> UpdateFilm(FilmDTO filmDto, Guid id)
    {
        var film = new FilmData(filmDto);
        
        var filmResult = await GetFilmById(id, true);

        if (!filmResult.Success)
        {
            return ServiceResult<FilmData>.Fail(filmResult.ErrorCode, filmResult.Error!);
        }
        
        var entity = filmResult.Data!;
        
        entity.Title = film.Title;
        
        entity.ReleaseDate = film.ReleaseDate;
        
        entity.Budget = film.Budget;

        entity.Actors.Clear();

        var actorTitles = film.Actors.Select(x => x.Name).Distinct().ToList();
        
        var allActors = await _actorResolver.GetOrCreateActorsAsync(actorTitles);
        
        foreach (var actor in allActors.Values)
        {
            entity.Actors.Add(actor);
        }
        
        try
        {
            await _csvContext.SaveChangesAsync();
        }
        catch (Exception e)
        {
            return ServiceResult<FilmData>.Fail(ServiceErrorCodes.SaveFailed, e.Message);
        }
        
        return ServiceResult<FilmData>.Ok(entity);

    }
And here is GetOrCreateActorsClass 
public async Task<Dictionary<string, Actor>> GetOrCreateActorsAsync(List<string> actorTitles)
    {
        List<Actor> actorsFromDatabase = await _csvContext.Actors
            .Where(x => actorTitles.Contains(x.Name))
            .ToListAsync();

        var actorsDict = actorsFromDatabase.ToDictionary(x => x.Name);

        var allActors = new Dictionary<string, Actor>();
        
        var actorsToAdd = new List<Actor>();
        
        foreach (var actorDto in actorTitles)
        {
            if (actorsDict.TryGetValue(actorDto, out var outActor))
            {
                allActors[actorDto] = outActor;
                continue;
            }
            var actor = new Actor(actorDto);
            allActors[actorDto] = actor;
            actorsToAdd.Add(actor);
        }
        _csvContext.Actors.AddRange(actorsToAdd);
        return allActors;
    }
public async Task<Dictionary<string, Actor>> GetOrCreateActorsAsync(List<string> actorTitles)
    {
        List<Actor> actorsFromDatabase = await _csvContext.Actors
            .Where(x => actorTitles.Contains(x.Name))
            .ToListAsync();

        var actorsDict = actorsFromDatabase.ToDictionary(x => x.Name);

        var allActors = new Dictionary<string, Actor>();
        
        var actorsToAdd = new List<Actor>();
        
        foreach (var actorDto in actorTitles)
        {
            if (actorsDict.TryGetValue(actorDto, out var outActor))
            {
                allActors[actorDto] = outActor;
                continue;
            }
            var actor = new Actor(actorDto);
            allActors[actorDto] = actor;
            actorsToAdd.Add(actor);
        }
        _csvContext.Actors.AddRange(actorsToAdd);
        return allActors;
    }
Im currently passing csvContext via DI but as soon as its configured scoped that it will create new context and data wont be saved correctley. What should I do? Or should I just pass dbcontext as param for method?
8 replies
CC#
Created by Notchu on 3/16/2025 in #help
Beginner looking for project ideas to practice C# – any suggestions?
Hello people! I want to ask for help. I need some pet project or projects for practice But I dont have any ideas left. So I wanna be a .net BackEnd dev. Here some info about what I already did so you may consider this when giving me some projects. Thank you. Rust(game by Facepunch) plugins. Here is my works if you wanna take a look: https://umod.org/user/Notchu#plugins Telegram Bots via TelegramBot library(polls bot, superchat bot that creates chat In group for each person, so admins can chat personally in superchat) Also Decision Making Bot using OpenAi, and some other bots that are using Postgressql but just a bit WTelegramClient + Google Sheets(I made a bot that collects data from channels and writes it down to sheets) Personal API - Just a simple one that I use for open ai. Its just uhm for practice so in my project I use my api instead of OpenAiApi. Also this apo can send messages via telegram if needed
39 replies
CC#
Created by Notchu on 2/26/2025 in #help
Looking for a roadmap to become .net backend junior.
HI! I would be greatfull if somebod could give me a real roadmap of what I should learn and how to practice to become .net backend junior.
8 replies