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; } }
public static void personelSil(Personel personel) { SqlConnection sqlConnection = openConnection(); try { //DELETE FROM tPersonel WHERE tPersonel.kimlikNo = @kimlikNo SqlCommand sqlCommand = new SqlCommand("DELETE FROM tPersonel WHERE tPersonel.kimlikNo = @kimlikNo", sqlConnection); sqlCommand.Parameters.AddWithValue("@kimlikNo", personel.getKimlikNo()); sqlCommand.ExecuteNonQuery(); } catch (Exception e) { MessageBox.Show(e.Message); throw; } }