private bool isUserExist(string userName) { bool result = false; try { string sql = string.Format("SELECT * FROM M_USERS WHERE LOWER(USERID) = '{0}'", userName.ToLower()); var res = SQLiteCommon.ExecuteSqlWithResult(sql); if (res != null && res.HasRows) { result = true; } } catch (Exception ex) { log.Error(ex); } return(result); }
private bool isDeviceExist(string macAddress) { bool result = false; try { string sql = string.Format("SELECT * FROM M_DEVICES WHERE LOWER(MACADDRESS) = '{0}'", macAddress.ToLower()); var res = SQLiteCommon.ExecuteSqlWithResult(sql); if (res != null && res.HasRows) { result = true; } } catch (Exception ex) { log.Error(ex); } return(result); }
private void btnLogin_Click(object sender, EventArgs e) { try { string userName = this.txtUserName.Text.Trim(); string passWord = this.txtPassword.Text.Trim(); if (string.IsNullOrEmpty(userName) || string.IsNullOrEmpty(passWord)) { ShowMsg(MessageBoxIcon.Warning, "Please input UserName Or Password!"); this.txtUserName.Focus(); return; } string sql = string.Format("SELECT * FROM M_USERS WHERE LOWER(USERID)='{0}' AND PASSWORD='******'", userName.ToLower(), passWord); var result = SQLiteCommon.ExecuteSqlWithResult(sql); if (result != null && result.HasRows) { CURRENT_USER = userName; MainForm mainForm = new MainForm(); mainForm.Show(); this.Hide(); } else { ShowMsg(MessageBoxIcon.Warning, "UserName Or Password Wrong! Please input this again!"); this.txtUserName.Focus(); this.txtPassword.Text = string.Empty; } } catch (Exception ex) { log.Error(ex); ShowMsg(MessageBoxIcon.Error, ex.Message); } }