public Boolean insertUser(User user, Type type, String errorMethod) { int evaluetionMethod; EvaluetionMethodInfo emInfo = user.getEvaluetionMethodInfo(); if(user.getEvaluetionMethodInfo().getEvaluetionMethod().Equals(EvaluetionMethod.Grade)) evaluetionMethod = 0; else evaluetionMethod = 1; String insertUserString = "INSERT INTO USER (login, password, name, evaluetionMethod, " + "higherLimit, lowerLimit, step) " + "VALUES ('" + user.getLogin() + "', '" + user.getPassword() + "', '" + user.getName() + "', " + evaluetionMethod + ", " + emInfo.getHigherLimit() + ", " + emInfo.getLowerLimit() + ", '" + emInfo.getStep().ToString() + "')"; return executeNonQuery(insertUserString, type, errorMethod, "Insert user into databese failed."); }
private void tryToLogIn() { if (tbLogIn.Text.Length != 0 && tbPassword.Text.Length != 0) { DaoUser daoUser = new DaoUser(); daoUser.openConnection(this.GetType(), "sqlErrorHandler"); user = daoUser.getUserByLogin(tbLogIn.Text, this.GetType(), "sqlErrorHandler"); daoUser.closeConnection(); if (user != null && user.getPassword().Equals(tbPassword.Text)) { valid = true; } if (valid) this.Close(); else { MessageBox.Show("Usuário ou senha não encontrados. " + "Tente novamente ou cadastre-se"); tbLogIn.Focus(); } } else emptyFieldsWarning(); }