예제 #1
0
        public ActionResult FindByAjax(int id = 1, int page = 1)
        {

            int pageSize = 3;

            var userKnowledgers = serviceForUserKnowl.GetAll().Where((x) => x.KnowledgeId == id).Select(x => x.ToWebUserKnowl());

            var usersTemp = service.GetAll().Select(y => y.ToWebUser());

            Dictionary<int, string> usersForViewBag = new Dictionary<int, string>();
            foreach (var x in service.GetAll().ToList())
            {
                usersForViewBag.Add(x.UserId, x.Name);
            }
            ViewBag.Users = usersForViewBag;
            ViewBag.ID = id;

            var q = from t in userKnowledgers
                    join tID in usersTemp on t.UserId equals tID.UserId
                    select new UserViewModel { Email = tID.Email, Name = tID.Name, Photo = tID.Photo, UserId = tID.UserId };

            var users = q.Skip((page - 1) * pageSize).Take(pageSize);

            PageInfo pageInfo = new PageInfo { PageNumber = page, PageSize = pageSize, TotalItems = userKnowledgers.Count() };
            IndexViewModel ivm = new IndexViewModel { PageInfo = pageInfo, UserViewModel = users };
            return PartialView("FindByAjax", ivm);

        }
예제 #2
0
        public ActionResult Find(FormCollection form, int page = 1)
        {
            if (form["WhatDoYouWanna"] == "Find")
            {
                int pageSize = 3;




                var userKnowledgers = serviceForUserKnowl.GetAll().Where((x) => x.Degree >= Convert.ToInt32(form["Numbers"]) && x.KnowledgeId == Convert.ToInt32(form["Knowledges"])).Select(x => x.ToWebUserKnowl());

                var usersTemp = service.GetAll().Select(y => y.ToWebUser());

                Dictionary<int, string> usersForViewBag = new Dictionary<int, string>();
                foreach (var x in service.GetAll().ToList())
                {
                    usersForViewBag.Add(x.UserId, x.Name);
                }
                ViewBag.Users = usersForViewBag;


                var q = from t in userKnowledgers
                        join tID in usersTemp on t.UserId equals tID.UserId
                        select new UserViewModel { Email = tID.Email, Name = tID.Name, Photo = tID.Photo, UserId = tID.UserId };

                var users = q.Skip((page - 1) * pageSize).Take(pageSize);
                PageInfo pageInfo = new PageInfo { PageNumber = page, PageSize = pageSize, TotalItems = userKnowledgers.Count() };
                IndexViewModel ivm = new IndexViewModel { PageInfo = pageInfo, UserViewModel = users };
                return View("Find", ivm);
            }
            else
            {
                var knowledge = serviceForKnowl.GetById(Convert.ToInt32(form["Knowledges"]));
                var number = Convert.ToInt32(form["Numbers"]);

                var serviceForViewBagKnowl = serviceForKnowl.GetAll().ToList();


                var userKnowledgers = serviceForUserKnowl.GetAll().Where((x) => x.Degree >= number && x.KnowledgeId == knowledge.KnowledgeId).Select(x => x.ToWebUserKnowl());

                var usersTemp = service.GetAll().Select(y => y.ToWebUser());

                Dictionary<int, string> knowlName = new Dictionary<int, string>();
                foreach (var x in serviceForViewBagKnowl)
                {
                    knowlName.Add(x.KnowledgeId, x.Name);
                }


                var q = from t in userKnowledgers
                        join tID in usersTemp on t.UserId equals tID.UserId
                        select new UserViewModel { Email = tID.Email, Name = tID.Name, Photo = tID.Photo, UserId = tID.UserId };

                var q2 = q.ToList();



                object oMissing = System.Reflection.Missing.Value;
                object oEndOfDoc = "\\endofdoc";


                Word._Application oWord;
                Word._Document oDoc;
                oWord = new Word.Application();
                oWord.Visible = true;
                oDoc = oWord.Documents.Add(ref oMissing, ref oMissing,
                    ref oMissing, ref oMissing);


                Word.Paragraph oPara1;
                oPara1 = oDoc.Content.Paragraphs.Add(ref oMissing);
                oPara1.Range.Text = "Knowledge - " + knowledge.Name + ", Power of knowledge >= " + Convert.ToInt32(form["Numbers"]);
                oPara1.Range.Font.Bold = 1;
                oPara1.Format.SpaceAfter = 12;
                oPara1.Range.InsertParagraphAfter();

                foreach (var item in q2)
                {
                    Word.Paragraph oPara2;
                    oPara2 = oDoc.Content.Paragraphs.Add(ref oMissing);
                    oPara2.Range.InsertParagraphBefore();
                    oPara2.Range.Text = "IserId - " + item.UserId + ", Users name - " + item.Name + ", Email - " + item.Email;
                    oPara2.Range.InsertParagraphAfter();
                    foreach (var y in serviceForUserKnowl.GetAll().Where(x => x.UserId == item.UserId).ToList())
                    {
                        Word.Paragraph oPara4;
                        oPara4 = oDoc.Content.Paragraphs.Add(ref oMissing);
                        oPara4.Range.Font.Bold = 0;
                        oPara4.Range.Text = "Knowledge - " + knowlName[y.KnowledgeId] + ", Power - " + y.Degree + ", Description - " + y.Description;
                        oPara4.Range.InsertParagraphAfter();
                    }
                }

                return View("DocForYou");
            }

        }
예제 #3
0
        public ActionResult DetailsForAdmin(int page = 1)
        {

            int pageSize = 3;
            var users = service.GetAll().Skip((page - 1) * pageSize).Take(pageSize).Select(x => x.ToWebUser());
            PageInfo pageInfo = new PageInfo { PageNumber = page, PageSize = pageSize, TotalItems = service.GetAll().Count() };
            IndexViewModel ivm = new IndexViewModel { PageInfo = pageInfo, UserViewModel = users };


            if (Request.IsAjaxRequest())
            {
                return PartialView("AdminPartial", ivm);
            }

            return View("Admin", ivm);
        }