/// <summary> /// Get the borrower with the supplied PersonId from the database. /// </summary> /// <param name="borrower">A variable of typ Borrower. Will be set to a new instance or null if /// no borrower with given id was found.</param> /// <param name="PersonId">The id of the borrower as a string.</param> /// <returns>Returns true if no errors occured.</returns> public static bool GetBorrower(out Borrower borrower, string PersonId) { borrower = null; SqlCommand command = new SqlCommand("SELECT * from BORROWER WHERE PersonId = @PersonId"); command.Parameters.AddWithValue("@PersonId", PersonId); List<Borrower> borrowerList; bool result = GetBorrowers(out borrowerList, command); if (borrowerList.Count > 0) { borrower = borrowerList[0]; } return result; }
/// <summary> /// Update or insert a borrower. /// </summary> /// <param name="borrower">The Borrower to upsert.</param> /// <returns>Returns true if upsert failed or an error occured.</returns> public static bool Upsert(Borrower borrower) { try { using (SqlConnection connection = HelperFunctions.GetConnection()) { connection.Open(); // Update BOOK using (SqlCommand command = new SqlCommand("EXEC UpsertBorrower @PersonId, @FirstName, @LastName, @Address, @Telno, @CategoryId")) { command.Connection = connection; command.Parameters.AddWithValue("@PersonId", borrower.PersonId); command.Parameters.AddWithValue("@FirstName", HelperFunctions.ValueOrDBNull(borrower.FirstName)); command.Parameters.AddWithValue("@LastName", HelperFunctions.ValueOrDBNull(borrower.LastName)); command.Parameters.AddWithValue("@Address", HelperFunctions.ValueOrDBNull(borrower.Adress)); command.Parameters.AddWithValue("@Telno", HelperFunctions.ValueOrDBNull(borrower.TelNo)); command.Parameters.AddWithValue("@CategoryId", HelperFunctions.ValueOrDBNull(borrower.CategoryId)); if (command.ExecuteNonQuery() != 1) { return false; } } } } catch(Exception) { return false; } return true; }