private void UpdateUser()
{
try
{
if (!string.IsNullOrEmpty(TxtLastPassword.Text) && !string.IsNullOrEmpty(TxtNewPassword1.Text) &&
!string.IsNullOrEmpty(TxtNewPassword2.Text) && !string.IsNullOrEmpty(TxtUsername.Text))
{
if (password.Equals(TxtLastPassword.Text))
{
if (!TxtNewPassword1.Text.Equals(TxtNewPassword2.Text))
{
MessageBox.Show(this, "Les deux mots de passe ne sont pas identiques !", "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error);
TxtNewPassword1.Focus();
}
else
{
user = new User
{
Username = TxtUsername.Text,
Password = TxtNewPassword2.Text
};
if (Glossaire.Instance.UpdateUser(user))
{
if (MessageBox.Show(this, "Information enregistrée avec succès !\n\nL'application doit rédemarrer pour appliquer les modifications.", "Rédemarrage requis", MessageBoxButtons.OKCancel, MessageBoxIcon.Information) == DialogResult.OK)
{
Application.Restart();
}
else
{
//
}
}
}
}
else
{
MessageBox.Show(this, "Votre mot de passe est incorrect !", "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error);
TxtLastPassword.Focus();
}
}
else
{
MessageBox.Show(this, "Remplisser tous les champs svp !", "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error);
TxtUsername.Focus();
}
}
catch (Exception ex)
{
MessageBox.Show(this, "Une erreur s'est produite lors de l'opération", "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error);
Console.WriteLine("Cette erreur s'est produite lors de l'opération : " + ex);
}
}
void login()
{
database db = new database();
db.Login(TxtUsername.Text, TxtPassword.Text);
foreach (Control objectX in this.Controls)
{
if (objectX is TextBox)
{
objectX.Text = "";
}
}
TxtUsername.Focus();
}
private void Form1_Load(object sender, EventArgs e)
{
//DataSet ds = new DataSet();
//connection.callOrg(ds);
//if (ds.Tables[0].Rows.Count > 0) {
// cmbOrg.DataSource = ds.Tables[0].DefaultView;
// cmbOrg.DisplayMember = "org_name";
// cmbOrg.ValueMember = "org_code";
//}
orgCode = connection.getOrg();
TxtUsername.Focus();
}
private void BtnLogin_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(TxtUsername.Text) && !string.IsNullOrEmpty(TxtPassword.Text))
{
SqlConnection sqlConn = new SqlConnection("Data Source=DESKTOP-0997K4M;Initial Catalog=UserRegistrationDB;Integrated Security=True");
SqlCommand sqlComm = new SqlCommand("SELECT * FROM tblUser WHERE EmailAddress = @EmailAddress and Password = @Password", sqlConn);
sqlConn.Open();
SqlDataAdapter dataAdapter = new SqlDataAdapter();
DataTable dataTable = new DataTable();
sqlComm.Parameters.AddWithValue("@EmailAddress", TxtUsername.Text);
sqlComm.Parameters.AddWithValue("@Password", TxtPassword.Text);
DataSet dataSet = new DataSet();
dataAdapter.SelectCommand = sqlComm;
dataAdapter.Fill(dataTable);
if (dataTable.Rows.Count > 0)
{
TxtUsername.Clear();
TxtPassword.Clear();
ChckShowPassword.Checked = false;
this.Hide();
BCMainForm mainForm = new BCMainForm();
mainForm.ShowDialog();
mainForm = null;
this.Hide();
this.TxtUsername.Select();
}
else
{
//show error message
MessageBox.Show("Username or Password incorrect. Try Agian", "Login form", MessageBoxButtons.OK, MessageBoxIcon.Stop);
TxtUsername.Focus();
TxtUsername.SelectAll();
}
}
else
{
MessageBox.Show("Please enter username and password. ", "Create Account", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
TxtUsername.Select();
}
}
private void OK_Click(object sender, EventArgs e)
{
tesLogin(TxtUsername.Text, TxtPassword.Text, orgCode);
if (sukses)
{
MainForm1 menu = new MainForm1();
menu.ShowDialog();
this.Hide();
}
else
{
MessageBox.Show("Username atau Password salah", "Barcode Printing System", MessageBoxButtons.OK, MessageBoxIcon.Warning);
TxtUsername.Text = "";
TxtPassword.Text = "";
TxtUsername.Focus();
}
}
private bool Validate()
{
if (string.IsNullOrEmpty(TxtUsername.Text))
{
DisplayAlert("Error", "Debe ingresar un nombre de usuario", "Aceptar");
TxtUsername.Focus();
return(false);
}
else if (string.IsNullOrEmpty(TxtEmail.Text))
{
DisplayAlert("Error", "Debe ingresar un Correo Válido", "Aceptar");
TxtEmail.Focus();
return(false);
}
else if (string.IsNullOrEmpty(TxtPass.Text))
{
DisplayAlert("Error", "Debe ingresar una Contraseña", "Aceptar");
TxtPass.Focus();
return(false);
}
else if (TxtPass.Text != TxtPassC.Text)
{
DisplayAlert("Error", "Las contraseñas no coinciden", "Aceptar");
TxtPass.Focus();
return(false);
}
try
{
MailAddress m = new MailAddress(TxtEmail.Text);
}
catch (FormatException)
{
DisplayAlert("Alerta", "Correo electrónico inválido", "Ok");
return(false);
}
Regex rgx = new Regex(@"^(?=.*[a-z])(?=.*[A-Z])(?=.*\d)(?=.*[^\da-zA-Z]).{8,15}$");
if (!rgx.IsMatch(TxtPass.Text))
{
DisplayAlert("Error", "La contraseña debe contener de 8-15 caracteres; al menos 1 Mayúscula, Minúscula, Digito y Caracter especial", "OK");
return(false);
}
return(true);
}
private async void BtnLogin_Click(object sender, RoutedEventArgs e)
{
if (await AppState.AttemptLogin(TxtUsername.Text, PswdPassword.Password))
{
AppState.CurrentUser = await AppState.LoadUser(TxtUsername.Text);
AppState.SetUserDatabaseInformation();
AppState.Navigate(new TrackerPage());
TxtUsername.Clear();
PswdPassword.Clear();
TxtUsername.Focus();
}
else
{
AppState.DisplayNotification("Invalid credentials. Please try again.", "Personal Tracker");
}
}
private void btnIngresar_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(TxtUsername.Text))
{
MessageBox.Show("Ingrese Usuario", "Mensaje", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
TxtUsername.Focus();
}
else if (string.IsNullOrEmpty(TxtPassword.Text))
{
MessageBox.Show("Ingrese Contraseña", "Mensaje", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
TxtPassword.Focus();
}
else
{
Login(TxtUsername.Text, TxtPassword.Text);;
}
}
private Boolean isValid()
{
Boolean isValidated = true;
if (String.IsNullOrEmpty(TxtUsername.Text))
{
isValidated = false;
MessageBox.Show("Username can not be blank!", "Warning!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
TxtUsername.Focus();
}
else if (String.IsNullOrEmpty(TxtPassword.Text))
{
isValidated = false;
MessageBox.Show("Password can not be blank!", "Warning!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
TxtPassword.Focus();
}
return(isValidated);
}
private void TxtPassword_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == 13)
{
AuthBAL Auth = new AuthBAL();
if (TxtUsername.Text.Trim() != "" && TxtPassword.Text.Trim() != "")
{
Auth.Username = TxtUsername.Text.Trim();
Auth.Password = TxtPassword.Text.Trim();
bool result = Ad.Auth(Auth);
if (result == true)
{
Home main = new Home();
main.Show();
Hide();
}
else
{
MessageBox.Show("Invalid Username and Password");
}
}
else if (TxtUsername.Text.Trim() == "")
{
MessageBox.Show("Username Cannot be Empty");
TxtUsername.Focus();
}
else if (TxtPassword.Text.Trim() == "")
{
MessageBox.Show("Password Cannot be Empty");
TxtPassword.Focus();
}
else
{
MessageBox.Show("Username and Password Invalid");
}
}
}
private void OnErrorOccurred(object sender, EventArgs e)
{
if (_manageDriverViewModel.IsErrorInFirstName)
{
LblErrorMsg.Text = "First Name must be not null and contains alphabet only.";
TxtFirstName.Focus();
return;
}
if (_manageDriverViewModel.IsErrorInLastName)
{
LblErrorMsg.Text = "Last Name must be not null and contains alphabet only.";
TxtLastName.Focus();
return;
}
if (_manageDriverViewModel.IsErrorInUsername && _manageDriverViewModel.IsAddingDriver)
{
LblErrorMsg.Text = string.IsNullOrEmpty(_manageDriverViewModel.ErrorMessage) ? "Username must be not null and contains alphanumberic only." : _manageDriverViewModel.ErrorMessage;;
TxtUsername.Focus();
return;
}
if (_manageDriverViewModel.IsErrorInPin)
{
LblErrorMsg.Text = "Pin number must be four digit only, no any aphabet allowed.";
TxtPin.Focus();
return;
}
if (_manageDriverViewModel.IsErrorInGroup)
{
LblErrorMsg.Text = "Please select any Group.";
CBGroup.Focus();
return;
}
}
private async void BtnCreate_Click(object sender, RoutedEventArgs e)
{
if (TxtUsername.Text.Length > 0)
{
if (PswdPassword.Password.Length >= 4 && PswdConfirmPassword.Password.Length >= 4)
{
if (PswdPassword.Password == PswdConfirmPassword.Password)
{
User newUser = new User(TxtUsername.Text, PBKDF2.HashPassword(PswdPassword.Password));
if (!await AppState.CreateUser(newUser))
{
TxtUsername.Focus();
}
else
{
AppState.GoBack();
}
}
else
{
AppState.DisplayNotification("Please ensure that your passwords match.", "Personal Tracker");
PswdPassword.Focus();
}
}
else
{
AppState.DisplayNotification("Please ensure that your passwords are at least 4 characters in length.", "Personal Tracker");
PswdPassword.Focus();
}
}
else
{
AppState.DisplayNotification("Please ensure that your username is filled out.", "Personal Tracker");
TxtUsername.Focus();
}
}
private void TxtPasWord_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == 13)
{
AuthBAL Auth = new AuthBAL();
AuthDAL Ad = new AuthDAL();
if (TxtUseName.Text.Trim() != "" && TxtPasWord.Text.Trim() != "")
{
Auth.Username = TxtUseName.Text.Trim();
Auth.Password = TxtPasWord.Text.Trim();
bool result = Ad.Auth(Auth);
if (result == true)
{
TUnlock.Enabled = true;
}
else
{
MessageBox.Show("Invalid Username and Password");
}
}
else if (TxtUseName.Text.Trim() == "")
{
MessageBox.Show("Username Cannot be Empty");
TxtUsername.Focus();
}
else if (TxtPasWord.Text.Trim() == "")
{
MessageBox.Show("Password Cannot be Empty");
TxtPassword.Focus();
}
else
{
MessageBox.Show("Username and Password cannot be empty");
}
}
}
private void BtnLogin_Click(object sender, EventArgs e)
{
//MessageBox.Show(rezult);
if (TxtPassword.Text == "")
{
MessageBox.Show("Please enter password", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
TxtPassword.Focus();
return;
}
try
{
SqlConnection myConnection = default(SqlConnection);
myConnection = new SqlConnection(@"Data Source=DESKTOP-NP1RDM2\BAZALUIMARIAN;Initial Catalog=task;Persist Security Info=True;User ID=sa; Password = 0299");
SqlCommand myCommand = default(SqlCommand);
myCommand = new SqlCommand("SELECT NameUser,PasswordUser FROM Users WHERE NameUser = @NameUser AND PasswordUser = @PasswordUser", myConnection);
SqlParameter uName = new SqlParameter("@NameUser", SqlDbType.VarChar);
SqlParameter uPassword = new SqlParameter("@PasswordUser", SqlDbType.VarChar);
uName.Value = TxtUsername.Text;
uPassword.Value = TxtPassword.Text;
myCommand.Parameters.Add(uName);
myCommand.Parameters.Add(uPassword);
myCommand.Connection.Open();
SqlDataReader myReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
if (myReader.Read() == true)
{
string rezult = "";
string NameUser = "******";
rezult = setValue(NameUser, rezult, TxtUsername.Text);
if (rezult == "0")
{
Clients newForm = new Clients();
newForm.ShowDialog(this);
}
else
{
Admins newForm = new Admins();
newForm.ShowDialog(this);
}
con.Close();
}
else
{
MessageBox.Show("Login Failed...Try again !", "Login Denied", MessageBoxButtons.OK, MessageBoxIcon.Error);
TxtUsername.Clear();
TxtPassword.Clear();
TxtUsername.Focus();
}
if (myConnection.State == ConnectionState.Open)
{
myConnection.Dispose();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public LoginPage()
{
InitializeComponent();
TxtUsername.Focus();
}
private void login_Load(object sender, EventArgs e)
{
TxtUsername.Focus();
}
private void RequestFocus(object sender, EventArgs e)
{
TxtUsername.Focus();
}
protected void BtnSaveUsers_Click(object sender, EventArgs e)
{
if (DListOrganization.SelectedValue == "0")
{
ShowModal();
Config.MsgBoxAjax("Qurumun adını seçin.", Page);
return;
}
// Əgər yeni istifadəçi əlavə edilirsə login passüordu yoxlayaq
if (string.IsNullOrEmpty(BtnSaveUsers.CommandArgument))
{
TxtUsername.Text = TxtUsername.Text.Trim();
if (TxtUsername.Text.Length < 4)
{
ShowModal();
TxtUsername.Focus();
Config.MsgBoxAjax("İstifadəçi adı minimum 4 simvoldan ibarət olmalıdır.", Page);
return;
}
if (TxtUsername.Text.Length > 25)
{
ShowModal();
TxtUsername.Focus();
Config.MsgBoxAjax("İstifadəçi adı maksimum 25 simvoldan ibarət olmalıdır.", Page);
return;
}
string LoginAllowChars = "qazwsxedcrfvtgbyhnujmikolpQAZWSXEDCRFVTGBYHNUJMIKOLP0123456789._";
for (int i = 0; i < TxtUsername.Text.Length; i++)
{
//İlk və son simvollar ancaq rəqəm hərf olsun.
if (i == 0)
{
if (TxtUsername.Text.Substring(i, 1) == "." || TxtUsername.Text.Substring(i, 1) == "_")
{
ShowModal();
TxtUsername.Focus();
Config.MsgBoxAjax("İstifadəçi adının ilk simvolu rəqəm və ya hərf tipli olmalıdır.", Page);
return;
}
}
if (LoginAllowChars.IndexOf(TxtUsername.Text.Substring(i, 1)) < 0)
{
ShowModal();
TxtUsername.Focus();
Config.MsgBoxAjax("İstifadəçi adının tərkibində yalnız rəqəm (0-9), hərf (a-z), nöqtə (.) və alt xətt (_) qəbul edilir.", Page);
return;
}
if (i == (TxtUsername.Text.Length - 1))
{
if (TxtUsername.Text.Substring(i, 1) == "." || TxtUsername.Text.Substring(i, 1) == "_")
{
ShowModal();
TxtUsername.Focus();
Config.MsgBoxAjax("İstifadəçi adının son simvolu rəqəm və ya hərf tipli olmalıdır.", Page);
return;
}
}
}
//Login varmı:
string LoginCount = DALC.GetDbSingleValuesParams("Count(*)", "Users", "IsActive=1 and Username", TxtUsername.Text, "", "-1");
//Əgər mənfi bir olarsa serverdə yüklənmə var.
if (LoginCount == "-1")
{
ShowModal();
Config.MsgBoxAjax(Config._DefaultSystemErrorMessages, Page);
return;
}
//Əgər mənfi bir olmasa keçir bura və əgər sıfır deyilsə deməli bazada var 1 yada daha çoxdu
if (LoginCount != "0")
{
ShowModal();
Config.MsgBoxAjax("Bu istifadəçi adı artıq qeydiyyatdan keçirilib.", Page);
return;
}
if (TxtPass.Text.Length < 4)
{
ShowModal();
Config.MsgBoxAjax("İstifadəçi şifrəsi ən az 4 simvoldan ibarət olmalıdır.", Page);
return;
}
if (TxtPass.Text.Length > 20)
{
ShowModal();
Config.MsgBoxAjax("İstifadəçi şifrəsi maksimum 20 simvoldan ibarət olmalıdır.", Page);
return;
}
}
if (TxtPassportNumber.Text.Length < 1)
{
ShowModal();
Config.MsgBoxAjax("Şəxsiyyət vəsiqəsinin nömrəsini daxil edin.", Page);
return;
}
if (!TxtPassportNumber.Text.IsNumeric())
{
ShowModal();
Config.MsgBoxAjax("Şəxsiyyət vəsiqəsinin nömrəsi rəqəm tipli olmalıdır.", Page);
return;
}
if (TxtFin.Text.Length != 7)
{
ShowModal();
Config.MsgBoxAjax("Şəxsiyyət vəsiqəsinin FİN kodu 7 simvoldan ibarət olmalıdır.", Page);
return;
}
if (TxtFullname.Text.Length < 1)
{
ShowModal();
Config.MsgBoxAjax("Soyadı, adı və atasının adını daxil edin.", Page);
return;
}
if (!TxtEmail.Text.IsEmail())
{
ShowModal();
Config.MsgBoxAjax("Elektron poçt ünvanını düzgün formatda daxil edin.", Page);
return;
}
if (TxtContacts.Text.Trim().Length < 1)
{
ShowModal();
Config.MsgBoxAjax("Telefon nömrəsini daxil edin.", Page);
return;
}
if (!string.IsNullOrEmpty(BtnSaveUsers.CommandArgument))
{
Dictionary <string, object> DictUpdate = new Dictionary <string, object>();
DictUpdate.Add("OrganizationsID", int.Parse(DListOrganization.SelectedValue));
DictUpdate.Add("PassportNumber", int.Parse(TxtPassportNumber.Text.Trim()));
DictUpdate.Add("Pin", TxtFin.Text.Trim());
DictUpdate.Add("Fullname", TxtFullname.Text.Trim());
DictUpdate.Add("Email", TxtEmail.Text.Trim());
DictUpdate.Add("Contacts", TxtContacts.Text.Trim());
DictUpdate.Add("Description", TxtDescription.Text.Trim());
DictUpdate.Add("Add_Dt", DateTime.Now);
DictUpdate.Add("Add_Ip", Request.UserHostAddress.IPToInteger());
DictUpdate.Add("WhereID", int.Parse(BtnSaveUsers.CommandArgument));
int Chek = DALC.UpdateDatabase("Users", DictUpdate);
if (Chek < 1)
{
ShowModal();
Config.MsgBoxAjax(Config._DefaultSystemErrorMessages, Page);
return;
}
DALC.AdministratorsHistoryInsert("İstifadəçinin məlumatları yeniləndi. UsersID: " + BtnSaveUsers.CommandArgument);
}
else
{
Dictionary <string, object> Dictionary = new Dictionary <string, object>();
Dictionary.Add("OrganizationsID", int.Parse(DListOrganization.SelectedValue));
Dictionary.Add("Username", TxtUsername.Text.Trim());
Dictionary.Add("Password", Config.SHA1Special(TxtPass.Text));
Dictionary.Add("PassportNumber", int.Parse(TxtPassportNumber.Text.Trim()));
Dictionary.Add("Pin", TxtFin.Text.Trim());
Dictionary.Add("Fullname", TxtFullname.Text.Trim());
Dictionary.Add("Email", TxtEmail.Text.Trim());
Dictionary.Add("Contacts", TxtContacts.Text.Trim());
Dictionary.Add("Description", TxtDescription.Text.Trim());
Dictionary.Add("Add_Dt", DateTime.Now);
Dictionary.Add("Add_Ip", Request.UserHostAddress.IPToInteger());
int UsersID = DALC.InsertDatabase("Users", Dictionary);
if (UsersID < 1)
{
ShowModal();
Config.MsgBoxAjax(Config._DefaultSystemErrorMessages, Page);
return;
}
DALC.AdministratorsHistoryInsert("Yeni istifadəçi əlavə edildi. UsersID: " + UsersID.ToString());
}
LnkOtherApp_Click(null, null);
Config.MsgBoxAjax("Əməliyyat uğurla yerinə yertirildi.", Page, true);
}
public NewUserPage()
{
InitializeComponent();
TxtUsername.Focus();
}
//button register
private void BtnLogin_Click(object sender, EventArgs e)
{
//MessageBox.Show(rezult);
if (TxtPassword.Text == "")
{
MessageBox.Show("Please enter password", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
TxtPassword.Focus();
return;
}
if (TxtPassword2.Text == "")
{
MessageBox.Show("Please enter confirm password", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
TxtPassword.Focus();
return;
}
if (TxtUsername.Text == "")
{
MessageBox.Show("Please enter username", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
TxtPassword.Focus();
return;
}
try
{
SqlConnection myConnection = default(SqlConnection);
myConnection = new SqlConnection(@"Data Source=DESKTOP-NP1RDM2\BAZALUIMARIAN;Initial Catalog=task;Persist Security Info=True;User ID=sa; Password = 0299");
if (TxtPassword.Text == TxtPassword2.Text)
{
String query = "INSERT INTO dbo.Users (NameUser,PasswordUser) VALUES (@UserName,@Password)";
using (SqlCommand command = new SqlCommand(query, con))
{
command.Parameters.AddWithValue("@UserName", TxtUsername.Text);
command.Parameters.AddWithValue("@Password", TxtPassword.Text);
MessageBox.Show("Register successfully !", "Register Successfully", MessageBoxButtons.OK, MessageBoxIcon.Error);
con.Open();
int result = command.ExecuteNonQuery();
// Check Error
if (result < 0)
{
Console.WriteLine("Error inserting data into Database!");
}
Close();
}
}
else
{
MessageBox.Show("Register Denied", "Register Denied", MessageBoxButtons.OK, MessageBoxIcon.Error);
TxtUsername.Clear();
TxtPassword.Clear();
TxtPassword2.Clear();
TxtUsername.Focus();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
TxtUsername.Focus();
}
private void Page_Loaded(object sender, RoutedEventArgs e)
{
DataContext = _createUser;
CheckButtons();
TxtUsername.Focus();
}
private void OnErrorOccurred(object sender, EventArgs e)
{
TxtUsername.Focus();
}
protected override void OnInitialized(EventArgs e)
{
base.OnInitialized(e);
TxtUsername.Focus();
}
private void TxtsResetter()
{
TxtUsername.Clear();
TxtPassword.Clear();
TxtUsername.Focus();
}
private void UserControl_Loaded(object sender, RoutedEventArgs e)
{
TxtUsername.Focus();
}
