public async Task <int> UpdateProjectMaintenanceMemberAsync(ProjectMaintenanceMemberDto dto)
{
var sql = " UPDATE [dbo].[Member] " +
" SET [EmpId] = @EmpId " +
" ,[ProjectPositionId] = @ProjectPositionId " +
" WHERE Member.Id = @Id";
var x = await Connection.ExecuteAsync(sql, new
{
Id = dto.Id,
EmpId = dto.EmpId,
ProjectPositionId = dto.ProjectPositionId,
}, Transaction);
return(x);
}
public async Task <int> InsertProjectMaintenanceMemberAsync(ProjectMaintenanceMemberDto dto)
{
var sql = " INSERT INTO [dbo].[Member] " +
" ([ProjectMaintenanceId] " +
" ,[EmpId] " +
" ,[ProjectPositionId]) " +
" VALUES " +
" (@ProjectMaintenanceId " +
" ,@EmpId" +
" ,@ProjectPositionId )";
int count = await Connection.ExecuteAsync(sql, new
{
ProjectMaintenanceId = dto.ProjectMaintenanceId,
EmpId = dto.EmpId,
ProjectPositionId = dto.ProjectPositionId
}, Transaction);
return(count);
}
