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