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