private void btn_signup_Click(object sender, EventArgs e) { lbl_error_msg.Text = ""; if (txt_email.TextLength < 1 || txt_password.TextLength < 1 || txt_username.TextLength < 1) { lbl_error_msg.Text = "Tous les champs sont obligatoires !"; } if (UserAuthService.userExist(txt_email.Text, txt_username.Text)) { lbl_error_msg.Text = "Veuillez indiquer un autre email ou nom d'utilisateur !"; } try { SlaDataSet dataSet = new SlaDataSet(); SlaDataSetTableAdapters.SLA_USERSTableAdapter usersTableAdapter = new SlaDataSetTableAdapters.SLA_USERSTableAdapter(); // Create a new row. SlaDataSet.SLA_USERSRow usersRow; usersRow = dataSet.SLA_USERS.NewSLA_USERSRow(); usersRow.USR_EMAIL = txt_email.Text; usersRow.USR_NAME = txt_username.Text; usersRow.USR_PASSWORD = txt_password.Text; usersRow.USR_AGE = (int)nud_age.Value; switch (cbo_type.SelectedText) { case "Client": usersRow.USR_TYPE = 1; break; case "Artiste": usersRow.USR_TYPE = 2; break; default: usersRow.USR_TYPE = 1; break; } usersTableAdapter.InsertQuery(usersRow.USR_NAME, usersRow.USR_PASSWORD, usersRow.USR_TYPE, usersRow.USR_EMAIL, usersRow.USR_AGE); lbl_error_msg.Text = "Votre compte a bien été enregistré !"; Dispose(); } catch (SqlException ex) { lbl_error_msg.Text = "Une erreur est survenue ! Veuillez introduire des champs valides !"; } }
public static bool userExist(String email, String username) { SlaDataSet dataSet = new SlaDataSet(); SlaDataSetTableAdapters.SLA_USERSTableAdapter listLogin = new SlaDataSetTableAdapters.SLA_USERSTableAdapter(); listLogin.Fill(dataSet.SLA_USERS); SlaDataSet.SLA_USERSRow user = listLogin.GetDataByUserEmail(username, email).FirstOrDefault(); if (user != null) { return(true); } return(false); }
public static bool login(String username, String password) { SlaDataSet dataSet = new SlaDataSet(); SlaDataSetTableAdapters.SLA_USERSTableAdapter listLogin = new SlaDataSetTableAdapters.SLA_USERSTableAdapter(); listLogin.Fill(dataSet.SLA_USERS); SlaDataSet.SLA_USERSRow user = listLogin.GetDataByUser(username).First(); if (user != null && user.USR_PASSWORD.Equals(password)) { actual_user = user; return(true); } return(false); }