public void FiilComboboxKat() { try { cmbKat.Items.Clear(); cmbKat.Items.Add(Localization.Tümü); 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(); if (string.Equals(cmbOdaBlok.SelectedItem.ToString(), Localization.Tümü)) { cmd.CommandText = "Select KatNo from Kat"; } else { cmd.CommandText = "Select KatNo from Kat where blokAdı='" + cmbOdaBlok.SelectedItem.ToString() + "'"; } cmd.Connection = connection; cmd.CommandType = CommandType.Text; SqlDataReader Dr; connection.Open(); Dr = cmd.ExecuteReader(); while (Dr.Read()) { cmbKat.Items.Add(Dr["KatNo"]); } connection.Close(); ortakFormIslemleri.cmbIlkDegerGetir(cmbKat); } catch (Exception ex) { HotelWarningForm.Show(ex.ToString(), Localization.Tamam, 1); } }
private void metroButton1_Click(object sender, EventArgs e) { try { string personelKategorisi = ""; if (chechBoxTümPersoneller.Checked) { personelKategorisi = "Tüm Personeller"; } else { personelKategorisi = cmbPersonelKategori.SelectedItem.ToString(); } string tarih = Convert.ToDateTime(dtToplantiTarihSaat.EditValue).ToString("yyyy-MM-dd hh:mm:ss"); 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 = "insert into Toplanti values ('" + txtisim.Text + "','" + cmbSalon.SelectedItem.ToString() + "','" + tarih + "','" + personelKategorisi + "','" + txtAciklama.Text + "','" + Kullanici.KullaniciAdi + "')"; cmd.ExecuteNonQuery(); connection.Close(); if (Kullanici.BilgilendirmeFormlari.Equals("True")) { HotelWarningForm.Show(Localization.ToplantiEklemeBasarili, Localization.Tamam, 0); } btnTemizle.PerformClick(); } catch (Exception ex) { HotelWarningForm.Show(ex.ToString(), Localization.Tamam, 1); } }
private void jsonBilgisiniAl() { try { 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(); ListeHavuzlar.Items.Clear(); cmd.CommandText = "select url from Havuzlar where havuzAdi ='" + txtisim.Text + "'"; cmd.Connection = connection; cmd.CommandType = CommandType.Text; connection.Open(); Dr = cmd.ExecuteReader(); while (Dr.Read()) { jsonUrl.Text = (Dr["url"].ToString()); } connection.Close(); } catch (Exception ex) { HotelWarningForm.Show(ex.ToString(), Localization.Tamam, 1); } }
private void silinmişDuyuruyuGeriAlToolStripMenuItem_Click(object sender, EventArgs e) { try { if (metroGrid1.SelectedCells.Count > 0) { SqlCommand cmd = new SqlCommand(); 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"); cmd.Connection = connection; connection.Open(); cmd.CommandText = "update Duyuru set Gorunur=1 where Baslik='" + metroGrid1.SelectedCells[0].Value.ToString() + "' and DuyuruGrubu='" + metroGrid1.SelectedCells[1].Value.ToString() + "' and Icerik='" + metroGrid1.SelectedCells[2].Value.ToString() + "'"; cmd.ExecuteNonQuery(); connection.Close(); if (Kullanici.BilgilendirmeFormlari.Equals("True")) { HotelWarningForm.Show(Localization.DuyuruGerialmaBasarili, Localization.Tamam, 0); } btnFiltrele.PerformClick(); } else { HotelWarningForm.Show(Localization.GeriAlinacakDuyuruSec, Localization.Tamam, 1); } } catch (Exception ex) { HotelWarningForm.Show(ex.ToString(), Localization.Tamam, 1); } }
private void chechBoxTümPersoneller_CheckedChanged(object sender, EventArgs e) { try { if (chechBoxTümPersoneller.Checked == true) { lblPersonelKategori.Enabled = false; cmbPersonelKategori.Enabled = false; btnPersonelKategoriEkle.Enabled = false; lblPersonelKategori.Visible = false; cmbPersonelKategori.Visible = false; btnPersonelKategoriEkle.Visible = false; } else { lblPersonelKategori.Enabled = true; cmbPersonelKategori.Enabled = true; btnPersonelKategoriEkle.Enabled = true; lblPersonelKategori.Visible = true; cmbPersonelKategori.Visible = true; btnPersonelKategoriEkle.Visible = true; } } catch (Exception ex) { HotelWarningForm.Show(ex.ToString(), Localization.Tamam, 1); } }
private void tileItem14_ItemClick(object sender, DevExpress.XtraEditors.TileItemEventArgs e) { try { if (Kullanici.OnayFormlari.Equals("True")) { DialogResult sonuc; sonuc = HotelMessageBox.Show(Localization.ProgramCikisOnay, Localization.Evet, Localization.Hayır); if (sonuc == DialogResult.No) { //MessageBox.Show("");// hiçbir işlem yaptırmıyorum } if (sonuc == DialogResult.Yes) { this.Close(); Application.Exit(); } } else { Application.Exit(); } } catch (Exception ex) { HotelWarningForm.Show(ex.ToString(), Localization.Tamam, 1); } }
private void EgeTablosu(string kosul) { try { 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.CommandText = "select musteriAdi,musteriSoyadi,musteriMail from Musteriler " + kosul; cmd.Connection = connection; cmd.CommandType = CommandType.Text; SqlDataReader Dr; connection.Open(); Dr = cmd.ExecuteReader(); while (Dr.Read()) { musteriListesi.Add(new Musteri(Dr["musteriAdi"].ToString(), Dr["musteriSoyadi"].ToString(), Dr["musteriMail"].ToString(), "ege")); } connection.Close(); } catch (Exception ex) { HotelWarningForm.Show(ex.ToString(), Localization.Tamam, 1); } }
private bool personelEkliMi() { //Personel daha önceden veri tabanına eklenmiş mi bool var = false; try { 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.CommandText = "select * from Personel where personelMail='" + mail + "'"; cmd.Connection = connection; cmd.CommandType = CommandType.Text; SqlDataReader Dr; connection.Open(); Dr = cmd.ExecuteReader(); if (Dr.Read()) { HotelWarningForm.Show(Localization.personelDahaOncedenTanimlanmis, Localization.Tamam, 1); var = true; } else { var = false; } connection.Close(); } catch (Exception ex) { HotelWarningForm.Show(ex.ToString(), Localization.Tamam, 1); } return(var); }
private void BilgiDoldur() { // Form mevcut kullanıcı ile ilgili açıldı ise bu kullanıcıya ait bilgileri ilgili yerlere yazar try { if (!String.IsNullOrEmpty(MevcutPersonelKadi)) { 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.CommandText = "select * from Personel where personelKullaniciAdi ='" + MevcutPersonelKadi + "'"; cmd.Connection = connection; cmd.CommandType = CommandType.Text; SqlDataReader Dr; connection.Open(); Dr = cmd.ExecuteReader(); while (Dr.Read()) { txtisim.Text = Dr["personelAdi"].ToString(); txtsoyisim.Text = Dr["personelSoyadi"].ToString(); txttelefon.Text = Dr["personelTelefon"].ToString(); cmbPersonelGrubu.SelectedItem = Dr["personelDepartman"].ToString(); txtmail.Text = Dr["personelMail"].ToString(); txtKullaniciAdi.Text = Dr["personelKullaniciAdi"].ToString(); txtSifre.Text = Dr["personelSifre"].ToString(); txtadres.Text = Dr["personelAdresi"].ToString(); } connection.Close(); } } catch (Exception ex) { HotelWarningForm.Show(ex.ToString(), Localization.Tamam, 1); } }
private void metroButton5_Click(object sender, EventArgs e) { try { if (CheckinKontrol() && TarihKontrol()) { 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(); string tempdatetime = DateTime.Now.ToString(); cmd.Connection = connection; connection.Open(); cmd.CommandText = "insert into OdaHareket values('" + ListeOdalar.SelectedItems[0].Text + "','" + Convert.ToDateTime(dtGirisTarihi.EditValue).ToString("yyyy-MM-dd HH:mm:ss") + "','" + Convert.ToDateTime(dtCikisTarihi.EditValue).ToString("yyyy-MM-dd HH:mm:ss") + "','" + cmbMusteriAdi.SelectedItem.ToString() + "','Check-in',0,'" + musteriListesi[cmbMusteriAdi.SelectedIndex].email + "','" + ortakFormIslemleri.odaTipGetir(ListeOdalar.SelectedItems[0].Text) + "','" + ortakFormIslemleri.odaBlokGetir(ListeOdalar.SelectedItems[0].Text) + "','" + ortakFormIslemleri.odaKatGetir(ListeOdalar.SelectedItems[0].Text) + "')"; cmd.ExecuteNonQuery(); connection.Close(); MusteriActiveGuncelle(); if (Kullanici.BilgilendirmeFormlari.Equals("True")) { HotelWarningForm.Show(Localization.BasariliCheckin, Localization.Tamam, 0); } } } catch (Exception ex) { HotelWarningForm.Show(ex.ToString(), Localization.Tamam, 1); } }
private void PersonelOlusturma_Load(object sender, EventArgs e) { try { MultiLanguage(); this.Text = Localization.tilePersonelOlustur; FiilCombobox(); BilgiDoldur(); EnableFalse(); FiilComboBoxYetkiler(); this.StyleManager = metroStyleManager1; if (Convert.ToInt32(DateTime.Now.Hour.ToString()) < 7 && Kullanici.otoGeceModu.Equals("True")) { metroStyleManager1.Theme = MetroFramework.MetroThemeStyle.Dark; ortakFormIslemleri.LabelRenkDegistir(Color.White, lblAd, lblSoyad, lblTelefon, lblAdres, lblMail, lblKullaniciAdi, lblSifre, lblPersonelGrubu, lblPersonelYetkisi); ortakFormIslemleri.TextBoxRenkDegistir(Color.White, txtadres, txtisim, txtKullaniciAdi, txtmail, txtSifre, txtsoyisim, txttelefon); ortakFormIslemleri.ComboBoxRenkDegistir(Color.Gray, cmbPersonelGrubu, cmbYetki); } if (Kullanici.klavye.Equals("True")) { btnKlavye.Visible = true; } else { btnKlavye.Visible = false; } } catch (Exception ex) { HotelWarningForm.Show(ex.ToString(), Localization.Tamam, 1); } }
private bool HareketKontrol(string musteriAdi, DateTime girisTarihi, DateTime cikisTarihi) { try { SqlDataReader Dr3; SqlConnection connection3 = 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 cmd3 = new SqlCommand(); cmd3.CommandText = "select * from OdaHareket where musteriPersonel = '" + musteriAdi + "' and islemTarihi1 > '" + girisTarihi.ToString("yyyy-MM-dd HH:mm:ss") + "' and islemTarihii2 < '" + cikisTarihi.ToString("yyyy-MM-dd HH:mm:ss") + "' and islemTipi = 'Check-in'"; cmd3.Connection = connection3; cmd3.CommandType = CommandType.Text; connection3.Open(); Dr3 = cmd3.ExecuteReader(); if (Dr3.HasRows) { return(false); } connection3.Close(); return(true); } catch (Exception ex) { HotelWarningForm.Show(ex.ToString(), Localization.Tamam, 1); return(false); } }
private void silToolStripMenuItem_Click(object sender, EventArgs e) { try { if (metroGrid1.SelectedCells.Count > 0) { if (OdaBosKontrol(metroGrid1.SelectedCells[0].ToString(), DateTime.Now)) { SqlCommand cmd = new SqlCommand(); 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"); cmd.Connection = connection; connection.Open(); cmd.CommandText = "update Oda set Gorunur=0 where OdaNo='" + metroGrid1.SelectedCells[0].Value.ToString() + "'"; cmd.ExecuteNonQuery(); connection.Close(); HotelWarningForm.Show(Localization.odaSilmeBasarili, Localization.Tamam, 0); btnFiltrele.PerformClick(); } } else { HotelWarningForm.Show(Localization.silmekIcınOdaSec, Localization.Tamam, 1); } } catch (Exception ex) { HotelWarningForm.Show(ex.ToString(), Localization.Tamam, 1); } }
private void silinmişOdalarıGösterToolStripMenuItem_Click(object sender, EventArgs e) { try { if (!string.Equals(silinmişOdalarıGösterToolStripMenuItem.Text, Localization.silinmisOdalariGoster)) { silinmişOdayıGeriAlToolStripMenuItem.Visible = false; FillDataGridView("Select * from Oda where Gorunur =1"); silinmişOdalarıGösterToolStripMenuItem.Text = Localization.silinmisOdalariGoster; silinmişOdayıGeriAlToolStripMenuItem.BackColor = Color.YellowGreen; metroGrid1.DefaultCellStyle.BackColor = Color.White; } else { silinmişOdalarıGösterToolStripMenuItem.Text = Localization.silinmisOdalariGosterme; silinmişOdayıGeriAlToolStripMenuItem.Visible = true; FillDataGridView("Select * from Oda where Gorunur =0"); metroGrid1.DefaultCellStyle.BackColor = Color.Red; } } catch (Exception ex) { HotelWarningForm.Show(ex.ToString(), Localization.Tamam, 1); } }
private void btnSureUzat_Click(object sender, EventArgs e) { try { if (Convert.ToInt32(txtGunSayisi.Text) > 0) { 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(); string tarih = Convert.ToDateTime(TarihAl().AddDays(Convert.ToDouble(txtGunSayisi.Text))).ToString("yyyy-MM-dd"); cmd.CommandText = "update OdaHareket set islemTarihii2='" + tarih + "'where OdaHareketID=" + metroGrid1.SelectedCells[0].Value.ToString(); cmd.ExecuteNonQuery(); connection.Close(); if (Kullanici.BilgilendirmeFormlari.Equals("True")) { HotelWarningForm.Show(Localization.cikisTarihiUzatıldı, Localization.Tamam, 0); } Filtrele(); txtGunSayisi.Text = ""; } else { HotelWarningForm.Show(Localization.eklenecekGunSayisiPozitifHata, Localization.Tamam, 1); txtGunSayisi.Focus(); } } catch (Exception ex) { HotelWarningForm.Show(ex.ToString(), Localization.Tamam, 1); } }
private bool musteriVarmi(string musteriMail) { try { 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.CommandText = "select * from Musteriler where musteriMail ='" + musteriMail + "'"; cmd.Connection = connection; cmd.CommandType = CommandType.Text; SqlDataReader Dr; connection.Open(); Dr = cmd.ExecuteReader(); if (!Dr.HasRows) { connection.Close(); return(true); } else { connection.Close(); guncellemeYap = false; HotelWarningForm.Show(Localization.MusteriSistemeKayitliHata, Localization.Tamam, 1); return(false); } } catch (Exception ex) { HotelWarningForm.Show(ex.ToString(), Localization.Tamam, 1); } return(false); }
private void GridGuncelle(string kosul) { try { 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 sqlCmd = new SqlCommand(); sqlCmd.Connection = connection; sqlCmd.CommandType = CommandType.Text; string tarih = Convert.ToDateTime(DateTime.Now).ToString("yyyy-MM-dd"); sqlCmd.CommandText = "select * from OdaHareket where islemTipi='Check-in' and islemTarihii2>'" + tarih + "'" + kosul; SqlDataAdapter sqlDataAdap = new SqlDataAdapter(sqlCmd); DataTable dtRecord = new DataTable(); sqlDataAdap.Fill(dtRecord); metroGrid1.DataSource = dtRecord; metroGrid1.Columns[0].Visible = false; metroGrid1.Columns[1].HeaderText = Localization.OdaNumarasi; metroGrid1.Columns[2].HeaderText = Localization.GirisTarihi; metroGrid1.Columns[3].HeaderText = Localization.GirisTarihi; metroGrid1.Columns[4].HeaderText = Localization.MusteriAdi; metroGrid1.Columns[5].Visible = false; metroGrid1.Columns[6].Visible = false; metroGrid1.Columns[7].Visible = false; metroGrid1.Columns[8].Visible = false; metroGrid1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; } catch (Exception ex) { HotelWarningForm.Show(ex.ToString(), Localization.Tamam, 1); } }
private bool katBosKontrolSalon() { try { SqlDataReader Dr3; SqlConnection connection3 = 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 cmd3 = new SqlCommand(); cmd3.CommandText = "select * from Salon where katAdi = '" + metroListView1.SelectedItems[0].Text + "'"; cmd3.Connection = connection3; cmd3.CommandType = CommandType.Text; connection3.Open(); Dr3 = cmd3.ExecuteReader(); if (Dr3.HasRows) { HotelWarningForm.Show(Localization.kattaBulunanSalonlariSilin, Localization.Tamam, 1); return(false); } connection3.Close(); return(true); } catch (Exception ex) { HotelWarningForm.Show(ex.ToString(), Localization.Tamam, 1); return(true); } }
private void ArdunioKontrol() { try { SqlConnection connection = new SqlConnection(@"Data Source=DESKTOP-R5FHQ20;Initial Catalog=OtelOdev;Persist Security Info=True;User ID=sa;Password=14101410.,"); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "select * from Ardunio where ArdunioCinsi='SıcaklıkHavuz1'"; cmd.Connection = connection; cmd.CommandType = CommandType.Text; SqlDataReader Dr; connection.Open(); Dr = cmd.ExecuteReader(); while (Dr.Read()) { Ardunio.ArdunioAktif = Convert.ToBoolean(Dr["Aktif"]); Ardunio.Port = Dr["Port"].ToString(); } connection.Close(); } catch (Exception ex) { HotelWarningForm.Show(ex.ToString(), Localization.Tamam, 1); } }
private void silinmişKaydıGeriAlToolStripMenuItem_Click(object sender, EventArgs e) { try { if (metroListView1.SelectedItems.Count > 0) { 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 Kat set Gorunur=1 where KatNo='" + metroListView1.SelectedItems[0].Text + "'"; cmd.ExecuteNonQuery(); connection.Close(); if (Kullanici.BilgilendirmeFormlari.Equals("True")) { HotelWarningForm.Show(Localization.katGeriAlmaIslemiBasarili, Localization.Tamam, 0); } ListeGuncelle(); } else { HotelWarningForm.Show(Localization.geriAlinacakKatiSecin, Localization.Tamam, 1); } } catch (Exception ex) { HotelWarningForm.Show(ex.ToString(), Localization.Tamam, 1); } }
private void CheckBoxOzelGonderim_CheckedChanged(object sender, EventArgs e) { try { if (CheckBoxOzelGonderim.Checked) { ComboBoxKriter.Visible = true; KriterLabel.Visible = true; OdaGrupLabel.Visible = true; ComboBoxOdaGrubu.Visible = true; } else { ComboBoxKriter.Visible = false; KriterLabel.Visible = false; OdaGrupLabel.Visible = false; ComboBoxOdaGrubu.Visible = false; CheckBoxTumPersoneller.Visible = false; CheckBoxTumPersoneller.Enabled = false; LabelPersonelGrup.Enabled = false; LabelPersonelGrup.Visible = false; ComboBoxPersonelGrubu.Visible = false; ComboBoxPersonelGrubu.Enabled = false; } } catch (Exception ex) { HotelWarningForm.Show(ex.ToString(), Localization.Tamam, 1); } }
private void KatEkle_Load(object sender, EventArgs e) { try { MultiLanguage(); this.Text = Localization.katAyarlari; this.StyleManager = metroStyleManager1; if (Convert.ToInt32(DateTime.Now.Hour.ToString()) < 7 && Kullanici.otoGeceModu.Equals("True")) { metroStyleManager1.Theme = MetroFramework.MetroThemeStyle.Dark; ortakFormIslemleri.LabelRenkDegistir(Color.White, lblBlok, lblKatAdi, lblBloktakiKatlar); ortakFormIslemleri.ComboBoxRenkDegistir(Color.Gray, cmbBlok); ortakFormIslemleri.TextBoxRenkDegistir(Color.White, txtKatAdi); ortakFormIslemleri.ListViewRenkDegistir(Color.Black, metroListView1); } FiilComboboxBlok(); if (Kullanici.klavye.Equals("True")) { btnKlavye.Visible = true; } else { btnKlavye.Visible = false; } } catch (Exception ex) { HotelWarningForm.Show(ex.ToString(), Localization.Tamam, 1); } }
private void DuyuruListesi_Load(object sender, EventArgs e) { try { MultiLanguage(); silinmişDuyuruyuGeriAlToolStripMenuItem.Visible = false; cmbDuyuruTipi.Items.Add(Localization.Tümü); FiilCombobox(); FiilComboboxOdaGrubu(); FiilComboboxMusteriAdi(); metroDateTime1.Value = DateTime.Now.AddDays(-1); Yetki(); ComboBoxKriter.Items.Add(Localization.OdaGrubu); ComboBoxKriter.Items.Add(Localization.OzelMusteri); ComboBoxKriter.Items.Add(Localization.Personel); this.Text = Localization.duyuruListesi; ComboBoxKriter.SelectedIndex = 0; FiilComboboxPersonelGrubu(); KriterLabel.Visible = false; OdaGrupLabel.Visible = false; ComboBoxKriter.Visible = false; ComboBoxOdaGrubu.Visible = false; ortakFormIslemleri.cmbIlkDegerGetir(cmbDuyuruTipi, cmbMusteriAdi, ComboBoxKriter, ComboBoxOdaGrubu, ComboBoxPersonelGrubu); metroDateTime1.Value = DateTime.Now.AddDays(-1); btnFiltrele.PerformClick(); } catch (Exception ex) { HotelWarningForm.Show(ex.ToString(), Localization.Tamam, 1); } }
private void metroButton1_Click(object sender, EventArgs e) { try { 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"); string[] parcalar; string kullaniciadiPersonel = ""; parcalar = cmbPersonel.SelectedItem.ToString().Split(' '); SqlCommand cmd3 = new SqlCommand(); cmd3.CommandText = "select personelKullaniciAdi from Personel where personelAdi ='" + parcalar[0] + "' and personelSoyadi='" + parcalar[1] + "'"; cmd3.Connection = connection; cmd3.CommandType = CommandType.Text; SqlDataReader Dr; connection.Open(); Dr = cmd3.ExecuteReader(); while (Dr.Read()) { kullaniciadiPersonel = (Dr["personelKullaniciAdi"]).ToString(); } connection.Close(); FillDataGridView("SELECT * FROM OdaHareket WHERE musteriPersonel ='" + cmbPersonel.SelectedItem.ToString() + "'and islemTarihi1>='" + Convert.ToDateTime(metroDateTime1.Value).ToString("yyyy-MM-dd HH:mm:ss") + "'and islemTarihii2<='" + Convert.ToDateTime(metroDateTime2.Value).ToString("yyyy-MM-dd HH:mm:ss") + "'"); } catch (Exception ex) { HotelWarningForm.Show(ex.ToString(), Localization.Tamam, 1); } }
public void FiilToplantiSalonu() { try { 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.CommandText = "select* from Salon where kategori='Toplantı Salonu'"; cmd.Connection = connection; cmd.CommandType = CommandType.Text; SqlDataReader Dr; connection.Open(); Dr = cmd.ExecuteReader(); while (Dr.Read()) { cmbSalon.Items.Add(Dr["salonAdı"]); } connection.Close(); ortakFormIslemleri.cmbIlkDegerGetir(cmbSalon); } catch (Exception ex) { HotelWarningForm.Show(ex.ToString(), Localization.Tamam, 1); } }
private void TemizlikciListesiDoldur() { try { 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.CommandText = "Select * from Personel where personelDepartman='Temizlikçi'"; cmd.Connection = connection; cmd.CommandType = CommandType.Text; SqlDataReader Dr; connection.Open(); Dr = cmd.ExecuteReader(); while (Dr.Read()) { cmbPersonel.Items.Add(Dr["personelAdi"] + " " + Dr["personelSoyadi"]); } connection.Close(); } catch (Exception ex) { HotelWarningForm.Show(ex.ToString(), Localization.Tamam, 1); } }
public void FiilComboboxPersonelKategorisi() { try { cmbPersonelKategori.Items.Clear(); 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.CommandText = "Select KategoriAciklama from PeronelKategori"; cmd.Connection = connection; cmd.CommandType = CommandType.Text; SqlDataReader Dr; connection.Open(); Dr = cmd.ExecuteReader(); while (Dr.Read()) { cmbPersonelKategori.Items.Add(Dr["KategoriAciklama"]); } connection.Close(); } catch (Exception ex) { HotelWarningForm.Show(ex.ToString(), Localization.Tamam, 1); } }
private DateTime TarihAl() { try { DateTime value = DateTime.Now; 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.CommandText = "select islemTarihii2 from OdaHareket where OdaHareketID='" + metroGrid1.SelectedCells[0].Value.ToString() + "'"; cmd.Connection = connection; cmd.CommandType = CommandType.Text; SqlDataReader Dr; connection.Open(); Dr = cmd.ExecuteReader(); while (Dr.Read()) { value = Convert.ToDateTime(Dr["islemTarihii2"].ToString()); } connection.Close(); return(value); } catch (Exception ex) { HotelWarningForm.Show(ex.ToString(), Localization.Tamam, 1); } return(DateTime.Now); }
private void silToolStripMenuItem_Click(object sender, EventArgs e) { try { if (ListeHavuzlar.SelectedItems.Count > 0) { 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 Havuzlar set gorunur=0 where havuzAdi='" + ListeHavuzlar.SelectedItems[0].Text + "'"; cmd.ExecuteNonQuery(); connection.Close(); if (Kullanici.BilgilendirmeFormlari.Equals("True")) { HotelWarningForm.Show(Localization.HavuzSilmeBasarili, Localization.Tamam, 0); } HavuzListesiGuncelleme(); } else { HotelWarningForm.Show(Localization.SilinecekHavuzSeciniz, Localization.Tamam, 1); } } catch (Exception ex) { HotelWarningForm.Show(ex.ToString(), Localization.Tamam, 1); } }
private bool OgunKontrol(string yemekAdı, string yemekAciklama) { try { bool ogunMu = 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.CommandText = "select OgunMu from Yemek where YemekAdi='" + yemekAdı + "' and Aciklama='" + yemekAciklama + "'"; cmd.Connection = connection; cmd.CommandType = CommandType.Text; SqlDataReader Dr; connection.Open(); Dr = cmd.ExecuteReader(); while (Dr.Read()) { ogunMu = (Convert.ToBoolean(Dr["OgunMu"])); } connection.Close(); if (ogunMu) { return(true); } else { return(false); } } catch (Exception ex) { HotelWarningForm.Show(ex.ToString(), Localization.Tamam, 1); } return(false); }