public override OperationResult Execute(VlogEntities entities)
{
IEnumerable <AspNetRole> ieRoles = entities.AspNetRoles;
if (!Criteria.Uuid.IsNullOrWhiteSpace())
{
ieRoles = ieRoles.Where(r => r.Id == Criteria.Uuid);
}
if (!Criteria.Name.IsNullOrWhiteSpace())
{
ieRoles = ieRoles.Where(r => r.Name == Criteria.Name);
}
IEnumerable <RoleDto> ieDto = from role in ieRoles
select new RoleDto
{
Name = role.Name,
Uuid = role.Id
};
OperationResult result = new OperationResult();
result.Items = ieDto.ToArray();
result.Status = true;
return(result);
}
public override OperationResult Execute(VlogEntities entities)
{
IEnumerable <PostDto> iePosts = from posts in entities.Posts
join user in entities.AspNetUsers
on posts.UserID equals user.Id
join categories in entities.Categories
on posts.CategoryID equals categories.CategoryID
select new PostDto
{
Id = posts.PostID,
Post = posts.Post1,
Path = posts.Path,
Text = posts.Text,
UserID = posts.UserID,
Uuid = posts.UserID,
Created_At = posts.Created_At,
Updated_At = posts.Updated_At,
CategoryID = posts.CategoryID,
Username = user.UserName
};
OperationResult result = new OperationResult();
result.Items = iePosts.ToArray();
result.Status = true;
return(result);
}
public override OperationResult Execute(VlogEntities entities)
{
IEnumerable <Menu> ieMenus = entities.Menus;
if (Criteria.Id != 0)
{
ieMenus = ieMenus.Where(r => r.MenuID == Criteria.Id);
}
IEnumerable <MenuDto> ieMenu = from menus in ieMenus
select new MenuDto
{
Id = menus.MenuID,
Controller = menus.Controller,
Link = menus.Link,
Menu = menus.Menu1,
Area = menus.Area,
ParentID = menus.ParentID
};
OperationResult result = new OperationResult();
result.Items = ieMenu.ToArray();
result.Status = true;
return(result);
}
public override OperationResult Execute(VlogEntities entities)
{
Category category = new Category();
category.Category1 = this.category.Category;
entities.Categories.Add(category);
entities.SaveChanges();
return(base.Execute(entities));
}
public override OperationResult Execute(VlogEntities entities)
{
AspNetRole role = new AspNetRole();
role.Name = this.Role.Name;
role.Id = Guid.NewGuid().ToString();
entities.AspNetRoles.Add(role);
entities.SaveChanges();
return(base.Execute(entities));
}
public override OperationResult Execute(VlogEntities entities)
{
Menu menu = new Menu();
menu.Link = this.Menu.Link;
menu.Menu1 = this.Menu.Menu;
menu.Area = this.Menu.Area;
menu.Controller = this.Menu.Controller;
menu.ParentID = this.Menu.ParentID;
entities.Menus.Add(menu);
entities.SaveChanges();
return(base.Execute(entities));
}
public override OperationResult Execute(VlogEntities entities)
{
Post post = new Post();
post.CategoryID = this.Postdto.CategoryID;
post.Created_At = DateTime.Now;
post.Updated_At = DateTime.Now;
post.Post1 = this.Postdto.Post;
post.Text = this.Postdto.Text;
post.UserID = this.Postdto.UserID;
post.Path = this.Postdto.Path;
entities.Posts.Add(post);
entities.SaveChanges();
return(base.Execute(entities));
}
public override OperationResult Execute(VlogEntities entities)
{
Comment commentDtos = new Comment();
commentDtos.UserID = this.Comment.UserID;
commentDtos.Comment1 = this.Comment.Comment;
commentDtos.Created_At = DateTime.Now;
commentDtos.Updated_At = DateTime.Now;
commentDtos.PostID = this.Comment.PostID;
OperationResult result = new OperationResult();
entities.Comments.Add(commentDtos);
entities.SaveChanges();
return(base.Execute(entities));
}
void IActionFilter.OnActionExecuting(ActionExecutingContext filterContext)
{
//Do some logic: Get some parameters and create log entry
using (VlogEntities storeDb = new VlogEntities())
{
ActionLog log = new ActionLog()
{
Controller = filterContext.ActionDescriptor.ControllerDescriptor.ControllerName,
Action = string.Concat(filterContext.ActionDescriptor.ActionName, " (Logged By: " + HttpContext.Current.User.Identity.Name + ")"),
IP = filterContext.HttpContext.Request.UserHostAddress,
DateTime = filterContext.HttpContext.Timestamp
};
storeDb.ActionLogs.Add(log);
storeDb.SaveChanges();
OnActionExecuting(filterContext);
}
}
public override OperationResult Execute(VlogEntities entities)
{
Category categori = entities.Categories.Where(r => r.CategoryID == category.Id).FirstOrDefault();
if (categori != null)
{
categori.Category1 = category.Category;
entities.SaveChanges();
return(base.Execute(entities));
}
OperationResult result = new OperationResult();
result.Status = false;
result.Message = "Kategorija ne postoji.";
return(result);
}
public override OperationResult Execute(VlogEntities entities)
{
IEnumerable <ActivityLogDto> ieActivity = from log in entities.ActionLogs
select new ActivityLogDto
{
Id = log.ActionLogId,
Action = log.Action,
Controller = log.Controller,
DateTime = log.DateTime,
IP = log.IP
};
OperationResult result = new OperationResult();
result.Items = ieActivity.ToArray();
result.Status = true;
return(result);
}
public override OperationResult Execute(VlogEntities entities)
{
AspNetRole role = entities.AspNetRoles.Where(r => r.Id == Role.Uuid).FirstOrDefault();
if (role != null)
{
role.Name = Role.Name;
entities.SaveChanges();
return(base.Execute(entities));
}
OperationResult result = new OperationResult();
result.Status = false;
result.Message = "Uloga ne postoji.";
return(result);
}
public override OperationResult Execute(VlogEntities entities)
{
Menu menu = entities.Menus.Where(r => r.MenuID == Id).FirstOrDefault();
if (menu != null)
{
entities.Menus.Remove(menu);
entities.SaveChanges();
return(base.Execute(entities));
}
else
{
OperationResult result = new OperationResult();
result.Status = false;
result.Message = "Meni ne postoji.";
return(result);
}
}
public override OperationResult Execute(VlogEntities entities)
{
AspNetRole role = entities.AspNetRoles.Where(r => r.Id == Uuid && r.AspNetUsers.Count() == 0).FirstOrDefault();
if (role != null)
{
entities.AspNetRoles.Remove(role);
entities.SaveChanges();
return(base.Execute(entities));
}
else
{
OperationResult result = new OperationResult();
result.Status = false;
result.Message = "Uloga ne postoji ili sadrzi korisnike.";
return(result);
}
}
public override OperationResult Execute(VlogEntities entities)
{
if (this.Criteria.Uuid != "")
{
IEnumerable <RoleDto> ieRoles = from roles in entities.AspNetRoles
where roles.Id == this.Role.Uuid
select new RoleDto
{
Uuid = roles.Id,
Name = roles.Name
};
OperationResult result = new OperationResult();
result.Items = ieRoles.ToArray();
result.Status = true;
return(result);
}
return(base.Execute(entities));
}
public override OperationResult Execute(VlogEntities entities)
{
IEnumerable <CommentDto> comments = from comment in entities.Comments
join users in entities.AspNetUsers
on comment.UserID equals users.Id
where comment.UserID == users.Id
select new CommentDto
{
UserID = comment.UserID,
Comment = comment.Comment1,
Id = comment.CommentID,
Created_At = comment.Created_At,
Updated_At = comment.Updated_At,
PostID = comment.PostID
};
OperationResult result = new OperationResult();
result.Items = comments.ToArray();
result.Status = true;
return(result);
}
public override OperationResult Execute(VlogEntities entities)
{
Menu menus = entities.Menus.Where(r => r.MenuID == Menu.Id).FirstOrDefault();
if (menus != null)
{
menus.Menu1 = this.Menu.Menu;
menus.Link = this.Menu.Link;
menus.Area = this.Menu.Area;
menus.Controller = this.Menu.Controller;
menus.ParentID = this.Menu.ParentID;
entities.SaveChanges();
return(base.Execute(entities));
}
OperationResult result = new OperationResult();
result.Status = false;
result.Message = "Meni ne postoji.";
return(result);
}
public override OperationResult Execute(VlogEntities entities)
{
IEnumerable <Category> ieCategories = entities.Categories;
if (Criteria.Id != 0)
{
ieCategories = ieCategories.Where(r => r.CategoryID == Criteria.Id);
}
IEnumerable <CategoryDto> ieDto = from category in ieCategories
select new CategoryDto
{
Category = category.Category1,
Id = category.CategoryID
};
OperationResult result = new OperationResult();
result.Items = ieDto.ToArray();
result.Status = true;
return(result);
}
public abstract OperationResult Execute(VlogEntities entities);
public override OperationResult Execute(VlogEntities entities)
{
OperationResult result = new OperationResult();
if (this.Postdto.CategoryID == 0 && this.criteria.Id != 0)
{
IEnumerable <PostDto> postsC = from posts in entities.Posts
join user in entities.AspNetUsers
on posts.UserID equals user.Id
join categories in entities.Categories
on posts.CategoryID equals categories.CategoryID
where posts.PostID == this.criteria.Id
// join comments in entities.Comments
//on posts.PostID equals comments.PostID into koment
// from k in koment.DefaultIfEmpty(new Comment()
// {
// })
//where posts.PostID == k.PostID
select new PostDto
{
Id = posts.PostID,
Post = posts.Post1,
Path = posts.Path,
Text = posts.Text,
UserID = posts.UserID,
Uuid = posts.UserID,
Created_At = posts.Created_At,
Updated_At = posts.Updated_At,
CategoryID = posts.CategoryID,
Username = user.UserName,
//Comment = (from comment in k
// select new CommentDto
// {
// Comment = comment.Comment1
// }).ToList()
};
List <PostDto> z = postsC.ToList();
foreach (var i in z)
{
IEnumerable <CommentDto> comments = from c in entities.Comments
join users in entities.AspNetUsers
on c.AspNetUser.Id equals users.Id
where c.PostID == i.Id
where c.AspNetUser.Id == users.Id
select new CommentDto
{
Comment = c.Comment1,
Created_At = c.Created_At,
Updated_At = c.Updated_At,
AspNetUser = (from user in entities.AspNetUsers
where user.Id == c.UserID
select new UserDto
{
UserName = user.UserName
}).FirstOrDefault()
};
i.Comment = comments.ToList();
}
result.Items = z.ToArray();
result.Status = true;
return(result);
}
else if (this.Postdto.CategoryID != 0)
{
IEnumerable <PostDto> customPosts = from posts in entities.Posts
join user in entities.AspNetUsers
on posts.UserID equals user.Id
join categories in entities.Categories
on posts.CategoryID equals categories.CategoryID
where posts.CategoryID == this.Postdto.CategoryID
// join comments in entities.Comments
//on posts.PostID equals comments.PostID into koment
// from k in koment.DefaultIfEmpty(new Comment()
// {
// })
//where posts.PostID == k.PostID
select new PostDto
{
Id = posts.PostID,
Post = posts.Post1,
Path = posts.Path,
Text = posts.Text,
UserID = posts.UserID,
Uuid = posts.UserID,
Created_At = posts.Created_At,
Updated_At = posts.Updated_At,
CategoryID = posts.CategoryID,
Username = user.UserName,
//Comment = (from comment in k
// select new CommentDto
// {
// Comment = comment.Comment1
// }).ToList()
};
List <PostDto> p = customPosts.ToList();
foreach (var i in p)
{
IEnumerable <CommentDto> comments = from c in entities.Comments
where c.PostID == i.Id
select new CommentDto
{
Comment = c.Comment1
};
i.Comment = comments.ToList();
}
result.Items = p.ToArray();
result.Status = true;
return(result);
}
else
{
return(base.Execute(entities));
}
}
