/// <summary>
/// Function to update users in the database from Auth0
/// </summary>
/// <returns></returns>
public bool UpdateUsersFromAuth0()
{
try
{
using (var db = new TicketingSystemDBContext())
{
var users = Auth0APIClient.GetAllUsers();
foreach (var user in users)
{
Users dbuser = db.Users.Where(u => u.Auth0Uid == user.user_id).FirstOrDefault();
if (dbuser != null)
{
dbuser.Email = user.email;
dbuser.FullName = user.name;
var roles = Auth0APIClient.GetUserRole(dbuser.Auth0Uid);
dbuser.ShiftType = roles.ElementAt(0).name;
db.Users.Update(dbuser);
db.SaveChanges();
}
}
}
return(true);
}
catch (Exception e)
{
throw new HttpResponseException(Utility.CreateResponseMessage(e));
}
}
/// <summary>
/// Updates the user in the database after creation in Auth0
/// </summary>
/// <param name="Auth0ID"></param>
/// <returns>Boolean indicating success</returns>
public static bool UpdateDBUser(string Auth0ID)
{
try
{
if (!ValidateToken())
{
InitAPIToken();
}
using (var db = new TicketingSystemDBContext())
{
//get the Auth0Id from Auth0
UserData ud = GetUserData(Auth0ID);
var u = db.Users.Where(uid => uid.Email == ud.email).FirstOrDefault();
u.Auth0Uid = ud.user_id;
db.SaveChanges();
}
return(true);
}
catch (Exception e)
{
throw new HttpResponseException(Utility.CreateResponseMessage(e));
}
}
/// <summary>
/// Function to log changes in entries to the database
/// </summary>
/// <param name="action"></param>
/// <param name="details"></param>
/// <param name="entryID"></param>
/// <param name="changedByUserID"></param>
/// <returns></returns>
public bool LogChange(string action, string details, int entryID, int changedByUserID)
{
try
{
using (var context = new TicketingSystemDBContext())
{
TicketDataLog tdLog = new TicketDataLog()
{
ChangedByUserId = changedByUserID,
ChangeTime = DateTime.Now,
DataAction = action,
Details = details,
EntryId = entryID
};
context.TicketDataLog.Add(tdLog);
context.SaveChanges();
}
}
catch (Exception e)
{
throw new HttpResponseException(Utility.CreateResponseMessage(e));
}
return(true);
}
public static void Cleanup()
{
using (var db = new TicketingSystemDBContext())
{
Users user = db.Users.Where(u => u.FullName == "Test User").FirstOrDefault();
var data = db.TicketData.Where(t => t.EntryAuthorId == user.UserId);
db.TicketData.RemoveRange(data);
db.SaveChanges();
}
}
/// <summary>
/// Posts the new ticket entry to the database
/// </summary>
/// <param name="td"></param>
/// <param name="loggedInUser"></param>
/// <returns></returns>
public bool PostEntry(TicketData td, UserData loggedInUser)
{
try
{
using (var context = new TicketingSystemDBContext())
{
IEnumerable<JobType> jobs = context.JobType;
int jtypeID = 1;
jtypeID = context.JobType.Where(j => j.JobName == td.JobType.JobName).FirstOrDefault().JobTypeId;
int authorID = context.Users.Where(a => a.Auth0Uid == loggedInUser.user_id).FirstOrDefault().UserId;
var worker = context.Users.Where(w => w.FullName == td.TicketWorker.FullName).FirstOrDefault();
int workerID;
if (worker != null)
{
workerID = worker.UserId;
td.TicketWorkerId = workerID;
}
else
{
throw new Exception("Error, Employee with name: " + worker.FullName + " not found in System");
}
td.JobTypeId = jtypeID;
td.TicketClosed = false;
td.EntryAuthorId = authorID;
td.WorkerName = td.TicketWorker.FullName;
td.StartDate = DateTime.Today;
//very important null assignment
td.JobType = null;
td.TicketWorker = null;
td.EntryAuthor = null;
context.TicketData.Add(td);
context.SaveChanges();
int entryID = td.EntryId;
TicketDataLogger tdl = new TicketDataLogger();
tdl.LogChange("new entry", "created new entry", entryID, authorID);
}
}
catch (Exception e)
{
throw new HttpResponseException(Utility.CreateResponseMessage(e));
}
return true;
}
/// <summary>
/// Posts the edited TicketData object to the database and logs the user who triggered it
/// </summary>
/// <param name="td">The ticket data instance to update</param>
/// <param name="loggedInUser">The currently logged user</param>
/// <returns></returns>
public bool PostEditor(TicketData td, UserData loggedInUser)
{
try
{
using (var context = new TicketingSystemDBContext())
{
int jtypeID;
jtypeID = context.JobType.Where(j => j.JobName == td.JobType.JobName).FirstOrDefault().JobTypeId;
int authorID = -1;
int workerID;
var author = context.Users.Where(a => a.Auth0Uid == loggedInUser.user_id).FirstOrDefault();
var worker = context.Users.Where(w => w.FullName == td.TicketWorker.FullName).FirstOrDefault();
if (author != null)
{
authorID = author.UserId;
td.EntryAuthorId = authorID;
}
if (worker != null)
{
workerID = worker.UserId;
td.TicketWorkerId = workerID;
}
td.JobTypeId = jtypeID;
td.WorkerName = td.TicketWorker.FullName;
//very important null assignment
td.JobType = null;
td.TicketWorker = null;
td.EntryAuthor = null;
context.TicketData.Update(td);
context.SaveChanges();
TicketDataLogger tdl = new TicketDataLogger();
tdl.LogChange("new edits", "edited entry", td.EntryId, authorID);
}
}
catch (Exception e)
{
throw new HttpResponseException(Utility.CreateResponseMessage(e));
}
return(true);
}
/// <summary>
/// Function to delete a user from the Database
/// </summary>
/// <param name="UserId"></param>
/// <returns></returns>
public bool DeleteUser(int UserId)
{
try
{
using (var db = new TicketingSystemDBContext())
{
Users user = db.Users.Find(UserId);
db.Users.Remove(user);
db.SaveChanges();
return(true);
}
}
catch (Exception e)
{
throw new HttpResponseException(Utility.CreateResponseMessage(e));
}
}
/// <summary>
/// Closes the specified ticket data entry
/// </summary>
/// <param name="td"></param>
/// <returns></returns>
public bool CloseTicket(TicketData td)
{
try
{
using (var context = new TicketingSystemDBContext())
{
context.TicketData.Find(td.EntryId).TicketClosed = true;
context.TicketData.Find(td.EntryId).EndTime = td.EndTime;
context.TicketData.Find(td.EntryId).EndDate = td.EndDate;
context.SaveChanges();
}
}
catch (Exception e)
{
throw new HttpResponseException(Utility.CreateResponseMessage(e));
}
return true;
}
//Not supported due to management API restrictions
//public bool UpdateUser(Users user)
//{
// try
// {
// using (var db = new TicketingSystemDBContext())
// {
// Users oldUser = db.Users.Find(user.UserId);
// string oldShiftType = oldUser.ShiftType;
// oldUser.Email = user.Email;
// oldUser.FullName = user.FullName;
// oldUser.ShiftType = user.ShiftType;
// db.Users.Update(oldUser);
// db.SaveChanges();
// // Auth0APIClient.UpdateUser(oldUser);
// Auth0APIClient.UpdateRole(oldUser.Auth0Uid, oldShiftType, user.ShiftType);
// }
// }
// catch (Exception e)
// {
// throw new HttpResponseException(Utility.CreateResponseMessage(e));
// }
// return true;
//}
/// <summary>
/// Function to delete a user from DB and Auth0
/// </summary>
/// <param name="UserId"></param>
/// <returns></returns>
public bool ToggleActivation(int UserId)
{
try
{
using (var db = new TicketingSystemDBContext())
{
Users user = db.Users.Find(UserId);
string auth0ID = user.Auth0Uid;
user.IsActive = !user.IsActive;
db.Users.Update(user);
db.SaveChanges();
return(true);
}
}
catch (Exception e)
{
throw new HttpResponseException(Utility.CreateResponseMessage(e));
}
}
/// <summary>
/// Helper function to create a User and add it to the database
/// </summary>
/// <param name="newUser"></param>
/// <returns></returns>
private string CreateAndAddUser(Users newUser)
{
using (var db = new TicketingSystemDBContext())
{
string tempPass = Guid.NewGuid().ToString().Substring(0, 12);
string encrypted = Utility.Encrypt(tempPass);
newUser.PassWrd = encrypted;
newUser.IsActive = true;
if (newUser.ShiftType != "Warehouse")
{
if (db.Users.Where(us => us.Email == newUser.Email).Any())
{
return("Email Exists");
}
}
db.Users.Add(newUser);
db.SaveChanges();
return(tempPass);
}
}
/// <summary>
/// Deletes the specified ticket data entry
/// </summary>
/// <param name="entryId">The unique id of the ticket to be deleted</param>
/// <param name="loggedInUser"></param>
/// <returns></returns>
public bool DeleteEntry(string entryId, UserData loggedInUser)
{
try
{
using (var db = new TicketingSystemDBContext())
{
TicketData td = db.TicketData.Find(int.Parse(entryId));
db.TicketData.Remove(td);
db.SaveChanges();
var author = db.Users.Where(auth => auth.Auth0Uid == loggedInUser.user_id).FirstOrDefault();
TicketDataLogger tdl = new TicketDataLogger();
tdl.LogChange("delete", "deleted entry with ID: " + td.EntryId, td.EntryId, author.UserId);
}
}
catch (Exception e)
{
throw new HttpResponseException(Utility.CreateResponseMessage(e));
}
return(true);
}