private string ListMySwaps(string Filter)
{
//this function lists swaps in the list box
//it takes one parameter which is a filter
//it returns a string indicating how many swaps were found
//
//var to store the SwapNo (unique identifier)
Int32 SwapNo;
//var to stor the swap title
string Title;
//create a connection to the database table applying the filter
clsDataConnection MySwaps = new clsDataConnection("select * from swap where title like('" + Filter + "%') order by title");
//var to store the number of swaps found
Int32 SwapCount;
//get the number of swaps found
SwapCount = MySwaps.Count;
//clear the list box
lstSwaps.Items.Clear();
Int32 Index = 0;
//loop through each swap
while (Index < SwapCount)
{
//get the SwapNo from the database
SwapNo = Convert.ToInt32(MySwaps.DataTable.Rows[Index]["SwapNo"]);
//get the Title of the swap from the database
Title = Convert.ToString(MySwaps.DataTable.Rows[Index]["Title"]);
//add the title to the list
lstSwaps.Items.Add(Title);
//set the value of the item in the list to the SwapNo
lstSwaps.Items[Index].Value = SwapNo.ToString();
Index++;
}
//if records were found
if (MySwaps.Count > 0)
{
//return how many records were found
return(MySwaps.Count + " record(s) found");
}
else
{
//return no records found
return("No records found");
}
}
private void DisplaySwaps()
{
//this sub displays the swaps in the swaps list box
//
//open a connection to the database
clsDataConnection MySwaps = new clsDataConnection("select * from swap order by title");
//var to store the count of swaps
Int32 SwapCount;
//var for the loop
Int32 Index = 0;
//var for the swap title
string Title;
//var for the unique identifier of the swap
Int32 SwapNo;
//var to store the number of offers on a swap
Int32 OfferCount;
//get the number of swaps
SwapCount = MySwaps.Count;
//loop through each swap
while (Index < SwapCount)
{
//get the swap number for this swap
SwapNo = (Int32)MySwaps.DataTable.Rows[Index]["SwapNo"];
//get the title for this swap
Title = (string)MySwaps.DataTable.Rows[Index]["Title"];
//get the number of offers on this swap
OfferCount = GetOfferCount(SwapNo);
//if there are no offers
if (OfferCount == 0)
{
//then just add the title
lstSwaps.Items.Add(Title);
}
else
{
//else add the title with the number of offers
lstSwaps.Items.Add(Title + " " + OfferCount + " offer(s)");
//End If
}
//set the value property for this entry in the list box
lstSwaps.Items[Index].Value = SwapNo.ToString();
Index++;
}
}
