/// <summary>
/// This method compiles list of users selected search criteria
/// </summary>
/// <returns>list of search criteria</returns>
public List <clsSearchLogic> ReturnSelection()
{
try
{
clsSearchLogic cs = new clsSearchLogic();
sSQL = DisplaySelection();
clsData = new clsDataAccess();
ds = clsData.ExecuteSQLStatement(sSQL, ref iRet);
List <clsSearchLogic> lstInvoices = new List <clsSearchLogic>();
for (int i = 0; i < iRet; i++)
{
lstInvoices.Add(new clsSearchLogic
{
sInvoiceNum = $"{ds.Tables[0].Rows[i]["InvoiceNum"]}",
sInvoiceDate = $"{ds.Tables[0].Rows[i]["InvoiceDate"]}",
sTotalCost = $"{ds.Tables[0].Rows[i]["TotalCost"]}"
});
}
return(lstInvoices);
}
catch (Exception ex)
{
throw new Exception(MethodInfo.GetCurrentMethod().DeclaringType.Name + "." +
MethodInfo.GetCurrentMethod().Name + " -> " + ex.Message);
}
}
//string InvoiceNumSelection = "";
//string InvoiceDateSelection = "";
//string InvoiceTotalCost = "";
public wndSearch(Main.wndMain wndMain)
{
InitializeComponent();
clsSql = new clsSearchSQL();
clsSL = new clsSearchLogic();
dgInvoices.ItemsSource = clsSql.GetInvoices();
cbInvoiceNum.ItemsSource = clsSql.GetInvoiceNum();
cbInvoiceNum.DisplayMemberPath = nameof(clsSearchLogic.sInvoiceNum);
cbInvoiceDate.ItemsSource = clsSql.GetInvoiceDate();
cbInvoiceDate.DisplayMemberPath = nameof(clsSearchLogic.sInvoiceDate);
cbTotalCost.ItemsSource = clsSql.GetTotalCost();
cbTotalCost.DisplayMemberPath = nameof(clsSearchLogic.sTotalCost);
mainWindow = wndMain;
}
