public void Insert(MenuCategory menuCategory)
{
var InsertQuery = "INSERT INTO [dbo].[MenuCategories] ([MenuCategoryId],[MenuCategoryVersionId],[Name],[Modified],[ModifiedBy],[IsDeleted]) VALUES " +
"(@MenuCategoryId, @MenuCategoryVersionId, @Name, @Modified, @ModifiedBy, @IsDeleted)";
DataAccessService.InsertObject(menuCategory, InsertQuery);
}
public void Update(MenuCategory menuCategory)
{
var UpdateQuery = "UPDATE [dbo].[MenuCategories] SET [MenuCategoryVersionId] = @MenuCategoryVersionId, [Name] = @Name," +
"[Modified] = @Modified, [ModifiedBy] = @ModifiedBy,[IsDeleted] = @IsDeleted WHERE [MenuCategoryId] = @MenuCategoryId";
DataAccessService.PersistObjectAsync(menuCategory, UpdateQuery);
}
public Guid Insert(MenuCategory menuCategory)
{
var InsertQuery = "INSERT INTO [History].[MenuCategoriesVersions] ([MenuCategoryId],[Name],[Modified],[ModifiedBy],[IsDeleted]) " +
"OUTPUT INSERTED.MenuCategoryVersionId " +
"VALUES (@MenuCategoryId, @Name, @Modified, @ModifiedBy, @IsDeleted)";
return (Guid)DataAccessService.InsertObject(menuCategory, InsertQuery);
}
public Guid Update(MenuCategory menuCategory)
{
menuCategory.Modified = DateTimeOffset.Now;
menuCategory.MenuCategoryVersionId = _menuCategoryVersionRepository.Insert(menuCategory);
_menuCategoryСacheRepository.Update(menuCategory);
return menuCategory.MenuCategoryVersionId;
}
