private void FrmPatientDetail_Load(object sender, EventArgs e) { PTC.Text = tc; SqlCommand command = new SqlCommand("select PatientName, PatientSurname from Tbl_Patients where PatientTC =@p1", cnt.connect()); command.Parameters.AddWithValue("@p1", PTC.Text); SqlDataReader rdr = command.ExecuteReader(); while (rdr.Read()) { PNameS.Text = rdr[0] + " " + rdr[1]; } cnt.connect().Close(); getAppointments(); SqlCommand command2 = new SqlCommand("select BranchName from Tbl_Branches", cnt.connect()); SqlDataReader rdr2 = command2.ExecuteReader(); while (rdr2.Read()) { Branch.Items.Add(rdr2[0]); } cnt.connect().Close(); }
private void getData() { DataTable dt2 = new DataTable(); SqlDataAdapter da2 = new SqlDataAdapter("select * from Tbl_Branches", cnt.connect()); da2.Fill(dt2); dataGridView1.DataSource = dt2; }
private void FrmDoctorPanel_Load(object sender, EventArgs e) { getData(); SqlCommand command = new SqlCommand("select BranchName from Tbl_Branches", cnt.connect()); SqlDataReader rdr = command.ExecuteReader(); while (rdr.Read()) { DBranch.Items.Add(rdr[0]); } cnt.connect().Close(); }
private void BtnLogIn_Click(object sender, EventArgs e) { sql_Connection cnt = new sql_Connection(); SqlCommand command = new SqlCommand("select * from Tbl_Secretaries where SecretaryTC=@p1 and SecretaryPassword=@p2", cnt.connect()); command.Parameters.AddWithValue("@p1", STC.Text); command.Parameters.AddWithValue("@p2", SPassword.Text); SqlDataReader rdr = command.ExecuteReader(); if (rdr.Read()) { FrmSecretaryDetail fr = new FrmSecretaryDetail(); fr.tc = STC.Text; fr.Show(); this.Close(); } else { MessageBox.Show("TC no or Password is wrong...", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } cnt.connect().Close(); }
private void FrmDEditInfo_Load(object sender, EventArgs e) { DTC.Text = tc; SqlCommand command = new SqlCommand("select * from Tbl_Doctors where DoctorTC=@p1", cnt.connect()); command.Parameters.AddWithValue("@p1", tc); SqlDataReader rdr = command.ExecuteReader(); while (rdr.Read()) { Dname.Text = rdr[0].ToString(); DSurname.Text = rdr[1].ToString(); DBranch.Text = rdr[2].ToString(); DPassword.Text = rdr[4].ToString(); } cnt.connect().Close(); }
public void getBranchTbl() { DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter("select * from Tbl_Branches", cnt.connect()); da.Fill(dt); dataGridView1.DataSource = dt; }
private void FrmPEditInfo_Load(object sender, EventArgs e) { sql_Connection cnt = new sql_Connection(); SqlCommand command = new SqlCommand("select * from Tbl_Patients where PatientTC='" + TCno + "'", cnt.connect()); SqlDataReader rdr = command.ExecuteReader(); while (rdr.Read()) { PTC.Text = rdr[0].ToString(); Pname.Text = rdr[1].ToString(); PSurname.Text = rdr[2].ToString(); PTel.Text = rdr[3].ToString(); PPassword.Text = rdr[4].ToString(); PGender.Text = rdr[5].ToString(); } cnt.connect().Close(); }
private void BtnRegister_Click(object sender, EventArgs e) { SqlCommand command = new SqlCommand("insert into Tbl_Patients( PatientTC,PatientName, PatientSurname, PatientNo, PatientPassword, PatientGender) values (@p1, @p2, @p3, @p4, @p5, @p6)", cnt.connect()); SqlCommand control = new SqlCommand("select PatientTC"); foreach (var tcno in control.Parameters) { if (tcno.Equals(PTC.Text)) { isInclude = true; break; } } if (!isInclude) { try { command.Parameters.AddWithValue("@p1", PTC.Text); command.Parameters.AddWithValue("@p2", Pname.Text); command.Parameters.AddWithValue("@p3", PSurname.Text); command.Parameters.AddWithValue("@p4", PTel.Text); command.Parameters.AddWithValue("@p5", PPassword.Text); command.Parameters.AddWithValue("@p6", PGender.SelectedItem); command.ExecuteNonQuery(); cnt.connect().Close(); MessageBox.Show("Registration is succesfull. ", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } catch (SqlException exception) { if (exception.Number == 2627) { MessageBox.Show("TC No must be unique", "Registration Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception exception) { MessageBox.Show("Values cannot be null!..", "Registration Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void FrmDoctorDetail_Load(object sender, EventArgs e) { DTC.Text = tc; SqlCommand command = new SqlCommand("select DoctorName, DoctorSurname from Tbl_Doctors where DoctorTC =@p1", cnt.connect()); command.Parameters.AddWithValue("@p1", DTC.Text); SqlDataReader rdr = command.ExecuteReader(); while (rdr.Read()) { DNameS.Text = rdr[0] + " " + rdr[1]; } cnt.connect().Close(); DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter("select * from Tbl_Appointments where AppointmentDoctor='" + DNameS.Text + "'", cnt.connect()); da.Fill(dt); dataGridView1.DataSource = dt; }
private void BtnLogIn_Click(object sender, EventArgs e) { SqlCommand command = new SqlCommand("Select * From Tbl_Patients Where PatientTC=@p1 and PatientPassword=@p2", cnt.connect()); command.Parameters.AddWithValue("@p1", PTC.Text); command.Parameters.AddWithValue("@p2", PPassword.Text); SqlDataReader rdr = command.ExecuteReader(); if (rdr.Read()) { FrmPatientDetail fr = new FrmPatientDetail(); fr.tc = PTC.Text; fr.ShowDialog(); this.Close(); } else { MessageBox.Show("Patient TC or Password is wrong...", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } cnt.connect().Close(); }
private void BtnEdit_Click(object sender, EventArgs e) { sql_Connection cnt = new sql_Connection(); SqlCommand command = new SqlCommand("update Tbl_Patients set PatientName=@p1, PatientSurname=@p2, PatientNo=@p4, PatientPassword=@p5, PatientGender=@p6 where PatientTC=@p3", cnt.connect()); if (Pname.Text.Equals("") | PSurname.Text.Equals("") | PTel.Text.Equals("") | PPassword.Text.Equals("") | PGender.Text.Equals("")) { MessageBox.Show("Please fill the blanks...", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { command.Parameters.AddWithValue("@p1", Pname.Text); command.Parameters.AddWithValue("@p2", PSurname.Text); command.Parameters.AddWithValue("@p4", PTel.Text); command.Parameters.AddWithValue("@p5", PPassword.Text); command.Parameters.AddWithValue("@p6", PGender.Text); command.ExecuteNonQuery(); cnt.connect().Close(); MessageBox.Show("Your information was updated...", "Information", MessageBoxButtons.OK); } }
private void FrmAnnouncements_Load(object sender, EventArgs e) { DataTable dt2 = new DataTable(); SqlDataAdapter da2 = new SqlDataAdapter("select * from Tbl_Announcements", cnt.connect()); da2.Fill(dt2); dataGridView1.DataSource = dt2; }