public void SalesOrder_Click(object sender)
{
sales_packing sales_packing = (sales_packing)sales_packingViewSource.View.CurrentItem;
foreach (sales_order item in pnlSalesOrder.selected_sales_order)
{
foreach (sales_order_detail _sales_order_detail in item.sales_order_detail)
{
if (sales_packing.sales_packing_detail.Where(x => x.id_item == _sales_order_detail.id_item).Count() == 0)
{
sales_packing_detail sales_packing_detail = new sales_packing_detail();
sales_packing_detail.id_sales_order_detail = _sales_order_detail.id_sales_order_detail;
sales_packing_detail.id_item = _sales_order_detail.id_item;
sales_packing_detail.item = _sales_order_detail.item;
sales_packing_detail.quantity = _sales_order_detail.quantity;
sales_packing.sales_packing_detail.Add(sales_packing_detail);
}
sales_packingsales_packinglist_detailViewSource.View.Refresh();
dbContext.Entry(sales_packing).Entity.State = EntityState.Added;
crud_modal.Children.Clear();
crud_modal.Visibility = Visibility.Collapsed;
}
}
}
private void select_Item(sales_packing sales_packing, item item, app_branch app_branch)
{
if (sales_packing.sales_packing_detail.Where(a => a.id_item == item.id_item).FirstOrDefault() == null)
{
sales_packing_detail _sales_packing_detail = new sales_packing_detail();
_sales_packing_detail.sales_packing = sales_packing;
_sales_packing_detail.item = item;
_sales_packing_detail.quantity = 1;
_sales_packing_detail.id_item = item.id_item;
if (app_branch != null)
{
_sales_packing_detail.id_location = app_branch.app_location.Where(x => x.is_default).FirstOrDefault().id_location;
_sales_packing_detail.app_location = app_branch.app_location.Where(x => x.is_default).FirstOrDefault();
}
sales_packing.sales_packing_detail.Add(_sales_packing_detail);
}
else
{
sales_packing_detail sales_packing_detail = sales_packing.sales_packing_detail.Where(a => a.id_item == item.id_item).FirstOrDefault();
sales_packing_detail.quantity += 1;
}
Dispatcher.BeginInvoke((Action)(() =>
{
sales_packingsales_packinglist_detailViewSource.View.Refresh();
}));
}
private void salespackinglist_PreviewMouseUp(object sender, MouseButtonEventArgs e)
{
Hyperlink Hyperlink = (Hyperlink)sender;
sales_packing sales_packing = (sales_packing)Hyperlink.Tag;
if (sales_packing != null)
{
entity.Brillo.Document.Start.Automatic(sales_packing, sales_packing.app_document_range);
}
}
private void toolBar_btnNew_Click(object sender)
{
PackingListSetting _pref_SalesOrder = new PackingListSetting();
sales_packing sales_packing = dbContext.New();
sales_packing.trans_date = DateTime.Now.AddDays(SalesSettings.TransDate_Offset);
dbContext.sales_packing.Add(sales_packing);
sales_packingViewSource.View.Refresh();
sales_packingViewSource.View.MoveCurrentToLast();
}
private void toolBar_btnPrint_Click(object sender, MouseButtonEventArgs e)
{
sales_packing sales_packing = sales_packingDataGrid.SelectedItem as sales_packing;
if (sales_packing != null)
{
entity.Brillo.Document.Start.Manual(sales_packing, sales_packing.app_document_range);
}
else
{
toolBar.msgWarning("Please select");
}
}
private void toolBar_btnEdit_Click(object sender)
{
if (sales_packingDataGrid.SelectedItem != null)
{
sales_packing sales_packing = (sales_packing)sales_packingDataGrid.SelectedItem;
sales_packing.IsSelected = true;
sales_packing.State = System.Data.Entity.EntityState.Unchanged;
dbContext.Entry(sales_packing).State = EntityState.Modified;
sales_packingViewSource.View.Refresh();
}
else
{
toolBar.msgWarning("Please Select an Item");
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
sales_packing sales_packing = sales_packingViewSource.View.CurrentItem as sales_packing;
item_movement item_movement = item_movementViewSource.View.CurrentItem as item_movement;
sales_packing.contact = item_movement.sales_invoice_detail.sales_invoice.contact;
sales_packing.id_contact = item_movement.sales_invoice_detail.sales_invoice.id_contact;
foreach (item_movement _item_movement in item_movementViewSource.View.OfType <item_movement>().ToList())
{
//Creates a Packing Detail
sales_packing_detail sales_packing_detail = new sales_packing_detail();
sales_packing_detail.id_location = _item_movement.id_location;
sales_packing_detail.id_item = _item_movement.item_product.id_item;
sales_packing_detail.quantity = _item_movement.debit;
sales_packing_detail.sales_packing = sales_packing;
//Creates relationship with Sales Invoice.
sales_packing_relation sales_packing_relation = new entity.sales_packing_relation();
sales_packing_relation.sales_packing_detail = sales_packing_detail;
sales_packing_relation.id_sales_invoice_detail = (long)_item_movement.id_sales_invoice_detail;
sales_packing.id_opportunity = _item_movement.sales_invoice_detail.sales_invoice.id_opportunity;
dbContext.sales_packing_relation.Add(sales_packing_relation);
sales_packing.sales_packing_detail.Add(sales_packing_detail);
//Relates the Item Movement to Packing
_item_movement.sales_packing_detail = sales_packing_detail;
}
if (sales_packing.number == null && sales_packing.id_range > 0)
{
entity.Brillo.Logic.Range.branch_Code = dbContext.app_branch.Where(x => x.id_branch == sales_packing.id_branch).FirstOrDefault().code;
entity.Brillo.Logic.Range.terminal_Code = dbContext.app_terminal.Where(x => x.id_terminal == sales_packing.id_terminal).FirstOrDefault().code;
app_document_range app_document_range = dbContext.app_document_range.Where(x => x.id_range == sales_packing.id_range).FirstOrDefault();
sales_packing.number = entity.Brillo.Logic.Range.calc_Range(app_document_range, true);
sales_packing.RaisePropertyChanged("number");
sales_packing.is_issued = true;
entity.Brillo.Document.Start.Automatic(sales_packing, app_document_range);
}
else
{
sales_packing.is_issued = false;
}
dbContext.SaveChanges();
item_movementViewSource.Source = null;
}
public void Link_Click(object sender)
{
sales_invoice _sales_invoice = (sales_invoice)sales_invoiceViewSource.View.CurrentItem;
foreach (sales_packing item in pnlPacking.selected_sales_packing)
{
sales_packing sales_packing = SalesInvoiceDB.sales_packing.Where(x => x.id_sales_packing == item.id_sales_packing).FirstOrDefault();
foreach (sales_packing_detail _sales_packing_detail in sales_packing.sales_packing_detail)
{
if (_sales_invoice.sales_invoice_detail.Where(x => x.id_item == _sales_packing_detail.id_item).Count() == 0)
{
sales_invoice_detail sales_invoice_detail = new sales_invoice_detail();
sales_invoice_detail.sales_invoice = _sales_invoice;
sales_invoice_detail.Contact = SalesInvoiceDB.contacts.Where(x => x.id_contact == sbxContact.ContactID).FirstOrDefault();// sbxContact.Contact;
sales_invoice_detail.item = _sales_packing_detail.item;
sales_invoice_detail.id_item = _sales_packing_detail.id_item;
sales_invoice_detail.quantity = _sales_packing_detail.quantity;
// sales_invoice_detail.unit_price = 0;
sales_packing_relation sales_packing_relation = new sales_packing_relation();
sales_packing_relation.id_sales_packing_detail = _sales_packing_detail.id_sales_packing_detail;
sales_packing_relation.sales_packing_detail = _sales_packing_detail;
sales_invoice_detail.sales_packing_relation.Add(sales_packing_relation);
_sales_invoice.sales_invoice_detail.Add(sales_invoice_detail);
}
}
CollectionViewSource sales_invoicesales_invoice_detailViewSource = FindResource("sales_invoicesales_invoice_detailViewSource") as CollectionViewSource;
sales_invoicesales_invoice_detailViewSource.View.Refresh();
sales_invoicesales_invoice_detailViewSource.View.MoveCurrentToFirst();
}
CollectionViewSource sales_invoicesales_invoice_detailsales_packinglist_relationViewSource = FindResource("sales_invoicesales_invoice_detailsales_packinglist_relationViewSource") as CollectionViewSource;
if (sales_invoicesales_invoice_detailsales_packinglist_relationViewSource != null)
{
sales_invoicesales_invoice_detailsales_packinglist_relationViewSource.Source = SalesInvoiceDB.sales_packing_relation.Local.Where(x => x.sales_invoice_detail.id_sales_invoice == _sales_invoice.id_sales_invoice).ToList();
}
else
{
sales_invoicesales_invoice_detailsales_packinglist_relationViewSource.Source = null;
}
crud_modal.Children.Clear();
crud_modal.Visibility = Visibility.Collapsed;
_sales_invoice.RaisePropertyChanged("GrandTotal");
}
private void set_ContactPref(object sender, EventArgs e)
{
try
{
if (sbxContact.ContactID > 0)
{
contact contact = dbContext.contacts.Where(x => x.id_contact == sbxContact.ContactID).FirstOrDefault();
sales_packing sales_packing = (sales_packing)sales_packingDataGrid.SelectedItem;
sales_packing.id_contact = contact.id_contact;
sales_packing.contact = contact;
}
}
catch (Exception ex)
{
toolBar.msgError(ex);
}
}
public Packing()
{
InitializeComponent();
item_movementViewSource = ((CollectionViewSource)(FindResource("item_movementViewSource")));
inventoryViewSource = ((CollectionViewSource)(FindResource("inventoryViewSource")));
cbxDocument.ItemsSource = entity.Brillo.Logic.Range.List_Range(dbContext, entity.App.Names.PackingList, CurrentSession.Id_Branch, CurrentSession.Id_Terminal);
sales_packing sales_packing = new sales_packing();
dbContext.sales_packing.Add(sales_packing);
sales_packingViewSource = ((CollectionViewSource)(FindResource("sales_packingViewSource")));
sales_packingViewSource.Source = dbContext.sales_packing.Local;
sales_packingViewSource.View.MoveCurrentToLast();
app_branch = dbContext.app_branch.Where(x => x.id_branch == CurrentSession.Id_Branch).FirstOrDefault();
cbxLocation.ItemsSource = app_branch.app_location.ToList();
}
private void item_Select(object sender, EventArgs e)
{
app_branch app_branch = null;
if (sbxItem.ItemID > 0)
{
sales_packing sales_packing = sales_packingViewSource.View.CurrentItem as sales_packing;
item item = dbContext.items.Where(x => x.id_item == sbxItem.ItemID).FirstOrDefault();
if (item != null && item.id_item > 0 && sales_packing != null)
{
if (cbxBranch.SelectedItem != null)
{
app_branch = cbxBranch.SelectedItem as app_branch;
}
Task Thread = Task.Factory.StartNew(() => select_Item(sales_packing, item, app_branch));
}
}
}
//packinglist
public void Document_PrintPackingList(int document_id, sales_packing sales_packing)
{
app_document app_document;
using (db db = new db())
{
app_document = db.app_document.Where(x => x.id_document == document_id).FirstOrDefault();
}
if (app_document != null)
{
if (app_document.style_reciept == true)
{
string header = app_document.reciept_header;
string Mainheader = "";
foreach (sales_packing_detail sales_packing_detail in sales_packing.sales_packing_detail)
{
Mainheader += header.Replace("<<item>>", sales_packing_detail.item.name);
Mainheader += header.Replace("<<debit>>", sales_packing_detail.quantity.ToString());
Mainheader += header.Replace("<<Credit>>", "0");
Mainheader += header.Replace("<<Transcation>>", sales_packing.trans_date.ToString());
Mainheader += "\n";
}
string footer = app_document.reciept_footer;
string Mainfooter = "";
foreach (sales_packing_detail sales_packing_detail in sales_packing.sales_packing_detail)
{
Mainfooter += footer.Replace("<<item>>", sales_packing_detail.item.name);
Mainfooter += footer.Replace("<<debit>>", sales_packing_detail.quantity.ToString());
Mainfooter += footer.Replace("<<Credit>>", "0");
Mainfooter += footer.Replace("<<Transcation>>", sales_packing.trans_date.ToString());
Mainfooter += "\n";
}
string body = app_document.reciept_body;
string Mainbody = "";
foreach (sales_packing_detail sales_packing_detail in sales_packing.sales_packing_detail)
{
Mainbody += body.Replace("<<item>>", sales_packing_detail.item.name);
Mainbody += body.Replace("<<debit>>", sales_packing_detail.quantity.ToString());
Mainbody += body.Replace("<<Credit>>", "0");
Mainbody += body.Replace("<<Transcation>>", sales_packing.trans_date.ToString());
Mainbody += "\n";
}
PrintDialog pd = new PrintDialog();
FlowDocument doc = new FlowDocument(new Paragraph(new Run(Mainheader + "\n\n" + Mainbody + "\n\n" + Mainfooter)));
doc.Name = "FlowDoc";
IDocumentPaginatorSource idpSource = doc;
pd.PrintDocument(idpSource.DocumentPaginator, Mainheader + "\n\n" + Mainbody + "\n\n" + Mainfooter);
}
else if (app_document.style_printer == true)
{
if (sales_packing.app_document_range.printer_name != null)
{
DocumentViewr MainWindow = new DocumentViewr();
MainWindow.loadSalesPackingList(sales_packing.id_sales_packing);
}
else
{
DocumentViewr MainWindow = new DocumentViewr();
MainWindow.loadSalesPackingList(sales_packing.id_sales_packing);
Window window = new Window
{
Title = "Report",
Content = MainWindow
};
window.ShowDialog();
}
}
}
}
