public List<InvoiceDetail> GetFactureDetails(FactureCase fc) { var details = new List<InvoiceDetail>(); try { foreach (OrderDetail od in fc.Facture.Order.OrderDetails) { OrderDetail getDetail = od; Customer getCustomer = fc.Facture.Order.Customer; Product getProduct = getDetail.Product; Facture getFacture = fc.Facture; if (getFacture.FactureDate == null) continue; InvoiceDetail id = new InvoiceDetail { InvoiceDate = (DateTime) getFacture.FactureDate, InvoiceNumber = getFacture.FactureID, PayMode = fc.Facture.TypePayment, RS = getCustomer.CompanyName, ProductNAme = getProduct.ProductName, Quantity = getDetail.Quantity, UnitPrice = getDetail.UnitPrice, Amount = getDetail.UnitPrice*getDetail.Quantity, TotalHT = fc.TotalHt, PTVA = fc.Tva*fc.TotalHt, TVA = fc.Tva, Total = fc.Ttc, Timbre = fc.Timbre }; details.Add(id); } return details; } catch (Exception) { return null; } }
private void PrintBtn_Click(object sender, RoutedEventArgs e) { if (DgFactures.VisibleRowCount == 0) return; int rowHandle = DgFactures.View.FocusedRowHandle; if (rowHandle < 0) return; var orderClient = new OrderClient(); var ordre = orderClient.GetOrderById(Convert.ToInt32(DgFactures.GetCellValue(rowHandle, "OrderID"))); if (ordre == null) return; /* la fcture dans la base de données */ var factureClient = new FacturesClient(); var facture = new Facture { FactureDate = DateTime.Now, Order = ordre, FactureNum = Convert.ToInt32(NumTxtBox.Text), TVA = _tvaClient.GetTvaByName(_tva.ToString()), TypePayment = CbPayment.Text, Status = 0, Type = TypeFacture }; //ou facture proforma factureClient.AddFacture(facture); /* fin de l'ajout de la facture a la base de données */ /* debut de l'impression de la facture */ var settingsClient = new SettingsClient(); Setting settings = settingsClient.GetSetting(); FactureCase factureCase = new FactureCase { Order = ordre, TotalHt = _total, Ttc = _ttc, Tva = _tva, Timbre = _timbre, Numbre = NumTxtBox.Text, Facture = facture }; //var report = new InvoiceReport(factureCase); //if (settings.Logo!= null) report.Logo = Validator.ConvertByteArrayToImage(settings.Logo); ////report.HeaderContent = "ITCastle Company Boumerdes"; //report.PayMode = CbPayment.Text; //report.SetSettings(); //PrintHelper.ShowPrintPreview(null, report).WindowState = WindowState.Maximized; /* fin de l'impression de la facture */ /* debut de modifiction de l'après impression de la facture */ settings.FactureNumber = (Convert.ToInt32(settings.FactureNumber) + 1).ToString(); SettingsClient.MajSettings(settings); LoadGridFact(); /* fin de modifiction de l'après impression de la facture */ }
private void PInvoiceBtn_Click(object sender, RoutedEventArgs e) { if(theOrder==null)return; /* Ajout de la facture dans la base de données */ // var settingsClient = new SettingsClient(); // Setting settings = settingsClient.GetSetting(); Order getOrder = gestionDb.Orders.FirstOrDefault(c => c.OrderID == theOrder.OrderID); var facture = new Facture { FactureDate = DateTime.Now, Order = getOrder, TVA = _tvaClient.GetTvaByName(_tvaValue.ToString(CultureInfo.InvariantCulture)), TypePayment = "Espèce", Status = 10, Type = "Facture Proforma" }; gestionDb.Factures.Add(facture); gestionDb.SaveChanges(); /* fin de l'ajout de la facture a la base de données */ /* debut de l'impression de la facture */ FactureCase factureCase = new FactureCase { Order = theOrder, TotalHt = _total, Ttc = _ttc, Tva = _tvaValue, Timbre = _timbre, Numbre = facture.FactureNum.ToString(), Facture = facture }; Initialiser(); // InvoiceReport report = new InvoiceReport(factureCase); // // if (settings.Logo != null) report.Logo = Validator.ConvertByteArrayToImage(settings.Logo); // //report.HeaderContent = "ITCastle Company Boumerdes"; // report.PayMode = facture.TypePayment; // report.SetSettings(); // PrintHelper.ShowPrintPreview(null, report);//.WindowState = WindowState.Maximized; //// settings.FactureProNumber = (Convert.ToInt32(settings.FactureProNumber) + 1).ToString(); // // SettingsClient.MajSettings(settings); // /* fin de modifiction de l'après impression de la facture */ }
private void PrintProBtn_Click(object sender, RoutedEventArgs e) { if (DgFactures.VisibleRowCount == 0) return; int rowHandle = DgFactures.View.FocusedRowHandle; if (rowHandle >= 0) { OrderClient oc = new OrderClient(); Order ordre = oc.GetOrderById(Convert.ToInt32(DgFactures.GetCellValue(rowHandle, "OrderID"))); /* la fcture dans la base de données */ var factureClient = new FacturesClient(); var facture = factureClient.GetFactureByOrdre(ordre); var settingsClient = new SettingsClient(); var settings = settingsClient.GetSetting(); var factureCase = new FactureCase { Order = ordre, TotalHt = _total, Ttc = _ttc, Tva = _tva, Timbre = _timbre, Numbre = facture.FactureNum.ToString(), Facture = facture }; //var report = new InvoiceReport(factureCase); //if (settings.Logo != null) report.Logo = Validator.ConvertByteArrayToImage(settings.Logo); //report.PayMode = facture.TypePayment; //report.SetSettings(); //PrintHelper.ShowPrintPreview(null, report).WindowState = WindowState.Maximized; /* fin de l'impression de la facture */ /* debut de modifiction de l'après impression de la facture */ LoadGridFact(); /* fin de modifiction de l'après impression de la facture */ } }
private void InvoiceBtn_Click(object sender, RoutedEventArgs e) { String message = Enregistrer(); if (!message.Equals("Votre commande a été enregistrer avec succes")) return; OrderClient oc = new OrderClient(); Order ordre = oc.GetOrderById(theOrder.OrderID); if (ordre == null) return; /* Ajout de la fcture dans la base de données */ var settingsClient = new SettingsClient(); // Setting settings = settingsClient.GetSetting(); Order getOrder = GetTheOrder(ordre); var facture = new Facture { FactureDate = DateTime.Now, Order = getOrder, // FactureNum = Convert.ToInt32(settings.FactureNumber), TVA = _tvaClient.GetTvaByName(_tvaValue.ToString(CultureInfo.InvariantCulture)), TypePayment = "Espèce", Status = 0, Type = "Facture" }; gestionDb.Factures.Add(facture); gestionDb.SaveChanges(); //ou facture proforma // factureClient.AddFacture(facture); /* fin de l'ajout de la facture a la base de données */ /* debut de l'impression de la facture */ FactureCase factureCase = new FactureCase { Order = getOrder, TotalHt = _total, Ttc = _ttc, Tva = _tvaValue, Timbre = _timbre, Numbre = facture.FactureNum.ToString(), Facture = facture }; Initialiser(); //InvoiceReport report = new InvoiceReport(factureCase) //{ // PayMode = facture.TypePayment //}; // if (settings.Logo != null) report.Logo = Validator.ConvertByteArrayToImage(settings.Logo); //report.HeaderContent = "ITCastle Company Boumerdes"; //report.SetSettings(); //PrintHelper.ShowPrintPreview(null, report).WindowState = WindowState.Maximized; //settings.FactureNumber = (Convert.ToInt32(settings.FactureNumber) + 1).ToString(); //SettingsClient.MajSettings(settings); /* fin de modifiction de l'après impression de la facture */ }