public override OperationResult Execute(skiiiEntities entities)
{
IQueryable <Post> iePosts = entities.Posts;
iePosts = iePosts.Where(r => r.idCategory == Criteria.Id);
IEnumerable <PostDTO> iePostDTO = (from p in iePosts
orderby p.idPost descending
select new PostDTO
{
Id = p.idPost,
CategoryName = p.Category.name,
heading = p.heading,
paragraph = p.paragraph,
publish = p.publish,
src = p.Image.src,
username = p.AspNetUser.UserName
}).Take(3);
OperationResult result = new OperationResult();
result.Items = iePostDTO.ToArray();
result.Status = true;
return(result);
}
public override OperationResult Execute(skiiiEntities entities)
{
IQueryable <Category> iqCategory = entities.Categories;
if (Criteria.Id != 0)
{
iqCategory = iqCategory.Where(r => r.idCategory == Criteria.Id);
}
IEnumerable <CategoryDTO> ieCat =
from c in iqCategory
select new CategoryDTO
{
Id = c.idCategory,
Name = c.name,
Number = c.Posts.Count
};
OperationResult result = new OperationResult
{
Items = ieCat.ToArray(),
Status = true
};
return(result);
}
public override OperationResult Execute(skiiiEntities entities)
{
IQueryable <Contact> iqContact = entities.Contacts;
if (Criteria.Id != 0)
{
iqContact = iqContact.Where(r => r.idContact == Criteria.Id);
}
IEnumerable <ContactDTO> ieContact =
from c in iqContact
select new ContactDTO
{
Id = c.idContact,
Uuid = c.AspNetUser.UserName,
message = c.message,
date = c.date
};
OperationResult result = new OperationResult();
result.Items = ieContact.ToArray();
result.Status = true;
return(result);
}
public override OperationResult Execute(skiiiEntities entities)
{
Category cat = new Category();
cat.name = this.Cat.Name;
entities.Categories.Add(cat);
entities.SaveChanges();
return(base.Execute(entities));
}
public override OperationResult Execute(skiiiEntities entities)
{
var contact = new Contact();
contact.idUser = this.DTO.Uuid;
contact.message = this.DTO.message;
entities.Contacts.Add(contact);
entities.SaveChanges();
return(base.Execute(entities));
}
public override OperationResult Execute(skiiiEntities entities)
{
Category cat = entities.Categories.Where(r => r.idCategory == Cat.Id).FirstOrDefault();
if (cat != null)
{
cat.name = Cat.Name;
entities.SaveChanges();
return(base.Execute(entities));
}
OperationResult result = new OperationResult();
result.Status = false;
result.Message = "Kategorija ne postoji";
return(result);
}
public override OperationResult Execute(skiiiEntities entities)
{
Post postzabrisanje = entities.Posts.Where(p => p.idPost == idzabriranje).FirstOrDefault();
if (postzabrisanje != null)
{
entities.Posts.Remove(postzabrisanje);
entities.SaveChanges();
return(base.Execute(entities));
}
else
{
OperationResult result = new OperationResult();
result.Status = false;
result.Message = "Doslo je do greske, post ne postoji u bazi.";
return(result);
}
}
public override OperationResult Execute(skiiiEntities entities)
{
Category cat = entities.Categories.Where(p => p.idCategory == IdzaBrisanje).FirstOrDefault();
if (cat != null)
{
entities.Categories.Remove(cat);
entities.SaveChanges();
return(base.Execute(entities));
}
else
{
OperationResult result = new OperationResult();
result.Status = false;
result.Message = "Doslo je do greske. Odredjeni postovi se nalaze u kategoriji";
return(result);
}
}
public override OperationResult Execute(skiiiEntities entities)
{
IEnumerable <HeaderDTO> ieHeader =
(from h in entities.Headers
orderby h.idHeader descending
select new HeaderDTO
{
Id = h.idHeader,
heading = h.heading,
src = h.Image.src
}).Take(1);
OperationResult result = new OperationResult
{
Status = true,
Items = ieHeader.ToArray()
};
return(result);
}
public override OperationResult Execute(skiiiEntities entities)
{
IQueryable <Post> iqPost = entities.Posts;
if (Criteria.Id != 0)
{
iqPost = iqPost.Where(r => r.idPost == Criteria.Id);
}
if (!String.IsNullOrEmpty(Criteria.Uuid))
{
iqPost = iqPost.Where(r => r.idUser == Criteria.Uuid);
}
IEnumerable <PostDTO> iePosts =
(from p in iqPost
orderby p.idPost descending
select new PostDTO
{
Id = p.idPost,
CategoryName = p.Category.name,
heading = p.heading,
paragraph = p.paragraph,
publish = p.publish,
src = p.Image.src,
username = p.AspNetUser.UserName,
ImageAbout = p.ImageAbout,
paragraph2 = p.paragraph2
}).Take(3);
var e = iqPost.Count();
OperationResult result = new OperationResult
{
Items = iePosts.ToArray(),
Status = true,
Broj = e
};
return(result);
}
public override OperationResult Execute(skiiiEntities entities)
{
var slika = new Image();
slika.src = this.DTO.src;
Post post = new Post();
post.Image = slika;
post.heading = DTO.heading;
post.idCategory = 4;
post.idUser = DTO.Uuid;
post.ImageAbout = DTO.ImageAbout;
post.paragraph = DTO.paragraph;
post.paragraph2 = DTO.paragraph2;
post.Image = slika;
entities.Images.Add(slika);
entities.Posts.Add(post);
entities.SaveChanges();
return(base.Execute(entities));
}
public abstract OperationResult Execute(skiiiEntities entities);