public static bool hastaneYoneticiArama(Yonetici yonetici) { SqlConnection sqlbaglanti = openConnection(); try { SqlCommand veriOku = new SqlCommand("select * from Yonetici where yoneticiKodu=@yKodu " + "and adi=@adi and soyadi=@soyadi and gorevKodu='222222'", sqlbaglanti); veriOku.Parameters.AddWithValue("@yKodu", yonetici.getYoneticiKodu()); veriOku.Parameters.AddWithValue("@adi", yonetici.getYoneticiAdi()); veriOku.Parameters.AddWithValue("@soyadi", yonetici.getYoneticiSoyadi()); SqlDataReader rdr = veriOku.ExecuteReader(); rdr.Read(); if (rdr.HasRows) { return(true); } else { return(false); } } catch (Exception) { throw; } finally { connectionClose(sqlbaglanti); } }
public static void bagisMerkeziYoneticiGuncelle(Yonetici yonetici) { SqlConnection sqlbaglanti = openConnection(); SqlCommand veriOku = new SqlCommand("UPDATE Yonetici SET adi=@adi,soyadi=@soyadi,parola=@parola where yoneticiKodu=@yoneticiKodu", sqlbaglanti); veriOku.Parameters.AddWithValue("@yoneticiKodu", yonetici.getYoneticiKodu()); veriOku.Parameters.AddWithValue("@adi", yonetici.getYoneticiAdi()); veriOku.Parameters.AddWithValue("@soyadi", yonetici.getYoneticiSoyadi()); veriOku.Parameters.AddWithValue("@parola", yonetici.getYoneticiParola()); try { veriOku.ExecuteNonQuery(); } catch (Exception) { } finally { connectionClose(sqlbaglanti); } }
public static void bagisMerkeziYoneticiekle(Yonetici yonetici) { SqlConnection sqlbaglanti = openConnection(); SqlCommand veriOku = new SqlCommand("INSERT INTO Yonetici (yoneticiKodu,adi,soyadi,parola,gorevKodu) VALUES (@yoneticiKodu,@adi,@soyadi,@parola,@gorevKodu)", sqlbaglanti); veriOku.Parameters.AddWithValue("@yoneticiKodu", yonetici.getYoneticiKodu()); veriOku.Parameters.AddWithValue("@adi", yonetici.getYoneticiAdi()); veriOku.Parameters.AddWithValue("@soyadi", yonetici.getYoneticiSoyadi()); veriOku.Parameters.AddWithValue("@parola", yonetici.getYoneticiParola()); veriOku.Parameters.AddWithValue("@gorevKodu", yonetici.getGorevKodu()); try { veriOku.ExecuteNonQuery(); } catch (Exception) { } finally { connectionClose(sqlbaglanti); } }