コード例 #1
0
        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);
            }
        }
コード例 #2
0
 private void tileKlavye_CheckedChanged(object sender, DevExpress.XtraEditors.TileItemEventArgs e)
 {
     try
     {
         Kullanici.BilgiGuncelle();
     }
     catch (Exception ex)
     {
         HotelWarningForm.Show(ex.ToString(), Localization.Tamam, 1);
     }
 }
コード例 #3
0
 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);
     }
 }