public static QueueInfo GetQueue(string link) { using (var context = new eQueueContext()) { return(context.Queues.FirstOrDefault(q => q.Link == link)); } }
public static List <User> GetUsers(int queueId) { using (var context = new eQueueContext()) { return(context.UserAccesses.Where(qo => qo.QueueInfoId == queueId).Select(qo => qo.User).ToList()); } }
/*registrate new user*/ public static User Insert() { using (var context = new eQueueContext()) { using (var transaction = context.Database.BeginTransaction()) { try { User user = new User { PasswordHash = null, LastActivity = DateTime.Now, IsTemporary = true }; user.Login = "******"; TokenManager.Insert(user); context.Users.Add(user); context.SaveChanges(); user.Login += user.Id; context.SaveChanges(); transaction.Commit(); return(user); } catch (Exception e) { transaction.Rollback(); return(null); } } } }
public static QueueInfo GetQueue(int id) { using (var context = new eQueueContext()) { return(context.Queues.Find(id)); } }
public static List <QueueInfo> GetQueues(int userId) { using (var context = new eQueueContext()) { return(context.UserAccesses.Where(qo => qo.UserId == userId).Select(qo => qo.QueueInfo).ToList()); } }
public static User GetUser(int id) { using (var context = new eQueueContext()) { return(context.Users.Find(id)); } }
public static User GetUserByLogin(string login, string passwordHash) { using (var context = new eQueueContext()) { return(context.Users.Where(u => u.Login == login && u.PasswordHash == passwordHash).FirstOrDefault()); } }
public static bool SwapUsers(int userIdA, int userIdB, int queueId) { using (var context = new eQueueContext()) { using (var transaction = context.Database.BeginTransaction()) { try { var orderA = context.QueueOrders .Where(a => a.QueueInfoId == queueId && a.UserId == userIdA) .FirstOrDefault(); var orderB = context.QueueOrders .Where(b => b.QueueInfoId == queueId && b.UserId == userIdB) .FirstOrDefault(); int tempNumber = orderA.Number; orderA.Number = orderB.Number; orderB.Number = tempNumber; context.SaveChanges(); transaction.Commit(); } catch (Exception e) { transaction.Rollback(); return(false); } } } return(true); }
public static DateTime?GetTimer(int id) { using (var context = new eQueueContext()) { var queue = context.Queues.Find(id); return(queue?.Timer); } }
public static string GetLogin(int id) { using (var context = new eQueueContext()) { User user = context.Users.Find(id); return(user?.Login); } }
public static bool?GetStatus(int id) { using (var context = new eQueueContext()) { User user = context.Users.Find(id); return(user?.IsTemporary); } }
public static int GetUserId(string token) { using (var context = new eQueueContext()) { var user = context.Tokens.FirstOrDefault(t => t.Token == token); return(user != null ? user.Id : 0); } }
public static void UpdatePassword(int id, string newPasswordHash) { using (var context = new eQueueContext()) { User user = context.Users.Find(id); user.PasswordHash = newPasswordHash; context.SaveChanges(); } }
public static void UpdateName(int id, string newName) { using (var context = new eQueueContext()) { var queue = context.Queues.Find(id); queue.Name = newName; context.SaveChanges(); } }
public static void UpdateActivity(int id) { using (var context = new eQueueContext()) { User user = context.Users.Find(id); user.LastActivity = DateTime.Now; context.SaveChanges(); } }
public static void UpdateTimer(int id, DateTime newTimer) { using (var context = new eQueueContext()) { var queue = context.Queues.Find(id); queue.Timer = newTimer; context.SaveChanges(); } }
public static void UpdateLogin(int id, string newLogin) { using (var context = new eQueueContext()) { User user = context.Users.Find(id); user.Login = newLogin; context.SaveChanges(); } }
public static UserAccess GetOwner(int queueId) { using (var context = new eQueueContext()) { return(context.UserAccesses .Where(a => a.QueueInfoId == queueId && a.AccessTypeName == AccessType.Owner) .FirstOrDefault()); } }
public static string GetToken(int userId) { using (var context = new eQueueContext()) { var token = context.Tokens .Where(t => t.UserId == userId) .FirstOrDefault(); return(token.Token); } }
public static bool UpdateStatus(int id) { using (var context = new eQueueContext()) { User user = context.Users.Find(id); user.IsTemporary = false; context.SaveChanges(); } return(true); }
public static bool CheckPrivilegedAccess(int userId, int queueId) { using (var context = new eQueueContext()) { var access = context.UserAccesses .Where(a => a.QueueInfoId == queueId && a.UserId == userId) .FirstOrDefault(); return(access?.AccessTypeName == AccessType.Owner ? true : false); } }
public static string GetAccessType(int userId, int queueId) { using (var context = new eQueueContext()) { var access = context.UserAccesses .Where(a => a.QueueInfoId == queueId && a.UserId == userId) .FirstOrDefault(); return(access?.AccessTypeName.ToString()); } }
public static bool CheckAccess(int userId, int queueId) { using (var context = new eQueueContext()) { var access = context.UserAccesses .Where(a => a.QueueInfoId == queueId && a.UserId == userId) .FirstOrDefault(); return(access != null ? true : false); } }
public static void Delete(int userId) { using (var context = new eQueueContext()) { var token = context.Tokens .Where(t => t.UserId == userId) .FirstOrDefault(); context.Tokens.Remove(token); context.SaveChanges(); } }
public static void UpdateAccessType(int userId, int queueId, AccessType type) { using (var context = new eQueueContext()) { var access = context.UserAccesses .Where(a => a.QueueInfoId == queueId && a.UserId == userId) .FirstOrDefault(); access.AccessTypeName = type; context.SaveChanges(); } }
public static string GetName(int id) { using (var context = new eQueueContext()) { var queue = context.Queues.Find(id); if (queue == null) { return(null); } return(queue?.Name); } }
public static void UpdateNickname(int userId, int queueId, string newNickname) { using (var context = new eQueueContext()) { var access = context.UserAccesses .Where(a => a.QueueInfoId == queueId && a.UserId == userId) .FirstOrDefault(); access.Nickname = newNickname; context.SaveChanges(); } }
public static bool UpdateNumber(int userId, int queueId, int newNumber) { using (var context = new eQueueContext()) { var order = context.QueueOrders .Where(qo => qo.QueueInfoId == queueId && qo.UserId == userId) .FirstOrDefault(); order.Number = newNumber; context.SaveChanges(); } return(true); }
public static bool Delete(int id) { using (var context = new eQueueContext()) { User user = context.Users.Find(id); if (user == null) { return(false); } context.Users.Remove(user); context.SaveChanges(); } return(true); }
public static bool Delete(int id) { using (var context = new eQueueContext()) { QueueInfo queue = context.Queues.Find(id); if (queue == null) { return(false); } context.Queues.Remove(queue); context.SaveChanges(); } return(true); }