public int Create(UserInformation user)
{
if (CheckIfExists(user.Username))
{
throw new InvalidOperationException("Username already exists. Registration failed.");
}
var userDto = new Userstable();
PropertyCopier <UserInformation, Userstable> .Copy(user, userDto);
var script = GetInsertScript(userDto);
return(ExecDbScripts(script));
}
public bool GetUser(string UName, string Pws)
{
StringBuilder sb = new StringBuilder("SELECT * FROM t1 WHERE Name='");
sb.Append(UName);
sb.Append("' AND Password='******'");
using (SqlDataReader dr = DBHelper.ExecuteReader(sb.ToString()))
{
while (dr.Read())
{
Userstable ut = new Userstable();
ut.UName = dr["Name"].ToString();
if (ut.UName.Equals(UName))
{
return(true);
}
}
}
return(false);
}
private Userstable GetUserInfo(string username)
{
var user = new Userstable();
using (var connection = new MySqlConnection(_connectionString))
{
connection.Open();
var sql = @"SELECT * FROM UsersTable WHERE Username=@username";
using (var command = new MySqlCommand(sql, connection))
{
command.Parameters.AddWithValue("@username", username);
var reader = command.ExecuteReader();
while (reader.Read())
{
user = CreateInstance <Userstable>(reader);
}
}
connection.Close();
}
return(user);
}
