public User GetUserByUsernme(string username)
{
User result = null;
SQLiteConnection con;
SQLiteDataReader reader = _sqliteHelper.ExecuteCommand("Select * FROM User where Username='******'", out con);
while (reader.Read())
{
result = new User { ID = Convert.ToInt32(reader["ID"]), Username = reader["Username"].ToString(), Email = reader["Email"].ToString(), Password = reader["Password"].ToString() };
}
con.Close();
return result;
}
public User GetUserByEmail(string email)
{
User result = null;
SQLiteConnection con;
SQLiteDataReader reader = _sqliteHelper.ExecuteCommand("Select * FROM User where Email='" + email + "'", out con);
while (reader.Read())
{
result = new User { Username = reader["Username"].ToString(), Email = reader["Email"].ToString(), Password = reader["Password"].ToString() };
}
con.Close();
return result;
}
public void CreteUser(User user)
{
if (string.IsNullOrWhiteSpace(user.Username))
throw new MembershipException("Username cannot be empty.");
else if (user.Username.Length < 4 || user.Username.Length > 8)
throw new MembershipException("Username must be 4 to 8 charcters long.");
else if (!_inputValidtor.IsAlphaNumeric(user.Username))
throw new MembershipException("Username must contain only alpha-numeric characters.");
else if (string.IsNullOrWhiteSpace(user.Email))
throw new MembershipException("Email cannot be empty.");
else if (!_inputValidtor.IsEmail(user.Email))
throw new MembershipException("Invalid email.");
else if (string.IsNullOrWhiteSpace(user.Password))
throw new MembershipException("Password cannot be empty.");
else if (user.Username.Length < 4 || user.Username.Length > 6)
throw new MembershipException("Username must be 4 to 6 charcters long.");
else if (_userRepository.GetUserByEmail(user.Email) != null)
throw new MembershipException("Email address already exist.");
else if (_userRepository.GetUserByUsernme(user.Username) != null)
throw new MembershipException("Username already exist.");
_userRepository.Insert(user);
}
public void CreteUser(RegisterViewModel viewmodel)
{
User entity = new User { Email = viewmodel.Email, Username = viewmodel.UserName, Password = viewmodel.Password };
_membershipService.CreteUser(entity);
}
public void Update(User entity)
{
throw new NotImplementedException();
}
public void Insert(User entity)
{
_sqliteHelper.ExecuteNonQuery("INSERT INTO User (Username,Email,Password) Values ('" + entity.Username + "','" + entity.Email + "','" + entity.Password + "')");
}
