public void Update(Tax tax)
{
var InsertQuery = "UPDATE[dbo].[Taxes] SET [TaxVersionId] = @TaxVersionId, [Name] = @Name, [Modified] = @Modified," +
"[ModifiedBy] = @ModifiedBy, [IsDeleted] = @IsDeleted WHERE [TaxId] = @TaxId;";
DataAccessService.InsertObject(tax, InsertQuery);
}
public void Insert(Tax tax)
{
var InsertQuery = "INSERT INTO [dbo].[Taxes] ([TaxId],[TaxVersionId],[Name],[Modified],[ModifiedBy],[IsDeleted]) VALUES " +
"(@TaxId, @TaxVersionId, @Name, @Modified, @ModifiedBy, @IsDeleted)";
DataAccessService.InsertObject(tax, InsertQuery);
}
public Guid Insert(Tax tax)
{
var InsertQuery = "INSERT INTO [History].[TaxesVersions] ([TaxId],[Name],[Modified],[ModifiedBy],[IsDeleted]) " +
"OUTPUT INSERTED.TaxVersionId " +
"VALUES (@TaxId, @Name, @Modified, @ModifiedBy, @IsDeleted)";
return (Guid)DataAccessService.InsertObject(tax, InsertQuery);
}