public static DataSet personelListele(Personel arananPersonel)
{
SqlConnection sqlConnection = openConnection();
string sqlKomut = "select KimlikNo,personelAd,personelSoyad,baslamaTarih,bolumAd,gorevAd,egitimAd from view_personel ";
string kosul = " WHERE 1 = 1 ";
try
{
if (arananPersonel.getKimlikNo() != "")
{
kosul = kosul + " and kimlikNo LIKE '%" + arananPersonel.getKimlikNo() + "%'";
}
else if (arananPersonel.getPersonelAd() != "")
{
kosul = kosul + " and personelAd LIKE '%" + arananPersonel.getPersonelAd() + "%'";
}
else if (arananPersonel.getPersonelSoyad() != "")
{
kosul = kosul + " and personelSoyad LIKE '%" + arananPersonel.getPersonelSoyad() + "%'";
}
else if (arananPersonel.getGorevNo() > 0)
{
kosul = kosul + " and gorevNo = " + arananPersonel.getGorevNo();
}
else if (arananPersonel.getBolumNo() > 0)
{
kosul = kosul + " and bolumNo = " + arananPersonel.getBolumNo();
}
else if (arananPersonel.getEgitimNo() > 0)
{
kosul = kosul + " and egitimNo = " + arananPersonel.getEgitimNo();
}
sqlKomut = sqlKomut + kosul;
SqlCommand sqlCommand = new SqlCommand(sqlKomut, sqlConnection);
sqlCommand.CommandType = CommandType.Text;
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand);
DataSet dataSet = new DataSet();
sqlDataAdapter.Fill(dataSet);
return(dataSet);
}
catch (Exception e)
{
MessageBox.Show(e.Message);
throw;
}
finally
{
sqlConnection.Close();
}
}
public static bool personelEkle(Personel personel)
{
SqlConnection sqlConnection = openConnection();
try
{
// @kimlikNo , @ad , @soyad , @baslamaTarih , @bolumAd , @gorevAd , @egitim
SqlCommand sqlCommand = new SqlCommand("sp_personelEkle", sqlConnection);
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@kimNo", personel.getKimlikNo());
sqlCommand.Parameters.AddWithValue("@ad", personel.getPersonelAd());
sqlCommand.Parameters.AddWithValue("@soyad", personel.getPersonelSoyad());
sqlCommand.Parameters.AddWithValue("@basTarih", personel.getBaslamaTarih());
sqlCommand.Parameters.AddWithValue("@bolAd", personel.getBolumAd());
sqlCommand.Parameters.AddWithValue("@gorAd", personel.getGorevAd());
sqlCommand.Parameters.AddWithValue("@egitAd", personel.getEgitimAd());
sqlCommand.ExecuteNonQuery();
return(true);
}
catch (Exception e)
{
return(false);
MessageBox.Show(e.Message);
throw;
}
}