Ejemplo n.º 1
0
 private void btnSave_Click(object sender, EventArgs e)
 {
     if (string.IsNullOrEmpty(txtAdi.Text) || string.IsNullOrEmpty(txtSoyadi.Text) || string.IsNullOrEmpty(txtTCNo.Text))
     {
         MessageBox.Show("Ad, Soyad ve TC girilmesi zorunludur.");
         return;
     }
     try
     {
         SqlCommand cmd = SqlBaglantisi.getCommand("select PatientID,Name,LastName from PatientInfo where TCNo=@no");
         cmd.Parameters.AddWithValue("@no", txtTCNo.Text.Trim());
         SqlDataReader dr = cmd.ExecuteReader();
         dr.Read();
         string name = dr.GetString(1);
         GlobalVariables.TCNo      = txtTCNo.Text;
         GlobalVariables.pName     = txtAdi.Text;
         GlobalVariables.pLastName = txtSoyadi.Text;
         MessageBox.Show("veri tabanında kayıtlıdır !");
         //PrgClass.Mesajor("Patient is exist in database !.");
         this.Close();
     }
     catch (Exception ex)
     {
         SqlCommand cmd1 = SqlBaglantisi.getCommand("insert into PatientInfo (TCNo,Name,LastName,History,DateOfInspection,GSM,Tel, Adres) values (@TCNo,@Name,@LastName,@History,@DateOfInspection,@GSM,@Tel, @Adres)");
         cmd1.Parameters.AddWithValue("@TCNo", txtTCNo.Text);
         cmd1.Parameters.AddWithValue("@Name", txtAdi.Text);
         cmd1.Parameters.AddWithValue("@LastName", txtSoyadi.Text);
         cmd1.Parameters.AddWithValue("@History", rtbGecmis.Text);
         cmd1.Parameters.AddWithValue("@DateOfInspection", DateTime.Now.ToString("yyyy-MM-dd"));
         cmd1.Parameters.AddWithValue("@GSM", txtGSM.Text);
         cmd1.Parameters.AddWithValue("@Tel", txtTel.Text);
         cmd1.Parameters.AddWithValue("@Adres", rtbAdres.Text);
         try
         {
             cmd1.ExecuteNonQuery();
             cmd1.Connection.Close();
             cmd1.Connection.Dispose();
             //PrgClass.Mesajor("The Process is completed !.");
             GlobalVariables.TCNo      = txtTCNo.Text;
             GlobalVariables.pName     = txtAdi.Text;
             GlobalVariables.pLastName = txtSoyadi.Text;
             //MessageBox.Show("işlem tamam!");
             veritabaniForm vtf = new patient_db.veritabaniForm();
             vtf.ShowDialog();
         }
         catch (Exception ex1)
         {
             throw ex1;
         }
     }
 }
Ejemplo n.º 2
0
 public void veri_getir()
 {
     try
     {
         SqlCommand cmd = SqlBaglantisi.getCommand("select * from PatientInfo");                
         SqlDataReader dr = cmd.ExecuteReader();
         DataTable dt = new DataTable();
         dt.Load(dr);
         dataGridView1.DataSource = dt;               
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }