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; }