public ApplicationController()
{
//var user = System.Web.HttpContext.Current.User;
//if (user != null)
//{
// using (var db = new FISDataMartEntities())
//{
// var userp = db.udf_Catbert3_vUsers(ApplicationsAbbr).FirstOrDefault(u => u.LoginID.ToLower() == user.Identity.Name.ToLower());
// if (userp != null)
// {
// var userRoles = db.udf_Catbert3_UserRoles(ApplicationsAbbr).Where(ur => ur.UserID == userp.UserID);
// var role = Roles.FirstOrDefault(r => r.Role.Equals("User"));
// bool isInRole = userRoles.Any(u => u.RoleID == role.RoleID);
// Console.WriteLine(userp.FirstName);
// }
//}
//}
//using (var context = new FISDataMartEntities())
//{
// var users =
// from u in
// context.udf_Catbert3_vUsers(ApplicationsAbbr)
// select new
// {
// u.LoginID,
// u.Email,
// u.FirstName,
// u.LastName
// };
// foreach (var usr in users)
// {
// Console.WriteLine(usr.LoginID);
// Console.WriteLine(usr.Email);
// Console.WriteLine(usr.FirstName);
// Console.WriteLine(usr.LastName);
// }
//} // end using (var context = new FISDataMartEntities())
}