public splash()
{
_user = new User();
InitializeComponent();
this.DataContext = _user;
Model m = new Model(CONFIG.DB_NAME);
m.CreateDatabase(CONFIG.DB_NAME);
txt_username.Focus();
}
/// <summary>
/// Search user record
/// </summary>
/// <param name="_username">the username of the user</param>
/// <returns>Null if not found, User object if found.</returns>
public User search(string _username)
{
User user = new User();
DataTable result = this.selectQuery("SELECT * from '" + this.table + "' where username='******' and status='active' LIMIT 1");
if (result.Rows.Count > 0)
{
user.firstname = (result.Rows[0]["firstname"].ToString());
user.middlename = (result.Rows[0]["middlename"].ToString());
user.lastname = (result.Rows[0]["lastname"].ToString());
user.username = (result.Rows[0]["username"].ToString());
user.password = (result.Rows[0]["password"].ToString());
user.id = Helpers.Convert(result.Rows[0]["id"].ToString());
user.forgot_answer = (result.Rows[0]["forgot_answer"].ToString());
user.forgot_question = (result.Rows[0]["forgot_question"].ToString());
return user;
}
return null;
}
