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