public int Update(DepartmanEntities departman)
{
cmd = new SqlCommand("update Departmanlar SET IlacAdi=@dAd where DepartmanID=@departmanID", conn);
cmd.Parameters.AddWithValue("@dAd", departman.DepartmanAdi);
cmd.Parameters.AddWithValue("@departmanID", departman.DepartmanID);
return(ExecuteCommand());
}
public DepartmanEntities GetDepartmanById(int departmanID)
{
DepartmanEntities currentDepartman = new DepartmanEntities();
cmd = new SqlCommand("Select * From Departmanlar Where DepartmanID = @id", conn);
cmd.Parameters.AddWithValue("@id", departmanID);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
reader.Read();
currentDepartman.DepartmanID = reader.GetInt32(0);
currentDepartman.DepartmanAdi = reader.GetString(1);
reader.Close();
return(currentDepartman);
}
public DoktorFrm(int doktorID)
{
InitializeComponent();
doktorController = new DoktorController();
randevuController = new RandevuController();
hastaController = new HastaController();
muayeneController = new MuayeneController();
departmanController = new DepartmanController();
departman = new DepartmanEntities();
doktor = new DoktorEntities();
randevu = new RandevuEntities();
hasta = new HastaEntities();
randevus = new List <RandevuHastaDTO>();
muaneler = new List <HastaMuaneleriDTO>();
doktor = doktorController.GetDoktor(doktorID);
departman = departmanController.IDyeGoreDepartmanGetir(doktor.DepartmanID);
labelDoktor.Text = departman.DepartmanAdi + " Uzmanı Dr. " + doktor.Adi + " " + doktor.Soyadi;
gBoxMuaneSorgula.Hide();
gBoxHesapBilgileri.Hide();
gBoxCalismaGunu.Hide();
}
public int Add(DepartmanEntities departman)
{
cmd = new SqlCommand("INSERT INTO Departmanlar VALUES (@dAd)", conn);
cmd.Parameters.AddWithValue("@dAd", departman.DepartmanAdi);
return(ExecuteCommand());
}
