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