public static User GetCurrentUser()
{
var user = new User();
using (var sql = new SampleTravelersContext())
{
var name = System.Security.Principal.WindowsIdentity.GetCurrent().Name;
user = sql.Users.Where(x => x.WindowsName == name).First();
}
return(user);
}
public Response GetLatestResponse(Question q)
{
using (var sql = new SampleTravelersContext())
{
var p = this.Questions.Where(x => x.Id == q.Id);
if (p.Any())
{
if (p.First().GetMilestoneResponseForQuestion(this).Responses.Any())
{
p.First().GetMilestoneResponseForQuestion(this).Responses.First();
}
else
{
return(null);
}
}
else
{
return(null);
}
}
return(null);
}