private void sales_orderDatagrid_LoadingRowDetails(object sender, DataGridRowDetailsEventArgs e) { sales_budget _sales_budget = ((DataGrid)sender).SelectedItem as sales_budget; int id_sales_budget = _sales_budget.id_sales_budget; DataGrid RowDataGrid = e.DetailsElement as DataGrid; var salesBudget = (from sales_budget_detail in db.sales_budget_detail where sales_budget_detail.id_sales_budget == id_sales_budget && sales_budget_detail.sales_budget.status == Status.Documents_General.Approved join sales_order_detail in db.sales_order_detail on sales_budget_detail.id_sales_budget_detail equals sales_order_detail.id_sales_order_detail into lst from list in lst.DefaultIfEmpty() group list by new { sales_budget_detail = sales_budget_detail, } into grouped select new { item = grouped.Key.sales_budget_detail.item_description, unitprice = grouped.Key.sales_budget_detail.unit_price > 0 ? grouped.Key.sales_budget_detail.unit_price : 0, balance = grouped.Key.sales_budget_detail.quantity > 0 ? grouped.Key.sales_budget_detail.quantity : 0 - grouped.Sum(x => x.quantity > 0 ? x.quantity : 0), }).ToList(); RowDataGrid.ItemsSource = salesBudget; }
private void select_Item(sales_budget sales_budget, item item) { Settings SalesSettings = new Settings(); if (sales_budget.sales_budget_detail.Where(a => a.id_item == item.id_item).FirstOrDefault() == null || SalesSettings.AllowDuplicateItem) { sales_budget_detail _sales_budget_detail = new sales_budget_detail(); _sales_budget_detail.State = EntityState.Added; _sales_budget_detail.sales_budget = sales_budget; _sales_budget_detail.Contact = sales_budget.contact; _sales_budget_detail.item_description = item.description; _sales_budget_detail.item = item; _sales_budget_detail.id_item = item.id_item; sales_budget.sales_budget_detail.Add(_sales_budget_detail); } else { sales_budget_detail sales_budget_detail = sales_budget.sales_budget_detail.Where(a => a.id_item == item.id_item).FirstOrDefault(); sales_budget_detail.quantity += 1; } Dispatcher.BeginInvoke((Action)(() => { sales_budgetsales_budget_detailViewSource.View.Refresh(); calculate_vat(null, null); })); }
//Sales Budget public void Document_PrintSalesBudget(int?document_id, sales_budget sales_budget) { if (sales_budget.app_document_range != null) { if (sales_budget.app_document_range.printer_name != null) { DocumentViewr MainWindow = new DocumentViewr(); MainWindow.loadSalesBudgetReport(sales_budget.id_sales_budget); } else { DocumentViewr MainWindow = new DocumentViewr(); MainWindow.loadSalesBudgetReport(sales_budget.id_sales_budget); Window window = new Window { Title = "Document", Content = MainWindow }; window.ShowDialog(); } } else { DocumentViewr MainWindow = new DocumentViewr(); MainWindow.loadSalesBudgetReport(sales_budget.id_sales_budget); Window window = new Window { Title = "Document", Content = MainWindow }; window.ShowDialog(); } }
private void toolBar_btnSearch_Click(object sender, string query) { try { if (!string.IsNullOrEmpty(query)) { sales_budgetViewSource.View.Filter = i => { sales_budget sales_budget = i as sales_budget; if (sales_budget.contact.name.ToLower().Contains(query.ToLower())) { return(true); } else { return(false); } }; } else { sales_budgetViewSource.View.Filter = null; } } catch (Exception) { } }
private void id_conditionComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e) { sales_budget sales_budget = sales_budgetDataGrid.SelectedItem as sales_budget; if (cbxCondition.SelectedItem != null) { app_condition app_condition = cbxCondition.SelectedItem as app_condition; CollectionViewSource contractViewSource = ((CollectionViewSource)(FindResource("contractViewSource"))); contractViewSource.View.Filter = i => { app_contract objContract = (app_contract)i; if (objContract.id_condition == app_condition.id_condition) { return(true); } else { return(false); } }; if (sales_budget != null) { if (sales_budget.id_contract == 0) { cbxContract.SelectedIndex = 0; } } } }
private void New_Click(object sender) { sales_budget sales_budget = SalesBudgetDB.New(); cbxCurrency.get_DefaultCurrencyActiveRate(); SalesBudgetDB.sales_budget.Add(sales_budget); sales_budgetViewSource.View.MoveCurrentTo(sales_budget); }
private void sales_budgetDataGrid_SelectionChanged(object sender, SelectionChangedEventArgs e) { sales_budget sales_budget = (sales_budget)sales_budgetDataGrid.SelectedItem; if (sales_budget != null) { calculate_vat(sender, e); } }
private void set_ContactPref(object sender, MouseButtonEventArgs e) { if (contactComboBox.Data != null) { sales_budget sales_budget = (sales_budget)contactComboBox.Data; contactComboBox.focusGrid = false; contactComboBox.Text = sales_budget.number; } }
private void SalesBudget_DocViewer_Click(object sender, RoutedEventArgs e) { Hyperlink Hyperlink = (Hyperlink)sender; sales_budget sales_budget = (sales_budget)Hyperlink.Tag; if (sales_budget != null) { entity.Brillo.Document.Start.Automatic(sales_budget, sales_budget.app_document_range); } }
private void Totals_btnClean_Click(object sender) { sales_budget sales_budget = sales_budgetViewSource.View.CurrentItem as sales_budget; if (sales_budget != null) { decimal TrailingDecimals = sales_budget.GrandTotal - Math.Floor(sales_budget.GrandTotal); sales_budget.DiscountWithoutPercentage += TrailingDecimals; } }
private void set_ContactPref(object sender, EventArgs e) { if (sbxContact.ContactID > 0) { contact contact = SalesBudgetDB.contacts.Where(x => x.id_contact == sbxContact.ContactID).FirstOrDefault(); sales_budget sales_budget = (sales_budget)sales_budgetDataGrid.SelectedItem; sales_budget.id_contact = contact.id_contact; sales_budget.contact = contact; Task thread_SecondaryData = Task.Factory.StartNew(() => set_ContactPref_Thread(contact)); } }
private void toolBar_btnPrint_Click(object sender, MouseButtonEventArgs e) { sales_budget sales_budget = sales_budgetDataGrid.SelectedItem as sales_budget; if (sales_budget != null) { // sales_invoice sales_invoice = sales_invoiceViewSource.View.CurrentItem as sales_invoice; entity.Brillo.Document.Start.Manual(sales_budget, sales_budget.app_document_range); } else { toolBar.msgWarning("Please select"); } }
private void item_Select(object sender, EventArgs e) { if (sbxItem.ItemID > 0) { sales_budget sales_budget = sales_budgetViewSource.View.CurrentItem as sales_budget; item item = SalesBudgetDB.items.Where(x => x.id_item == sbxItem.ItemID).FirstOrDefault(); if (item != null && item.id_item > 0 && sales_budget != null) { Task Thread = Task.Factory.StartNew(() => select_Item(sales_budget, item)); } sales_budget.RaisePropertyChanged("GrandTotal"); } }
private void toolBar_btnEdit_Click(object sender) { if (sales_budgetDataGrid.SelectedItem != null) { sales_budget sales_budget = (sales_budget)sales_budgetDataGrid.SelectedItem; sales_budget.IsSelected = true; sales_budget.State = EntityState.Modified; SalesBudgetDB.Entry(sales_budget).State = EntityState.Modified; } else { toolBar.msgWarning("Please Select A Record"); } }
private void cbxCurrency_LostFocus(object sender, RoutedEventArgs e) { sales_budget sales_budget = sales_budgetViewSource.View.CurrentItem as sales_budget; if (sales_budget != null) { if (sales_budget.id_currencyfx > 0) { if (SalesBudgetDB.app_currencyfx.Where(x => x.id_currencyfx == sales_budget.id_currencyfx).FirstOrDefault() != null) { sales_budget.app_currencyfx = SalesBudgetDB.app_currencyfx.Where(x => x.id_currencyfx == sales_budget.id_currencyfx).FirstOrDefault(); } } } calculate_vat(sender, e); }
private void calculate_vat(object sender, EventArgs e) { sales_budget sales_budget = (sales_budget)sales_budgetDataGrid.SelectedItem; sales_budget.RaisePropertyChanged("GrandTotal"); List <sales_budget_detail> sales_budget_detail = sales_budget.sales_budget_detail.ToList(); dgvvat.ItemsSource = sales_budget_detail .Join(SalesBudgetDB.app_vat_group_details, ad => ad.id_vat_group, cfx => cfx.id_vat_group , (ad, cfx) => new { name = cfx.app_vat.name, value = ad.unit_price * cfx.app_vat.coefficient, id_vat = cfx.app_vat.id_vat, ad }) .GroupBy(a => new { a.name, a.id_vat, a.ad }) .Select(g => new { id_vat = g.Key.id_vat, name = g.Key.name, value = g.Sum(a => a.value * a.ad.quantity) }).ToList(); }
private void btnDuplicateInvoice_PreviewMouseUp(object sender, MouseButtonEventArgs e) { sales_budget sales_budget = sales_budgetViewSource.View.CurrentItem as sales_budget; if (sales_budget != null) { if (sales_budget.id_sales_budget != 0) { var originalEntity = SalesBudgetDB.sales_budget.AsNoTracking().FirstOrDefault(x => x.id_sales_budget == sales_budget.id_sales_budget); SalesBudgetDB.sales_budget.Add(originalEntity); sales_budgetViewSource.View.Refresh(); sales_budgetViewSource.View.MoveCurrentToLast(); } else { toolBar.msgWarning("Please save before duplicating"); } } }
void filter_sales() { if (sales_budgetViewSource != null) { if (sales_budgetViewSource.View != null) { if (sales_budgetViewSource.View.OfType <sales_budget>().Count() > 0) { sales_budgetViewSource.View.Filter = i => { sales_budget sales_budget = (sales_budget)i; if (sales_budget.sales_budget_detail.Sum(x => x.balance) > 0) { return(true); } else { return(false); } }; } } } }
private void saveOrder_Click(object sender, RoutedEventArgs e) { project_event project_costing = project_costingViewSource.View.CurrentItem as project_event; if (project_costing != null) { contact contact = EventDB.contacts.Where(x => x.id_contact == sbxContact.ContactID).FirstOrDefault(); app_condition app_condition = id_conditionComboBox.SelectedItem as app_condition; app_contract app_contract = id_contractComboBox.SelectedItem as app_contract; if (contact != null && app_condition != null && app_contract != null) { using (SalesBudgetDB db = new SalesBudgetDB()) { sales_budget sales_budget = new sales_budget(); sales_budget.IsSelected = true; sales_budget.State = EntityState.Added; sales_budget.status = Status.Documents_General.Pending; sales_budget.id_contact = contact.id_contact; sales_budget.contact = db.contacts.Where(x => x.id_contact == contact.id_contact).FirstOrDefault(); if (CurrentSession.Id_Branch > 0) { sales_budget.id_branch = CurrentSession.Id_Branch; } else { sales_budget.id_branch = db.app_branch.Where(a => a.is_active == true && a.id_company == CurrentSession.Id_Company).FirstOrDefault().id_branch; } sales_budget.id_condition = app_condition.id_condition; sales_budget.id_contract = app_contract.id_contract; sales_budget.id_currencyfx = project_costing.id_currencyfx; foreach (project_event_variable project_event_variable in project_costing.project_event_variable.Where(a => a.is_included == true)) { sales_budget_detail sales_budget_detail = new sales_budget_detail(); sales_budget_detail.sales_budget = sales_budget; sales_budget_detail.item = db.items.Where(a => a.id_item == project_event_variable.id_item).FirstOrDefault(); sales_budget_detail.id_item = project_event_variable.id_item; sales_budget_detail.quantity = ((project_event_variable.adult_consumption) + (project_event_variable.child_consumption)); sales_budget_detail.UnitPrice_Vat = Math.Round(get_Price(contact, IDcurrencyfx, sales_budget_detail.item, entity.App.Modules.Sales)); sales_budget.sales_budget_detail.Add(sales_budget_detail); } foreach (project_event_fixed project_event_fixed in project_costing.project_event_fixed.Where(a => a.is_included == true)) { sales_budget_detail sales_budget_detail = new sales_budget_detail(); sales_budget_detail.sales_budget = sales_budget; sales_budget_detail.item = db.items.Where(a => a.id_item == project_event_fixed.id_item).FirstOrDefault(); sales_budget_detail.id_item = project_event_fixed.id_item; sales_budget_detail.quantity = project_event_fixed.consumption; sales_budget_detail.UnitPrice_Vat = Math.Round(get_Price(contact, IDcurrencyfx, sales_budget_detail.item, entity.App.Modules.Sales)); sales_budget.sales_budget_detail.Add(sales_budget_detail); } sales_budget_detail sales_budget_detail_hall = new sales_budget_detail(); sales_budget_detail_hall.sales_budget = sales_budget; sales_budget_detail_hall.item = db.items.Where(a => a.id_item == project_costing.id_item).FirstOrDefault(); sales_budget_detail_hall.id_item = project_costing.id_item; sales_budget_detail_hall.quantity = 1; sales_budget_detail_hall.UnitPrice_Vat = Math.Round(get_Price(contact, IDcurrencyfx, sales_budget_detail_hall.item, entity.App.Modules.Sales)); sales_budget.sales_budget_detail.Add(sales_budget_detail_hall); db.sales_budget.Add(sales_budget); db.SaveChanges(); } lblCancel_MouseDown(null, null); } else { if (MessageBox.Show("VALIDATION EXCEPTION : Please fill up all the fields", "Cognitivo", MessageBoxButton.OKCancel, MessageBoxImage.Asterisk) == MessageBoxResult.Cancel) { lblCancel_MouseDown(null, null); } } } }