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