public ActionResult GetAllMessages(int id)
{
try
{
// Searching all visitors/messages with portfolio ID
var questbookContent = (from q in _context.QuestbookMessages
where q.UserId == id
join v in _context.Visitors
on q.VisitorId equals v.VisitorId
select new
{
q.MessageId,
v.Firstname,
v.Lastname,
v.Company,
q.VisitationTimestamp,
q.Message
}).ToList();
return(Ok(questbookContent));
}
catch (Exception ex)
{
return(BadRequest("Problem detected while searching messages for questbook. Error message: " + ex.Message));
}
finally
{
_context.Dispose();
}
}
public ActionResult GetProjects(int id)
{
try
{
var projects = (from p in _context.Projects
where p.SkillId == id
select new
{
p.ProjectId,
p.Name,
p.Link,
p.Description
}).ToList();
return(Ok(projects));
}
catch (Exception ex)
{
return(BadRequest("Problem detected while getting skills for user " + id + ". Error message: " + ex.Message));
}
finally
{
_context.Dispose();
}
}
public ActionResult GetContent(int id)
{
try
{
var content = (from pc in _context.PortfolioContent
where pc.UserId == id
join u in _context.Users
on pc.UserId equals u.UserId
select new
{
pc.Firstname,
pc.Lastname,
pc.Birthdate,
pc.City,
pc.Country,
pc.Phonenumber,
pc.Punchline,
pc.BasicKnowledge,
pc.Education,
pc.WorkHistory,
pc.LanguageSkills,
u.ThemeId
}).ToList();
return(Ok(content));
}
catch (Exception ex)
{
return(BadRequest("Problem detected while getting portfolio content for user " + id + ". Error message: " + ex.Message));
}
finally
{
_context.Dispose();
}
}
public ActionResult GetImages(int id)
{
try
{
var images = (from i in _context.ImageUrls
where i.UserId == id
select new
{
i.TypeId,
i.Url
}).ToList();
return(Ok(images));
}
catch (Exception ex)
{
return(BadRequest("Problem detected while getting images for user " + id + ". Error message: " + ex.Message));
}
finally
{
_context.Dispose();
}
}
public ActionResult GetLinks(int id)
{
try
{
var allLinks = (from sml in _context.SocialMediaLinks
where sml.UserId == id
select new
{
sml.LinkId,
sml.ServiceId,
sml.Link
}).ToList();
return(Ok(allLinks));
}
catch (Exception ex)
{
return(BadRequest("Problem detected while getting links for portfolio " + id + ". Error message: " + ex.Message));
}
finally
{
_context.Dispose();
}
}
public ActionResult GetSkills(int id)
{
try
{
var skills = (from s in _context.Skills
where s.UserId == id
select new
{
s.SkillId,
s.Skill,
s.SkillLevel
}).ToList();
return(Ok(skills));
}
catch (Exception ex)
{
return(BadRequest("Problem detected while getting skills for user " + id + ". Error message: " + ex.Message));
}
finally
{
_context.Dispose();
}
}
public ActionResult GetDocumentation()
{
try
{
// Searching doc
var doc = (from d in _context.Documentation
select d).ToList();
return(Ok(doc));
}
catch (Exception ex)
{
return(BadRequest("Problem detected while searching messages for questbook. Error message: " + ex.Message));
}
finally
{
_context.Dispose();
}
}
public ActionResult CheckSignIn([FromBody] Users loginCredentials)
{
try
{
var user = (from u in _context.Users
where u.Username == loginCredentials.Username
select u).FirstOrDefault();
if (user != null)
{
if (user.Password == loginCredentials.Password)
{
return(Ok("Login succesfull!"));
}
else
{
return(NotFound("Inccorrect password!"));
}
}
else
{
return(NotFound("Inccorrect username!"));
}
}
catch (Exception ex)
{
return(BadRequest("Problem detected while checking the login credentials. Error message: " + ex.Message));
}
finally
{
_context.Dispose();
}
}