private CategoryDto GetCategoryModelDto(ArticleCategories model) { var category = new CategoryDto(); var postsFromCategory = db.Articles.Where(x => x.CategoryId == model.Id && x.IsPublished) .OrderByDescending(x => x.DateCreated) .ToList(); var postList = new List <ArticleDto>(); foreach (var post in postsFromCategory) { var element = new ArticleDto { Id = post.Id, Name = post.Name, CodedName = generalHelper.RemoveSpecialCharsFromString(post.Name), ImageUrl = articleHelper.GetImageRelativePathByArticleId(post.Id), Subcategory = articleHelper.GetSubCategoryById(post.SubCategoryId).Name }; postList.Add(element); } category.CategoryPosts = postList; category.CategoryName = model.Name; category.Description = model.Description; category.Subcategories = category.CategoryPosts.Select(x => x.Subcategory).Distinct().ToList(); return(category); }
public void Execute(ArticlesDto request) { _validator.ValidateAndThrow(request); var pictures = new Pictures { src = request.Pictures.src }; _context.Pictures.Add(pictures); _context.SaveChanges(); var article = new Article { Subject = request.Subject, Text = request.Text, PicturesId = pictures.Id, UserId = _actor.Id }; _context.Articles.Add(article); _context.SaveChanges(); foreach (var c in request.Categories) { var categories = new ArticleCategories { ArticlesId = article.Id, CategoryId = c.Id }; _context.ArticleCategories.Add(categories); _context.SaveChanges(); } }
public void Execute(ArticlesDto request, int id) { _validator.ValidateAndThrow(request); var post = _context.Articles.Find(id); var pic = _context.Pictures.Find(post.PicturesId); var postcat = _context.ArticleCategories.Where(x => x.ArticlesId == id).Select(x => x.Id).ToList(); post.Subject = request.Subject; post.Text = request.Text; post.UserId = request.UserId; pic.src = request.Pictures.src; // pic.alt = request.Pictures.alt; post.Pictures.ModifiedAt = DateTime.Now; post.ModifiedAt = DateTime.Now; var brojKategorije = request.Categories; foreach (var i in postcat) { var pc = _context.ArticleCategories.Find(i); _context.ArticleCategories.Remove(pc); } foreach (var bk in brojKategorije) { var cat = new ArticleCategories { ArticlesId = id, CategoryId = bk.Id }; _context.ArticleCategories.Add(cat); } _context.SaveChanges(); }
public ActionResult CategoriesDetails(ArticleCategories category) { if (ModelState.IsValid) { articleHelper.ChangeCategoryDetails(category); return(RedirectToAction("Categories")); } return(View()); }
public void ChangeCategoryDetails(ArticleCategories category) { var categoryToChange = GetCategoryById(category.Id); categoryToChange.Name = category.Name; categoryToChange.Description = category.Description; categoryToChange.SortCode = category.SortCode; db.Entry(categoryToChange).State = EntityState.Modified; db.SaveChanges(); }
public ActionResult CategoriesCreate(ArticleCategories category) { if (ModelState.IsValid) { category.Id = Guid.NewGuid(); db.Categories.Add(category); db.SaveChanges(); return(RedirectToAction("Categories")); } return(View()); }
// TODO : How to measure an article follow these dimensions or this weigth // public float Weigth { get; } // public float Size { get; } // public float Other { get; } public Article( string name, string barCode, ArticleCategories category, double price ) { Name = name; BarCode = barCode; Category = category; Price = price; }
protected void Page_Load(object sender, EventArgs e) { if (!(Request.Cookies["NewsVendorCookie"] != null && new Bitmask().checkEditor(int.Parse(Request.Cookies.Get("NewsVendorCookie")["role"])))) { Response.Redirect("~/Index.aspx"); } if (!this.IsPostBack) { SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["MyDb"].ConnectionString); SqlCommand cmd = new SqlCommand("SELECT Id, Name FROM Categories;", con); con.Open(); try { DataTable dt = new DataTable(); dt.Load(cmd.ExecuteReader()); ArticleCategories.DataSource = dt; ArticleCategories.DataTextField = "Name"; ArticleCategories.DataValueField = "Name"; ArticleCategories.DataBind(); ArticleCategories.Items.Insert(0, new ListItem("-- Select Category --", "0")); } catch (Exception ex) { FinishArticleErrorLabel.Text = "Internal Error"; } finally { con.Close(); } } }