public string AddUser(CSC425Context db) { var user = db.Users.Where(u => u.Username.ToLower().Equals(Username.ToLower())).FirstOrDefault(); if (user == null) { return(JsonConvert.SerializeObject(new ReturnCode(404, "Not Found", $"User: {Username} doesn't exist."))); } var nv = db.NoteViewers.Where(n => n.NoteId.Equals(this.NoteID) && n.UserId.Equals(user.UserId)).FirstOrDefault(); if (nv != null) { return(JsonConvert.SerializeObject(new ReturnCode(403, "Forbidden", $"User: {Username} is already allowed to view this note."))); } var noteviewer = new NoteViewers(); noteviewer.NoteId = this.NoteID; noteviewer.UserId = user.UserId; db.NoteViewers.Add(noteviewer); db.SaveChangesAsync(); return(JsonConvert.SerializeObject(new ReturnCode(200, "OK", $"User: {Username} added successfully."))); }
public string AddNote(CSC425Context db) { var noteCreator = db.Users.Where(u => u.Username.ToLower().Equals(Username.ToLower())).FirstOrDefault(); if (NoteDate.Year == 0001) { this.NoteDate = DateTime.Now; } this.UploadDate = DateTime.Now; Notes note = new Notes(); note.UserId = noteCreator.UserId; note.ClassId = this.ClassID; note.Note = this.Note; note.NoteFile = this.NoteFile; note.NoteFileName = this.NoteFileName; note.Extension = this.Extension; note.NoteDate = this.NoteDate; note.UploadDate = this.UploadDate; foreach (string user in Users) { var allowedUser = db.Users.Where(u => u.Username.ToLower() == user.ToLower()).FirstOrDefault(); if (allowedUser != null) { NoteViewers nv = new NoteViewers(); nv.NoteId = note.NotesId; nv.UserId = allowedUser.UserId; note.NoteViewers.Add(nv); } } db.Notes.Add(note); db.SaveChangesAsync(); return(JsonConvert.SerializeObject(new ReturnCode(200, "OK", $"Note added successfully."))); }