/// <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; }