private void pictureBox1_Click(object sender, EventArgs e) { frmPersonelGirisCikis f2 = new frmPersonelGirisCikis(); f2.Show(); this.Close(); }
private void BtnYonetici_Click(object sender, EventArgs e) { frmPersonelGirisCikis f1 = new frmPersonelGirisCikis(); f1.Close(); frmYonetici f2 = new frmYonetici(); f2.Show(); this.Hide(); }
private void BtnCıkıs_Click(object sender, EventArgs e) { frmPersonelGirisCikis f1 = new frmPersonelGirisCikis(); f1.Close(); FrmPersonelCikisi f2 = new FrmPersonelCikisi(); f2.Show(); this.Hide(); }
private void BtnGiris_Click(object sender, EventArgs e) { frmPersonelGirisCikis f1 = new frmPersonelGirisCikis(); f1.Close(); frmPersonelGirisi f2 = new frmPersonelGirisi(lblZaman.Text, lblZamanİki.Text); f2.Show(); this.Hide(); }
private void Button2_Click(object sender, EventArgs e) { string zaman = DateTime.Now.ToLongTimeString() + " " + DateTime.Now.ToLongDateString(); conn.Open(); SQLiteCommand cmd = conn.CreateCommand(); cmd.CommandText = "SELECT * FROM tblgiriscikis where ID='" + cmbAdSoyad.SelectedValue + "'"; SQLiteDataReader dr = cmd.ExecuteReader(); string ad = ""; string soyad = ""; string giris = ""; //GİRİŞ ZAMANI int kontrol; //bu değişlken çıkış yapıldıysa tekrar çıkışı engeller dr.Read(); ad = dr["ADI"].ToString(); soyad = dr["SOYADI"].ToString(); giris = dr["GIRIS"].ToString(); kontrol = int.Parse(dr["DEGER"].ToString()); dr.Close(); if (kontrol == 1) { MessageBox.Show("PERSONEL GİRİŞ YAPMAMIŞ", "UYARI", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { string sql1 = "UPDATE tblgiriscikis SET DEGER='1', CIKIS='" + zaman.ToString() + "' WHERE ID='" + cmbAdSoyad.SelectedValue + "'"; SQLiteCommand command1 = new SQLiteCommand(sql1, conn); command1.ExecuteNonQuery(); //label1.Visible = true; //label1.Text = "Hoçakal " + ad; MessageBox.Show("HOŞÇAKAL " + ad, "UYARI", MessageBoxButtons.OK, MessageBoxIcon.Information); // LOG KAYDI string sql3 = "insert into tbllogkaydi(ADI,SOYADI,GIRIS,CIKIS) values ('" + ad + "','" + soyad + "','" + giris + "','" + zaman + "')"; SQLiteCommand command3 = new SQLiteCommand(sql3, conn); command3.ExecuteNonQuery(); this.Close(); frmPersonelGirisCikis f2 = new frmPersonelGirisCikis(); f2.Show(); } conn.Close(); }
private void BtnGiris_Click(object sender, EventArgs e) { string zaman = DateTime.Now.ToLongTimeString() + " " + DateTime.Now.ToLongDateString(); conn.Open(); SQLiteCommand cmd = conn.CreateCommand(); cmd.CommandText = "SELECT * FROM tblgiriscikis where ID='" + cmbSecim.SelectedValue + "'"; SQLiteDataReader dr = cmd.ExecuteReader(); string ad = ""; string soyad = ""; int kontrol;//bu değişlken çıkış yapılmadıysa tekrar girişi engeller dr.Read(); ad = dr["ADI"].ToString(); soyad = dr["SOYADI"].ToString(); kontrol = int.Parse(dr["DEGER"].ToString()); dr.Close(); if (kontrol == 0) { MessageBox.Show("PERSONEL ÇIKIŞ YAPMAMIŞ"); } else { string sql1 = "UPDATE tblgiriscikis SET DEGER='0', GIRIS='" + zaman.ToString() + "', CIKIS='Çıkış yapmadı' WHERE ID='" + cmbSecim.SelectedValue + "'"; SQLiteCommand command1 = new SQLiteCommand(sql1, conn); command1.ExecuteNonQuery(); lblHosgeldiniz.Visible = true; lblHosgeldiniz.Text = "Hoşgeldin " + ad; MessageBox.Show("GİRİŞ BAŞARILI", "UYARI", MessageBoxButtons.OK, MessageBoxIcon.Information); //MessageBox.Show(comboBox1.SelectedValue.ToString(), "UYARI", MessageBoxButtons.OK, MessageBoxIcon.Information); frmPersonelGirisCikis f2 = new frmPersonelGirisCikis(); f2.Show(); this.Close(); } conn.Close(); }