private void txtIban_TextChanged(object sender, EventArgs e)
{
if (txtIban.Text.Count() == 8 && cboList.SelectedIndex != -1)
{
DatabaseManagement database = new DatabaseManagement();
database.OpenConnection();
string destEmail = database.EmailFromIban(txtIban.Text.ToUpper());
database.CloseConnection();
if (destEmail != null && userInfo.Email != destEmail)
{
lblNameUser.Text = $"Vous allez ajouter :\n{destEmail}";
cmdAddToList.Enabled = true;
}
else
{
lblNameUser.Text = "";
cmdAddToList.Enabled = false;
}
if (txtIban.Text.ToUpper() == userInfo.Iban)
{
lblNameUser.Text = "Vous ne pouvez vous ajouter à la liste";
}
}
else
{
lblNameUser.Text = "";
cmdAddToList.Enabled = false;
}
}
private void cmdPay_Click(object sender, EventArgs e)
{
if (cboPayList.SelectedIndex == 0 || cboPayList.SelectedIndex == -1)
{
if (userInformations.Money >= Convert.ToDouble(updPayAmount.Value))
{
DatabaseManagement database = new DatabaseManagement();
database.OpenConnection();
bool success = database.Transact(Convert.ToDouble(updPayAmount.Value), txtPayReason.Text, userInformations.Iban, txtPayIban.Text);
if (success)
{
userInformations = (PublicUser)database.GetUser(userInformations.Email);
}
database.CloseConnection();
updateInfos();
txtPayIban.Text = "";
updPayAmount.Value = 1;
txtPayReason.Text = "";
}
else
{
MessageBox.Show("Vous n'avez pas assez d'argent pour effectuer cette transaction", "Erreur");
}
}
else
{
if (userInformations.Money >= Convert.ToDouble(((UsersList)cboPayList.SelectedItem).Users.Count() * updPayAmount.Value))
{
foreach (User user in ((UsersList)cboPayList.SelectedItem).Users)
{
DatabaseManagement database = new DatabaseManagement();
database.OpenConnection();
bool success = database.Transact(Convert.ToDouble(updPayAmount.Value), txtPayReason.Text, userInformations.Iban, user.Iban);
if (success)
{
userInformations = (PublicUser)database.GetUser(userInformations.Email);
}
database.CloseConnection();
updateInfos();
}
updPayAmount.Value = 1;
txtPayReason.Text = "";
cboPayList.SelectedIndex = 0;
txtPayIban.Text = "";
}
else
{
MessageBox.Show("Vous n'avez pas assez d'argent pour effectuer cette transaction", "Erreur");
}
}
}
private void cmdAddToListMethod()
{
if (((UsersList)cboList.SelectedItem).Users.All(item => item.Iban != txtIban.Text.ToUpper()))
{
DatabaseManagement database = new DatabaseManagement();
database.OpenConnection();
database.AddUserList(((UsersList)cboList.SelectedItem).Name, txtIban.Text.Trim());
userInfo = (EnterpriseUser)database.GetUser(userInfo.Email);
database.CloseConnection();
int selectedList = cboList.SelectedIndex;
displayEnterpriseLists();
cboList.SelectedIndex = selectedList;
displayUsersLists();
txtIban.Text = "";
lblNameUser.Text = "L'utilisateur a bien été ajouté";
cmdAddToList.Enabled = false;
}
else
{
MessageBox.Show("Cet utilisateur est déjà dans cette liste");
}
}
private void cmdModifyMonney_Click(object sender, EventArgs e)
{
FrmAdminMoneyChanger form = new FrmAdminMoneyChanger(userInformations);
form.ShowDialog();
DatabaseManagement database = new DatabaseManagement();
database.OpenConnection();
userInformations = (AdminUser)database.GetUser(userInformations.Email);
database.CloseConnection();
updateInfos();
}
private void cmdModifyList_Click(object sender, EventArgs e)
{
FrmListManagement Listform = new FrmListManagement((EnterpriseUser)userInformations);
Listform.ShowDialog();
DatabaseManagement database = new DatabaseManagement();
database.OpenConnection();
userInformations = (EnterpriseUser)database.GetUser(userInformations.Email);
database.CloseConnection();
displayEnterpriseLists();
}
private void cmdChangeAmount_Click(object sender, EventArgs e)
{
int flag = 0;
lblError.Text = "";
txtUserEmail.BackColor = Color.FromArgb(255, 255, 255);
if (txtUserEmail.Text.Trim() == "")
{
txtUserEmail.BackColor = Color.FromArgb(255, 128, 128);
lblError.Text = "Champ(s) incomplet(s)";
flag++;
}
if (flag == 0)
{
lblError.Text = "";
txtUserEmail.BackColor = Color.FromArgb(255, 255, 255);
try
{
DatabaseManagement database = new DatabaseManagement();
database.OpenConnection();
if (database.ChangeMoney(txtUserEmail.Text.Trim(), (double)updAmount.Value))
{
lblError.Text = "Le solde a été changé";
txtUserEmail.Text = "";
updAmount.Value = 0;
}
else
{
lblError.Text = "Utilisateur introuvable";
txtUserEmail.BackColor = Color.FromArgb(255, 128, 128);
}
database.CloseConnection();
}
catch (UnableToJoinDatabase)
{
lblError.Text = "La base de données est injoignable";
txtUserEmail.BackColor = Color.FromArgb(255, 128, 128);
}
}
}
private void cmdDeleteAccount_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("Êtes-vous sûr de vouloir effacer votre compte ?\nVotre argent ne sera plus accessible.",
"Effacer votre compte", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
DatabaseManagement database = new DatabaseManagement();
database.OpenConnection();
database.DisableAccount(userInfos.Email);
database.CloseConnection();
MessageBox.Show("Au revoir", "Merci");
Application.Exit();
}
}
private void cmdDeleteList_Click(object sender, EventArgs e)
{
DatabaseManagement database = new DatabaseManagement();
database.OpenConnection();
database.DeleteList(((UsersList)cboList.SelectedItem).Name);
userInfo = (EnterpriseUser)database.GetUser(userInfo.Email);
database.CloseConnection();
displayEnterpriseLists();
lstList.Items.Clear();
cmdListToDelete.Enabled = false;
cmdDeleteList.Enabled = false;
cmdAddToList.Enabled = false;
txtIban.Enabled = false;
}
private void cmdListToDelete_Click(object sender, EventArgs e)
{
DatabaseManagement database = new DatabaseManagement();
database.OpenConnection();
database.DeleteUserList(((UsersList)cboList.SelectedItem).Name, ((User)lstList.SelectedItem).Iban);
userInfo = (EnterpriseUser)database.GetUser(userInfo.Email);
database.CloseConnection();
int selectedList = cboList.SelectedIndex;
displayEnterpriseLists();
cboList.SelectedIndex = selectedList;
displayUsersLists();
cmdListToDelete.Enabled = false;
}
private void cmdAddList_Click(object sender, EventArgs e)
{
DatabaseManagement database = new DatabaseManagement();
database.OpenConnection();
try
{
database.CreateList(txtNameList.Text.Trim(), userInfo.Iban);
userInfo = (EnterpriseUser)database.GetUser(userInfo.Email);
database.CloseConnection();
}
catch (ListAlreadyExistsException)
{
MessageBox.Show("Ce nom de liste existe déjà");
}
displayEnterpriseLists();
lstList.Items.Clear();
txtNameList.Text = "";
}
private void txtPayIban_TextChanged(object sender, EventArgs e)
{
if (txtPayIban.Text.Count() == 8)
{
DatabaseManagement database = new DatabaseManagement();
database.OpenConnection();
string destEmail = database.EmailFromIban(txtPayIban.Text.ToUpper());
database.CloseConnection();
if (destEmail != null && userInformations.Email != destEmail)
{
lblEmailReceiver.Text = $"Vous allez faire un payement a :\n{destEmail}";
cmdPay.Enabled = true;
}
else if (userInformations.Email == destEmail)
{
lblEmailReceiver.Text = "Opération non possible";
cmdPay.Enabled = false;
}
else
{
lblEmailReceiver.Text = "L'Iban que vous avez entré ne correspond à personne,\nveuillez vérifiez l'Iban";
cmdPay.Enabled = false;
}
}
else
{
lblEmailReceiver.Text = "";
cmdPay.Enabled = false;
}
}
private void cmdChangePassword_Click(object sender, EventArgs e)
{
int flag = 0;
lblError.Text = "";
txtUserEmail.BackColor = Color.FromArgb(255, 255, 255);
txtNewPassword.BackColor = Color.FromArgb(255, 255, 255);
txtNewPasswordVerify.BackColor = Color.FromArgb(255, 255, 255);
if (txtNewPassword.Text.Trim() != txtNewPasswordVerify.Text.Trim())
{
lblError.Text = "Les mots de passes sont différents";
txtNewPasswordVerify.BackColor = Color.FromArgb(255, 128, 128);
flag++;
}
if (txtNewPassword.Text.Count() < 8)
{
lblError.Text = "Votre mot de passe est trop court, 8 caractères minimum";
txtNewPassword.BackColor = Color.FromArgb(255, 128, 128);
txtNewPasswordVerify.BackColor = Color.FromArgb(255, 128, 128);
flag++;
}
if (txtUserEmail.Text.Trim() == "")
{
txtUserEmail.BackColor = Color.FromArgb(255, 128, 128);
lblError.Text = "Champ(s) incomplet(s)";
flag++;
}
if (txtNewPassword.Text.Trim() == "")
{
txtNewPassword.BackColor = Color.FromArgb(255, 128, 128);
lblError.Text = "Champ(s) incomplet(s)";
flag++;
}
if (txtNewPasswordVerify.Text.Trim() == "")
{
txtNewPasswordVerify.BackColor = Color.FromArgb(255, 128, 128);
lblError.Text = "Champ(s) incomplet(s)";
flag++;
}
if (flag == 0)
{
lblError.Text = "";
txtUserEmail.BackColor = Color.FromArgb(255, 255, 255);
txtNewPassword.BackColor = Color.FromArgb(255, 255, 255);
try
{
DatabaseManagement database = new DatabaseManagement();
database = new DatabaseManagement();
database.OpenConnection();
if (database.ChangePassword(txtUserEmail.Text.Trim(), txtNewPassword.Text.Trim()))
{
lblError.Text = "Le mot de passe a été changé";
txtUserEmail.Text = "";
txtNewPassword.Text = "";
txtNewPasswordVerify.Text = "";
}
else
{
lblError.Text = "Utilisateur introuvable";
txtUserEmail.BackColor = Color.FromArgb(255, 128, 128);
}
database.CloseConnection();
}
catch (UnableToJoinDatabase)
{
lblError.Text = "La base de données est injoignable";
txtUserEmail.BackColor = Color.FromArgb(255, 128, 128);
}
}
}
private void cmdRegister_Click(object sender, EventArgs e)
{
int flag = 0;
lblError.Text = "";
txtEmail.BackColor = Color.FromArgb(255, 255, 255);
txtPassword.BackColor = Color.FromArgb(255, 255, 255);
txtPasswordVerify.BackColor = Color.FromArgb(255, 255, 255);
if (password.Trim() != passwordVerify.Trim())
{
lblError.Text = "Les mots de passes sont différents";
txtPasswordVerify.BackColor = Color.FromArgb(255, 128, 128);
flag++;
}
if (password.Count() < 8)
{
lblError.Text = "Votre mot de passe est trop court, 8 caractères minimum";
txtPassword.BackColor = Color.FromArgb(255, 128, 128);
txtPasswordVerify.BackColor = Color.FromArgb(255, 128, 128);
flag++;
}
if (txtEmail.Text.ToLower().Trim() == "")
{
txtEmail.BackColor = Color.FromArgb(255, 128, 128);
lblError.Text = "Champ(s) incomplet(s)";
flag++;
//lblError.Text = "Erreur lors de la création du compte";
}
if (password.Trim() == "")
{
txtPassword.BackColor = Color.FromArgb(255, 128, 128);
lblError.Text = "Champ(s) incomplet(s)";
flag++;
//lblError.Text = "Erreur lors de la création du compte";
}
if (passwordVerify.Trim() == "")
{
txtPasswordVerify.BackColor = Color.FromArgb(255, 128, 128);
lblError.Text = "Champ(s) incomplet(s)";
flag++;
//lblError.Text = "Erreur lors de la création du compte";
}
if (flag == 0)
{
try
{
DatabaseManagement database = new DatabaseManagement();
database.OpenConnection();
bool successCreation;
if (chkEnterprise.Checked)
{
successCreation = database.AddUser(txtEmail.Text.ToLower().Trim(), password.Trim(), "Enterprise", 10000.5);
}
else
{
successCreation = database.AddUser(txtEmail.Text.ToLower().Trim(), password.Trim(), "Public", 10000.5);
}
database.CloseConnection();
if (successCreation)
{
FrmConfirmRegister formConfirm = new FrmConfirmRegister();
formConfirm.Email = $"{txtEmail.Text.ToLower().Trim()}, vous êtes bien incrit-e";
formConfirm.ShowDialog();
Close();
}
lblError.Text = "Erreur lors de la création du compte";
txtEmail.BackColor = Color.FromArgb(255, 128, 128);
}
catch (UnableToJoinDatabase)
{
lblError.Text = "La base de données est injoignable";
txtEmail.BackColor = Color.FromArgb(255, 128, 128);
txtPassword.BackColor = Color.FromArgb(255, 128, 128);
}
catch (UserAlreadyExistsException)
{
//lblError.Text = "Oups.. Cette email est deja utilisée par une autre personne";
lblError.Text = "Erreur lors de la création du compte, cet email est deja utilisé";
}
catch (WrongEmailFormatException)
{
lblError.Text = "Format d'email invalide ex. exemple@exemple";
txtEmail.BackColor = Color.FromArgb(255, 128, 128);
}
catch (WrongAccountTypeException)
{
lblError.Text = "Erreur lors de la création du compte";
}
}
}
private void tryLogin()
{
lblError.Text = "";
txtEmail.BackColor = Color.FromArgb(255, 255, 255);
txtPassword.BackColor = Color.FromArgb(255, 255, 255);
try
{
DatabaseManagement database = new DatabaseManagement();
database.OpenConnection();
bool allowConnection = database.VerifyUser(txtEmail.Text.ToLower().Trim(), password.Trim());
database.CloseConnection();
if (allowConnection)
{
database = new DatabaseManagement();
database.OpenConnection();
PublicUser loggedUserInfos = (PublicUser)database.GetUser(txtEmail.Text.ToLower().Trim());
database.CloseConnection();
Visible = false;
Form homeForm;
if (loggedUserInfos.GetType() == typeof(AdminUser))
{
homeForm = new FrmHomeAdmin((AdminUser)loggedUserInfos, jsonStorage);
homeForm.ShowDialog();
}
else
{
homeForm = new FrmHome(loggedUserInfos, jsonStorage);
homeForm.ShowDialog();
}
jsonStorage.HomeWindowLocation = homeForm.Location;
jsonStorage.HomeWindowSize = homeForm.Size;
jsonFile.InsertData(jsonStorage);
Close();
}
else
{
//User and password doesn't match case
lblError.Text = "Login incorrect";
txtEmail.BackColor = Color.FromArgb(255, 128, 128);
txtPassword.BackColor = Color.FromArgb(255, 128, 128);
}
}
catch (UnableToJoinDatabase)
{
lblError.Text = "La base de données est injoignable";
txtEmail.BackColor = Color.FromArgb(255, 128, 128);
txtPassword.BackColor = Color.FromArgb(255, 128, 128);
}
catch (UserDoesNotExistsException)
{
lblError.Text = "Login incorrect";
txtEmail.BackColor = Color.FromArgb(255, 128, 128);
txtPassword.BackColor = Color.FromArgb(255, 128, 128);
}
}
private void cmdChangePassword_Click(object sender, EventArgs e)
{
int flag = 0;
lblError.Text = "";
txtOldPassword.BackColor = Color.FromArgb(255, 255, 255);
txtNewPassword.BackColor = Color.FromArgb(255, 255, 255);
txtNewPasswordVerify.BackColor = Color.FromArgb(255, 255, 255);
if (txtNewPassword.Text.Trim() != txtNewPasswordVerify.Text.Trim())
{
lblError.Text = "Les mots de passes sont différents";
txtNewPasswordVerify.BackColor = Color.FromArgb(255, 128, 128);
flag++;
}
if (txtNewPassword.Text.Count() < 8)
{
lblError.Text = "Votre mot de passe est trop court, 8 caractères minimum";
txtNewPassword.BackColor = Color.FromArgb(255, 128, 128);
txtNewPasswordVerify.BackColor = Color.FromArgb(255, 128, 128);
flag++;
}
if (txtOldPassword.Text.Trim() == "")
{
txtOldPassword.BackColor = Color.FromArgb(255, 128, 128);
lblError.Text = "Champ(s) incomplet(s)";
flag++;
}
if (txtNewPassword.Text.Trim() == "")
{
txtNewPassword.BackColor = Color.FromArgb(255, 128, 128);
lblError.Text = "Champ(s) incomplet(s)";
flag++;
}
if (txtNewPasswordVerify.Text.Trim() == "")
{
txtNewPasswordVerify.BackColor = Color.FromArgb(255, 128, 128);
lblError.Text = "Champ(s) incomplet(s)";
flag++;
}
if (flag == 0)
{
lblError.Text = "";
txtOldPassword.BackColor = Color.FromArgb(255, 255, 255);
txtNewPassword.BackColor = Color.FromArgb(255, 255, 255);
try
{
DatabaseManagement database = new DatabaseManagement();
database.OpenConnection();
bool allowConnection = database.VerifyUser(userInfos.Email, txtOldPassword.Text.Trim());
database.CloseConnection();
if (allowConnection)
{
database = new DatabaseManagement();
database.OpenConnection();
database.ChangePassword(userInfos.Email, txtNewPassword.Text.Trim());
database.CloseConnection();
lblError.Text = "Votre mot de passe a été changé";
txtOldPassword.Text = "";
txtNewPassword.Text = "";
txtNewPasswordVerify.Text = "";
}
else
{
//User and password doesn't match case
lblError.Text = "Login incorrect";
txtOldPassword.BackColor = Color.FromArgb(255, 128, 128);
}
}
catch (UnableToJoinDatabase)
{
lblError.Text = "La base de données est injoignable";
txtOldPassword.BackColor = Color.FromArgb(255, 128, 128);
}
}
}
