private void CreateFile(app_document_range app_range) { string path = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + "\\CogntivoERP"; //If path (CognitivoERP) does not exist, create path. if (Directory.Exists(path) == false) { Directory.CreateDirectory(path); } string SubFolder = "\\TemplateFiles"; //If path (TemplateFiles) does not exist, create path if (!Directory.Exists(path + SubFolder)) { Directory.CreateDirectory(path + SubFolder); } //If file does not exist, create file. if (!File.Exists(path + SubFolder + "\\" + app_range.app_document.name + ".rdlc")) { //Add Logic if (File.Exists(AppDomain.CurrentDomain.BaseDirectory + app_range.app_document.id_application.ToString() + ".rdlc")) { File.Copy(AppDomain.CurrentDomain.BaseDirectory + app_range.app_document.id_application.ToString() + ".rdlc", path + SubFolder + "\\" + app_range.app_document.name + ".rdlc"); } } }
private void cbxDocument_SelectionChanged(object sender, SelectionChangedEventArgs e) { if (cbxDocument.SelectedItem != null) { app_document_range app_document_range = cbxDocument.SelectedItem as app_document_range; app_document_range _app_range = SalesOrderDB.app_document_range.Where(x => x.id_range == app_document_range.id_range).FirstOrDefault(); if (SalesOrderDB.app_branch.Where(x => x.id_branch == CurrentSession.Id_Branch).FirstOrDefault() != null) { entity.Brillo.Logic.Range.branch_Code = SalesOrderDB.app_branch.Where(x => x.id_branch == CurrentSession.Id_Branch).FirstOrDefault().code; } if (SalesOrderDB.app_terminal.Where(x => x.id_terminal == CurrentSession.Id_Terminal).FirstOrDefault() != null) { entity.Brillo.Logic.Range.terminal_Code = SalesOrderDB.app_terminal.Where(x => x.id_terminal == CurrentSession.Id_Terminal).FirstOrDefault().code; } if (SalesOrderDB.security_user.Where(x => x.id_user == CurrentSession.Id_User).FirstOrDefault() != null) { entity.Brillo.Logic.Range.user_Code = SalesOrderDB.security_user.Where(x => x.id_user == CurrentSession.Id_User).FirstOrDefault().code; } txtnumber.Text = entity.Brillo.Logic.Range.calc_Range(_app_range, false); } }
private void toolBar_btnPrint_Click(object sender, MouseButtonEventArgs e) { purchase_invoice purchase_invoice = purchase_invoiceDataGrid.SelectedItem as purchase_invoice; if (purchase_invoice != null) { app_document_range app_document_range; if (purchase_invoice.app_document_range != null) { app_document_range = purchase_invoice.app_document_range; } else { app_document app_document = new entity.app_document(); app_document.id_application = entity.App.Names.PurchaseInvoice; app_document.name = "PurchaseInvoice"; app_document_range = new app_document_range(); app_document_range.use_default_printer = false; app_document_range.app_document = app_document; } entity.Brillo.Document.Start.Manual(purchase_invoice, app_document_range); } else { toolBar.msgWarning("Please select"); } }
public static void Manual(object Document, app_document_range Range) { if (Range != null) { Normal Normal = new Normal(Document, Range, Normal.PrintStyles.Manual); } }
private void ComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e) { if (cmbdocument.SelectedValue != null) { entity.Brillo.Logic.Document _Document = new entity.Brillo.Logic.Document(); app_document_range app_document_range = (app_document_range)cmbdocument.SelectedItem; _number = entity.Brillo.Logic.Range.calc_Range(app_document_range, false); } }
public Normal(object Document, app_document_range app_range, PrintStyles PrintStyle) { if (app_range.app_document != null ? app_range.app_document.style_reciept : false || app_range.app_document != null ? app_range.app_document.id_application == App.Names.PointOfSale:false) { TicketPrint.Document_Print(app_range.app_document.id_document, Document); } else { string DocumentName = string.Empty; if (app_range != null) { DocumentName = app_range.app_document.name; } else { DocumentName = "PurchaseInvoice"; } string PathFull = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + "\\CogntivoERP\\TemplateFiles\\" + app_range.app_document.name + ".rdlc"; if (Directory.Exists(PathFull) == false) { CreateFile(app_range); } DataSource DataSource = new DataSource(); /// if (PrintStyle == PrintStyles.Automatic && !app_range.use_default_printer && app_range.printer_name != null) { LocalReport LocalReport = new LocalReport(); PrintInvoice PrintInvoice = new PrintInvoice(); LocalReport.ReportPath = PathFull; // Path of the rdlc file LocalReport.DataSources.Add(DataSource.Create(Document)); PrintInvoice.Export(LocalReport); PrintInvoice.Print(app_range.printer_name); } else { DocumentViewr DocumentViewr = new DocumentViewr(); DocumentViewr.reportViewer.LocalReport.ReportPath = PathFull; // Path of the rdlc file DocumentViewr.reportViewer.LocalReport.DataSources.Add(DataSource.Create(Document)); DocumentViewr.reportViewer.RefreshReport(); Window window = new Window { Title = "Report", Content = DocumentViewr }; window.ShowDialog(); } } }
private void btnNew_Click(object sender, RoutedEventArgs e) { crud_modal.Visibility = System.Windows.Visibility.Visible; cntrl.range objRange = new cntrl.range(); app_document_range app_document_range = new app_document_range(); entity.db.app_document_range.Add(app_document_range); document_rangeViewSource.View.MoveCurrentToLast(); objRange.document_rangeViewSource = document_rangeViewSource; objRange.entity = entity; crud_modal.Children.Add(objRange); }
public static int?Return_RangeID(App.Names AppName) { using (db db = new db()) { //Returns Range from a Using Context. Do not Use Range as Is. Must convert into ID and then pass it on. app_document_range app_document_range = Logic.Range.List_Range(db, AppName, CurrentSession.Id_Branch, CurrentSession.Id_Terminal).FirstOrDefault(); if (app_document_range != null) { return(app_document_range.id_range); } } return(null); }
public static string calc_Range(app_document_range original_app_document_range, bool is_generated) { string prefix = string.Empty; if (original_app_document_range != null) { int current_value = original_app_document_range.range_current; int end_value = original_app_document_range.range_end; //Range Calculator prefix = original_app_document_range.range_template; prefix = return_Prefix(prefix); if (prefix != null & current_value <= end_value) { ///Get latest Current Value to be sure we don't use the same value somebody else has already used. using (db db = new db()) { app_document_range _app_document_range = db.app_document_range.Where(x => x.id_range == original_app_document_range.id_range).FirstOrDefault(); //Range if (prefix.Contains("#Range")) { //Add Padding filler _app_document_range.range_current += 1; string str = _app_document_range.range_current.ToString(original_app_document_range.range_padding); prefix = prefix.Replace("#Range", str); } else { _app_document_range.range_current += 1; prefix = prefix + _app_document_range.range_current.ToString(original_app_document_range.range_padding); } if (is_generated) { original_app_document_range.range_current = _app_document_range.range_current; if (original_app_document_range.range_current == end_value) { original_app_document_range.is_active = false; } //Save new number into database, as quick as possible. db.SaveChangesAsync(); } } } } return(prefix); }
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; }
private void btnDelete_Click(object sender, RoutedEventArgs e) { try { MessageBoxResult res = MessageBox.Show("Are you sure want to Delete?", "Cognitivo", MessageBoxButton.YesNo, MessageBoxImage.Question); if (res == MessageBoxResult.Yes) { app_document_range app_document_range = document_rangeViewSource.View.CurrentItem as app_document_range; app_document_range.is_active = false; btnSave_Click(sender, e); } } catch (Exception ex) { throw ex; } }
private void toolBar_btnSave_Click(object sender) { production_order _production_order = (production_order)production_orderDataGrid.SelectedItem; if ((_production_order.work_number == null || _production_order.work_number == string.Empty) && _production_order.id_range > 0) { if (_production_order.id_branch > 0) { entity.Brillo.Logic.Range.branch_Code = OrderDB.app_branch.Where(x => x.id_branch == _production_order.id_branch).FirstOrDefault().code; } if (_production_order.id_terminal > 0) { entity.Brillo.Logic.Range.terminal_Code = OrderDB.app_terminal.Where(x => x.id_terminal == _production_order.id_terminal).FirstOrDefault().code; } app_document_range app_document_range = OrderDB.app_document_range.Where(x => x.id_range == _production_order.id_range).FirstOrDefault(); _production_order.work_number = entity.Brillo.Logic.Range.calc_Range(app_document_range, true); _production_order.RaisePropertyChanged("work_number"); } OrderDB.SaveChanges(); }
private void btnSave_Click(object sender, RoutedEventArgs e) { payment_schedual payment_schedual = payment_schedualViewSource.View.CurrentItem as payment_schedual; if (payment_schedual != null) { if (payment_schedual.id_range > 0) { app_document_range app_document_range = PaymentDBold.app_document_range.Where(x => x.id_range == payment_schedual.id_range).FirstOrDefault(); if (app_document_range != null) { payment_schedual.number = entity.Brillo.Logic.Range.calc_Range(app_document_range, true); entity.Brillo.Document.Start.Manual(payment_schedual, app_document_range); } } payment_schedual.status = Status.Documents_General.Approved; payment_schedual.RaisePropertyChanged("status"); try { PaymentDBold.SaveChanges(); } catch (Exception) { throw; } if (SaveChanges != null) { SaveChanges(this, new RoutedEventArgs()); } Grid parentGrid = (Grid)this.Parent; parentGrid.Children.Clear(); parentGrid.Visibility = Visibility.Hidden; } }
private void toolBar_btnApprove_Click(object sender) { if (project_taskViewSource.View != null) { project_taskViewSource.View.Filter = null; List <project_task> _project_task = treeProject.ItemsSource.Cast <project_task>().ToList(); _project_task = _project_task.Where(x => x.IsSelected == true).ToList(); app_document_range app_document_range = ProjectTaskDB.app_document_range.Where(x => x.id_range == Project_TaskApprove.id_range).FirstOrDefault(); string number = entity.Brillo.Logic.Range.calc_Range(app_document_range, true); foreach (project_task project_task in _project_task) { project_task.project.code = Project_TaskApprove.code; if (Project_TaskApprove.id_range != null) { project_task.id_range = Project_TaskApprove.id_range; // app_document_range = ProjectTaskDB.app_document_range.Where(x => x.id_range == Project_TaskApprove.id_range).FirstOrDefault(); if (app_document_range != null) { project_task.app_document_range = app_document_range; project_task.number = number; } } // project_task.number = number; if (project_task.status == Status.Project.Management_Approved) { if (project_task.status == Status.Project.Management_Approved || project_task.status == null) { project_task.status = Status.Project.Approved; } } project_task.IsSelected = false; } ProjectTaskDB.SaveChanges(); entity.Brillo.Document.Start.Automatic(_project_task.FirstOrDefault().project, _project_task.FirstOrDefault().app_document_range); filter_task(); } }
private void toolBar_btnApprove_Click(object sender) { item_transfer item_transfer = item_transferViewSource.View.CurrentItem as item_transfer; if ((item_transfer.number == null || item_transfer.number == string.Empty) && item_transfer.app_document_range != null) { entity.Brillo.Logic.Document _Document = new entity.Brillo.Logic.Document(); if (item_transfer.id_branch > 0) { if (dbContext.app_branch.Where(x => x.id_branch == item_transfer.id_branch).FirstOrDefault() != null) { entity.Brillo.Logic.Range.branch_Code = dbContext.app_branch.Where(x => x.id_branch == item_transfer.id_branch).FirstOrDefault().code; } } if (item_transfer.id_terminal > 0) { if (dbContext.app_terminal.Where(x => x.id_terminal == item_transfer.id_terminal).FirstOrDefault() != null) { entity.Brillo.Logic.Range.terminal_Code = dbContext.app_terminal.Where(x => x.id_terminal == item_transfer.id_terminal).FirstOrDefault().code; } } if (item_transfer.id_user > 0) { if (dbContext.security_user.Where(x => x.id_user == item_transfer.id_user).FirstOrDefault() != null) { entity.Brillo.Logic.Range.user_Code = dbContext.security_user.Where(x => x.id_user == item_transfer.id_user).FirstOrDefault().code; } } if (item_transfer.id_project > 0) { if (dbContext.projects.Where(x => x.id_project == item_transfer.id_project).FirstOrDefault() != null) { entity.Brillo.Logic.Range.project_Code = dbContext.projects.Where(x => x.id_project == item_transfer.id_project).FirstOrDefault().code; } } app_document_range app_document_range = item_transfer.app_document_range; item_transfer.number = entity.Brillo.Logic.Range.calc_Range(app_document_range, true); } item_transfer.user_requested = dbContext.security_user.Where(x => x.id_user == CurrentSession.Id_User).FirstOrDefault(); item_transfer.user_given = dbContext.security_user.Where(x => x.id_user == CurrentSession.Id_User).FirstOrDefault(); item_transfer.status = Status.Transfer.Approved; dbContext.SaveChanges(); for (int i = 0; i < item_transfer_detailDataGrid.Items.Count; i++) { entity.Brillo.Logic.Stock stock = new entity.Brillo.Logic.Stock(); item_transfer_detail item_transfer_detail = (item_transfer_detail)item_transfer_detailDataGrid.Items[i]; List <entity.Brillo.StockList> Items_InStockLIST; app_currencyfx app_currencyfx = ProductMovementDB.app_currencyfx.Where(x => x.app_currency.is_active).FirstOrDefault(); app_location app_location = item_transfer_detail.item_transfer.app_location_origin; if (itemMovement.item_movement != null) { entity.Brillo.Stock stockBrillo = new entity.Brillo.Stock(); Items_InStockLIST = stockBrillo.ScalarMovement(itemMovement.item_movement); } else { entity.Brillo.Stock stockBrillo = new entity.Brillo.Stock(); Items_InStockLIST = stockBrillo.List(app_location.app_branch, app_location, item_transfer_detail.item_product); } ///Debit Movement from Origin. List <item_movement> item_movement_originList; item_movement_originList = stock.DebitOnly_MovementLIST(ProductMovementDB, Items_InStockLIST, Status.Stock.InStock, entity.App.Names.Movement, item_transfer_detail.id_transfer, item_transfer_detail.id_transfer_detail, app_currencyfx, item_transfer_detail.item_product, app_location, item_transfer_detail.quantity_origin, item_transfer_detail.item_transfer.trans_date, stock.comment_Generator(entity.App.Names.Movement, item_transfer_detail.item_transfer.number != null ? item_transfer_detail.item_transfer.number.ToString() : "", "")); ProductMovementDB.item_movement.AddRange(item_movement_originList); //Credit Movement to Destination item_movement item_movement_dest; item_movement parent_item_movement = item_movement_originList.FirstOrDefault(); List <item_movement_dimension> DimensionList = null; if (item_movement_originList.FirstOrDefault().item_movement_dimension.Count() > 0) { DimensionList = new List <item_movement_dimension>(); foreach (item_movement_dimension item_movement_dimension in item_movement_originList.FirstOrDefault().item_movement_dimension) { item_movement_dimension _item_movement_dimension = new item_movement_dimension(); _item_movement_dimension.id_dimension = item_movement_dimension.id_dimension; _item_movement_dimension.value = item_movement_dimension.value; DimensionList.Add(_item_movement_dimension); } } item_movement_dest = stock.CreditOnly_Movement( Status.Stock.InStock, entity.App.Names.Movement, item_transfer_detail.id_transfer, item_transfer_detail.id_transfer_detail, app_currencyfx, item_transfer_detail.item_product, item_transfer_detail.item_transfer.app_location_destination, item_transfer_detail.quantity_destination, item_transfer_detail.item_transfer.trans_date, item_movement_originList.Sum(x => (x.item_movement_value.Sum(y => y.unit_value) / (x.item_movement_value.Count() != 0 ? x.item_movement_value.Count() : 1))), stock.comment_Generator(entity.App.Names.Movement, item_transfer_detail.item_transfer.number != null ? item_transfer_detail.item_transfer.number.ToString() : "", ""), DimensionList ); //item_movement_dest._parent = Items_InStockLIST.FirstOrDefault(); ProductMovementDB.item_movement.Add(item_movement_dest); item_transfer.status = Status.Transfer.Approved; } if (item_transfer.status == Status.Transfer.Approved && item_transfer.app_document_range != null) { entity.Brillo.Document.Start.Automatic(item_transfer, item_transfer.app_document_range); } if (ProductMovementDB.SaveChanges() > 0) { toolBar.msgSaved(ProductMovementDB.NumberOfRecords); itemMovement = new Configs.itemMovement(); } }