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
);
}
