private void button1_Click(object sender, EventArgs e)
{
BL.SelectData sel1 = new BL.SelectData();
DataTable dt1 = new DataTable();
dt1 = sel1.getpatientidarchif();
DataRow dr1 = dt1.Rows[0];
if (dataGridView1.Rows[0].Cells[0].Value == dr1["PId"])
{
}
else
{
BL.SelectData sel = new BL.SelectData();
DataTable dt = new DataTable();
BL.InsertData insert = new BL.InsertData();
// dt=sel.treatid(listBox1)
if (listBox1.Items.Count != 0)
{
foreach (string treat in listBox1.Items)
{
dt = sel.treatid(treat);
DataRow dr2 = dt.Rows[0];
insert.add_patient_treats(Convert.ToInt32(dataGridView1.Rows[0].Cells[0].Value), Convert.ToInt32(dr2["ID"].ToString()));
}
}
MessageBox.Show("add Successfuly");
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
if (adminradio.Checked)
{
type = "Admin";
}
else
{
type = "User";
}
BL.InsertData insert = new BL.InsertData();
insert.add_user(usertxt.Text, passtxt.Text, type);
MessageBox.Show("add successfuly");
usertxt.Clear();
passtxt.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void SaveBtn_Click(object sender, EventArgs e)
{
try {
if (kashf_rdiobtn.Checked)
{
visit_type = "كشف";
}
else
{
visit_type = "استشارة";
}
BL.SelectData sel = new BL.SelectData();
DataTable dt = new DataTable();
//dtp = selpat.get_Patientss();
//if (dtp.Rows.Count < 50)
//{
BL.InsertData insert_patientdata = new BL.InsertData();
dt = sel.get_Patientss();
DataRow dr = dt.Rows[0];
if (Idtxt.Text == dr["patientID"].ToString())
{
insert_patientdata.register_isteshara(Convert.ToInt32(Idtxt.Text), dateTimePicker1.Value.Date, visit_type);
MessageBox.Show("add successfuly");
}
else
{
insert_patientdata.add_patient(
Convert.ToInt32(Idtxt.Text),
Nametxt.Text,
Convert.ToInt32(Agetxt.Text),
gendercompobox.SelectedItem.ToString(),
phonenum.Text,
emailtxt.Text,
dateTimePicker1.Value.Date,
visit_type,
Convert.ToInt32(reversnum.Value.ToString()),
Convert.ToDecimal(costtxt.Text)
);
MessageBox.Show("add successfuly");
//////////////////////////////////////////////////////
Idtxt.Clear();
Nametxt.Clear();
Agetxt.Clear();
phonenum.Clear();
emailtxt.Clear();
}
// costtxt.Clear();
//}
//else
// MessageBox.Show("error =D");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button4_Click(object sender, EventArgs e)
{
BL.InsertData insert = new BL.InsertData();
insert.update_len_wit_stre(Convert.ToDecimal(dataGridView1.Rows[0].Cells[4].Value), Convert.ToDecimal(dataGridView1.Rows[0].Cells[5].Value), dataGridView1.Rows[0].Cells[6].Value.ToString());
MessageBox.Show("updated");
}
