private static void ClearAssignedToPaidBill(int billId)
{
string sql = $"sp_ClearAssignedOnBillClosed {billId}";
SqlDataAccess.ExecuteQuery(sql);
}
private static void RemoveAssignedBill(int billId, int roommateId)
{
string sql = $"sp_RemoveAssignedBill '{billId}', '{roommateId}'";
SqlDataAccess.ExecuteQuery(sql);
}