public int UpdateLaborCategoryRates(LaborCategoryRates laborCategoryRates) { string insertQuery = $@"UPDATE LaborCategoryRates set UpdatedOn = @UpdatedOn , UpdatedBy = @UpdatedBy , IsDeleted = @IsDeleted , IsActive = @IsActive where CategoryRateGuid = @CategoryRateGuid "; return(_context.Connection.Execute(insertQuery, new { UpdatedOn = laborCategoryRates.UpdatedOn, UpdatedBy = laborCategoryRates.UpdatedBy, IsDeleted = laborCategoryRates.IsDeleted, IsActive = laborCategoryRates.IsActive, CategoryRateGuid = laborCategoryRates.CategoryRateGuid })); }
public int AddLaborCategoryRates(LaborCategoryRates model) { string insertQuery = $@"INSERT INTO [dbo].[LaborCategoryRates] ( CategoryRateGuid , ContractGuid , UploadFileName , IsCsv , CreatedOn , UpdatedOn , CreatedBy , UpdatedBy , IsDeleted , IsActive ) VALUES ( @CategoryRateGuid , @ContractGuid , @UploadFileName , @IsCsv , @CreatedOn , @UpdatedOn , @CreatedBy , @UpdatedBy , @IsDeleted , @IsActive )"; return(_context.Connection.Execute(insertQuery, new { CategoryRateGuid = model.CategoryRateGuid, ContractGuid = model.ContractGuid, UploadFileName = model.UploadFileName, IsCsv = model.IsCsv, CreatedOn = model.CreatedOn, UpdatedOn = model.UpdatedOn, CreatedBy = model.CreatedBy, UpdatedBy = model.UpdatedBy, IsDeleted = model.IsDeleted, IsActive = model.IsActive })); }
public int UpdateLaborCategoryRates(LaborCategoryRates laborCategoryRates) { return(_iProjectRepository.UpdateLaborCategoryRates(laborCategoryRates)); }
//LaborCategoryRates public int AddLaborCategoryRates(LaborCategoryRates laborCategoryRates) { return(_iProjectRepository.AddLaborCategoryRates(laborCategoryRates)); }
public int UpdateLaborCategoryRates(LaborCategoryRates laborCategoryRates) { return(_subcontractorBillingRatesRepository.UpdateLaborCategoryRates(laborCategoryRates)); }