public static int GetUserIdFromEmail(string email)
{
HourMarkingDatabaseEntities db = new HourMarkingDatabaseEntities();
User user = db.Users.Where(u => u.email == email).SingleOrDefault();
return(user.id);
}
public static string GetUserInfoFromEmail(string email)
{
HourMarkingDatabaseEntities db = new HourMarkingDatabaseEntities();
User user = db.Users.Where(u => u.email == email).SingleOrDefault();
string info = "First name: " + user.firstName + ", last name: " + user.lastName;
return(info);
}
public ActionResult About()
{
String userName = User.Identity.GetUserName();
HourMarkingDatabaseEntities db = new HourMarkingDatabaseEntities();
string query = @"SELECT DISTINCT [User].id, [User].firstName, [User].lastName,
[User].email, [User].phoneNumber, [User].isAdmin FROM [User]
WHERE [User].email = @userNamePlaceHolder";
IEnumerable <User> data = db.Database.SqlQuery <User>(query, new SqlParameter("@userNamePlaceHolder", userName));
string query1 = @"SELECT DISTINCT [WorkTarget].name, [WorkTarget].id, [WorkTarget].description FROM [WorkTarget]
JOIN [UserWorkTarget] ON([WorkTarget].id = [UserWorkTarget].workTargetId)
JOIN [User] ON([UserWorkTarget].userId = [User].id)
WHERE [User].email = @userNamePlaceHolder";
IEnumerable <WorkTarget> data1 = db.Database.SqlQuery <WorkTarget>(query1, new SqlParameter("@userNamePlaceHolder", userName));
List <User> listOfUsers = data.ToList();
List <WorkTarget> listOfWorkTargets = data1.ToList();
User user = null;
WorkTarget workTarget = null;
if (listOfUsers.Count > 0)
{
user = listOfUsers[0];
workTarget = listOfWorkTargets[0];
}
if (user != null)
{
ViewBag.user = listOfUsers;
ViewBag.workTarget = listOfWorkTargets;
return(View());
}
else
{
return(View("Index"));
}
}
