private void tileBilgilendirmeFormu_CheckedChanged(object sender, DevExpress.XtraEditors.TileItemEventArgs e) { try { if (tileBilgilendirmeFormu.Checked == true) { bilgilendirmeFormlari = true; } else { bilgilendirmeFormlari = false; } SqlConnection connection = new SqlConnection(@"Server = tcp:hotelieu.database.windows.net,1433; Initial Catalog = HotelProject; Persist Security Info = False; User ID = hotelieu; Password = Hotelproject35; MultipleActiveResultSets = False; Encrypt = True; TrustServerCertificate = False; Connection Timeout = 30"); SqlCommand cmd = new SqlCommand(); cmd.Connection = connection; connection.Open(); cmd.CommandText = "update Personel set bilgilendirmeFormlari='" + bilgilendirmeFormlari + "' where personelKullaniciAdi='" + Kullanici.KullaniciAdi + "'"; cmd.ExecuteNonQuery(); connection.Close(); Kullanici.BilgiGuncelle(); } catch (Exception ex) { HotelWarningForm.Show(ex.ToString(), Localization.Tamam, 1); } }
private void tileKlavye_CheckedChanged(object sender, DevExpress.XtraEditors.TileItemEventArgs e) { try { Kullanici.BilgiGuncelle(); } catch (Exception ex) { HotelWarningForm.Show(ex.ToString(), Localization.Tamam, 1); } }
private void tileRenkDeğistir_ItemClick(object sender, DevExpress.XtraEditors.TileItemEventArgs e) { try { DialogResult result = colorDialog1.ShowDialog(); if (result == DialogResult.OK) { tileRenkDeğistir.AppearanceItem.Normal.BackColor = colorDialog1.Color; SqlConnection connection = new SqlConnection(@"Server = tcp:hotelieu.database.windows.net,1433; Initial Catalog = HotelProject; Persist Security Info = False; User ID = hotelieu; Password = Hotelproject35; MultipleActiveResultSets = False; Encrypt = True; TrustServerCertificate = False; Connection Timeout = 30"); SqlCommand cmd = new SqlCommand(); cmd.Connection = connection; connection.Open(); cmd.CommandText = "update Personel set tileItemColor ='" + System.Drawing.ColorTranslator.ToHtml(colorDialog1.Color) + "' where personelKullaniciAdi='" + Kullanici.KullaniciAdi + "'"; cmd.ExecuteNonQuery(); connection.Close(); Kullanici.BilgiGuncelle(); } } catch (Exception ex) { HotelWarningForm.Show(ex.ToString(), Localization.Tamam, 1); } }