Example #1
0
        public void UserSearch(SearchWindow window)
        {
            string name    = window.TxtSearchUserName.Text;
            string pin     = window.TxtSearchUserPin.Text;
            bool?  working = window.ChkSearchUserWorking.IsChecked;

            List <User> users = new UserCRUD().GetUsers();

            if (!String.IsNullOrEmpty(name))
            {
                users.RemoveAll(x => x.Name.ToLower() != name.ToLower());
            }

            if (!String.IsNullOrEmpty(pin))
            {
                users.RemoveAll(x => x.Pin != pin);
            }

            if (working != null)
            {
                users.RemoveAll(x => x.Working != working);
            }

            if (users.Count > 0)
            {
                BindDataGrid(users);
                window.Close();
            }
            else
            {
                MessageBox.Show("There are no results", "Information");
            }
        }
Example #2
0
        public void TimeSearch(SearchWindow window)
        {
            int      selectedUserId    = Convert.ToInt32(window.CbSearchTimesUserId.SelectedValue.ToString());
            DateTime?selectedStartDate = window.DpSearchTimesStartDate.SelectedDate;
            DateTime?selectedEndDate   = window.DpSearchTimesEndDate.SelectedDate;

            List <WorkPeriod> periods = new WorkPeriodCRUD().GetWorkPeriods();

            if (selectedUserId > 0)
            {
                periods.RemoveAll(x => x.UserId != selectedUserId);
            }

            if (selectedStartDate != null)
            {
                periods.RemoveAll(x => x.Start >= Convert.ToDateTime(selectedStartDate));
            }

            if (selectedEndDate != null)
            {
                periods.RemoveAll(x => x.End <= Convert.ToDateTime(selectedEndDate));
            }

            if (periods.Count > 0)
            {
                BindDataGrid(periods);
                window.Close();
            }
            else
            {
                MessageBox.Show("There are no results", "Information");
            }
        }
        public void InvoiceSearch(SearchWindow window)
        {
            string name     = window.TxtSearchInvoiceName.Text;
            string statusId = window.CbSearchInvoiceStatus.Text;

            List <Objects.Invoice> invoices = new InvoiceCRUD().GetInvoices();

            if (!String.IsNullOrEmpty(name))
            {
                invoices.RemoveAll(x => x.InvoiceName != name);
            }

            if (!String.IsNullOrEmpty(statusId))
            {
                invoices.RemoveAll(x => x.InvoiceTypeId != Convert.ToInt32(statusId));
            }

            if (invoices.Count > 0)
            {
                BindDataGrid(invoices);
                window.Close();
            }
            else
            {
                MessageBox.Show("There are no results", "Information");
            }
        }
        public void JobSearch(SearchWindow window)
        {
            string name          = window.TxtSearchJobName.Text;
            string balanceDue    = window.TxtSearchJobBalanceDue.Text;
            string city          = window.TxtSearchJobCity.Text;
            bool?  mobile        = window.ChkSearchJobMobile.IsChecked;
            string statusId      = window.CbSearchJobJobStatusId.Text;
            string scheduledDate = window.DpSearchJobScheduledDate.Text;

            List <Job> jobs = new JobCRUD().GetJobs();

            if (!String.IsNullOrEmpty(name))
            {
                jobs.RemoveAll(x => x.Name != name);
            }

            if (!String.IsNullOrEmpty(balanceDue))
            {
                jobs.RemoveAll(x => x.BalanceDue != Convert.ToDecimal(balanceDue));
            }

            if (!String.IsNullOrEmpty(city))
            {
                jobs.RemoveAll(x => x.City != city);
            }

            if (mobile != null)
            {
                jobs.RemoveAll(x => x.Mobile != mobile);
            }

            if (!String.IsNullOrEmpty(statusId))
            {
                jobs.RemoveAll(x => x.JobStatusId != Convert.ToInt32(statusId));
            }

            if (scheduledDate.Length > 0)
            {
                jobs.RemoveAll(x => x.ScheduledDate != Convert.ToDateTime(scheduledDate));
            }

            if (jobs.Count > 0)
            {
                BindDataGrid(jobs);
                window.Close();
            }
            else
            {
                MessageBox.Show("There are no results", "Information");
            }
        }
        public void InventorySearch(SearchWindow window)
        {
            string name           = window.TxtSearchItemName.Text;
            string price          = window.TxtSearchItemPrice.Text;
            string quantity       = window.TxtSearchItemQuantity.Text;
            string skuNumber      = window.TxtSearchItemSkuNumber.Text;
            string itemTypeId     = window.CbSearchItemItemTypeId.Text;
            string locationTypeId = window.CbSearchItemLocationTypeId.Text;

            List <Item> items = new ItemCRUD().GetAllItems();

            if (!String.IsNullOrEmpty(name))
            {
                items.RemoveAll(x => x.Name != name);
            }

            if (!String.IsNullOrEmpty(price))
            {
                items.RemoveAll(x => x.Price != Convert.ToDecimal(price));
            }

            if (!String.IsNullOrEmpty(quantity))
            {
                items.RemoveAll(x => x.Quantity != Convert.ToInt32(quantity));
            }

            if (!String.IsNullOrEmpty(skuNumber))
            {
                items.RemoveAll(x => x.SkuNumber != skuNumber);
            }

            if (!String.IsNullOrEmpty(itemTypeId))
            {
                items.RemoveAll(x => x.ItemTypeId != Convert.ToInt32(itemTypeId));
            }

            if (!String.IsNullOrEmpty(locationTypeId))
            {
                items.RemoveAll(x => x.LocationTypeId != Convert.ToInt32(locationTypeId));
            }

            if (items.Count > 0)
            {
                BindDataGrid(items);
                window.Close();
            }
            else
            {
                MessageBox.Show("There are no results", "Information");
            }
        }
        public void OrdersSearch(SearchWindow window)
        {
            string name     = window.TxtSearchOrderName.Text;
            string price    = window.TxtSearchOrderPrice.Text;
            string quantity = window.TxtSearchOrderQuantity.Text;
            string statusId = window.CbOrderStatusId.Text;

            List <Order> order = new OrderCRUD().GetOrders();

            if (!String.IsNullOrEmpty(name))
            {
                order.RemoveAll(x => x.Name.ToLower() != name.ToLower());
            }

            if (!String.IsNullOrEmpty(price))
            {
                order.RemoveAll(x => x.Price != Convert.ToDecimal(price));
            }

            if (!String.IsNullOrEmpty(quantity))
            {
                order.RemoveAll(x => x.Quantity != Convert.ToInt32(quantity));
            }

            if (!String.IsNullOrEmpty(statusId))
            {
                order.RemoveAll(x => x.OrderStatusId != Convert.ToInt32(statusId));
            }

            if (order.Count > 0)
            {
                BindDataGrid(order);
                window.Close();
            }
            else
            {
                MessageBox.Show("There are no results", "Information");
            }
        }