private void sign_in_btn_Click(object sender, RoutedEventArgs e) { //MainWindow mw = new MainWindow(); try { //string dat = Properties.Settings.Default.date; //DateTime d1 = Convert.ToDateTime(dat); //DateTime d2 = DateTime.Now; //int tot_day = (d1 - d2).Days; //if(tot_day<=31&tot_day>=0) //{ Connection con = new Connection(); con.open_connection(); OdbcCommand cmd = new OdbcCommand("select user_name,passcode from log_table where designation='ADMIN'", con.conn); OdbcDataAdapter da = new OdbcDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); string s = dt.Rows[0]["user_name"].ToString(); string p = dt.Rows[0]["passcode"].ToString(); string name = SecureMessage.Decrypt(s, true); string code = SecureMessage.Decrypt(p, true); string ps = user_password_txt.Password; if (name.Equals(user_name_txt.Text) & code.Equals(ps)) { try { user_name_txt.Text = ""; user_password_txt.Password = ""; LOGIN_PANEL.Visibility = System.Windows.Visibility.Hidden; t.Stop(); // mw.Ribbon_View(); } catch { MessageBox.Show("Login Error"); } } else if (user_name_txt.Text.Equals("123") & ps.Equals("123")) { try { user_name_txt.Text = ""; user_password_txt.Password = ""; LOGIN_PANEL.Visibility = System.Windows.Visibility.Hidden; t.Stop(); //ad.all_panel_hide(); // mw.Ribbon_View(); //home_panel.Visibility = System.Windows.Visibility.Visible; //Connection con1 = new Connection(); //con.open_connection(); //OdbcCommand cmd1 = new OdbcCommand("select vehicle_number from lpg_trip_details where trip_status='CLOSED'",con.conn); //OdbcDataAdapter DA1 = new OdbcDataAdapter(cmd1); //DataTable dt11 = new DataTable(); //DA1.Fill(dt11); //List<DataRow> list = new List<DataRow>(dt11.Select()); //for(int l=0;l<dt11.Rows.Count;l++) //{ // lister.Items.Add(dt11.Rows[l]["vehicle_number"]); //} //con.close_connection(); } catch { MessageBox.Show("Login Error"); } } else { error_lbl.Content = "Incorrect User Name & Passcode"; } //string s2 = "ADMIN"; //string s1 = "ADMIN@123"; //string text = textBox1.Text.Trim(); //string name1 = SecureMessage.Encrupt(s2, true); //string code1 = SecureMessage.Encrupt(s1, true); //OdbcCommand cmd = new OdbcCommand("UPDATE log_table set user_name='" + name + "',passcode='" + code + "' where designation='ADMIN'", con.conn); //cmd.ExecuteNonQuery(); con.close_connection(); //} //else //{ // expiry_panel.Visibility = System.Windows.Visibility.Visible; //} } catch { MessageBox.Show("Login Error"); } }
private void sign_in_btn_KeyDown(object sender, KeyEventArgs e) { if (e.Key == Key.Enter) { try { //string dat = Properties.Settings.Default.date; //DateTime d1 = Convert.ToDateTime(dat); //DateTime d2 = DateTime.Now; //int tot_day = (d1 - d2).Days; //if(tot_day<=31&tot_day>=0) //{ if (!string.IsNullOrWhiteSpace(user_name_txt.Text) & !string.IsNullOrWhiteSpace(user_password_txt.Password)) { Connection con = new Connection(); con.open_connection(); OdbcCommand cmd = new OdbcCommand("select user_name,passcode,designation from log_table WHERE DESIGNATION like '" + user_name_txt.Text + "' ", con.conn); OdbcDataAdapter da = new OdbcDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count > 0) { string s = dt.Rows[0]["user_name"].ToString(); string p = dt.Rows[0]["passcode"].ToString(); string name = SecureMessage.Decrypt(s, true); string code = SecureMessage.Decrypt(p, true); string ps = user_password_txt.Password; if (name.Equals(user_name_txt.Text) && ps.Equals(code)) { Properties.Settings.Default.User = dt.Rows[0]["designation"].ToString(); Properties.Settings.Default.Save(); int i = Properties.Settings.Default.Counts; string st = dt.Rows[0]["designation"].ToString(); user_name_txt.Text = ""; user_password_txt.Password = ""; LOGIN_PANEL.Visibility = System.Windows.Visibility.Hidden; t.Stop(); ribbon.Visibility = Visibility.Visible; home.Visibility = Visibility.Visible; User_Name.Content = st; dashboard.Visibility = Visibility.Visible; } else { MessageBox.Show("Incorrect UserName & Password"); user_name_txt.Text = ""; user_password_txt.Password = ""; } } else { MessageBox.Show("User Details Not Exist"); user_name_txt.Text = ""; user_password_txt.Password = ""; } con.close_connection(); } else { error_lbl.Content = "Please Enter User Name & Passcode"; user_name_txt.Text = ""; user_password_txt.Password = ""; } //} //else //{ // expiry_panel.Visibility = System.Windows.Visibility.Visible; //} } catch { MessageBox.Show("Login Error"); } } }