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