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