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