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