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