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