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