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);
}
