entity data model

[samaremad]

hello everyone can you help me please

i create data model to manipulate the database in the functions that responsible to do (CRUD) in the controller files but i found that not all the attribute found

to be specify i want when the create function execute it will check a boolean field in (user- table ) if it is true then take the id of the user Unit (which it is the foreign key ) and go to( Units table) increase the( field of votes ) by 1

[edwardch]

Take a look in the UserRepository for some inspiration.

Inside your MySaveHandler you can override your AfterSave.

There are some examples of updating other tables, specifically in the MyDeleteHandler, which overrides the OnBeforeDelete here

[samaremad]

first I didn't understand but i discovered that there is missing library ( using System.Linq;)
but my problem now i dont know how to update the table with increment

var result = new MyRepository().Create(uow, request);

        var n = request.Entity.GroupId;
       var x = request.Entity.Situation;
        var c = db.Units.Where(c => c.group_id == n);
        
        if(x==true)

### (here i want to write that db.units.no_votes +1 )

        return result;

[edwardch]

In your UserRepository.cs, try something like this

private class MySaveHandler : SaveRequestHandler<MyRow> 
{
    protected override void AfterSave()
    {
        base.AfterSave();

        new SqlUpdate(YourOtherTableRow.Fields.TableName)
            .Where(YourOtherTableRow.Fields.UserId == Row.UserId.Value)
            .Inc(YourOtherTableRow.Fields.Units, 1)
            .Execute(Connection);
    }
}