//Insert
private void Btninsert_Click_1(object sender, EventArgs e)
{
string insertQuery = "INSERT INTO patient(p_name) " +
"VALUES('" + txtpname.Text + "')";
if (qs.executeQuery(insertQuery) == "T")
{
MessageBox.Show("Successfully Inserted!");
clearAll();
}
else
{
MessageBox.Show("Failed to Insert!");
MessageBox.Show(qs.executeQuery(insertQuery));
}
}
private void Btninsert_Click(object sender, EventArgs e)
{
if (cmbpatient.Text != "None" && cmbdoc.Text != "None")
{
string insertQuery = "INSERT INTO doctorpatient(e_id,p_id,treat) " +
"VALUES('" + cmbdoc.Text + "', '" + cmbpatient.Text + "', '" + txttreat.Text + "')";
if (qs.executeQuery(insertQuery) == "T")
{
MessageBox.Show("Successfully Inserted!");
clearAll();
}
else
{
MessageBox.Show("Failed to Insert!");
MessageBox.Show(qs.executeQuery(insertQuery));
}
}
else
{
MessageBox.Show("Please Select a Patient Number and Doctor Number");
}
}
//Insert
private void Btninsert_Click(object sender, EventArgs e)
{
if (cmbemptype.Text != "None")
{
string insertQuery = "INSERT INTO employee(e_name,salary,etype,dep_no,major) " +
"VALUES('" + txtempname.Text + "','" + txtempsal.Text + "', '" + cmbemptype.SelectedItem + "', '" + txtdepno.Text + "', '" + txtmajor.Text + "')";
if (qs.executeQuery(insertQuery) == "T")
{
MessageBox.Show("Successfully Inserted!");
clearAll();
}
else
{
MessageBox.Show("Failed to Insert!");
MessageBox.Show(qs.executeQuery(insertQuery));
}
}
else
{
MessageBox.Show("Please select an Employee Type!");
}
}
private void Btninsert_Click(object sender, EventArgs e)
{
if (cmbetype.Text != "None")
{
string insertQuery = "INSERT INTO useracc(e_id,pass,ustype) " +
"VALUES('" + txteid.Text + "','" + txtpass.Text + "','" + cmbetype.SelectedItem + "')";
if (qs.executeQuery(insertQuery) == "T")
{
MessageBox.Show("Successfully Inserted!");
clearAll();
}
else
{
MessageBox.Show("Failed to Insert!");
MessageBox.Show(qs.executeQuery(insertQuery));
}
}
else
{
MessageBox.Show("Please Set a User Type!");
}
}
//Insert
private void Btninsert_Click(object sender, EventArgs e)
{
if (cmbrtype.Text != "None")
{
string insertQuery = "INSERT INTO room(rtype) " +
"VALUES('" + cmbrtype.SelectedItem + "')";
if (qs.executeQuery(insertQuery) == "T")
{
MessageBox.Show("Successfully Inserted!");
clearAll();
}
else
{
MessageBox.Show("Failed to Insert!");
MessageBox.Show(qs.executeQuery(insertQuery));
}
}
else
{
MessageBox.Show("Please Select a Room Type");
}
}
//Insert
private void Btninsert_Click(object sender, EventArgs e)
{
if (cmbroom.Text != "None" && cmbpatient.Text != "None" && cmbdoc.Text != "None")
{
string insertQuery = "INSERT INTO appointment(a_date,r_no,p_id,e_id) " +
"VALUES('" + txtdate.Text + "','" + cmbroom.SelectedItem + "', '" + cmbpatient.SelectedItem + "', '" + cmbdoc.SelectedItem + "')";
if (qs.executeQuery(insertQuery) == "T")
{
MessageBox.Show("Successfully Inserted!");
clearAll();
}
else
{
MessageBox.Show("Failed to Insert!");
MessageBox.Show(qs.executeQuery(insertQuery));
}
}
else
{
MessageBox.Show("Please Set a Room Number, Patient ID and Doctor ID!");
}
}
//Insert
private void Btninsert_Click(object sender, EventArgs e)
{
if (cmbpatient.Text != "None")
{
string insertQuery = "INSERT INTO payment(amount,p_id) " +
"VALUES('" + txtamt.Text + "','" + cmbpatient.SelectedItem + "')";
if (qs.executeQuery(insertQuery) == "T")
{
MessageBox.Show("Successfully Inserted!");
clearAll();
}
else
{
MessageBox.Show("Failed to Insert!");
MessageBox.Show(qs.executeQuery(insertQuery));
}
}
else
{
MessageBox.Show("Please Set a Patient ID!");
}
}
//Insert Doctorrrom
private void Btninsert_Click(object sender, EventArgs e)
{
if (cmbrn.Text != "None")
{
string insertQuery1 = "INSERT INTO doctorroom(e_id,room_no) " +
"VALUES('" + txtdo.Text + "', '" + cmbrn.SelectedItem + "')";
if (qs.executeQuery(insertQuery1) == "T")
{
MessageBox.Show("Successfully Inserted!");
clearAll();
}
else
{
MessageBox.Show("Failed to Insert!");
MessageBox.Show(qs.executeQuery(insertQuery1));
}
}
else
{
MessageBox.Show("Please Select a Room Number");
}
}