public sales_packing New() { sales_packing sales_packing = new sales_packing(); sales_packing.State = EntityState.Added; sales_packing.id_range = Brillo.GetDefault.Return_RangeID(App.Names.PackingList); sales_packing.IsSelected = true; return(sales_packing); }
private void add_CRM(sales_packing sales_packing) { if (sales_packing.id_sales_packing == 0 || sales_packing == null) { crm_opportunity crm_opportunity = new crm_opportunity(); crm_opportunity.id_contact = sales_packing.id_contact; crm_opportunity.sales_packing.Add(sales_packing); base.crm_opportunity.Add(crm_opportunity); } else { crm_opportunity crm_opportunity = sales_order.Where(x => x.id_sales_order == sales_packing.id_sales_packing).FirstOrDefault().crm_opportunity; crm_opportunity.sales_packing.Add(sales_packing); base.crm_opportunity.Attach(crm_opportunity); } }
public void loadSalesPackingList(int id) { try { ReportDataSource reportDataSource = new ReportDataSource(); reportDataSource.Name = "DataSet1"; // Name of the DataSet we set in .rdlc sales_packing sales_packing = db.sales_packing.Where(x => x.id_sales_packing == id).FirstOrDefault(); List <sales_packing_detail> sales_packing_detail = db.sales_packing_detail.Where(x => x.id_sales_packing == sales_packing.id_sales_packing).ToList(); reportDataSource.Value = sales_packing_detail .Select(g => new { contact_name = g.sales_packing.contact.name, customer_address = g.sales_packing.contact.address, customer_telephone = g.sales_packing.contact.telephone, customer_email = g.sales_packing.contact.email, company_Name = g.app_company.name, sales_terminal = g.sales_packing.app_terminal.name, branch_Name = g.sales_packing.app_branch.name, security_user_name = g.sales_packing.security_user.name, trans_date = g.sales_packing.trans_date, sales_order_Comment = g.sales_packing.comment, item_code = g.item.code, item_description = g.item.name, item_brand = g.item.item_brand != null ? g.item.item_brand.name : "", quantity = g.quantity, }).ToList(); string path = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments); path = path + "\\CogntivoERP"; string SubFolder = ""; SubFolder = "\\TemplateFiles"; if (!Directory.Exists(path)) { Directory.CreateDirectory(path); Directory.CreateDirectory(path + SubFolder); File.Copy(AppDomain.CurrentDomain.BaseDirectory + "\\bin\\debug\\Sales_PackingList.rdlc", path + SubFolder + "\\Sales_PackingList.rdlc"); } else if (!Directory.Exists(path + SubFolder)) { Directory.CreateDirectory(path + SubFolder); File.Copy(AppDomain.CurrentDomain.BaseDirectory + "\\bin\\debug\\Sales_PackingList.rdlc", path + SubFolder + "\\Sales_PackingList.rdlc"); } else if (!File.Exists(path + SubFolder + "\\Sales_PackingList.rdlc")) { File.Copy(AppDomain.CurrentDomain.BaseDirectory + "\\bin\\debug\\Sales_PackingList.rdlc", path + SubFolder + "\\Sales_PackingList.rdlc"); } if (!sales_packing.app_document_range.use_default_printer) { reportViewer.LocalReport.ReportPath = path + SubFolder + "\\Sales_PackingList.rdlc"; // Path of the rdlc file reportViewer.LocalReport.DataSources.Add(reportDataSource); reportViewer.RefreshReport(); } else { try { if (sales_packing.app_document_range.printer_name != null) { LocalReport report = new LocalReport(); PrintInvoice PrintInvoice = new PrintInvoice(); report.ReportPath = path + SubFolder + "\\Sales_PackingList.rdlc"; // Path of the rdlc file report.DataSources.Add(reportDataSource); PrintInvoice.Export(report); PrintInvoice.Print(sales_packing.app_document_range.printer_name); } else { NotSupportedException ex = new NotSupportedException(); throw ex; } } catch { reportViewer.LocalReport.ReportPath = path + SubFolder + "\\Sales_PackingList.rdlc"; // Path of the rdlc file reportViewer.LocalReport.DataSources.Add(reportDataSource); reportViewer.RefreshReport(); Window window = new Window { Title = "Report", Content = this }; window.ShowDialog(); } } } catch { } }