public static void syncGroups() { using (var db = new ClassroomContext()) { var em = new ElasticManager(); var finishedGroups = new List <string>(); List <FacebookGroup> groups = db.FacebookGroups //.Include(x => x.posts) // .ThenInclude(post => post.comments) //.Include(x => x.posts) .Include(x => x.parentAuth) .ToList(); foreach (FacebookGroup group in groups) { if (!finishedGroups.Contains(group.id)) { try { List <FacebookGroupPost> posts = getGroupFeed(group.id, group.parentAuth); db.FacebookGroupPosts.RemoveRange(db.FacebookGroupPosts.ToList()); db.SaveChanges(); var extantDocs = db.Documents.Where(x => x.ExternalParentId == group.id); db.Documents.RemoveRange(extantDocs); foreach (var post in posts) { var convertedDoc = convertToDocument(post); if (convertedDoc != null) { db.Documents.Add(convertToDocument(post)); } } db.SaveChanges(); db.FacebookGroupPosts.AddRange(posts); db.SaveChanges(); finishedGroups.Add(group.id); } catch (Exception ex) { //swallow } } var docPosts = db.Documents.Where(x => x.ExternalParentId == group.id).ToList(); docPosts.ForEach(x => x.Id = x.ExternalId); em.addManyDocuments(docPosts); } //em.fill(); } }
public void OnPost(int todoId, string updatedText) { todos = db.ToDo.ToList(); foreach (var item in todos) { if (item.Id == todoId) { item.text = updatedText; break; } } db.SaveChanges(); }
public IActionResult saveGroupToRoom(int roomId, string groupset, string groupid) { using (var db = new ClassroomContext()) { if (groupset.ToLower() == "facebook") { var faceGroup = new FacebookGroup(); var fb = new FacebookConnector(HttpContext.Session); var fbGroups = fb.getGroups(); faceGroup = fbGroups.Where(x => x.id == groupid).FirstOrDefault(); faceGroup.ClassroomId = roomId; if (db.FacebookGroups.Where(x => x.id == groupid && x.ClassroomId == roomId).Count() == 0) { db.FacebookAuthSet.Update(faceGroup.parentAuth); db.FacebookGroups.Add(faceGroup); } else { db.FacebookGroups.Remove(db.FacebookGroups.Where(x => x.id == groupid && x.ClassroomId == roomId).First()); } } db.SaveChanges(); } return(Content("success")); }
public void OnPost(string name, string email, string password) { var newPerson = new Individual { fullname = name, email = email, password = password }; db.Person.Add(newPerson); db.SaveChanges(); Response.Redirect("/People"); }
public IActionResult removeUserFromClassroom(int id, int userId) { using (var db = new ClassroomContext()) { UserClassrooms uc = new UserClassrooms(); uc = db.StudentClassrooms.Where(sc => sc.UserId == userId && sc.ClassroomId == id).Single(); db.StudentClassrooms.Remove(uc); db.SaveChanges(); } return(Json("fakjea")); }
public IActionResult addUserToClassroom(int id, int userId) { using (var db = new ClassroomContext()) { UserClassrooms uc = new UserClassrooms(); uc.ClassroomId = id; uc.UserId = userId; db.StudentClassrooms.Add(uc); db.SaveChanges(); } return(Json("fakjea")); }
public IActionResult docdatasave(Document data) { using (var db = new ClassroomContext()) { db.Update(data); db.SaveChanges(); ElasticManager em = new ElasticManager(); em.addDocument(data); } return(Content("success")); }
public void OnPost(string content) { var newPost = new BoardPost { userId = (int)HttpContext.Session.GetInt32("userId"), content = content, postedOn = DateTime.Now }; db.BoardPosts.Add(newPost); db.SaveChanges(); OnGet(); }
public static int register(User newUser, string confpassword) { if (isRegistrable(newUser.Username, newUser.Email, newUser.Password, confpassword)) { using (var db = new ClassroomContext()) { db.Users.Add(newUser); db.SaveChanges(); return(newUser.Id); } } return(0); }
public IActionResult NewUserSave(User user) { if (!SecurityHelper.isRegistrable(user.Username, user.Email, user.Password, Request.Form["confpassword"])) { return(Redirect("/classroom/admin/newuser")); } using (var db = new ClassroomContext()) { if (user.Id == 0) { db.Users.Add(user); } else { db.Users.Update(user); } db.SaveChanges(); var roles = db.Roles; List <string> roleCodes = new List <string>(); roleCodes.AddRange(Request.Form["roles"].ToString().Split(',').ToList()); List <Role> resultRoles = roles.Where(r => roleCodes.Where(x => x.ToLower() == r.Slug.ToLower()).Count() > 0).ToList(); List <UserRole> existingRoles = db.UserRoles.Where(ur => ur.UserId == user.Id).ToList(); db.UserRoles.RemoveRange(existingRoles); foreach (Role role in resultRoles) { UserRole userRole = new UserRole(); userRole.User = user; userRole.Role = role; db.UserRoles.Add(userRole); } db.SaveChanges(); } return(Redirect("users")); }
public void OnPost(string text) { if (text.Length > 50) { text = text.Substring(0, 50); } var item = new ToDoItem { text = text }; db.ToDo.Add(item); db.SaveChanges(); Response.Redirect("/"); }
public IActionResult SaveNewClassroom(Classroom newRoom) { var db = new ClassroomContext(); newRoom.OwnerId = SecurityHelper.currentUserId(HttpContext.Session); if (newRoom.Id == 0) { db.Classrooms.Add(newRoom); } else { db.Classrooms.Update(newRoom); } db.SaveChanges(); return(Redirect(Url.Action("NewClassroom", "Admin") + "/" + newRoom.Id)); }
public bool OnPost() { string action = Request.Form["action"]; string username = Request.Form["username"]; string password = Request.Form["password"]; if (username.Length > 50) { username = username.Substring(0, 50); } if (password.Length > 50) { password = password.Substring(0, 50); } switch (action) { case "login": try { var user = db.BoardUsers.Where( u => u.username == username && u.password == password ).Single(); loginSuccessful(user); return(true); } catch { return(false); } case "register": try { var newUser = new BoardUser { username = username, password = password, }; db.BoardUsers.Add(newUser); db.SaveChanges(); loginSuccessful(newUser); return(true); } catch { return(false); } default: return(false); } }
public IActionResult Groups() { FacebookConnector fb = new FacebookConnector(HttpContext.Session); List <FacebookGroup> groups = fb.getGroups(); List <FacebookGroupPost> posts = fb.getGroupFeed("302929356816829"); using (var db = new ClassroomContext()) { db.FacebookGroupPosts.UpdateRange(posts); db.SaveChanges(); } List <Document> documents = new List <Document>(); return(View()); }
public static int register(string username, string email, string password, string confpassword) { if (isRegistrable(username, email, password, confpassword)) { using (var db = new ClassroomContext()) { User newUser = new User(); newUser.Username = username; newUser.Email = email; newUser.Password = password; db.Users.Add(newUser); db.SaveChanges(); return(newUser.Id); } } return(0); }
public IActionResult NewRoleSave(int?id) { Role role = new Role(); using (var db = new ClassroomContext()) { if (id != null) { role = db.Roles.Single(r => r.Id == id); } else { db.Roles.Add(role); } role.Name = Request.Form["role_name"]; role.Description = Request.Form["description"]; db.SaveChanges(); } return(Redirect("roles")); }
public IActionResult saveAuthObject(FacebookAuth auth) { int? userId = HttpContext.Session.GetInt32("currentuser"); dynamic stringResponse; if (userId != null) { using (var db = new ClassroomContext()) { using (var client = new HttpClient()) { client.BaseAddress = new Uri("https://graph.facebook.com/v2.9/"); HttpResponseMessage response = client.GetAsync("oauth/access_token?grant_type=fb_exchange_token&client_id=" + Environment.GetEnvironmentVariable("FACEBOOK_APP_ID") + @"&client_secret=" + Environment.GetEnvironmentVariable("FACEBOOK_APP_SECRET") + @"&fb_exchange_token=" + auth.accessToken).Result; response.EnsureSuccessStatusCode(); // Throw in not success stringResponse = JsonConvert.DeserializeObject <dynamic>(response.Content.ReadAsStringAsync().Result); } User currentUser = db.Users.Find(userId); int? currAuth = db.FacebookAuthSet.Where(x => x.facebookUserId == auth.facebookUserId).Select(x => x.Id).SingleOrDefault(); auth.accessToken = stringResponse.access_token.ToString(); if (currAuth != 0) { auth.Id = (int)currAuth; db.FacebookAuthSet.Update(auth); } else { db.FacebookAuthSet.Add(auth); } auth.User = currentUser; db.SaveChanges(); } } return(Content("success")); }
public IActionResult UploadDocuments(IFormFile file) { Stream fileBuffer = file.OpenReadStream(); var db = new ClassroomContext(); Document doc = new Document(); doc.KeyName = WebUtility.UrlEncode(file.FileName); doc.FileName = file.FileName; if (file.ContentType.Contains("image")) { Stream fileBuffer2 = new MemoryStream(); fileBuffer.CopyTo(fileBuffer2); fileBuffer.Seek(0, SeekOrigin.Begin); IReadOnlyList <EntityAnnotation> resultText = GoogleMLConnector.ReadImageText(fileBuffer); fileBuffer = fileBuffer2; fileBuffer.Seek(0, SeekOrigin.Begin); IReadOnlyList <EntityAnnotation> resultLabels = GoogleMLConnector.LabelImage(fileBuffer); string lang = ""; string content = ""; foreach (var thing in resultText) { if (thing.Locale != null) { lang = thing.Locale; } content += thing.Description; } doc.Content = content; content = ""; foreach (var thing in resultLabels) { content += thing.Description + ", "; } doc.GoogleTags = content; fileBuffer = fileBuffer2; } else if (textValues.Contains <string>(file.ContentType)) { StreamReader reader = new StreamReader(fileBuffer); doc.Content = reader.ReadToEnd(); } else if (file.ContentType.ToLower().Contains("pdf")) { string cont = ""; PdfFixedDocument pdfdoc = new PdfFixedDocument(fileBuffer); List <PdfVisualImageCollection> img = new List <PdfVisualImageCollection>(); foreach (PdfPage page in pdfdoc.Pages) { PdfContentExtractor ce = new PdfContentExtractor(page); cont += ce.ExtractText(); //img.Add(ce.ExtractImages(true)); } doc.Content = cont; } else { StreamReader reader = new StreamReader(fileBuffer); doc.Content = reader.ReadToEnd(); } var uploadResult = S3Connector.UploadObject(file.FileName, fileBuffer, WebUtility.UrlEncode(file.FileName)); if (db.Documents.Where(x => x.KeyName == doc.KeyName).Count() == 0) { db.Documents.Add(doc); db.SaveChanges(); ElasticManager em = new ElasticManager(); em.addDocument(doc); } return(Content(doc.Id.ToString())); }