/// <summary>
/// Get List of UI Functionalities
/// </summary>
/// <returns></returns>
static public GlobalVars.ResultUIFunctionalities GetUIFunctionalities()
{
List <GlobalVars.UIFunctionality> uiFunctionalities = new List <GlobalVars.UIFunctionality>();
GlobalVars.ResultUIFunctionalities resultUIFunctionalities = new GlobalVars.ResultUIFunctionalities()
{
ReturnCode = 0,
Message = "",
ReturnValue = uiFunctionalities,
RecordsCount = 0,
HttpStatusCode = ""
};
try
{
logger.Trace("Entering into GetUIFunctionalities Method ...");
using (ScanningDBContext DB = new ScanningDBContext())
{
var results = DB.Sssfunctionality;
resultUIFunctionalities.RecordsCount = results.Count();
if (results.Count() >= 1)
{
foreach (var x in results)
{
GlobalVars.UIFunctionality uiFunctionality = new GlobalVars.UIFunctionality()
{
FunctionalityID = x.FunctionalityId,
Description = (x.Functionality ?? "").Trim(),
};
uiFunctionalities.Add(uiFunctionality);
}
}
}
resultUIFunctionalities.ReturnValue = uiFunctionalities;
resultUIFunctionalities.Message = "GetUIFunctionalities transaction completed successfully. Number of records found: " + resultUIFunctionalities.RecordsCount;
logger.Debug(resultUIFunctionalities.Message);
}
catch (Exception e)
{
logger.Error("Error:" + e.Message + "\n" + "Exception: " + e.InnerException);
resultUIFunctionalities.ReturnCode = -2;
resultUIFunctionalities.Message = e.Message;
var baseException = e.GetBaseException();
resultUIFunctionalities.Exception = baseException.ToString();
}
logger.Trace("Leaving GetUIFunctionalities Method ...");
return(resultUIFunctionalities);
}
/// <summary>
/// Get User Information by ID
/// </summary>
/// <returns></returns>
static public GlobalVars.ResultUsers GetUserByID(int userID)
{
List <GlobalVars.User> users = new List <GlobalVars.User>();
GlobalVars.ResultUsers resultUsers = new GlobalVars.ResultUsers()
{
ReturnCode = 0,
Message = "",
ReturnValue = users,
RecordsCount = 0,
HttpStatusCode = ""
};
try
{
logger.Trace("Entering into GetUserByID Method ...");
using (ScanningDBContext DB = new ScanningDBContext())
{
var results = DB.Users.Where(x => x.UserId == userID);
resultUsers.RecordsCount = results.Count();
if (results.Count() >= 1)
{
foreach (var x in results)
{
GlobalVars.User user = new GlobalVars.User()
{
UserID = x.UserId,
UserName = (x.UserName ?? "").Trim(),
Title = x.Title,
Email = x.Email,
ActiveFlag = Convert.ToBoolean(x.ActiveFlag)
};
var result_aux = from u in DB.UserUifunctionality
join f in DB.Sssfunctionality on u.FunctionalityId equals f.FunctionalityId
where u.UserId == x.UserId
select new { f.FunctionalityId, f.Functionality };
List <GlobalVars.UIFunctionality> funtionalities = new List <GlobalVars.UIFunctionality>();
if (result_aux.Count() >= 1)
{
foreach (var y in result_aux)
{
GlobalVars.UIFunctionality functionality = new GlobalVars.UIFunctionality();
functionality.FunctionalityID = y.FunctionalityId;
functionality.Description = y.Functionality;
funtionalities.Add(functionality);
}
}
user.UIFunctionality = funtionalities;
users.Add(user);
}
}
}
resultUsers.ReturnValue = users;
resultUsers.Message = "GetUserByID transaction completed successfully. Number of records found: " + resultUsers.RecordsCount;
logger.Debug(resultUsers.Message);
}
catch (Exception e)
{
logger.Error("Error:" + e.Message + "\n" + "Exception: " + e.InnerException);
resultUsers.ReturnCode = -2;
resultUsers.Message = e.Message;
var baseException = e.GetBaseException();
resultUsers.Exception = baseException.ToString();
}
logger.Trace("Leaving GetUserByID Method ...");
return(resultUsers);
}
