public bool PersonelSil(Personeller p)
{
bool Sonuc = false;
SqlCommand comm = new SqlCommand("Update Personeller set silindi=1 where personelID=@personelID", conn);
comm.Parameters.Add("@personelID", SqlDbType.Int).Value = p._personelID;
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
try
{
Sonuc = Convert.ToBoolean(comm.ExecuteNonQuery());
}
catch (SqlException ex)
{
string hata = ex.Message;
}
finally
{
conn.Close();
}
return(Sonuc);
}
public void PersonelAdiGetir(ComboBox liste, string KlinikAd)
{
liste.Items.Clear();
SqlCommand comm = new SqlCommand("Select ad,soyad from Personeller inner join Klinikler on Personeller.klinikID=Klinikler.klinikNo where Personeller.silindi=0 and unvanID=1 and Klinikler.klinikAd=@klinikAd ", conn);
comm.Parameters.Add("@klinikAd", SqlDbType.VarChar).Value = KlinikAd;
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlDataReader dr = comm.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
Personeller p = new Personeller();
p._ad = dr["ad"].ToString();
p._soyad = dr["soyad"].ToString();
string HekimAd = p._ad + " " + p._soyad;
liste.Items.Add(HekimAd);
}
}
dr.Close();
conn.Close();
}
public Personeller PersonelBilgileriGetir(string KullaniciAdi, string Sifre)
{
Personeller p = new Personeller();
SqlCommand comm = new SqlCommand("select * from Personeller where kullaniciAdi=@kullaniciAdi and sifre=@sifre", conn);
comm.Parameters.Add("@kullaniciAdi", SqlDbType.VarChar).Value = KullaniciAdi;
comm.Parameters.Add("@sifre", SqlDbType.VarChar).Value = Sifre;
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlDataReader dr;
try
{
dr = comm.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
p._personelID = Convert.ToInt32(dr[0]);
p._sicilNo = Convert.ToInt32(dr[1]);
p._unvanID = Convert.ToInt32(dr[2]);
p._klinikID = Convert.ToInt32(dr[3]);
p._ad = dr[4].ToString();
p._soyad = dr[5].ToString();
p._diplomaNo = Convert.ToInt32(dr[6]);
p._adres = dr[7].ToString();
p._evTel = dr[8].ToString();
p._cepTel = dr[9].ToString();
p._dogumTarihi = Convert.ToDateTime(dr[10]);
p._dogumYeri = dr[11].ToString();
}
dr.Close();
}
}
catch (SqlException ex)
{
string hata = ex.Message;
}
finally
{
conn.Close();
}
return(p);
}
public bool PersonelGuncelle(Personeller p)
{
bool Sonuc = false;
SqlCommand comm = new SqlCommand("Update Personeller set sicilNo=@sicilNo,unvanID=@unvanID,klinikID=@klinikID,ad=@ad,soyad=@soyad,diplomaNo=@diplomaNo,adres=@adres,evTel=@evTel,cepTel=@cepTel,dogumYeri=@dogumYeri,dogumTarihi=@dogumTarihi,kullaniciAdi=@kullaniciAdi,sifre=@sifre where personelID=@personelID", conn);
comm.Parameters.Add("@sicilNo", SqlDbType.Int).Value = p._sicilNo;
comm.Parameters.Add("@unvanID", SqlDbType.Int).Value = p._unvanID;
comm.Parameters.Add("@klinikID", SqlDbType.Int).Value = p._klinikID;
comm.Parameters.Add("@ad", SqlDbType.VarChar).Value = p._ad;
comm.Parameters.Add("@soyad", SqlDbType.VarChar).Value = p._soyad;
comm.Parameters.Add("@diplomaNo", SqlDbType.Int).Value = p._diplomaNo;
comm.Parameters.Add("@adres", SqlDbType.VarChar).Value = p._adres;
comm.Parameters.Add("@evTel", SqlDbType.VarChar).Value = p._evTel;
comm.Parameters.Add("@cepTel", SqlDbType.VarChar).Value = p._cepTel;
comm.Parameters.Add("@dogumYeri", SqlDbType.VarChar).Value = p._dogumYeri;
comm.Parameters.Add("@dogumTarihi", SqlDbType.DateTime).Value = p._dogumTarihi;
comm.Parameters.Add("@kullaniciAdi", SqlDbType.VarChar).Value = p._kullaniciAdi;
comm.Parameters.Add("@sifre", SqlDbType.VarChar).Value = p._sifre;
comm.Parameters.Add("@personelID", SqlDbType.Int).Value = p._personelID;
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
try
{
Sonuc = Convert.ToBoolean(comm.ExecuteNonQuery()); //Hata verip vermediği kontrol edilir.
}
catch (SqlException ex) //Hatayla karşılaşılması durumunda bu blok çalışır.
{
string hata = ex.Message;
}
finally { conn.Close(); } //Hata olsun yada olmasın mutlaka çalışır.
return(Sonuc);
}
public bool KisiEkle(Personeller p)
{
bool Sonuc = false;
SqlCommand comm = new SqlCommand("Insert into Personeller(sicilNo,unvanID,klinikID,ad,soyad,diplomaNo,adres,evTel,cepTel,dogumYeri,dogumTarihi,kullaniciAdi,sifre) values(@sicilNo,@unvanID,@klinikID,@ad,@soyad,@diplomaNo,@adres,@evTel,@cepTel,@dogumYeri,@dogumTarihi,@kullaniciAdi,@sifre)", conn);
comm.Parameters.Add("@sicilNo", SqlDbType.Int).Value = p._sicilNo;
comm.Parameters.Add("@unvanID", SqlDbType.Int).Value = p._unvanID;
comm.Parameters.Add("@klinikID", SqlDbType.Int).Value = p._klinikID;
comm.Parameters.Add("@ad", SqlDbType.VarChar).Value = p._ad;
comm.Parameters.Add("@soyad", SqlDbType.VarChar).Value = p._soyad;
comm.Parameters.Add("@diplomaNo", SqlDbType.Int).Value = p._diplomaNo;
comm.Parameters.Add("@adres", SqlDbType.VarChar).Value = p._adres;
comm.Parameters.Add("@evTel", SqlDbType.VarChar).Value = p._evTel;
comm.Parameters.Add("@cepTel", SqlDbType.VarChar).Value = p._cepTel;
comm.Parameters.Add("@dogumYeri", SqlDbType.VarChar).Value = p._dogumYeri;
comm.Parameters.Add("@dogumTarihi", SqlDbType.DateTime).Value = p._dogumTarihi;
comm.Parameters.Add("@kullaniciAdi", SqlDbType.VarChar).Value = p._kullaniciAdi;
comm.Parameters.Add("@sifre", SqlDbType.VarChar).Value = p._sifre;
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
try
{
Sonuc = Convert.ToBoolean(comm.ExecuteNonQuery());
}
catch (SqlException ex)
{
string hata = ex.Message;
}
finally { conn.Close(); }
return(Sonuc);
}