public string removeUserFromBoard([FromBody] JObject value) { var username = Request.Headers["username"].ToString(); var password = Request.Headers["pw"].ToString(); if (!User_Authentification.validateUserKey(username, password)) { return(null); } var jsonBoardUser = JsonConvert.DeserializeObject <BoardUser>(value.ToString()); using (var db = new APIAppDbContext()) { var existingUser = from users in db.User where users.EMail == jsonBoardUser.UserEMail select users; if (!existingUser.Any()) { return("User does not exists"); } var existingBoardUser = (from search in db.BoardUser where search.UserEMail == jsonBoardUser.UserEMail && search.BoardId == jsonBoardUser.BoardId select search).First(); if (existingBoardUser == null) { return("User has no access to Board"); } db.BoardUser.Remove(existingBoardUser); db.SaveChanges(); } return(JsonConvert.SerializeObject(queryBoardUsersByBoardId(jsonBoardUser.BoardId))); }
public string GetAllUsersFromBoard() { var username = Request.Headers["username"].ToString(); var password = Request.Headers["pw"].ToString(); var boardId = Int64.Parse(Request.Headers["boardId"].ToString()); if (!User_Authentification.validateUserKey(username, password)) { return(null); } return(JsonConvert.SerializeObject(queryBoardUsersByBoardId(boardId))); }
public string GetAllBoardsForSingleUser() { var username = Request.Headers["username"].ToString(); var password = Request.Headers["pw"].ToString(); if (!User_Authentification.validateUserKey(username, password)) { return(null); } var boardList = queryBoardsForUser(username); return(JsonConvert.SerializeObject(boardList)); }
public string deleteNote([FromBody] JObject value) { var username = Request.Headers["username"].ToString(); var password = Request.Headers["pw"].ToString(); if (!User_Authentification.validateUserKey(username, password)) { return(null); } var jsonNote = JsonConvert.DeserializeObject <Note>(value.ToString()); using (var db = new APIAppDbContext()) { db.Note.Remove(jsonNote); db.SaveChanges(); } return(JsonConvert.SerializeObject(getAllNotesByBoardID(jsonNote.BoardId))); }
public string UserLogin() { var username = Request.Headers["username"].ToString(); var password = Request.Headers["pw"].ToString(); var resultUser = new User(); using (var db = new APIAppDbContext()) { resultUser = db.User.FirstOrDefault(u => u.EMail == username); } if (resultUser == null) { return("User not registered!"); } //TODO Hash/Salt password if (resultUser.Password.Equals(password)) { return(User_Authentification.generateUserKey(username)); } return("Wrong password!"); }
public string CreateBoard([FromBody] JObject value) { var username = Request.Headers["username"].ToString(); var password = Request.Headers["pw"].ToString(); if (!User_Authentification.validateUserKey(username, password)) { return(null); } var jsonBoard = JsonConvert.DeserializeObject <Board>(value.ToString()); using (var db = new APIAppDbContext()) { db.Board.Add(jsonBoard); db.BoardUser.Add(new BoardUser { BoardId = jsonBoard.Id, UserEMail = username }); db.SaveChanges(); return(JsonConvert.SerializeObject(queryBoardsForUser(username))); } }