private void button5_Click(object sender, EventArgs e)
{
List <ProductInfo> ProductsInfo = new List <ProductInfo>();
for (int i = 0; i < dataGrid.Rows.Count - 1; i++)
{
ProductInfo ProductInfo = new ProductInfo
{
Product = DbEditor.GetItemByName(dataGrid[0, i].Value.ToString()),
Count = Convert.ToInt32(dataGrid[1, i].Value),
vatSumm = Convert.ToDouble(dataGrid[6, i].Value),
summWithVat = Convert.ToDouble(dataGrid[5, i].Value)
};
ProductsInfo.Add(ProductInfo);
}
textBox1.Text += ProductsInfo[0].Product.Name + Environment.NewLine;
}
private void button6_Click(object sender, EventArgs e)
{
int sellerId = comboBox1.SelectedIndex + 1;
int customerId = comboBox2.SelectedIndex + 1;
int currencyId = comboBox3.SelectedIndex + 1;
int unitId = comboBox3.SelectedIndex + 1;
if (sellerId <= 0 && customerId <= 0 && currencyId <= 0)
{
MessageBox.Show("Выберите продавца, покупателя и валюту из существующих или добавьте новые.", "Внимание",
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
else
{
string examplePath = Directory.CreateDirectory(Application.StartupPath + "/Example").FullName;
string filePath;
if (!File.Exists($"{examplePath}/Factura.xlsx"))
{
File.WriteAllBytes($"{examplePath}/Factura.xlsx", Resource.Factura);
}
Seller Seller = DbEditor.GetSellerById(sellerId);
Customer Customer = DbEditor.GetCustomerById(customerId);
Currency Currency = DbEditor.GetCurrencyById(currencyId);
List <ProductInfo> ProductsInfo = new List <ProductInfo>();
for (int i = 0; i < dataGrid.Rows.Count - 1; i++)
{
ProductInfo ProductInfo = new ProductInfo
{
Product = DbEditor.GetItemByName(dataGrid[0, i].Value.ToString()),
Count = Convert.ToInt32(dataGrid[1, i].Value),
vatSumm = Convert.ToDouble(dataGrid[6, i].Value),
summWithVat = Convert.ToDouble(dataGrid[5, i].Value),
summWithoutVat = Convert.ToDouble(dataGrid[7, i].Value)
};
ProductsInfo.Add(ProductInfo);
}
ExcelWorkbook WorkBook = new ExcelWorkbook($"{examplePath}/Factura.xlsx", Seller, Customer, ProductsInfo);
WorkBook.facturaNumber = numericUpDown1.Value.ToString();
WorkBook.facturaDate = dateTimePicker1.Value.ToString("dd MMMM yyyy");
WorkBook.payDocumentNumber = numericUpDown2.Value.ToString();
WorkBook.payDocumentDate = dateTimePicker2.Value.ToString("dd MMMM yyyy");;
WorkBook.currencyCode = Currency.Code;
WorkBook.Currency = Currency.Name;
// WorkBook.Products = Datas.ProductList;
using (SaveFileDialog SaveFileDialog = new SaveFileDialog())
{
SaveFileDialog.Filter = "Файлы Excel (*.xlsx) | *.xlsx";
if (SaveFileDialog.ShowDialog() == DialogResult.OK)
{
filePath = SaveFileDialog.FileName;
if (WorkBook.CreateFile(filePath) == null)
{
throw new Exception("Ошибка создания файла");
}
}
}
}
}
