Burak HABER / C# / Hastane Projesi
FrmBilgiDüzenle.cs
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace Proje_Hastane
{
public partial class FrmBilgiDuzenle : Form
{
public FrmBilgiDuzenle()
{
InitializeComponent();
}
public string TCno;
sqlbaglantisi bgl = new sqlbaglantisi();
private void FrmBilgiDuzenle_Load(object sender, EventArgs e)
{
MskTc.Text = TCno;
SqlCommand komut = new SqlCommand("select * From tbl_hastalar where HastaTC=@p1", bgl.baglanti());
komut.Parameters.AddWithValue("@p1", MskTc.Text);
SqlDataReader dr = komut.ExecuteReader();
while (dr.Read())
{
TxtAd.Text = dr[1].ToString();
TxtSoyad.Text = dr[2].ToString();
MskTel.Text = dr[4].ToString();
TxtSifre.Text = dr[5].ToString();
CmbCinsiyet.Text = dr[6].ToString();
}
bgl.baglanti().Close();
}
private void BtnBilgiGuncelle_Click(object sender, EventArgs e)
{
SqlCommand komut2 = new SqlCommand("Update tbl_hastalar set HastaAd=@p1,HastaSoyad=@p2,HastaTelefon=@p3,HastaSifre=@p4,HastaCinsiyet=@p5 where HastaTc=@p6", bgl.baglanti());
komut2.Parameters.AddWithValue("@p1", TxtAd.Text);
komut2.Parameters.AddWithValue("@p2", TxtSoyad.Text);
komut2.Parameters.AddWithValue("@p3", MskTel.Text);
komut2.Parameters.AddWithValue("@p4", TxtSifre.Text);
komut2.Parameters.AddWithValue("@p5", CmbCinsiyet.Text);
komut2.Parameters.AddWithValue("@p6", MskTc.Text);
komut2.ExecuteNonQuery();//update uygulamasında çalışır.
bgl.baglanti().Close();
MessageBox.Show("Bilgileriniz Güncellendi", "Bilgi", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
FrmBrans.cs
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace Proje_Hastane
{
public partial class FrmBrans : Form
{
public FrmBrans()
{
InitializeComponent();
}
sqlbaglantisi bgl = new sqlbaglantisi();
private void FrmBrans_Load(object sender, EventArgs e)
{
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter("select * from tbl_branslar", bgl.baglanti());
da.Fill(dt);
dataGridView1.DataSource = dt;
}
private void BtnEkle_Click(object sender, EventArgs e)
{
SqlCommand komut = new SqlCommand("insert into tbl_branslar (bransad) values (@b1)", bgl.baglanti());
komut.Parameters.AddWithValue("@b1", TxtBrans.Text);
komut.ExecuteNonQuery();
bgl.baglanti().Close();
MessageBox.Show("Branş Eklendi", "Bilgi", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
int secilen = dataGridView1.SelectedCells[0].RowIndex;
Txtİd.Text = dataGridView1.Rows[secilen].Cells[0].Value.ToString();
TxtBrans.Text = dataGridView1.Rows[secilen].Cells[1].Value.ToString();
}
private void BtnSil_Click(object sender, EventArgs e)
{
SqlCommand komut = new SqlCommand("delete from tbl_branslar where bransid=@b1", bgl.baglanti());
komut.Parameters.AddWithValue("@b1", Txtİd.Text);
komut.ExecuteNonQuery();
bgl.baglanti().Close();
MessageBox.Show("Branş Silindi");
}
private void BtnGuncelle_Click(object sender, EventArgs e)
{
SqlCommand komut = new SqlCommand("update tbl_branslar set bransad=@p1 where bransid=@p2", bgl.baglanti());
komut.Parameters.AddWithValue("@p1", TxtBrans.Text);
komut.Parameters.AddWithValue("@p2", Txtİd.Text);
komut.ExecuteNonQuery();
bgl.baglanti().Close();
MessageBox.Show("Branş Güncellendi");
}
}
}
FrmDoktorBilgiDüzenle.cs
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace Proje_Hastane
{
public partial class FrmDoktorBilgiDuzenle : Form
{
public FrmDoktorBilgiDuzenle()
{
InitializeComponent();
}
sqlbaglantisi bgl = new sqlbaglantisi();
public string TCNO;
private void FrmDoktorBilgiDuzenle_Load(object sender, EventArgs e)
{
MskTc.Text = TCNO;
SqlCommand komut = new SqlCommand("Select * from tbl_doktorlar where doktorTc=@p1", bgl.baglanti());
komut.Parameters.AddWithValue("@p1", MskTc.Text);
SqlDataReader dr = komut.ExecuteReader();
while (dr.Read())
{
TxtAd.Text = dr[1].ToString();
TxtSoyad.Text = dr[2].ToString();
CmbBrans.Text = dr[3].ToString();
TxtSifre.Text = dr[5].ToString();
}
bgl.baglanti().Close();
}
private void BtnBilgiGuncelle_Click(object sender, EventArgs e)
{
SqlCommand komut = new SqlCommand("Update Tbl_doktorlar set doktorad=@p1,doktorsoyad=@p2,DoktorBrans=@p3,DoktorSifre=@p4 Where DoktorTc=@p5", bgl.baglanti());
komut.Parameters.AddWithValue("@p1", TxtAd.Text);
komut.Parameters.AddWithValue("@p2", TxtSoyad.Text);
komut.Parameters.AddWithValue("@p3", CmbBrans.Text);
komut.Parameters.AddWithValue("@p4", TxtSifre.Text);
komut.Parameters.AddWithValue("@p5", MskTc.Text);
komut.ExecuteNonQuery();
bgl.baglanti().Close();
MessageBox.Show("Kayıt Güncellendi");
}
}
}
Frmdoktordetay.cs
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace Proje_Hastane
{
public partial class FrmDoktorDetay : Form
{
public FrmDoktorDetay()
{
InitializeComponent();
}
sqlbaglantisi bgl = new sqlbaglantisi();
public string TC;
private void FrmDoktorDetay_Load(object sender, EventArgs e)
{
LblTC.Text = TC;
//Doktor ad soyad
SqlCommand komut = new SqlCommand("select doktorad,doktorsoyad from tbl_doktorlar where doktortc=@p1", bgl.baglanti());
komut.Parameters.AddWithValue("@p1", LblTC.Text);
SqlDataReader dr = komut.ExecuteReader();
while (dr.Read())
{
LblAdSoyad.Text = dr[0] + " " + dr[1];
}
bgl.baglanti().Close();
//Randevular
DataTable dt = new DataTable();
string sqlText = "";
SqlDataAdapter da = new SqlDataAdapter("Select * from tbl_randevular where randevudoktor='" + LblAdSoyad.Text + "'", bgl.baglanti());
da.Fill(dt);
dataGridView1.DataSource = dt;
}
private void BtnGuncelle_Click(object sender, EventArgs e)
{
FrmDoktorBilgiDuzenle fr = new FrmDoktorBilgiDuzenle();
fr.TCNO = LblTC.Text;
fr.Show();
}
private void BtnDuyurular_Click(object sender, EventArgs e)
{
FrmDuyurular fr = new FrmDuyurular();
fr.Show();
}
private void BtnCikis_Click(object sender, EventArgs e)
{
Application.Exit();
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
int secilen = dataGridView1.SelectedCells[0].RowIndex;
RchSikayet.Text = dataGridView1.Rows[secilen].Cells[7].Value.ToString();
}
}
}
FrmDoktorGiris.cs
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace Proje_Hastane
{
public partial class FrmDoktorGiris : Form
{
public FrmDoktorGiris()
{
InitializeComponent();
}
sqlbaglantisi bgl = new sqlbaglantisi();
private void BtnGirisYap_Click(object sender, EventArgs e)
{
SqlCommand komut = new SqlCommand("Select * from tbl_doktorlar where doktortc=@p1 and doktorsifre=@p2", bgl.baglanti());
komut.Parameters.AddWithValue("@p1", MskTc.Text);
komut.Parameters.AddWithValue("@p2", TxtSifre.Text);
SqlDataReader dr = komut.ExecuteReader();
if (dr.Read())
{
FrmDoktorDetay fr = new FrmDoktorDetay();
fr.TC = MskTc.Text;
fr.Show();
this.Hide();
}
else
{
MessageBox.Show("Hatalı kullanıcı adı veya şifre");
}
bgl.baglanti().Close();
}
private void FrmDoktorGiris_Load(object sender, EventArgs e)
{
}
}
}
FrmDoktorPaneli.cs
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace Proje_Hastane
{
public partial class FrmDoktorPaneli : Form
{
public FrmDoktorPaneli()
{
InitializeComponent();
}
sqlbaglantisi bgl = new sqlbaglantisi();
private void FrmDoktorPaneli_Load(object sender, EventArgs e)
{
DataTable dt1 = new DataTable();
SqlDataAdapter da1 = new SqlDataAdapter("select * From Tbl_Doktorlar", bgl.baglanti());
da1.Fill(dt1);
dataGridView1.DataSource = dt1;
//branşları comboboxa aktarma
SqlCommand komut2 = new SqlCommand("Select BransAd from tbl_branslar", bgl.baglanti());
SqlDataReader dr2 = komut2.ExecuteReader();
while (dr2.Read())
{
CmbBrans.Items.Add(dr2[0]);
}
bgl.baglanti().Close();
}
private void BtnEkle_Click(object sender, EventArgs e)
{
SqlCommand komut = new SqlCommand("insert into tbl_doktorlar (DoktorAd,DoktorSoyad,DoktorBrans,DoktorTC,DoktorSifre) values (@d1,@d2,@d3,@d4,@d5)", bgl.baglanti());
komut.Parameters.AddWithValue("@d1", TxtAd.Text);
komut.Parameters.AddWithValue("@d2", TxtSoyad.Text);
komut.Parameters.AddWithValue("@d3", CmbBrans.Text);
komut.Parameters.AddWithValue("@d4", MskTC.Text);
komut.Parameters.AddWithValue("@d5", TxtSifre.Text);
komut.ExecuteNonQuery();
bgl.baglanti().Close();
MessageBox.Show("Doktor Eklendi", "Bilgi", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
int secilen = dataGridView1.SelectedCells[0].RowIndex;
TxtAd.Text = dataGridView1.Rows[secilen].Cells[1].Value.ToString();
TxtSoyad.Text = dataGridView1.Rows[secilen].Cells[2].Value.ToString();
CmbBrans.Text = dataGridView1.Rows[secilen].Cells[3].Value.ToString();
MskTC.Text = dataGridView1.Rows[secilen].Cells[4].Value.ToString();
TxtSifre.Text = dataGridView1.Rows[secilen].Cells[5].Value.ToString();
}
private void BtnSil_Click(object sender, EventArgs e)
{
SqlCommand komut = new SqlCommand("Delete from tbl_doktorlar where DoktorTc=@p1", bgl.baglanti());
komut.Parameters.AddWithValue("@p1", MskTC.Text);
komut.ExecuteNonQuery();
bgl.baglanti().Close();
MessageBox.Show("Kayıt Silindi", "Uyarı", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
private void BtnGuncelle_Click(object sender, EventArgs e)
{
SqlCommand komut = new SqlCommand("Update tbl_doktorlar set Doktorad=@d1,Doktorsoyad=@d2,DoktorBrans=@d3,Doktorsifre=@d5 where DoktorTc=@d4", bgl.baglanti());
komut.Parameters.AddWithValue("@d1", TxtAd.Text);
komut.Parameters.AddWithValue("@d2", TxtSoyad.Text);
komut.Parameters.AddWithValue("@d3", CmbBrans.Text);
komut.Parameters.AddWithValue("@d4", MskTC.Text);
komut.Parameters.AddWithValue("@d5", TxtSifre.Text);
komut.ExecuteNonQuery();
bgl.baglanti().Close();
MessageBox.Show("Doktor Güncellendi", "Bilgi", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
FrmDuyurular.cs
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace Proje_Hastane
{
public partial class FrmDuyurular : Form
{
public FrmDuyurular()
{
InitializeComponent();
}
sqlbaglantisi bgl = new sqlbaglantisi();
private void FrmDuyurular_Load(object sender, EventArgs e)
{
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter("select * from tbl_duyurular", bgl.baglanti());
da.Fill(dt);
dataGridView1.DataSource = dt;
}
}
}
FrmGirisler.cs
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace Proje_Hastane
{
public partial class FrmGirisler : Form
{
public FrmGirisler()
{
InitializeComponent();
}
private void BtnHastaGiris_Click(object sender, EventArgs e)
{
FrmHastaGiris fr = new FrmHastaGiris();
fr.Show();
this.Hide();
}
private void BtnDoktorGiris_Click(object sender, EventArgs e)
{
FrmDoktorGiris fr = new FrmDoktorGiris();
fr.Show();
this.Hide();
}
private void BtnSekreterGiris_Click(object sender, EventArgs e)
{
FrmSekreterGiris fr = new FrmSekreterGiris();
fr.Show();
this.Hide();
}
private void FrmGirisler_Load(object sender, EventArgs e)
{
}
}
}
FrmHastaDetay.cs
using System;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Data;
namespace Proje_Hastane
{
public partial class FrmHastaDetay : Form
{
public FrmHastaDetay()
{
InitializeComponent();
}
public string tc;
sqlbaglantisi bgl = new sqlbaglantisi();
private void FrmHastaDetay_Load(object sender, EventArgs e)
{
LblTC.Text = tc;
//Ad Soyad Çekme
SqlCommand komut = new SqlCommand("Select HastaAd,HastaSoyad From Tbl_Hastalar where HastaTC=@p1", bgl.baglanti());
komut.Parameters.AddWithValue("@p1", LblTC.Text);
SqlDataReader dr = komut.ExecuteReader();
while (dr.Read())
{
LblAdSoyad.Text = dr[0] + " " + dr[1];
}
bgl.baglanti().Close();
//Randevu Geçmişi
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter("Select * From Tbl_Randevular where HastaTc=" + tc, bgl.baglanti());
da.Fill(dt);
dataGridView1.DataSource = dt;
//Branşları Çekme
SqlCommand komut2 = new SqlCommand("Select BransAd From Tbl_branslar", bgl.baglanti());
SqlDataReader dr2 = komut2.ExecuteReader();
while (dr2.Read())
{
CmbBrans.Items.Add(dr2[0]);
}
bgl.baglanti().Close();
}
private void CmbBrans_SelectedIndexChanged(object sender, EventArgs e)
{
CmbDoktor.Items.Clear();
SqlCommand komut3 = new SqlCommand("Select DoktorAd,DoktorSoyad From Tbl_Doktorlar where DoktorBrans=@p1", bgl.baglanti());
komut3.Parameters.AddWithValue("@p1", CmbBrans.Text);
SqlDataReader dr3 = komut3.ExecuteReader();
while (dr3.Read())
{
CmbDoktor.Items.Add(dr3[0] + " " + dr3[1]);
}
bgl.baglanti().Close();
}
private void CmbDoktor_SelectedIndexChanged(object sender, EventArgs e)
{
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter("select * from tbl_randevular where RandevuBrans='" + CmbBrans.Text + "'" + " and RandevuDoktor='"+CmbDoktor.Text+"'and randevuDurum=0", bgl.baglanti());
da.Fill(dt);
dataGridView2.DataSource = dt;
}
private void LnkBilgiDuzenle_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
FrmBilgiDuzenle fr = new FrmBilgiDuzenle();
fr.TCno = LblTC.Text;
fr.Show();
}
private void dataGridView2_CellClick(object sender, DataGridViewCellEventArgs e)
{
int secilen = dataGridView2.SelectedCells[0].RowIndex;
Txtid.Text = dataGridView2.Rows[secilen].Cells[0].Value.ToString();
}
private void BtnRandevuAl_Click(object sender, EventArgs e)
{
SqlCommand komut = new SqlCommand("Update tbl_randevular set randevuDurum=1,HastaTc=@p1,HastaSikayet=@p2 where randevuid=@p3", bgl.baglanti());
komut.Parameters.AddWithValue("@p1", LblTC.Text);
komut.Parameters.AddWithValue("@p2", RchSikayet.Text);
komut.Parameters.AddWithValue("@p3", Txtid.Text);
komut.ExecuteNonQuery();
bgl.baglanti().Close();
MessageBox.Show("Randevu Alındı", "Uyarı", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
FrmHastaGiris.cs
using System;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace Proje_Hastane
{
public partial class FrmHastaGiris : Form
{
public FrmHastaGiris()
{
InitializeComponent();
}
sqlbaglantisi bgl = new sqlbaglantisi();
private void LnkUye_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
FrmHastaKayit fr = new FrmHastaKayit();
fr.Show();
}
private void BtnGirisYap_Click(object sender, EventArgs e)
{
SqlCommand komut = new SqlCommand("Select * From Tbl_Hastalar Where HastaTC=@p1 and HastaSifre=@p2", bgl.baglanti());
komut.Parameters.AddWithValue("@p1", MskTc.Text);
komut.Parameters.AddWithValue("@p2", TxtSifre.Text);
SqlDataReader dr = komut.ExecuteReader();
if (dr.Read())
{
FrmHastaDetay fr = new FrmHastaDetay();
fr.tc = MskTc.Text;
fr.Show();
this.Hide();
}
else
{
MessageBox.Show("Hatalı TC & Şifre");
}
bgl.baglanti().Close();
}
private void FrmHastaGiris_Load(object sender, EventArgs e)
{
}
}
}
FrmHastaKayit.cs
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace Proje_Hastane
{
public partial class FrmHastaKayit : Form
{
public FrmHastaKayit()
{
InitializeComponent();
}
sqlbaglantisi bgl = new sqlbaglantisi();
private void BtnKayitYap_Click(object sender, EventArgs e)
{
SqlCommand komut = new SqlCommand("insert into Tbl_Hastalar (HastaAd,HastaSoyad,HastaTC,HastaTelefon,HastaSifre,HastaCinsiyet) values (@p1,@p2,@p3,@p4,@p5,@p6)", bgl.baglanti());
komut.Parameters.AddWithValue("@p1", TxtAd.Text);
komut.Parameters.AddWithValue("@p2", TxtSoyad.Text);
komut.Parameters.AddWithValue("@p3", MskTc.Text);
komut.Parameters.AddWithValue("@p4", MskTelefon.Text);
komut.Parameters.AddWithValue("@p5", TxtSifre.Text);
komut.Parameters.AddWithValue("@p6", CmbCinsiyet.Text);
komut.ExecuteNonQuery();
bgl.baglanti().Close();
MessageBox.Show("Kaydınız Gerçekleşmiştir Şifreniz:" + TxtSifre.Text,"Bilgi",MessageBoxButtons.OK,MessageBoxIcon.Information);
}
private void FrmHastaKayit_Load(object sender, EventArgs e)
{
}
}
}
FrmRandevuListesi.cs
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace Proje_Hastane
{
public partial class FrmRandevuListesi : Form
{
public FrmRandevuListesi()
{
InitializeComponent();
}
sqlbaglantisi bgl = new sqlbaglantisi();
private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
}
private void FrmRandevuListesi_Load(object sender, EventArgs e)
{
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter("select * from tbl_randevular", bgl.baglanti());
da.Fill(dt);
dataGridView1.DataSource = dt;
}
}
}
FrmSekreterDetay.cs
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Data;
namespace Proje_Hastane
{
public partial class FrmSekreterDetay : Form
{
public FrmSekreterDetay()
{
InitializeComponent();
}
public string TCnumara;
public string secilen;
sqlbaglantisi bgl = new sqlbaglantisi();
private void FrmSekreterDetay_Load(object sender, EventArgs e)
{
LblTC.Text = TCnumara;
Txtid.Text = secilen;
//Ad Soyad
SqlCommand komut1 = new SqlCommand("Select SekreterAdSoyad From Tbl_Sekreter where sekretertc=@p1", bgl.baglanti());
komut1.Parameters.AddWithValue("@p1", LblTC.Text);
SqlDataReader dr1 = komut1.ExecuteReader();
while (dr1.Read())
{
LblAdSoyad.Text = dr1[0].ToString();
}
bgl.baglanti().Close();
//Branşları datagride aktarma
DataTable dt1 = new DataTable();
SqlDataAdapter da = new SqlDataAdapter("select * from tbl_branslar", bgl.baglanti());
da.Fill(dt1);
dataGridView1.DataSource = dt1;
// Doktorları listeye aktarma
DataTable dt2 = new DataTable();
SqlDataAdapter da2 = new SqlDataAdapter("select (Doktorad + ' ' + DoktorSoyad)as 'Doktorlar',DoktorBrans from tbl_doktorlar", bgl.baglanti());
da2.Fill(dt2);
dataGridView2.DataSource = dt2;
//Branşı comboboxa aktarma
SqlCommand komut2 = new SqlCommand("Select BransAd from tbl_branslar", bgl.baglanti());
SqlDataReader dr2 = komut2.ExecuteReader();
while (dr2.Read())
{
CmbBrans.Items.Add(dr2[0]);
}
bgl.baglanti().Close();
}
private void BtnKaydet_Click(object sender, EventArgs e)
{
SqlCommand komutkaydet = new SqlCommand("insert into tbl_randevular (randevutarih,randevusaat,randevubrans,randevudoktor) values (@r1,@r2,@r3,@r4)", bgl.baglanti());
komutkaydet.Parameters.AddWithValue("@r1", MskTarih.Text);
komutkaydet.Parameters.AddWithValue("@r2", MskSaat.Text);
komutkaydet.Parameters.AddWithValue("@r3", CmbBrans.Text);
komutkaydet.Parameters.AddWithValue("@r4", CmbDoktor.Text);
komutkaydet.ExecuteNonQuery();
bgl.baglanti().Close();
MessageBox.Show("Randevu Oluşturuldu");
}
private void CmbBrans_SelectedIndexChanged(object sender, EventArgs e)
{
CmbDoktor.Items.Clear();
SqlCommand komut = new SqlCommand("select doktorad,doktorsoyad from tbl_doktorlar where doktorbrans=@p1", bgl.baglanti());
komut.Parameters.AddWithValue("@p1", CmbBrans.Text);
SqlDataReader dr = komut.ExecuteReader();
while (dr.Read())
{
CmbDoktor.Items.Add(dr[0] + " " + dr[1]);
}
bgl.baglanti().Close();
}
private void BtnDuyuruOlustur_Click(object sender, EventArgs e)
{
SqlCommand komut = new SqlCommand("insert into tbl_duyurular (duyuru) values (@d1)", bgl.baglanti());
komut.Parameters.AddWithValue("@d1", RchDuyuru.Text);
komut.ExecuteNonQuery();
bgl.baglanti().Close();
MessageBox.Show("Duyuru Oluşturuldu");
}
private void button4_Click(object sender, EventArgs e)
{
FrmDoktorPaneli drp = new FrmDoktorPaneli();
drp.Show();
}
private void BtnGuncelle_Click(object sender, EventArgs e)
{
}
private void BtnBransPanel_Click(object sender, EventArgs e)
{
FrmBrans frb = new FrmBrans();
frb.Show();
}
private void BtnListe_Click(object sender, EventArgs e)
{
FrmRandevuListesi frl = new FrmRandevuListesi();
frl.Show();
}
private void button1_Click(object sender, EventArgs e)
{
FrmDuyurular fr = new FrmDuyurular();
fr.Show();
}
}
}
FrmSekreterGiris.cs
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace Proje_Hastane
{
public partial class FrmSekreterGiris : Form
{
public FrmSekreterGiris()
{
InitializeComponent();
}
sqlbaglantisi bgl = new sqlbaglantisi();
private void BtnGirisYap_Click(object sender, EventArgs e)
{
SqlCommand komut = new SqlCommand("Select * From Tbl_Sekreter where SekreterTc=@p1 and SekreterSifre=@p2", bgl.baglanti());
komut.Parameters.AddWithValue("@p1", MskTc.Text);
komut.Parameters.AddWithValue("@p2", TxtSifre.Text);
SqlDataReader dr = komut.ExecuteReader();
if (dr.Read())
{
FrmSekreterDetay frs = new FrmSekreterDetay();
frs.TCnumara = MskTc.Text;
frs.Show();
this.Hide();
}
else
{
MessageBox.Show("Hatalı TC & Şifre");
}
bgl.baglanti().Close();
}
private void FrmSekreterGiris_Load(object sender, EventArgs e)
{
}
}
}
Sql
tbl_branslar
tbl_doktorlar
Tbl_duyurular
Tbl_hastalar
tbl_randevular
tbl_sekreter
411