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