public void display()
{
SQLiteConnection sqlite_conn;
SQLiteCommand sqlite_cmd;
//SQLiteDataReader sqlite_datareader;
Receptionists A2 = new Receptionists();
sqlite_conn = new SQLiteConnection("Data Source=ReceptionistLogin.db;Version=3;Compress=True;");
sqlite_conn.Open();
sqlite_cmd = sqlite_conn.CreateCommand();
sqlite_cmd.CommandText = "SELECT Username FROM Login where Username='******' and Password='******'";
sqlite_cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SQLiteDataAdapter da = new SQLiteDataAdapter(sqlite_cmd);
da.Fill(dt);
dataGridView1.DataSource = dt;
sqlite_conn.Close();
}
private void button4_Click(object sender, EventArgs e)
{
var result = MessageBox.Show("Do you want to delete your account ? After pressing yes you will be logout from account and your account will be remove!", "Delete Account", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (result == DialogResult.Yes)
{
Receptionists A1 = new Receptionists();
SQLiteConnection sqlite_conn;
SQLiteCommand sqlite_cmd;
SQLiteDataReader sqlite_dataread;
SQLiteConnection sqlite_conn1;
SQLiteCommand sqlite_cmd1;
sqlite_conn = new SQLiteConnection("Data Source=ReceptionistLogin.db;Version=3;Compress=True;");
sqlite_conn.Open();
sqlite_cmd = sqlite_conn.CreateCommand();
sqlite_cmd.CommandText = "Select * from Login where Username='******' and Password='******'";
sqlite_dataread = sqlite_cmd.ExecuteReader();
if (sqlite_dataread.Read())
{
sqlite_conn.Close();
sqlite_conn1 = new SQLiteConnection("Data Source=ReceptionistLogin.db;Version=3;Compress=True;");
sqlite_conn1.Open();
sqlite_cmd1 = sqlite_conn1.CreateCommand();
sqlite_cmd1.CommandText = "Delete from Login where Username='******' and Password='******'";
sqlite_cmd1.ExecuteNonQuery();
sqlite_conn1.Close();
i = 1;
this.Hide();
this.Close();
}
else
{
i = 0;
sqlite_conn.Close();
MessageBox.Show("Username and Password is incorrect!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
private void button1_Click(object sender, EventArgs e)
{
Receptionists A1 = new Receptionists();
SQLiteConnection sqlite_conn;
SQLiteConnection sqlite_conn1;
SQLiteCommand sqlite_cmd;
SQLiteCommand sqlite_cmd1;
SQLiteDataReader sqlite_datareader;
//SQLiteDataReader sqlite_datareader1;
sqlite_conn = new SQLiteConnection("Data Source=ReceptionistLogin.db;Version=3;Compress=True;");
sqlite_conn.Open();
sqlite_cmd = sqlite_conn.CreateCommand();
sqlite_cmd.CommandText = "select * from Login where Password ='******'";
sqlite_datareader = sqlite_cmd.ExecuteReader();
if (sqlite_datareader.Read())
{
string a1 = sqlite_datareader.GetString(0);
sqlite_conn.Close();
sqlite_conn1 = new SQLiteConnection("Data Source=ReceptionistLogin.db;Version=3;Compress=True;");
sqlite_conn1.Open();
sqlite_cmd1 = sqlite_conn1.CreateCommand();
sqlite_cmd1.CommandText = "Update Login SET Password='******' where Password='******'";
sqlite_cmd1.ExecuteNonQuery();
A1.SetData(a1, textBox3.Text);
sqlite_conn1.Close();
MessageBox.Show("Password Update");
}
else
{
sqlite_conn.Close();
MessageBox.Show("Can't Update Password!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void button3_Click(object sender, EventArgs e)
{
SQLiteConnection sqlite_conn;
SQLiteCommand sqlite_cmd;
SQLiteDataReader sqlite_datareader;
if (!File.Exists("ReceptionistLogin.db"))
{
sqlite_conn = new SQLiteConnection("Data Source=ReceptionistLogin.db;Version=3;New=True;Compress=True;");
sqlite_conn.Open();
sqlite_cmd = sqlite_conn.CreateCommand();
sqlite_cmd.CommandText = "CREATE TABLE Login (Username varchar2 (100) NOT NULL UNIQUE, Password varchar2 (100));";
sqlite_cmd.ExecuteNonQuery();
sqlite_cmd.CommandText = "INSERT INTO Login (Username,Password) VALUES ('aqibahmed60', 'abcabc');";
sqlite_cmd.ExecuteNonQuery();
sqlite_cmd.CommandText = "INSERT INTO Login (Username,Password) VALUES ('ossaidahmed', '1234');";
sqlite_cmd.ExecuteNonQuery();
sqlite_cmd.CommandText = "INSERT INTO Login (Username,Password) VALUES ('HafizHarisAlam', 'otaku');";
sqlite_cmd.ExecuteNonQuery();
sqlite_cmd.CommandText = "SELECT * FROM Login where Username='******'and Password='******'";
sqlite_datareader = sqlite_cmd.ExecuteReader();
Receptionists R10 = new Receptionists();
R10.SetData(textBox1.Text, textBox2.Text);
if (sqlite_datareader.Read())
{
sqlite_conn.Close();
Billing_DB();
this.Hide();
Receptionist R1 = new Receptionist();
R1.ShowDialog();
LoginForm L1 = new LoginForm();
L1.ShowDialog();
}
else
{
MessageBox.Show("Invalid Login", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Warning);
textBox1.Clear();
textBox2.Clear();
}
sqlite_conn.Close();
}
else
{
sqlite_conn = new SQLiteConnection("Data Source=ReceptionistLogin.db;Version=3;Compress=True;");
sqlite_conn.Open();
sqlite_cmd = sqlite_conn.CreateCommand();
sqlite_cmd.CommandText = "SELECT * FROM Login where Username='******'and Password='******'";
Receptionists R10 = new Receptionists();
R10.SetData(textBox1.Text, textBox2.Text);
sqlite_datareader = sqlite_cmd.ExecuteReader();
if (sqlite_datareader.Read())
{
this.Hide();
sqlite_conn.Close();
Receptionist R1 = new Receptionist();
R1.ShowDialog();
LoginForm L1 = new LoginForm();
L1.ShowDialog();
}
else
{
MessageBox.Show("Invalid Login", "Login Alert", MessageBoxButtons.OK, MessageBoxIcon.Warning);
textBox1.Clear();
textBox2.Clear();
}
sqlite_conn.Close();
}
}
private void button2_Click(object sender, EventArgs e)
{
Receptionists A1 = new Receptionists();
if (string.IsNullOrWhiteSpace(textBox2.Text) || string.IsNullOrWhiteSpace(textBox5.Text))
{
MessageBox.Show("Please fill the missing field !", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
SQLiteConnection sqlite_conn;
SQLiteCommand sqlite_cmd;
SQLiteDataReader sqlite_dataread;
SQLiteConnection sqlite_conn1;
SQLiteCommand sqlite_cmd1;
SQLiteDataReader sqlite_dataread1;
SQLiteConnection sqlite_conn2;
SQLiteCommand sqlite_cmd2;
sqlite_conn = new SQLiteConnection("Data Source=ReceptionistLogin.db;Version=3;Compress=True;");
sqlite_conn.Open();
sqlite_cmd = sqlite_conn.CreateCommand();
sqlite_cmd.CommandText = "Select * from Login where Username='******' and Password='******'";
sqlite_dataread = sqlite_cmd.ExecuteReader();
if (sqlite_dataread.Read())
{
sqlite_conn.Close();
sqlite_conn1 = new SQLiteConnection("Data Source=ReceptionistLogin.db;Version=3;Compress=True;");
sqlite_conn1.Open();
sqlite_cmd1 = sqlite_conn1.CreateCommand();
sqlite_cmd1.CommandText = "select * from Login where Username='******'"; //UserName Verification
sqlite_dataread1 = sqlite_cmd1.ExecuteReader();
if (!sqlite_dataread1.Read())
{
sqlite_conn1.Close();
sqlite_conn2 = new SQLiteConnection("Data Source=ReceptionistLogin.db;Version=3;Compress=True;");
sqlite_conn2.Open();
sqlite_cmd2 = sqlite_conn2.CreateCommand();
sqlite_cmd2.CommandText = "Update Login set Username='******' where Username='******' and Password='******'";
sqlite_cmd2.ExecuteNonQuery();
sqlite_conn2.Close();
A1.SetData(textBox2.Text, textBox5.Text);
display();
MessageBox.Show("Username Update", "UPDATE", MessageBoxButtons.OK, MessageBoxIcon.Information);
textBox2.Clear();
textBox5.Clear();
}
else
{
MessageBox.Show("Username can not be Update", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Information);
textBox2.Clear();
textBox5.Clear();
sqlite_conn1.Close();
}
/*sqlite_cmd1.CommandText = "Update Login set Username='******' where Username='******' and Password='******'";
* sqlite_cmd1.ExecuteNonQuery();
* sqlite_conn1.Close();
*/
}
else
{
sqlite_conn.Close();
MessageBox.Show("Invalid Password ! Username can not be update", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Warning);
textBox2.Clear();
textBox5.Clear();
}
}
}
