public void Guncelle(Izin t)
{
try
{
cmd.CommandText = "Update Izinli SET Cikisaati='" + t.Cikisaati + "' Where Adisoyadi='" + t.Adisoyadi + "' and Bolum='" + t.Bolum + "' and Tarih='" + t.Tarih + "'and Girisaati='" + t.Girisaati + "'and ID='" + t.ID + "'and Cikisaati='GİRİŞ YAPILMADI'";
cmd.CommandType = CommandType.Text;
con.Open();
cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
finally
{
if (con != null)
{
con.Close();
}
}
}
public void Ekle(Izin t)
{
try
{
cmd.CommandText = "INSERT INTO Izinli (Tarih,Adisoyadi,Bolum,Kartno,Girisaati,Ziyaretnedeni,Cikisaati) VALUES('" + t.Tarih + "','" + t.Adisoyadi + "','" + t.Bolum + "','" + t.Kartno + "','" + t.Girisaati + "','" + t.Ziyaretnedeni + "','" + t.Cikisaati + "')";
cmd.CommandType = CommandType.Text;
con.Open();
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
finally
{
if (con != null)
{
con.Close();
}
}
}
public void Sil(Izin t)
{
try
{
cmd.CommandText = "DELETE FROM Izinli WHERE ID='" + t.ID + "'";
cmd.CommandType = CommandType.Text;
con.Open();
cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
finally
{
if (con != null)
{
con.Close();
}
}
}
public List <Izin> Listele()
{
try
{
List <Izin> Izinlilistesi = new List <Izin>();
cmd.CommandText = "SELECT * from Izinli where Convert(INT,SUBSTRING(Tarih,1,2))=DAY(GETDATE()) and Convert(INT,SUBSTRING(Tarih,4,2))=MONTH(GETDATE()) and Convert(INT,SUBSTRING(Tarih,7,5))=YEAR(GETDATE()) and Cikisaati='GİRİŞ YAPILMADI' union SELECT * from Izinli where Convert(INT,SUBSTRING(Tarih,1,2))=Convert(INT,SUBSTRING(Convert(varchar,GETDATE()-1,112),7,2)) and Convert(INT,SUBSTRING(Tarih,4,2))=Convert(INT,SUBSTRING(Convert(varchar,GETDATE()-1,112),5,2)) and Convert(INT,SUBSTRING(Tarih,7,5))=Convert(INT,SUBSTRING(Convert(varchar,GETDATE()-1,112),1,4)) and Cikisaati='GİRİŞ YAPILMADI'";
cmd.CommandType = CommandType.Text;
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Izin t = new Izin();
t.ID = Convert.ToInt32(reader[0]);
t.Tarih = reader[1].ToString();
t.Adisoyadi = reader[2].ToString();
t.Bolum = reader[3].ToString();
t.Kartno = reader[5].ToString();
t.Ziyaretnedeni = reader[4].ToString();
t.Girisaati = reader[6].ToString();
t.Cikisaati = reader[7].ToString();
Izinlilistesi.Add(t);
}
return(Izinlilistesi);
}
catch
{
throw;
}
finally
{
if (con != null)
{
con.Close();
}
}
}
