public static LabUser GetUserByLogin(string login)
{
using (var context = new DirectoryBrowserContext())
{
return(context.Users.Include(u => u.Query).FirstOrDefault(u => u.Login == login));
}
}
public static bool UserExists(string login)
{
using (var context = new DirectoryBrowserContext())
{
return(context.Users.Any(u => u.Login == login));
}
}
public static void SaveQuery(Query query)
{
using (var context = new DirectoryBrowserContext())
{
context.Entry(query).State = EntityState.Modified;
context.SaveChanges();
}
}
public static void AddUser(LabUser user)
{
using (var context = new DirectoryBrowserContext())
{
context.Users.Add(user);
context.SaveChanges();
}
}
public static void AddQuery(Query query)
{
using (var context = new DirectoryBrowserContext())
{
query.DeleteDatabaseValues();
context.Queries.Add(query);
context.SaveChanges();
}
}
public static User GetUserByLogin(string login)
{
using (var context = new DirectoryBrowserContext()) {
var queryResult = from u in context.Users
where u.Login == login
select u;
return(queryResult.FirstOrDefault());
}
}
public static IEnumerable <Query> GetQueriesForUser(LabUser user)
{
using (var context = new DirectoryBrowserContext())
{
var queryResult = from q in context.Queries
where q.User.UserId == user.UserId
select q;
return(queryResult.AsEnumerable().ToList());
}
}
public static void UpdateLoggedInDateToCurrent(LabUser user)
{
using (var context = new DirectoryBrowserContext())
{
var queryResult = from u in context.Users
where u.UserId == user.UserId
select u;
var foundUser = queryResult.First();
foundUser.LastLoginDate = DateTime.Now;
context.SaveChanges();
}
}
public static void WriteQueryForUser(LabUser user, string dirPath)
{
using (var context = new DirectoryBrowserContext())
{
var query = new Query
{
UserId = user.UserId,
Path = dirPath
};
context.Queries.Add(query);
context.SaveChanges();
}
}
