public async Task <IActionResult> Post([FromBody] AnnualBonusDto dto)
{
using (Logger.BeginScope("Insert Annual Bonus"))
{
if (!ModelState.IsValid)
{
return(BadRequest(new { message = "Not a valid model" + ModelState.ToString() }));
}
try
{
_UnitOfWork.Transaction = _UnitOfWork.Begin();
var id = await _UnitOfWork.AnnualBonusRepository.InsertAnnualBonusAsync(dto);
_UnitOfWork.Commit();
return(Ok(id));
}
catch (Exception ex)
{
_UnitOfWork.Dispose();
return(BadRequest(new { message = ex.Message }));
}
}
}
//edit
public async Task <int> UpdateAnnualBonusAsync(AnnualBonusDto dto)
{
var sql1 = " UPDATE [dbo].[AnnualBonus] " +
" SET Bonus = @Bonus " +
" , ProjectId = @ProjectId " +
" , ProjectMaintenanceId = @ProjectMaintenanceId " +
" , RatingFactorId = @RatingFactorId " +
" , Day = @Day " +
" ,[UpdatedId] = @UpdatedId" +
" ,[UpdatedDate] = GetDate() " +
" WHERE EmpId = @empId" +
" and year =@year";
var result = await Connection.ExecuteAsync(sql1, new
{
Bonus = dto.Bonus,
ProjectId = dto.ProjectId,
ProjectMaintenanceId = dto.ProjectMaintenanceId,
Day = dto.Day,
EmpId = dto.EmpId,
year = dto.Year,
UpdatedId = dto.UpdatedId
}, Transaction);
return(result);
}
//insert
public async Task <int> InsertAnnualBonusAsync(AnnualBonusDto dto)
{
var sql1 = "" +
" INSERT INTO [dbo].[AnnualBonus] " +
" ([Bonus] " +
" ,[ProjectId] " +
" ,[ProjectMaintenanceId] " +
" ,[RatingFactorId] " +
" ,[EmpId] " +
" ,[Day] " +
" ,[year] " +
" ,[CreatedId] " +
" ,[CreatedDate]) " +
" VALUES " +
" (@Bonus" +
" ,@ProjectId" +
" ,@ProjectMaintenanceId" +
" ,@RatingFactorId" +
" ,@EmpId" +
" ,@Day" +
" ,@year" +
" ,@CreatedId " +
" ,GETDATE() )";
var result = await Connection.ExecuteAsync(sql1, new
{
Bonus = dto.Bonus,
ProjectId = dto.ProjectId,
ProjectMaintenanceId = dto.ProjectMaintenanceId,
RatingFactorId = dto.RatingFactorId,
EmpId = dto.EmpId,
Day = dto.Day,
year = dto.Year,
CreatedId = dto.CreatedId
}, Transaction);
return(result);
}
public async Task <IActionResult> Put([FromBody] AnnualBonusDto dto)
{
if (!ModelState.IsValid)
{
return(BadRequest(new { message = "Not a valid model" + ModelState.ToString() }));
}
try
{
_UnitOfWork.Transaction = _UnitOfWork.Begin();
var x = await _UnitOfWork.AnnualBonusRepository.UpdateAnnualBonusAsync(dto);
_UnitOfWork.Commit();
return(Ok(x));
}
catch (Exception ex)
{
_UnitOfWork.Dispose();
return(BadRequest(new { message = ex.Message }));
}
finally
{
_UnitOfWork.Dispose();
}
}
