Exemple #1
0
        public IActionResult Add(AuthorVM model, int[] categoryid)
        {
            if (ModelState.IsValid)
            {
                Author author = new Author();
                author.ID        = model.ID;
                author.Name      = model.Name;
                author.SurName   = model.Surname;
                author.EMail     = model.EMail;
                author.Phone     = model.Phone;
                author.BirthDate = model.BirthDate;

                _newscontext.Authors.Add(author);
                _newscontext.SaveChanges();

                int authorid = author.ID;

                model.Categories = _newscontext.Categories.ToList();

                for (int i = 0; i < categoryid.Length; i++)
                {
                    AuthorCategory authorcategory = new AuthorCategory();
                    authorcategory.CategoryID = categoryid[i];
                    authorcategory.AuthorID   = authorid;
                    _newscontext.AuthorCategories.Add(authorcategory);
                }
                _newscontext.SaveChanges();
            }
            else
            {
                return(View(GetAuthorForAdd()));
            }

            return(Redirect("/Admin/Author/Index/"));
        }
Exemple #2
0
        public AuthorCategory GetAuthorCategory(int id)
        {
            AuthorCategory      autcat = new AuthorCategory();
            List <BookAuthor>   alfas  = _bookauthor.AllQuery.Where(x => x.BookId == id).ToList();
            List <BookCategory> betas  = _bookcategory.AllQuery.Where(x => x.BookId == id).ToList();

            autcat.authorcount   = alfas.Count;
            autcat.categorycount = betas.Count;
            List <string> BookAuthor   = new List <string>();
            List <string> BookCategory = new List <string>();

            foreach (var alfa in alfas)
            {
                BookAuthor.Add(_authors.AllQuery.Where(x => x.Id == alfa.AuthorId).FirstOrDefault().FullName);
            }
            foreach (var beta in betas)
            {
                BookCategory.Add(_category.AllQuery.Where(x => x.Id == beta.CategoryId).FirstOrDefault().Title);
            }
            autcat.BookAuthor   = BookAuthor;
            autcat.BookCategory = BookCategory;
            return(autcat);
        }
Exemple #3
0
        public IActionResult Edit(AuthorVM model, int[] categoryid)
        {
            Author author = _newscontext.Authors.FirstOrDefault(x => x.ID == model.ID);
            List <CategoryCheckVM> categoryChecks = new List <CategoryCheckVM>();

            if (ModelState.IsValid)
            {
                author.Name      = model.Name;
                author.SurName   = model.Surname;
                author.EMail     = model.EMail;
                author.Phone     = model.Phone;
                author.BirthDate = model.BirthDate;

                _newscontext.SaveChanges();

                int authorid = author.ID;

                model.Categories = _newscontext.Categories.Where(q => q.IsDeleted == false).ToList();
                int[] selectedCategories = _newscontext.AuthorCategories.Where(q => q.AuthorID == authorid).Select(q => q.CategoryID).ToArray();

                foreach (var item in model.Categories)
                {
                    CategoryCheckVM categoryCheck = new CategoryCheckVM();

                    categoryCheck.categoryid = item.ID;

                    foreach (var item2 in selectedCategories)
                    {
                        if (item2 == categoryCheck.categoryid)
                        {
                            categoryCheck.IsChecked = true;
                            break;
                        }
                        else
                        {
                            categoryCheck.IsChecked = false;
                        }
                    }

                    categoryCheck.Name = item.CategoryName;
                    categoryChecks.Add(categoryCheck);
                }

                model.categoryCheck = categoryChecks.ToArray();



                foreach (var item in categoryid)
                {
                    if (!selectedCategories.Contains(item))
                    {
                        AuthorCategory authorCategory = new AuthorCategory();
                        authorCategory.CategoryID = item;
                        authorCategory.AuthorID   = authorid;
                        _newscontext.AuthorCategories.Add(authorCategory);
                    }
                }
                _newscontext.SaveChanges();
            }

            else
            {
                return(View(GetAuthorForEdit(model.ID)));
            }

            return(Redirect("/Admin/Author/Index/"));
        }