private void button1_Click(object sender, EventArgs e)
{
SqlBaglanti sql = new SqlBaglanti(ServerName);
KullaniciBilgileri = sql.KullaniciOku();
for (int i = 0; i < Convert.ToInt16(KullaniciBilgileri[3][0]); i++)
{
if (textBox1.Text.CompareTo(KullaniciBilgileri[0][i]) == 0 && textBox2.Text.CompareTo(KullaniciBilgileri[1][i]) == 0)
{
KullaniciAdi = KullaniciBilgileri[2][i];
Personel_id = Convert.ToInt16(KullaniciBilgileri[4][i]);
Form2 form2 = new Form2(ServerName);
this.Hide();
form2.ShowDialog();
this.Close();
}
}
}
private void Form1_Load(object sender, EventArgs e)
{
this.FormBorderStyle = FormBorderStyle.FixedSingle;
Taployubastanolusturma();
SqlBaglanti sql = new SqlBaglanti(ServerName);
try
{
sql.KullaniciEkle("Vandellas", "24519551", "Mehmet", "1");
}
catch
{
}
Yıllıkİzin();
KullaniciBilgileri = sql.KullaniciOku();
textBox1.Text = "Vandellas";;
textBox2.Text = "24519551";
SqlConnection myCon = new SqlConnection(BaglantiOlustur());
string personelotomasyonname = "";
myCon.Open();
SqlCommand cmd = new SqlCommand("select * from personel_izin.dbo.Ayarlar", myCon);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
personelotomasyonname = dr["PersonelOtomasyonName"].ToString();
}
myCon.Close();
if (personelotomasyonname == "")
{
SqlCommand sorgu = new SqlCommand();
myCon.Open();
sorgu.Connection = myCon;
sorgu.CommandText = "insert into personel_izin.dbo.Ayarlar(PersonelOtomasyonName)values(@Adi)";
sorgu.Parameters.AddWithValue("@Adi", "Ahmet");
sorgu.ExecuteNonQuery();
myCon.Close();
}
}