internal MatrixMemberCollection(Matrix owner, MatrixMember parent, MatrixHeading headingDef, MatrixHeadingInstanceList headingInstances, List <int> memberMapping, bool isParentSubTotal) { m_owner = owner; m_parent = parent; m_headingInstances = headingInstances; m_headingDef = headingDef; m_memberMapping = memberMapping; m_isParentSubTotal = isParentSubTotal; if (!owner.NoRows) { return; } Subtotal subtotal = m_headingDef.Subtotal; if (subtotal != null) { if (subtotal.Position == Subtotal.PositionType.After) { m_subTotalPosition = 1; } else { m_subTotalPosition = 0; } } }
//[/BARCODE FUNCTIONS] private void UpdateCash() { SubtotalTemp = 0; TaxTemp = 0; Subtotal = 0; TotalTax = 0; if (!semaphore && !OnExit) { semaphore = true; foreach (DataGridViewRow r in TeldgView.Rows) { if (!r.IsNewRow && !OnExit) { try { //PriceLevelSelection DataRow aItemRow = ItemsMgmt.SelectItemRowByBarcode(TeldgView.Rows[r.Index].Cells["Barcode"].Value.ToString()); SubtotalTemp = Math.Round(double.Parse(TeldgView.Rows[r.Index].Cells["PriceTotal"].Value.ToString()), 3); Subtotal += SubtotalTemp; TaxTemp = double.Parse(TeldgView.Rows[r.Index].Cells["Tax"].Value.ToString()); TotalTax += (TaxTemp / 100) * SubtotalTemp; //Net amount = (Selling Price - Sales Price)*Tax //updates } catch (Exception ex) { MessageBox.Show("UPDATE CASH ERROR IN [DISPOSE ITEMS] Exception:" + ex.ToString()); return; } } } TotalTxtBox.Text = Math.Round(Subtotal + TotalTax, 2).ToString(); Subtotal = Math.Round(Subtotal, 2); SubtotalTxtBox.Text = Subtotal.ToString(); TotalTax = Math.Round(TotalTax, 3); TaxTxtBox.Text = TotalTax.ToString(); semaphore = false; } }
public void ShouldThrowIfInvalidFuncNumber() { var func = new Subtotal(); var args = FunctionsHelper.CreateArgs(139, 1); func.Execute(args, _context); }
void FillPrices() { FindViewById <TextView>(Resource.Id.tvSubtotal).Text = Subtotal.ToString("C", System.Globalization.CultureInfo.GetCultureInfo("es-mx")); FindViewById <TextView>(Resource.Id.tvDescuento).Text = Descuento.ToString("C", System.Globalization.CultureInfo.GetCultureInfo("es-mx")); FindViewById <TextView>(Resource.Id.tvIVA).Text = IVATotal.ToString("C", System.Globalization.CultureInfo.GetCultureInfo("es-mx")); FindViewById <TextView>(Resource.Id.tvTotal).Text = Total.ToString("C", System.Globalization.CultureInfo.GetCultureInfo("es-mx")); }
private void CMDFACUTRA_Click(object sender, EventArgs e) { //Programa para hacer factura de automovil //Silva Reyes Luis Adrian 19210549 //Tarea#12 //Declaracion de variables Double Precio, Ganancia, Comision, Iva, Subtotal, Total; string Descripciones; //Asignacion de variables Precio = System.Double.Parse(TXTPRE.Text); Descripciones = (TXTDES.Text); //Calculo de factura Ganancia = Precio * .20; Comision = Ganancia + 0.03; Subtotal = Ganancia + Precio + Comision; Iva = Subtotal * .15; Total = Subtotal + Iva; //Salida de datos TXTDESC.Text = Descripciones.ToString(); TXTSUB.Text = Subtotal.ToString(); TXTIVA.Text = Iva.ToString(); TXTTOTAL.Text = Total.ToString(); }
public override string ToString() { // TODO ArBy global culture, datetime format var formattedIssueDate = IssueDate.ToString("yyyy-MM-dd"); var formattedDueDate = DueDate.ToString("yyyy-MM-dd"); var formattedRedemptionDate = RedemptionDate != null?RedemptionDate.Value.ToString("yyyy-MM-dd") : "n/a"; return("Invoice(" + $"serial={Serial}, " + $"id={Id}, " + $"isPayed={IsPayed.ToString()}, " + $"issueDate={formattedIssueDate}, " + $"dueDate={formattedDueDate}, " + $"redemptionDate={formattedRedemptionDate}, " + $"supplier={Supplier}, " + $"receiver={Receiver}, " + $"total={Total.ToString(CultureInfo.InvariantCulture)}, " + $"subtotal={Subtotal.ToString(CultureInfo.InvariantCulture)}, " + $"discount={Discount.ToString(CultureInfo.InvariantCulture)}, " + $"payed={Payed.ToString(CultureInfo.InvariantCulture)}, " + $"due={Due.ToString(CultureInfo.InvariantCulture)}, " + $"items=[{string.Join(", ", Items)}], " + $"payments=[{string.Join(", ", Payments)}]" + ")"); }
/// <summary> /// Prints receipt /// </summary> /// <param name="pay"> number that represents the method of payment</param> private void Receipt(int pay) { ReceiptPrinter r = new ReceiptPrinter(); StringBuilder sb = new StringBuilder(); sb.Append("\t Cowboy Cafe\n _________________________________________\n\nOrder #" + OrderNumber.ToString() + "\t\t\t" + DateTime.Now + "\n\n"); foreach (IOrderItem i in Items) { sb.Append(i.ToString() + "\t\t " + i.Price.ToString("C2")); foreach (string st in i.SpecialInstructions) { sb.Append("\n\t" + st); } sb.Append("\n"); } sb.Append("\nSubtotal: " + Subtotal.ToString("C2") + "\nTax: \t " + Tax.ToString("C2") + "\nTotal: \t " + Total.ToString("C2") + "\n"); if (pay == 0) { sb.Append("\nPaid: \t" + Paid.ToString("C2")); } else { sb.Append("\nCredit: \t " + Paid.ToString("C2")); } sb.Append("\nChange: \t " + Change.ToString("C2")); string s = sb.ToString(); MessageBox.Show(s); r.Print(s); s = "Contents of the Cash Drawer\n\n____________________________\n Coins\n____________________________\n\nPennies: " + cd.Pennies + "\nNickels: " + cd.Nickels + "\nDimes: " + cd.Dimes + "\nQuarters: " + cd.Quarters + "\nHalf Dollars: " + cd.HalfDollars + "\nDollars: " + cd.Dollars + "\n\n____________________________\n Bills\n____________________________\n\nOnes: " + cd.Ones + "\nTwos: " + cd.Twos + "\nFives: " + cd.Fives + "\nTens: " + cd.Tens + "\nTwenties: " + cd.Twenties + "\nFifties: " + cd.Fifties + "\nHundreds: " + cd.Hundreds + "\n\n____________________________\nCash Drawer Total: " + cd.TotalValue.ToString("C2") + "\n____________________________\n"; MessageBox.Show(s); NewOrder(); }
private void Process(IXLRange root, GroupTag[] groups, bool summaryAbove, SubtotalSummaryFunc[] funcs, bool disableGrandTotal) { var groupRow = root.LastRow(); // DoGroups var level = 0; var r = root.Offset(0, 0, root.RowCount() - 1, root.ColumnCount()); using (var subtotal = new Subtotal(r, summaryAbove)) { if (TotalLabel != null) { subtotal.TotalLabel = TotalLabel; } if (GrandLabel != null) { subtotal.GrandLabel = GrandLabel; } if (!disableGrandTotal) { var total = subtotal.AddGrandTotal(funcs); total.SummaryRow.Cell(2).Value = total.SummaryRow.Cell(1).Value; total.SummaryRow.Cell(1).Value = null; level++; } foreach (var g in groups.OrderBy(x => x.Column)) { Func <string, string> labFormat = null; if (!string.IsNullOrEmpty(g.LabelFormat)) { labFormat = title => string.Format(LabelFormat, title); } subtotal.GroupBy(g.Column, g.DisableSubtotals ? new SubtotalSummaryFunc[0] : funcs, g.PageBreaks, labFormat); g.Level = ++level; } foreach (var g in groups.Where(x => x.IsWithHeader).OrderBy(x => x.Column)) { subtotal.AddHeaders(g.Column); } var gr = groups.Union(new[] { new GroupTag { Column = 1, Level = 1 } }) .ToDictionary(x => x.Level, x => x); foreach (var subGroup in subtotal.Groups.OrderBy(x => x.Column).Reverse()) { var groupTag = gr[subGroup.Level]; FormatHeaderFooter(subGroup, groupRow); GroupRender(subGroup, groupTag); } } // Rem DoDeleteSpecialRow root.LastRow().Delete(XLShiftDeletedCells.ShiftCellsUp); }
public void ShouldCalculateMaxWhenCalcTypeIs4() { var func = new Subtotal(); var args = FunctionsHelper.CreateArgs(4, 10, 20, 30, 40, 50); var result = func.Execute(args, _context); Assert.AreEqual(50d, result.Result); }
/* Send order to kitchen and subsequently clear order data */ private void DialogBoxAcceptExecute(object parameter) { POSOrder order = new POSOrder(); int numOfOrderItems = 0; int iterationCounter = 0; // prepare order for submission to service for (int i = 0; i < Enum.GetNames(typeof(menuItemType)).Length; i++) { foreach (MenuItem item in menuOrderLists[i]) { numOfOrderItems++; } } order.menuItems = new POSMenuItem[numOfOrderItems]; for (int i = 0; i < Enum.GetNames(typeof(menuItemType)).Length; i++) { for (int j = 0; j < menuOrderLists[i].Count; j++) { POSMenuItem item = new POSMenuItem(); item.Price = menuOrderLists[i][j].Price; item.Product = menuOrderLists[i][j].Product; item.ProductType = (POSMenuItemEnum)menuOrderLists[i][j].ProductType; item.Quantity = menuOrderLists[i][j].Quantity; order.menuItems[iterationCounter++] = item; } } order.SubTotal = float.Parse(Subtotal.Substring(1, Subtotal.Length - 1), CultureInfo.InvariantCulture.NumberFormat); order.Total = float.Parse(Total.Substring(1, Total.Length - 1), CultureInfo.InvariantCulture.NumberFormat); // send order information to service eventAggregator.GetEvent <PlaceOrderEvent>().Publish(order); // delete all items in current order foreach (ObservableCollection <MenuItem> list in orderModel.menuOrderLists) { list.Clear(); } // reset selected indices for (int i = 0; i < POSConstants.NUM_MENU_ORDER_TYPES; i++) { menuOrderListsSelectedIndex[i] = -1; } // recalculate new order price calcOrderPrice(); // increment number of orders incrementOrder(); // recheck order data removeOrderItemBtnICommand.RaiseCanExecuteChanged(); // hide gray overlay takeOrderGrayOverlay = Visibility.Hidden; OnPropertyChanged("takeOrderGrayOverlay"); }
public void ShouldCalculateStdevPWhenCalcTypeIs108() { var func = new Subtotal(); var args = FunctionsHelper.CreateArgs(108, 10, 20, 30, 40, 50); var result = func.Execute(args, _context); var resultRounded = Math.Round((double)result.Result, 8); Assert.AreEqual(14.14213562, resultRounded); }
public void ShouldCalculateStdevWhenCalcTypeIs7() { var func = new Subtotal(); var args = FunctionsHelper.CreateArgs(7, 10, 20, 30, 40, 50); var result = func.Execute(args, _context); var resultRounded = Math.Round((double)result.Result, 5); Assert.AreEqual(15.81139d, resultRounded); }
public void ScanForGroupsTest() { void AssertGroup(SubtotalGroup group, string expectedAddress, string expectedTitle) { group.Range.RangeAddress.ToString().Should().Be(expectedAddress); group.Level.Should().Be(1); group.GroupTitle.Should().Be(expectedTitle); } _workbook = new XLWorkbook(); var sheet = _workbook.AddWorksheet("test"); sheet.Range("A2:A5").Value = "val1"; sheet.Range("A6:A9").Value = "val2"; sheet.Range("A10:A13").Value = "val3"; sheet.Range("B2:B4").Value = "val4"; sheet.Range("B5:B11").Value = "val5"; sheet.Range("B12:B13").Value = "val6"; sheet.Range("C2:C3").Value = "val7"; sheet.Range("C4:C6").Value = "val8"; sheet.Range("C7:C8").Value = "val9"; sheet.Range("C9:C12").Value = "val7"; sheet.Range("C13:C13").Value = "val8"; _rng = sheet.Range("A2:C13"); using (var subtotal = new Subtotal(_rng)) { var groups = subtotal.ScanForGroups(1); groups.Length.Should().Be(3); AssertGroup(groups[0], "A2:C5", "val1"); AssertGroup(groups[1], "A6:C9", "val2"); AssertGroup(groups[2], "A10:C13", "val3"); groups = subtotal.ScanForGroups(2); groups.Length.Should().Be(5); AssertGroup(groups[0], "A2:C4", "val4"); AssertGroup(groups[1], "A5:C5", "val5"); AssertGroup(groups[2], "A6:C9", "val5"); AssertGroup(groups[3], "A10:C11", "val5"); AssertGroup(groups[4], "A12:C13", "val6"); groups = subtotal.ScanForGroups(3); groups.Length.Should().Be(9); AssertGroup(groups[0], "A2:C3", "val7"); AssertGroup(groups[1], "A4:C4", "val8"); AssertGroup(groups[2], "A5:C5", "val8"); AssertGroup(groups[3], "A6:C6", "val8"); AssertGroup(groups[4], "A7:C8", "val9"); AssertGroup(groups[5], "A9:C9", "val7"); AssertGroup(groups[6], "A10:C11", "val7"); AssertGroup(groups[7], "A12:C12", "val7"); AssertGroup(groups[8], "A13:C13", "val8"); } }
public void SubtotalWithInvalidArgumentReturnsPoundValue() { var func = new Subtotal(); var parsingContext = ParsingContext.Create(); var args = FunctionsHelper.CreateArgs(); var result = func.Execute(args, parsingContext); Assert.AreEqual(eErrorType.Value, ((ExcelErrorValue)result.Result).Type); }
/// <summary> /// Gets the hash code /// </summary> /// <returns>Hash code</returns> public override int GetHashCode() { unchecked // Overflow is fine, just wrap { int hashCode = 41; if (Id != null) { hashCode = hashCode * 59 + Id.GetHashCode(); } if (Consumer != null) { hashCode = hashCode * 59 + Consumer.GetHashCode(); } if (Store != null) { hashCode = hashCode * 59 + Store.GetHashCode(); } if (Subtotal != null) { hashCode = hashCode * 59 + Subtotal.GetHashCode(); } if (Tax != null) { hashCode = hashCode * 59 + Tax.GetHashCode(); } if (EstimatedPickupTime != null) { hashCode = hashCode * 59 + EstimatedPickupTime.GetHashCode(); } if (IsPickup != null) { hashCode = hashCode * 59 + IsPickup.GetHashCode(); } if (Categories != null) { hashCode = hashCode * 59 + Categories.GetHashCode(); } if (IsTaxRemittedByDoordash != null) { hashCode = hashCode * 59 + IsTaxRemittedByDoordash.GetHashCode(); } if (TaxAmountRemittedByDoordash != null) { hashCode = hashCode * 59 + TaxAmountRemittedByDoordash.GetHashCode(); } if (CommissionType != null) { hashCode = hashCode * 59 + CommissionType.GetHashCode(); } if (DeliveryShortCode != null) { hashCode = hashCode * 59 + DeliveryShortCode.GetHashCode(); } return(hashCode); } }
public void ShouldCalculateVarWhenCalcTypeIs110() { var func = new Subtotal(); var args = FunctionsHelper.CreateArgs(110, 10, 20, 30, 40, 50, 51); args.Last().SetExcelStateFlag(ExcelCellState.HiddenCell); var result = func.Execute(args, _context); Assert.AreEqual(250d, result.Result); }
public void WithHeaders() { LoadTemplate("91_plaindata.xlsx"); using (var subtotal = new Subtotal(_rng)) { var summaries = new [] { new SubtotalSummaryFunc("sum", 7), }; subtotal.AddGrandTotal(summaries); subtotal.GroupBy(2, summaries, true); subtotal.GroupBy(3, summaries, true); subtotal.AddHeaders(2); subtotal.AddHeaders(3); } CompareWithGauge(_workbook, "Subtotal_WithHeaders.xlsx"); }
public override string ToString() { string cadena = ""; cadena += Cliente.ToString() + "\n"; cadena += "Pedido: " + Folio.ToString() + " Subtotal: " + Subtotal.ToString("C") + " Iva: " + MontoIva.ToString("C") + " MontoIeps: " + MontoIeps.ToString("C") + " Total: " + Total.ToString("C") + "\n\n"; foreach (clsProductosPedido item in Items) { cadena += item.ToString(); } return(cadena); }
public void Update(Subtotal pEvent) { this.Clear(); if (this.prompt != null) { prompt.PromptText = pEvent.PromptText + "\n" + string.Format(new PosTextFormatter(), "{0:Money}", string.Format("{0:#########.00}", pEvent.Amount)); } if (PosHardware.Instance.LineDisplay != null) { PosHardware.Instance.LineDisplay.Clear(); PosHardware.Instance.LineDisplay.SetText(pEvent.PromptText, 0, 0); PosHardware.Instance.LineDisplay.SetText(string.Format("{0:#########.00}", pEvent.Amount), 1, 0); } }
private void button2_Click(object sender, EventArgs e) { Supplier.Clear(); SPhone.Clear(); DateTime iDate = DateTime.Now; OrderTime.Clear(); Subtotal.Clear(); TaxtxtBox.Clear(); total.Clear(); }
public override void WriteXml(ref IaXmlWriter xml) { xml.WriteStartElement("function"); xml.WriteAttribute("controlid", ControlId, true); xml.WriteStartElement("create_ictransaction"); xml.WriteElement("transactiontype", TransactionDefinition, true); xml.WriteStartElement("datecreated"); xml.WriteDateSplitElements(TransactionDate.Value, true); xml.WriteEndElement(); //datecreated xml.WriteElement("createdfrom", CreatedFrom); xml.WriteElement("documentno", DocumentNumber); xml.WriteElement("referenceno", ReferenceNumber); xml.WriteElement("message", Message); xml.WriteElement("externalid", ExternalId); xml.WriteElement("basecurr", BaseCurrency); xml.WriteCustomFieldsExplicit(CustomFields); xml.WriteElement("state", State); xml.WriteStartElement("ictransitems"); if (Lines.Count > 0) { foreach (InventoryTransactionLineCreate Line in Lines) { Line.WriteXml(ref xml); } } xml.WriteEndElement(); //ictransitems if (Subtotals.Count > 0) { xml.WriteStartElement("subtotals"); foreach (TransactionSubtotalCreate Subtotal in Subtotals) { Subtotal.WriteXml(ref xml); } xml.WriteEndElement(); //subtotals } xml.WriteEndElement(); //create_ictransaction xml.WriteEndElement(); //function }
public SeatPlan(PlayInfoForm upperForm) { InitializeComponent(); UpperForm = upperForm; Subtotal = 0.0; label10.Text = Subtotal.ToString("C", CultureInfo.CreateSpecificCulture("en-GB")); SelectedSeats = new List <Seat>(); foreach (Control p in panel1.Controls)//get all flowlaylout panels in panel1 { //check if flow layout panel if (p.GetType() == typeof(FlowLayoutPanel)) { foreach (Control b in p.Controls)//for each button a single flowlayoutpanel { foreach (Band band in UpperForm.ChosenPerformance.PerformanceBands) { Band currentBand = band; double price = currentBand.BandPrice; string letter = currentBand.BandNumber; foreach (Seat seat in band.BandSeats) { string number = seat.SeatNumber.ToString(); bool occupied = seat.Occupied; if (b.Name == letter + number) { if (occupied == true) { b.BackColor = Color.Red; b.Text = letter + number; b.Enabled = false; } else { b.BackColor = Color.Gray; b.Text = price.ToString("C", CultureInfo.CreateSpecificCulture("en-GB")) + "\n" + letter + number; b.Click += MyButtonClick; b.Enabled = true; } } } } } } } this.Show(); }
private static void ConfirmSubtotal(int function, double expected) { ValueEval[] values = new ValueEval[TEST_VALUES0.Length]; for (int i = 0; i < TEST_VALUES0.Length; i++) { values[i] = new NumberEval(TEST_VALUES0[i]); } AreaEval arg1 = EvalFactory.CreateAreaEval("C1:D5", values); ValueEval[] args = { new NumberEval(function), arg1 }; ValueEval result = new Subtotal().Evaluate(args, 0, 0); Assert.AreEqual(typeof(NumberEval), result.GetType()); Assert.AreEqual(expected, ((NumberEval)result).NumberValue, 0.0); }
public override int GetHashCode() { unchecked { var hashCode = (Product != null ? Product.GetHashCode() : 0); hashCode = (hashCode * 397) ^ (Description != null ? Description.GetHashCode() : 0); hashCode = (hashCode * 397) ^ Quantity.GetHashCode(); hashCode = (hashCode * 397) ^ Rate.GetHashCode(); hashCode = (hashCode * 397) ^ TaxPercentage.GetHashCode(); hashCode = (hashCode * 397) ^ DiscountPercentage.GetHashCode(); hashCode = (hashCode * 397) ^ Total.GetHashCode(); hashCode = (hashCode * 397) ^ Subtotal.GetHashCode(); hashCode = (hashCode * 397) ^ Tax.GetHashCode(); hashCode = (hashCode * 397) ^ LineIdx; return(hashCode); } }
Visibility _Visibility; // Indicates if all of the dynamic rows for this grouping // should be hidden and replaced with a subtotal row for // this grouping scope public DynamicRows(ReportDefn r, ReportLink p, XmlNode xNode) : base(r, p) { _Grouping=null; _Sorting=null; _Subtotal=null; _ReportItems=null; _Visibility=null; // Run thru the attributes // foreach(XmlAttribute xAttr in xNode.Attributes) // { // } // Loop thru all the child nodes foreach(XmlNode xNodeLoop in xNode.ChildNodes) { if (xNodeLoop.NodeType != XmlNodeType.Element) continue; switch (xNodeLoop.Name) { case "Grouping": _Grouping = new Grouping(r, this, xNodeLoop); break; case "Sorting": _Sorting = new Sorting(r, this, xNodeLoop); break; case "Subtotal": _Subtotal = new Subtotal(r, this, xNodeLoop); break; case "ReportItems": _ReportItems = new ReportItems(r, this, xNodeLoop); break; case "Visibility": _Visibility = new Visibility(r, this, xNodeLoop); break; default: // don't know this element - log it OwnerReport.rl.LogError(4, "Unknown DynamicRow element '" + xNodeLoop.Name + "' ignored."); break; } } if (_Grouping == null) OwnerReport.rl.LogError(8, "DynamicRows requires the Grouping element."); if (_ReportItems == null || _ReportItems.Items.Count != 1) OwnerReport.rl.LogError(8, "DynamicRows requires the ReportItems element defined with exactly one report item."); }
/// <summary> /// Creates the reciept to be sent to the printer /// </summary> /// <param name="cardOrCash">0 if card 1 if cash</param> private void PrintReceipt(int cardOrCash) { ReceiptPrinter rp = new ReceiptPrinter(); StringBuilder sb = new StringBuilder(); sb.Append("---------- COWBOY CAFE ----------\n"); sb.Append(DateTime.Now + "\n"); sb.Append("Order #: " + PrevOrderNumber + "\n"); /* Iterate over all items */ foreach (IOrderItem i in Items) { sb.Append(i.ToString() + "\t\t" + i.Price.ToString("C2") + "\n"); /* Iterate through the special instruction for the item i */ foreach (string s in i.SpecialInstructions) { sb.Append(s + "\n"); } sb.Append("\n"); } sb.Append("Subtotal: " + Subtotal.ToString("C2") + "\n"); sb.Append("Tax: " + Tax.ToString("C2") + "\n"); sb.Append("Total: " + TotalWithTax.ToString("C2") + "\n\n"); if (cardOrCash == 1) { sb.Append("Paid: " + Paid.ToString("C2") + "\n"); sb.Append("Change: " + Change.ToString("C2") + "\n"); } else { sb.Append("Credit Card was used!\n"); } string sr = sb.ToString(); MessageBox.Show(sr); rp.Print(sr); ShowDrawerContents(); SetNewOrder(); }
private void DgvListado_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { try { DgvMostrarDetalle.DataSource = NVenta.ListarDetalle(Convert.ToInt32(DgvListado.CurrentRow.Cells["ID"].Value)); decimal Total, Subtotal; decimal Impuesto = Convert.ToDecimal(DgvListado.CurrentRow.Cells["Impuesto"].Value); Total = Convert.ToDecimal(DgvListado.CurrentRow.Cells["Total"].Value); Subtotal = Total / (1 + Impuesto); TxtSubDetalle.Text = Subtotal.ToString("#0.00#"); TxtImDetalle.Text = (Total - Subtotal).ToString("#0.00#"); TxtTotDetalle.Text = Total.ToString("#0.00#"); PanelMostrar.Visible = true; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void ScanForGroupsTest() { LoadTemplate("9_plaindata.xlsx"); SubtotalGroup[] groups; using (var subtotal = new Subtotal(_rng)) groups = subtotal.ScanForGroups(2); groups.Length.Should().Be(3); groups[0].Range.RangeAddress.ToString().Should().Be("C3:I26"); groups[0].Level.Should().Be(1); groups[0].GroupTitle.Should().Be("Central"); groups[1].Range.RangeAddress.ToString().Should().Be("C27:I38"); groups[1].Level.Should().Be(1); groups[1].GroupTitle.Should().Be("East"); groups[2].Range.RangeAddress.ToString().Should().Be("C39:I44"); groups[2].Level.Should().Be(1); groups[2].GroupTitle.Should().Be("West"); }
private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { try { dgvMostarDetalle.DataSource = N_Factura.ListarDetalle(Convert.ToInt32(dataGridView1.CurrentRow.Cells["ID"].Value)); decimal Total, Subtotal; decimal Impuesto = Convert.ToDecimal(dataGridView1.CurrentRow.Cells["Impuesto"].Value); Total = Convert.ToDecimal(dataGridView1.CurrentRow.Cells["Total"].Value); Subtotal = Total / Impuesto; txtSubTotalDetalle.Text = Subtotal.ToString("#0.00#"); txtTotalDetalle.Text = Total.ToString("#0.00#"); txtIVADetalle.Text = (Total - Subtotal).ToString("#0.00#"); panelDetalleDoc.Visible = true; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public int CompareTo(Invoice other) { if (ReferenceEquals(this, other)) { return(0); } if (ReferenceEquals(null, other)) { return(1); } var serialNumberComparison = string.Compare(SerialNumber, other.SerialNumber, StringComparison.Ordinal); if (serialNumberComparison != 0) { return(serialNumberComparison); } var companyNameComparison = string.Compare(CompanyName, other.CompanyName, StringComparison.Ordinal); if (companyNameComparison != 0) { return(companyNameComparison); } var subtotalComparison = Subtotal.CompareTo(other.Subtotal); if (subtotalComparison != 0) { return(subtotalComparison); } var departmentComparison = Department.CompareTo(other.Department); if (departmentComparison != 0) { return(departmentComparison); } var issueDateComparison = IssueDate.CompareTo(other.IssueDate); if (issueDateComparison != 0) { return(issueDateComparison); } return(DueDate.CompareTo(other.DueDate)); }
private bool Equals(IInvoice other) { if (!(InvoiceId == other.InvoiceId && InvoiceNumber == other.InvoiceNumber && InvoiceNumberAsString == other.InvoiceNumberAsString && Total.Equals(other.Total) && Subtotal.Equals(other.Subtotal) && Nullable.Equals(Tax, other.Tax) && Nullable.Equals(TaxPercentage, other.TaxPercentage) && InvoiceDate.Equals(other.InvoiceDate) && ContractName == other.ContractName && PeriodStartDate.Equals(other.PeriodStartDate) && PeriodEndDate.Equals(other.PeriodEndDate) && Currency == other.Currency && Equals(From, other.From) && Equals(To, other.To))) { return(false); } if (LineItems is null && other.LineItems is null) { return(true); } if (LineItems is null || other.LineItems is null) { return(false); } return(LineItems.OrderBy(x => x.LineIdx).SequenceEqual(other.LineItems.OrderBy(x => x.LineIdx))); }