public bool Guncelle(Calisan calisan)
{
string sorguCumlesi = "Update Calisanlar SET Adi=@p1,SoyAdi=@p2,TCKimlikNo=@p3,PersonelNo=@p4,DogumTarihi=@p5,Departman=@p6,Unvan=@p7,Durumu=@p8 where Id=@p9)";
try
{
using (SqlCommand command = new SqlCommand(sorguCumlesi, SqlServerBaglanti.Connection))
{
command.Parameters.AddWithValue("@p1", calisan.Adi);
command.Parameters.AddWithValue("@p2", calisan.SoyAdi);
command.Parameters.AddWithValue("@p3", calisan.TCKimlikNo);
command.Parameters.AddWithValue("@p4", calisan.PersonelNo);
command.Parameters.AddWithValue("@p5", calisan.DogumTarihi);
command.Parameters.AddWithValue("@p6", calisan.Departman);
command.Parameters.AddWithValue("@p7", calisan.Unvan);
command.Parameters.AddWithValue("@p8", calisan.Durumu);
command.Parameters.AddWithValue("@p9", calisan.Id);
SqlServerBaglanti.BaglantiAc();
command.ExecuteNonQuery();
}
return(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(false);
}
finally
{
SqlServerBaglanti.BaglantiKapat();
}
}
public bool Kaydet(Calisan calisan)
{
string sorguCumlesi = "INSERT INTO Calisanlar (Adi,SoyAdi,TCKimlikNo,PersonelNo,DogumTarihi,Departman,Unvan,Durumu) Values (@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8)";
try
{
using (SqlCommand command = new SqlCommand(sorguCumlesi, SqlServerBaglanti.Connection))
{
command.Parameters.AddWithValue("@p1", calisan.Adi);
command.Parameters.AddWithValue("@p2", calisan.SoyAdi);
command.Parameters.AddWithValue("@p3", calisan.TCKimlikNo);
command.Parameters.AddWithValue("@p4", calisan.PersonelNo);
command.Parameters.AddWithValue("@p5", calisan.DogumTarihi);
command.Parameters.AddWithValue("@p6", calisan.Departman);
command.Parameters.AddWithValue("@p7", calisan.Unvan);
command.Parameters.AddWithValue("@p8", calisan.Durumu);
SqlServerBaglanti.BaglantiAc();
command.ExecuteNonQuery();
}
return(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(false);
}
finally
{
SqlServerBaglanti.BaglantiKapat();
}
}
public Calisan Getir(string kosulCumlesi)
{
Calisan _calisan = null;
try
{
int _sonuc = 0;
using (SqlCommand command = new SqlCommand($"SELECT COUNT (*) Calisanlar {kosulCumlesi}", SqlServerBaglanti.Connection))
{
SqlServerBaglanti.BaglantiAc();
_sonuc = Convert.ToInt32(command.ExecuteScalar());
}
if (_sonuc > 1)
{
MessageBox.Show("Yapılan sorgu sonucunda 1'den fazla kayıt bulundu...\nLütfen daha fazla kriter ile arama yapınız...");
}
else if (_sonuc == 1)
{
using (SqlCommand command = new SqlCommand($"SELECT * FROM Calisanlar {kosulCumlesi}", SqlServerBaglanti.Connection))
{
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
_calisan = new Calisan
{
Id = Convert.ToInt32(reader["Id"]),
Adi = reader["Adi"].ToString(),
SoyAdi = reader["SoyAdi"].ToString(),
TCKimlikNo = reader["TCKimlikNo"].ToString(),
PersonelNo = reader["PersonelNo"].ToString(),
DogumTarihi = Convert.ToDateTime(reader["DogumTarihi"]),
Departman = reader["Departman"].ToString(),
Unvan = reader["Unvan"].ToString(),
Durumu = reader["Durumu"].ToString()
};
}
}
}
}
return(_calisan);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(null);
}
finally
{
SqlServerBaglanti.BaglantiKapat();
}
}
public List <Calisan> Listele(string kosulCumlesi)
{
List <Calisan> calisanlar = new List <Calisan>();
try
{
using (SqlCommand command = new SqlCommand($"SELECT * FROM Calisanlar {kosulCumlesi}", SqlServerBaglanti.Connection))
{
SqlServerBaglanti.BaglantiAc();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Calisan _calisan = new Calisan
{
Id = Convert.ToInt32(reader["Id"]),
Adi = reader["Adi"].ToString(),
SoyAdi = reader["SoyAdi"].ToString(),
TCKimlikNo = reader["TCKimlikNo"].ToString(),
PersonelNo = reader["PersonelNo"].ToString(),
DogumTarihi = Convert.ToDateTime(reader["DogumTarihi"]),
Departman = reader["Departman"].ToString(),
Unvan = reader["Unvan"].ToString(),
Durumu = reader["Durumu"].ToString()
};
calisanlar.Add(_calisan);
}
}
return(calisanlar);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(null);
}
finally
{
SqlServerBaglanti.BaglantiKapat();
}
}
public bool Sil(string kosulCumlesi)
{
try
{
using (SqlCommand command = new SqlCommand($"DELETE FROM Calisanlar {kosulCumlesi}", SqlServerBaglanti.Connection))
{
SqlServerBaglanti.BaglantiAc();
command.ExecuteNonQuery();
}
return(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(false);
}
finally
{
SqlServerBaglanti.BaglantiKapat();
}
}
public bool Sil(int id)
{
try
{
using (SqlCommand command = new SqlCommand($"DELETE FROM Calisanlar where Id=@p1", SqlServerBaglanti.Connection))
{
command.Parameters.AddWithValue("@p1", id);
SqlServerBaglanti.BaglantiAc();
command.ExecuteNonQuery();
}
return(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(false);
}
finally
{
SqlServerBaglanti.BaglantiKapat();
}
}