public int SprawdzPracownika(Pracownik p) { try { command.CommandText = "SELECT PESEL FROM PracownicyT WHERE PESEL=@PESEL"; command.Parameters.AddWithValue("PESEL", p.PESEL); command.CommandType = System.Data.CommandType.Text; connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { if (reader.HasRows == true) { connection.Close(); return(1); } } connection.Close(); return(0); } catch (Exception) { return(0); throw; } }
public string WczytajPracownika(Pracownik p) { try { command.CommandText = "SELECT Imie, Nazwisko FROM PracownicyT WHERE PESEL=@PESEL"; command.Parameters.AddWithValue("PESEL", p.PESEL); command.CommandType = System.Data.CommandType.Text; connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { if (reader.HasRows == true) { return(reader["Imie"].ToString() + " " + reader["Nazwisko"].ToString()); } } return("Brak takiego pracownika w bazie danych"); } catch (Exception) { return(" Wystąpił Błąd "); } finally { connection.Close(); } }
public int UsunPracownika(Pracownik p) { try { command.CommandText = "DELETE FROM PracownicyT WHERE PESEL=@PESEL"; command.Parameters.AddWithValue("PESEL", p.PESEL); command.CommandType = System.Data.CommandType.Text; connection.Open(); int rowsaffect = command.ExecuteNonQuery(); connection.Close(); return(rowsaffect); } catch (Exception) { return(0); throw; } }
public int DodajPracownika(Pracownik p) { try { command.CommandText = "INSERT INTO PracownicyT VALUES (@PESEL,@Imie,@Nazwisko)"; command.Parameters.AddWithValue("PESEL", p.PESEL); command.Parameters.AddWithValue("Imie", p.Imie); command.Parameters.AddWithValue("Nazwisko", p.Nazwisko); command.CommandType = System.Data.CommandType.Text; connection.Open(); int rowsaffected = command.ExecuteNonQuery(); connection.Close(); return(rowsaffected); } catch (Exception) { return(0); throw; } }