private async Task InsertNewStandard(StandardNonApprovedCollation standard) { await _unitOfWork.Connection.ExecuteAsync( "INSERT INTO [StandardNonApprovedCollation] ([ReferenceNumber] ,[Title],[StandardData]) " + "VALUES (@referenceNumber, @title, @standardData)", param : new { standard.ReferenceNumber, standard.Title, standard.StandardData }, transaction : _unitOfWork.Transaction ); }
private async Task UpdateExistingStandardToRemoved(StandardNonApprovedCollation standard) { await _unitOfWork.Connection.ExecuteAsync( "Update [StandardNonApprovedCollation] set IsLive=0, DateRemoved=getutcdate() " + "where ReferenceNumber = @referenceNumber", param : new { standard.ReferenceNumber }, transaction : _unitOfWork.Transaction ); }
private async Task UpdateExistingStandard(StandardNonApprovedCollation standard, string standardData) { await _unitOfWork.Connection.ExecuteAsync( "Update [StandardNonApprovedCollation] set ReferenceNumber = @referenceNumber, Title = @Title, StandardData = @StandardData, DateUpdated=getutcdate(), DateRemoved=null, IsLive = 1 " + "where ReferenceNumber = @referenceNumber", param : new { standard.ReferenceNumber, standard.Title, standardData }, transaction : _unitOfWork.Transaction ); }
private async Task UpdateExistingStandardToRemoved(StandardNonApprovedCollation standard) { await _unitOfWork.Connection.ExecuteAsync( "UPDATE [StandardNonApprovedCollation] SET " + "IsLive = 0, " + "DateRemoved = GETUTCDATE() " + "WHERE ReferenceNumber = @referenceNumber", param : new { standard.ReferenceNumber }, transaction : _unitOfWork.Transaction ); }
private async Task UpdateExistingStandard(StandardNonApprovedCollation standard) { await _unitOfWork.Connection.ExecuteAsync( "UPDATE [StandardNonApprovedCollation] SET " + "ReferenceNumber = @referenceNumber, " + "Title = @title, " + "StandardData = @standardData, " + "DateUpdated = GETUTCDATE(), " + "DateRemoved = NULL, " + "IsLive = 1 " + "WHERE ReferenceNumber = @referenceNumber", param : new { standard.ReferenceNumber, standard.Title, standard.StandardData }, transaction : _unitOfWork.Transaction ); }