public static Borrowers Find(Borrowers record)
{
string query = "SELECT * FROM borrowers WHERE id = @id";
return(Database.GetConnection().QuerySingle <Borrowers>(query, record));
}
public static void Insert(Borrowers record)
{
string query = "INSERT INTO borrowers (firstName, lastName, phone, Email) VALUES (@firstName, @lastName, @phone, @Email)";
Database.IUD(query, record);
}
public static void Update(Borrowers record)
{
string query = "UPDATE borrowers SET firstName=@firstName, lastName=@lastName, phone=@phone, Email=@Email WHERE id = @id";
Database.IUD(query, record);
}
// or...
//public override string ToString()
//{
// return $"{FirstName} {LastName}";
//}
public static void Delete(Borrowers record)
{
string query = "DELETE FROM borrowers WHERE id = @id";
Database.IUD(query, record);
}
