private void typeButton_Click(object sender, RoutedEventArgs e)
{
GetStartedAsGydytojas getStartedDoc = Window.GetWindow(this) as GetStartedAsGydytojas;
getStartedDoc.scrollViewer.Width = 900;
getStartedDoc.itemPanel.Children.Clear();
getStartedDoc.PopulateWithUsers(Convert.ToString(typeLabel.Content));
}
////////////////////////////////////////////////////////////////////////
////////////////////LOGIN////////////////////////////////////////////
//////////////////////////////////////////////////////////////////
private void Button_Click(object sender, RoutedEventArgs e)
{
string uName = TxtName.Text;
string uPassword = TxtPass.Text;
string uGeneral = uName + "," + uPassword;
////////////////////LOGIN AND PASS TIKRINIMAS////////////////////////////////////////////
string conn = "C:\\Users\\s034240\\Desktop\\DB BRowser\\SQLiteDatabaseBrowserPortable\\Data\\Ligonine.db";
SQLiteConnection dbConection = new SQLiteConnection("Data Source=" + conn);
string sqlGydytojas = "select * from tbl_Gydytojas;";
string sqlPacientas = "select * from tbl_Pacientas;";
SQLiteCommand commandGydytojas = new SQLiteCommand(sqlGydytojas, dbConection);
SQLiteCommand commandPacientas = new SQLiteCommand(sqlPacientas, dbConection);
dbConection.Open();
// SQLiteDataReader reader = command.ExecuteReader();
// while (reader.Read()) { }
if (TxtName.Text == "")
{
MessageBox.Show("Please enter user name", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
TxtName.Focus();
return;
}
if (TxtPass.Text == "")
{
MessageBox.Show("Please enter Password", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
TxtName.Focus();
return;
}
try
{
person.PersonLoginInfo();
if (person.PersonLogin.Contains(uGeneral))
{
SQLiteDataReader readerGydytojas = commandGydytojas.ExecuteReader();
SQLiteDataReader readerPacientas = commandPacientas.ExecuteReader();
while (readerGydytojas.Read())
{
PersonData.Name = Convert.ToString(readerGydytojas[2]);
if (uName == PersonData.Name)
{
PersonData.User_Status = Convert.ToString(readerGydytojas[9]);
PersonData.Status = Convert.ToString(readerGydytojas[1]);
if (PersonData.User_Status == "Admin")
{
MessageBox.Show("WELCOME Admin: " + TxtName.Text + "!");
this.Hide();
GetStartedAsAdmin LogedInAdmin = new GetStartedAsAdmin();
LogedInAdmin.Show();
}
else if (PersonData.Status == "Gydytojas")
{
MessageBox.Show("WELCOME Gydytaju: " + TxtName.Text + "!");
this.Hide();
GetStartedAsGydytojas LogedInUserDoc = new GetStartedAsGydytojas();
LogedInUserDoc.Show();
}
/* if (PersonData.Status == "Pacientas")
* {
* MessageBox.Show("WELCOME Pacientas: " + TxtName.Text + "!");
* this.Hide();
* GetStartedAsPacientas LogedInUserPac = new GetStartedAsPacientas(TxtName.Text);
* LogedInUserPac.Show();
*
* }
*/
}
}
while (readerPacientas.Read())
{
PersonData.Name = Convert.ToString(readerPacientas[2]);
if (uName == PersonData.Name)
{
PersonData.User_Status = Convert.ToString(readerPacientas[9]);
PersonData.Status = Convert.ToString(readerPacientas[1]);
if (PersonData.User_Status == "Admin")
{
MessageBox.Show("WELCOME Admin: " + TxtName.Text + "!");
this.Hide();
GetStartedAsAdmin LogedInAdmin = new GetStartedAsAdmin();
LogedInAdmin.Show();
}
if (PersonData.Status == "Pacientas")
{
MessageBox.Show("WELCOME Pacientas: " + TxtName.Text + "!");
this.Hide();
GetStartedAsPacientas LogedInUserPac = new GetStartedAsPacientas(TxtName.Text);
LogedInUserPac.Show();
}
}
}
dbConection.Close();
}
else
{
MessageBox.Show("Login Failed.. Try again !", "Login Denied", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
catch (Exception ex)
{
MessageBox.Show(Convert.ToString(ex.LineNumber()) + " Line Eror ", "Login Denied", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
