/// <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);
            }
        }
Esempio n. 2
0
        //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;
        }