//update
public async Task <int> UpdateMonthlyOTAsync(MonthlyOTDto dto)
{
var sql = " UPDATE [dbo].[MonthlyOT] " +
" SET [Wage] = @Wage " +
" ,[ProjectId] = @ProjectId " +
" ,[ProjectMaintenanceId] = @ProjectMaintenanceId " +
" ,[Otdate] = @Otdate " +
" ,[StartTime] = @StartTime " +
" ,[EndTime] = @EndTime " +
" ,[UpdatedId] = @UpdatedId" +
" ,[UpdatedDate] = GetDate() " +
" WHERE MonthlyOT.Id = @Id";
var x = await Connection.ExecuteAsync(sql, new
{
Id = dto.Id,
Wage = dto.Wage,
ProjectId = dto.ProjectId,
ProjectMaintenanceId = dto.ProjectMaintenanceId,
StartTime = dto.StartTime,
EndTime = dto.EndTime,
Otdate = dto.Otdate,
UpdatedId = dto.UpdatedId
}, Transaction);
return(x);
}
public async Task <IActionResult> Put([FromBody] MonthlyOTDto dto)
{
if (!ModelState.IsValid)
{
return(BadRequest(new { message = "Not a valid model" + ModelState.ToString() }));
}
try
{
_UnitOfWork.Transaction = _UnitOfWork.Begin();
var x = await _UnitOfWork.SalaryRepository.UpdateMonthlyOTAsync(dto);
await _UnitOfWork.SalaryRepository.UpdateBonusOTAsync(dto.EmpId.Value, dto.Otdate.Value.ToString("yyyyMM"));
_UnitOfWork.Commit();
return(Ok(x));
}
catch (Exception ex)
{
_UnitOfWork.Dispose();
return(BadRequest(new { message = ex.Message }));
}
finally
{
_UnitOfWork.Dispose();
}
}
//insert
public async Task <int> InsertMonthlyOTAsync(MonthlyOTDto dto)
{
var sql = " DECLARE @ID int;" +
" INSERT INTO [dbo].[MonthlyOT] " +
" ([ProjectId] " +
" ,[ProjectMaintenanceId] " +
" ,[OTDate] " +
" ,[StartTime] " +
" ,[EndTime]" +
" ,[Wage]" +
" ,[EmpId] " +
" ,[CreatedId] " +
" ,[CreatedDate]) " +
" VALUES " +
" (@ProjectId" +
" ,@ProjectMaintenanceId" +
" ,@Otdate" +
" ,@StartTime" +
" ,@EndTime" +
" ,@Wage" +
" ,@EmpId " +
" ,@CreatedId " +
" ,GETDATE() )" +
" SET @ID = SCOPE_IDENTITY(); " +
" SELECT @ID";
var result = await Connection.ExecuteAsync(sql, new
{
Wage = dto.Wage,
ProjectId = dto.ProjectId,
ProjectMaintenanceId = dto.ProjectMaintenanceId,
StartTime = dto.StartTime,
EndTime = dto.EndTime,
Otdate = dto.Otdate,
EmpId = dto.EmpId,
CreatedId = dto.CreatedId
}, Transaction);
return(result);
}
