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