public ActionResult JoinGroup(int id) { using (var db = new DatabaseContext()) { ViewModels viewModel = new ViewModels(); Czlonkowie tempCzlonek = new Czlonkowie(); Uzytkownik currentUser = User.GetUserData(); Uzytkownik tempUser = db.Uzytkownik.FirstOrDefault(p => p.Id == currentUser.Id); KoloNaukowe tempKolo = db.KoloNaukowe.FirstOrDefault(p => p.Id == id); tempCzlonek.IdKola = tempKolo.Id; tempCzlonek.IdUzytkownika = tempUser.Id; tempCzlonek.Uzytkownik = tempUser; tempCzlonek.KoloNaukowe = tempKolo; tempCzlonek.Rola = 0; tempCzlonek.Aktywny = false; if (db.Czlonkowie.Any(p => p.IdUzytkownika == tempUser.Id && p.IdKola == tempKolo.Id)) { viewModel.Group = tempCzlonek.KoloNaukowe; return(View("JoinGroupError", viewModel)); } db.Czlonkowie.Add(tempCzlonek); db.SaveChanges(); viewModel.Group = tempCzlonek.KoloNaukowe; viewModel.Member = tempCzlonek; return(View(viewModel)); } }
private void SetCurrentMember(int groupId) { using (var db = new DatabaseContext()) { Czlonkowie temp = new Czlonkowie(); temp = db.Czlonkowie.FirstOrDefault(p => p.IdUzytkownika == userData.Id && p.IdKola == groupId); memberData = temp; } }
public ActionResult ShowPosts(int id, int page = 1) { using (var db = new DatabaseContext()) { ViewModels viewModel = new ViewModels(); PostListViewModel postList = new PostListViewModel(); KoloNaukowe group = new KoloNaukowe(); List <PostViewModel> postModels = new List <PostViewModel>(); List <string> authors = new List <string>(); postList.Posts = db.Post.Where(p => p.IdKola == id).ToList(); group = db.KoloNaukowe.FirstOrDefault(p => p.Id == id); if (postList.Posts == null) { return(View("Error", new string[] { "Brak postów" })); } viewModel.PostList = postList; int totalItems = db.Post.Where(p => p.IdKola == id).Count(); viewModel.PostList.Pages = (int)Math.Ceiling((decimal)totalItems / PageSize); viewModel.PostList.CurrentPage = page; foreach (Post post in viewModel.PostList.Posts) { Czlonkowie member = db.Czlonkowie.Include("Uzytkownik").FirstOrDefault(p => p.Id == post.IdCzlonka); string author; if (member == null) { author = ""; } author = member.Uzytkownik.Imie + " " + member.Uzytkownik.Nazwisko; authors.Add(author); } viewModel.PostList.AuthorsNames = authors; viewModel.PostList.Group = group; viewModel.Group = group; foreach (Post post in viewModel.PostList.Posts) { PostViewModel postView = new PostViewModel(); postView.Post = post; List <Komentarz> comList = new List <Komentarz>(); comList = db.Komentarz.Where(p => p.IdPostu == post.Id).ToList(); postView.Comments = comList; Czlonkowie author = db.Czlonkowie.Include("Uzytkownik").FirstOrDefault(p => p.Id == postView.Post.IdCzlonka); postView.AuthorName = author.Uzytkownik.Imie + " " + author.Uzytkownik.Nazwisko; if (postView.Post == null || author == null) { return(View("Error")); } postView = SetCommentsAuthors(postView); postModels.Add(postView); } viewModel.PostList.PostsModels = postModels; return(View(viewModel)); } }
public ActionResult AddPost() { using (var db = new DatabaseContext()) { ViewModels viewModel = new ViewModels(); AddPostViewModel addPost = new AddPostViewModel(); int userId = (User as ProjektIO.Auth.Principal).GetUserData().Id; Czlonkowie member = db.Czlonkowie.FirstOrDefault(p => p.IdUzytkownika == userId); addPost.Member = member; viewModel.AddPost = addPost; return(View(viewModel)); } }
private PostViewModel SetCommentsAuthors(PostViewModel postModel) { using (var db = new DatabaseContext()) { List <string> authors = new List <string>(); foreach (Komentarz comment in postModel.Comments) { string temp; Czlonkowie author = db.Czlonkowie.Include("Uzytkownik").FirstOrDefault(p => p.Id == comment.IdCzlonka); temp = author.Uzytkownik.Imie + " " + author.Uzytkownik.Nazwisko; authors.Add(temp); } postModel.CommentsAuthors = authors; return(postModel); } }
public ActionResult ContactAdmin(int id) { using (var db = new DatabaseContext()) { ViewModels viewModel = new ViewModels(); Czlonkowie member = new Czlonkowie(); member = db.Czlonkowie.Include("Uzytkownik").FirstOrDefault(p => p.Rola == 1 && p.IdKola == id); if (member == null) { return(View("Error", new string[] { "Ta grupa nie ma przewodniczącego" })); } viewModel.Group = member.KoloNaukowe; viewModel.Member = member; return(View(viewModel)); } }
private bool CheckCommentAuthor(int commentId) { using (var db = new DatabaseContext()) { Komentarz comment = new Komentarz(); comment = db.Komentarz.FirstOrDefault(p => p.Id == commentId); Czlonkowie temp = new Czlonkowie(); temp = db.Czlonkowie.FirstOrDefault(p => p.Id == comment.IdCzlonka); if (temp.IdUzytkownika == userData.Id) { return(true); } else { return(false); } } }
private bool CheckPostAuthor(int postId) { using (var db = new DatabaseContext()) { Post post = new Post(); post = db.Post.FirstOrDefault(p => p.Id == postId); Czlonkowie temp = new Czlonkowie(); temp = db.Czlonkowie.FirstOrDefault(p => p.Id == post.IdCzlonka); if (temp.IdUzytkownika == userData.Id) { return(true); } else { return(false); } } }
public ActionResult AddComment(ViewModels viewModel) { using (var db = new DatabaseContext()) { int id = (User as ProjektIO.Auth.Principal).GetUserData().Id; Czlonkowie member = db.Czlonkowie.FirstOrDefault(p => p.IdUzytkownika == id); Post post = db.Post.FirstOrDefault(p => p.Id == viewModel.AddComment.PostId); if (member == null || post == null) { return(View("Error")); } viewModel.AddComment.Comment.IdPostu = post.Id; viewModel.AddComment.Comment.Post = post; viewModel.AddComment.Comment.IdCzlonka = member.Id; viewModel.AddComment.Comment.Czlonkowie = member; db.Komentarz.Add(viewModel.AddComment.Comment); db.SaveChanges(); return(View()); } }
private GroupListViewModel SetDetails(GroupListViewModel model) { using (var db = new DatabaseContext()) { foreach (KoloNaukowe group in model.Groups) { GroupViewModel temp = new GroupViewModel(); Czlonkowie leader = new Czlonkowie(); leader = db.Czlonkowie.Include("Uzytkownik").FirstOrDefault(p => p.IdKola == group.Id && p.Rola == 1); if (leader != null) { temp.LeaderName = leader.Uzytkownik.Imie + " " + leader.Uzytkownik.Nazwisko ?? "Brak"; temp.Mail = leader.Uzytkownik.Email ?? "Brak"; temp.Group = group; temp.PhoneNumber = leader.Uzytkownik.NumerTelefonu ?? "Brak"; } model.viewGroup.Add(temp); } return(model); } }
public ActionResult ShowPost(int id, int page = 1) { int PageSize = 5; using (var db = new DatabaseContext()) { PostViewModel post = new PostViewModel(); ViewModels viewModel = new ViewModels(); post.Post = db.Post.FirstOrDefault(p => p.Id == id); post.Comments = db.Komentarz.Where(p => p.IdPostu == id).ToList(); Czlonkowie author = db.Czlonkowie.Include("Uzytkownik").FirstOrDefault(p => p.Id == post.Post.IdCzlonka); post.AuthorName = author.Uzytkownik.Imie + " " + author.Uzytkownik.Nazwisko; if (post.Post == null || author == null) { return(View("Error")); } int totalItems = db.Komentarz.Where(p => p.IdPostu == id).ToList().Count(); post.Pages = (int)Math.Ceiling((decimal)totalItems / PageSize); post.CurrentPage = page; post = SetCommentsAuthors(post); viewModel.PostModel = post; return(View(viewModel)); } }