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