private void Button_Click(object sender, RoutedEventArgs e) { String username = txtUsername.Text; string password = txtPassword.Password; byte[] theBytes = Encoding.UTF8.GetBytes(password); if (username.Equals("") || password.Equals("")) { MessageBox.Show(Settings.Default.MensajeCamposVacios); } else { /** * Consulta para encontrar el usuario */ using (DBEntities db = new DBEntities()) { try { var user = db.Usuarios.Where(b => b.username.Equals(username) && b.password == theBytes).FirstOrDefault(); if (user != null) { /** * De acuerdo al rol, entra al apartado del sistema correspondiente */ switch (user.idRol) { case 5: DashboardAdmin dashboard_Admin = new DashboardAdmin(user); dashboard_Admin.WindowStartupLocation = WindowStartupLocation.CenterScreen; dashboard_Admin.Show(); closeWindow(); break; case 6: Dashboard_Capturista dashboard_Capturista = new Dashboard_Capturista(user); dashboard_Capturista.WindowStartupLocation = WindowStartupLocation.CenterScreen; dashboard_Capturista.Show(); closeWindow(); break; case 7: Dashboard_Gestor dashboard_Gestor = new Dashboard_Gestor(); dashboard_Gestor.WindowStartupLocation = WindowStartupLocation.CenterScreen; dashboard_Gestor.Show(); closeWindow(); break; case 8: Dashboard_AnalistaC dashboard_AnalistaC = new Dashboard_AnalistaC(user); dashboard_AnalistaC.WindowStartupLocation = this.WindowStartupLocation; dashboard_AnalistaC.Show(); closeWindow(); break; } this.Close(); } else { MessageBox.Show(Settings.Default.MensajeNoEncontrado); } } catch (Exception ex) { MessageBox.Show(Settings.Default.MensajeErrorBD); Console.WriteLine(ex.Message); Console.WriteLine(ex.StackTrace); } } } }
private void loginMainWindow_Click(object sender, RoutedEventArgs e) { if (UserNameLogin.Text == "" || PasswordLogin.Password == "") { MessageBox.Show("Please provide UserName and Password"); return; } SqlConnection con = new SqlConnection(); con.ConnectionString = ConfigurationManager.ConnectionStrings["dbx"].ConnectionString; con.Open(); try { //Create SqlConnection SqlCommand cmd = new SqlCommand(); cmd.CommandText = "select userOpteam from Advantic_Users where empNo=@username and password=@password"; cmd.Connection = con; cmd.Parameters.AddWithValue("@username", UserNameLogin.Text); //cmd.Parameters.AddWithValue("@password", PasswordTextLogin.Password) cmd.Parameters.AddWithValue("@password", CommonFunctions.sha256_hash(PasswordLogin.Password)); Console.WriteLine("Password is" + CommonFunctions.sha256_hash(PasswordLogin.Password)); SqlDataAdapter adapt = new SqlDataAdapter(cmd); // DataSet ds = new DataSet(); DataTable ds = new DataTable(); adapt.Fill(ds); if (ds.Rows.Count == 1) { // Dashboard fm = new Dashboard(); //fm.Show(); //int count = ds.Tables[0].Rows.Count; if (ds.Rows[0][0].ToString() == "Supervisor") { DashboardAdmin supervisorModule = new DashboardAdmin(); supervisorModule.Show(); } //UploadCSV uploadCsv = new UploadCSV(); //uploadCsv.uploadCsv(); else if (ds.Rows[0][0].ToString() == "Administrator") { DashboardAdmin dashboardAdmin = new DashboardAdmin(); dashboardAdmin.Show(); } else { MessageBox.Show("Invalid"); } } else { MessageBox.Show("Please check your Username and Password"); } } catch (Exception ex) { MessageBox.Show(ex.Message); Console.WriteLine(ex); } //connection should be closed finally { con.Close(); } }