/// <summary> /// check with user name and password if user exists /// </summary> /// <param name="user"></param> /// <returns></returns> public bool ExistsUser(User user) { var matchedUser = context.Users.Where(u => u.username == user.username && u.password == user.password) .SingleOrDefault(); if (matchedUser == null) { return false; } return true; }
/// <summary> /// Deprecated Method for adding a new object to the Users EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToUsers(User user) { base.AddObject("Users", user); }
/// <summary> /// Create a new User object. /// </summary> /// <param name="username">Initial value of the username property.</param> /// <param name="password">Initial value of the password property.</param> /// <param name="lastLogin">Initial value of the lastLogin property.</param> public static User CreateUser(global::System.String username, global::System.String password, global::System.DateTime lastLogin) { User user = new User(); user.username = username; user.password = password; user.lastLogin = lastLogin; return user; }
/// <summary> /// update last login time when user logs in /// </summary> /// <param name="user"></param> public void UpdateLastLogin(User user) { var matchedUser = context.Users.First(u => u.username == user.username && u.password == user.password); matchedUser.lastLogin = DateTime.Now; context.SaveChanges(); }
/// <summary> /// insert user to database /// </summary> /// <param name="user"></param> public void InsertUser(User user) { context.Users.AddObject(user); context.SaveChanges(); }