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