/* Takes the input of userId and searches in the database table [users] This function will retrieve the userName from the database table [users] */
public static string GetUserName(string userId, string agentLocationCode)
{
using (tsc_tools db = new tsc_tools())
{
user user = new user();
var userRecord = db.users.Where(u => u.userId == userId.ToLower()).SingleOrDefault();
if (userRecord != null)
{
if (agentLocationCode != "" && (userRecord.locationCode == "" || userRecord.locationCode == null))
{
userRecord.locationCode = agentLocationCode.ToUpper();
db.Entry(userRecord).CurrentValues.SetValues(userRecord);
db.SaveChanges();
locationLookup locationLookup = new locationLookup();
var locationLookupRecord = db.locationLookups.Where(l => l.locationCode == agentLocationCode.ToUpper()).SingleOrDefault();
if (locationLookupRecord == null)
{
locationLookup.locationCode = agentLocationCode.ToUpper();
string locationName = "Building: " + agentLocationCode;
locationLookup.locationName = locationName;
db.locationLookups.Add(locationLookup);
db.SaveChanges();
var context = GlobalHost.ConnectionManager.GetHubContext <MyHub>();
context.Clients.Group(groupNames.Monitor).addLocationName(agentLocationCode, locationName);
}
}
return(userRecord.userName.ToUpper());
}
else
{
return(null);
}
}
}
/* Retrieves Location Codes and Location Names */
public static string GetLocationCodes()
{
using (tsc_tools db = new tsc_tools())
{
locationLookup locationCode = new locationLookup();
var locationLookupRecords =
from l in db.locationLookups
orderby l.locationName
select l;
return(JsonConvert.SerializeObject(locationLookupRecords));
}
}
