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