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