public static IEnumerable <Request> GetRequests(Guid id) { using (var context = new WordsCountDBContext()) { return(context.Requests.Where(r => r.OwnerGuid == id).ToList()); } }
public static User GetUser(String login) { using (var context = new WordsCountDBContext()) { IEnumerable <User> us = context.Users.Where(user => user.Login == login); if (us.Count() > 0) { return(us.First()); } else { return(null); } } }
public static bool AddUser(User user) { using (var context = new WordsCountDBContext()) { context.Users.Add(user); try { context.SaveChanges(); return(true); } catch (Exception) { return(false); } } }
public static bool AddRequest(Request request) { using (var context = new WordsCountDBContext()) { context.Requests.Add(request); try { context.SaveChanges(); return(true); } catch (Exception) { return(false); } } }
public static User UpdateUserDate(Guid userGuid) { using (var context = new WordsCountDBContext()) { IEnumerable <User> us = context.Users.Where(user => user.Guid == userGuid); if (us.Count() > 0) { User up = us.First(); up.DateOfEnter = DateTime.Now.ToLocalTime(); context.SaveChanges(); return(up); } else { return(null); } } }