private async void LoadDataFromDb() { CommonWarehouseReceipt receipt = await SASale.GetReceipt(Sale.SaleId); mlLabel17.Text = receipt.BuyerCompanyName; mlLabel15.Text = receipt.BuyerVATNumber; mlLabel13.Text = receipt.BuyerBulstat; mlLabel7.Text = receipt.BuyerMol; labelMolS.Text = receipt.BuyerMol; mlLabel9.Text = receipt.BuyerAddress; labelSalesReceiptNumber.Text = receipt.WarehouseReceiptNumber.ToString().PadLeft(10, '0'); mlLabelSalesReceiptDate.Text = Sale.Date.ToString(CultureInfo.InvariantCulture); mlLabel24.Text = receipt.OwnerCompanyName; mlLabel23.Text = receipt.OwnerVATNumber; mlLabel22.Text = receipt.OwnerBulstat; mlLabel21.Text = receipt.OwnerAddress; mlLabel20.Text = receipt.OwnerMol; labelSuplierMolS.Text = receipt.OwnerMol; decimal totalBoth = 0; decimal ddsTotal = 0; decimal totatAmount = 0; List <GridItem> items = new List <GridItem>(); foreach (var soldItem in Sale.SoldItems) { CommonItem item = await SAItem.GetItemsById(soldItem.ItemId.ToString()); if (item != null) { GridItem gridItem = new GridItem(); gridItem.Name = item.Name; gridItem.Quantity = soldItem.Quantity.ToString(); if (DataHolder.UserCulture.TwoLetterISOLanguageName == "bg") { Enums.UnitTypesBg types = (Enums.UnitTypesBg)item.MeasurmentUnit; gridItem.MeasurementUnitString = types.ToString(); } else { Enums.UnitTypes types = (Enums.UnitTypes)item.MeasurmentUnit; gridItem.MeasurementUnitString = types.ToString(); } decimal temp = item.SellingPriceCent; gridItem.Price = temp / 100; var vatPercent = DataHolder.Settings.VatSettingsByGroup.FirstOrDefault(p => p.Key == item.Type); gridItem.Total = soldItem.Quantity * gridItem.Price; items.Add(gridItem); totatAmount += gridItem.Price * soldItem.Quantity; ddsTotal += (gridItem.Price * soldItem.Quantity) * vatPercent.Value; totalBoth += (gridItem.Price * soldItem.Quantity) + ((gridItem.Price * soldItem.Quantity) * vatPercent.Value); } } dgvItemsS.DataSource = items; labelAmountS.Text = totatAmount.ToString(); labelTotalS.Text = totalBoth.ToString(); labelDDSS.Text = ddsTotal.ToString(); // do not change set grid size and export method order! SetGridSize(); if (SavePdf) { ExportInvoiceToPdf(); } }
public async void LoadDataAsync() { try { if (Settings.Default.ItemMapping) { List <KeyValuePair <Guid, List <CommonItem> > > results = await SAItem.GetAllItemsMapped(); foreach (var kvp in results) { foreach (var row in kvp.Value) { if (DataHolder.UserCulture.TwoLetterISOLanguageName == "bg") { Enums.UnitTypesBg types = (Enums.UnitTypesBg)row.MeasurmentUnit; row.MeasurmentUnitString = types.ToString(); } else { Enums.UnitTypes types = (Enums.UnitTypes)row.MeasurmentUnit; row.MeasurmentUnitString = types.ToString(); } } } MappedItems = results; cbSearchGoodsOrders.DropDownStyle = ComboBoxStyle.DropDown; cbSearchGoodsOrders.AutoCompleteMode = AutoCompleteMode.SuggestAppend; cbSearchGoodsOrders.AutoCompleteSource = AutoCompleteSource.ListItems; } else { AllItems = await SAItem.GetAllItems(cbSearchGoodsOrders.Text); List <CommonItem> k = new List <CommonItem>(); foreach (CommonItem Item in AllItems) { decimal temp = Item.SellingPriceCent; Item.ParcePrice = temp / 100; if (DataHolder.UserCulture.TwoLetterISOLanguageName == "bg") { Enums.UnitTypesBg types = (Enums.UnitTypesBg)Item.MeasurmentUnit; Item.MeasurmentUnitString = types.ToString(); } else { Enums.UnitTypes types = (Enums.UnitTypes)Item.MeasurmentUnit; Item.MeasurmentUnitString = types.ToString(); } } } cbSearchGoodsOrders.DataSource = AllItems; cbSearchGoodsOrders.SelectedIndex = -1; cbSearchGoodsOrders.DropDownStyle = ComboBoxStyle.DropDown; cbSearchGoodsOrders.AutoCompleteMode = AutoCompleteMode.SuggestAppend; cbSearchGoodsOrders.AutoCompleteSource = AutoCompleteSource.ListItems; } catch (Exception e) { MessageBox.Show(e.Message, DataHolder.GetString("error"), MessageBoxButtons.OK, MessageBoxIcon.Error); } }