private void LoadGridDataToItemsTable(string receiptid)
{
SqlDriver driver = new SqlDriver();
string[,] items = driver.GetItems(receiptid);
dataGridItems.Rows.Clear();
for (int index = 0; index < items.GetLength(0); index++)
{
dataGridItems.Rows.Add();
dataGridItems.Rows[index].Cells[0].Value = items[index, 0];
dataGridItems.Rows[index].Cells[1].Value = items[index, 1];
dataGridItems.Rows[index].Cells[2].Value = items[index, 7];
dataGridItems.Rows[index].Cells[3].Value = items[index, 2];
dataGridItems.Rows[index].Cells[4].Value = items[index, 3];
dataGridItems.Rows[index].Cells[5].Value = items[index, 4];
dataGridItems.Rows[index].Cells[6].Value = items[index, 5];
dataGridItems.Rows[index].Cells[7].Value = items[index, 6];
}
}
private void LoadGridData()
{
SqlDriver driver = new SqlDriver();
string[,] items = driver.GetAllReceipts();
dataGridView.Rows.Clear();
int receiptsCount = 0;
double priceSum = 0;
vyberyAmount = 0;
vkladyAmount = 0;
invoicesAmount = 0;
sumTaxBaseBasic = 0;
sumTaxBaseReduced = 0;
sumBasicVatAmount = 0;
sumReducedVatAmount = 0;
sumTaxFreeAmount = 0;
sumPaycard = 0;
sumPaycash = 0;
sumPaystr = 0;
sumPayvmp = 0;
sumPaycardInvoice = 0;
sumPaycashInvoice = 0;
for (int index = 0; index < items.GetLength(0); index++)
{
dataGridView.Rows.Add();
dataGridView.Rows[index].Cells[0].Value = items[index, 0];
dataGridView.Rows[index].Cells[1].Value = items[index, 5];
dataGridView.Rows[index].Cells[2].Value = items[index, 1];
dataGridView.Rows[index].Cells[3].Value = items[index, 2];
dataGridView.Rows[index].Cells[4].Value = items[index, 3];
dataGridView.Rows[index].Cells[5].Value = items[index, 4];
dataGridView.Rows[index].Cells[6].Value = items[index, 6];
dataGridView.Rows[index].Cells[7].Value = items[index, 8];
dataGridView.Rows[index].Cells[8].Value = items[index, 7];
dataGridView.Rows[index].Cells[9].Value = items[index, 9];
dataGridView.Rows[index].Cells[10].Value = items[index, 10];
dataGridView.Rows[index].Cells[11].Value = items[index, 11];
dataGridView.Rows[index].Cells[12].Value = items[index, 13];
dataGridView.Rows[index].Cells[13].Value = items[index, 15];
dataGridView.Rows[index].Cells[14].Value = items[index, 14];
dataGridView.Rows[index].Cells[15].Value = items[index, 16];
dataGridView.Rows[index].Cells[16].Value = items[index, 17];
dataGridView.Rows[index].Cells[17].Value = items[index, 12];
if (items[index, 6].Equals("ONLINE") || items[index, 6].Equals("OFFLINE"))
{
if (items[index, 11].Equals("UF"))
{
invoicesAmount += double.Parse(items[index, 2], CultureInfo.InvariantCulture);
sumPaycardInvoice += items[index, 7] == String.Empty ? 0 : double.Parse(items[index, 7], CultureInfo.InvariantCulture);
sumPaycashInvoice += items[index, 8] == String.Empty ? 0 : double.Parse(items[index, 8], CultureInfo.InvariantCulture);
}
if (items[index, 11].Equals("VY"))
{
vyberyAmount += double.Parse(items[index, 2], CultureInfo.InvariantCulture);
}
if (items[index, 11].Equals("VK"))
{
vkladyAmount += double.Parse(items[index, 2], CultureInfo.InvariantCulture);
}
if (items[index, 11].Equals("PD"))
{
priceSum += double.Parse(items[index, 2], CultureInfo.InvariantCulture);
sumPaycard += items[index, 7] == String.Empty ? 0 : double.Parse(items[index, 7], CultureInfo.InvariantCulture);
sumPaycash += items[index, 8] == String.Empty ? 0 : double.Parse(items[index, 8], CultureInfo.InvariantCulture);
sumPaystr += items[index, 9] == String.Empty ? 0 : double.Parse(items[index, 9], CultureInfo.InvariantCulture);
sumPayvmp += items[index, 10] == String.Empty ? 0 : double.Parse(items[index, 10], CultureInfo.InvariantCulture);
}
receiptsCount++;
sumTaxBaseBasic += items[index, 13] == String.Empty ? 0 : double.Parse(items[index, 13], CultureInfo.InvariantCulture);
sumTaxBaseReduced += items[index, 14] == String.Empty ? 0 : double.Parse(items[index, 14], CultureInfo.InvariantCulture);
sumBasicVatAmount += items[index, 15] == String.Empty ? 0 : double.Parse(items[index, 15], CultureInfo.InvariantCulture);
sumReducedVatAmount += items[index, 16] == String.Empty ? 0 : double.Parse(items[index, 16], CultureInfo.InvariantCulture);
sumTaxFreeAmount += items[index, 17] == String.Empty ? 0 : double.Parse(items[index, 17], CultureInfo.InvariantCulture);
}
}
if (dataGridView.Rows.Count > 0)
{
firstDate = dataGridView.Rows[0].Cells[1].Value.ToString();
lastDate = dataGridView.Rows[dataGridView.Rows.Count - 1].Cells[1].Value.ToString();
}
else
{
var now = DateTime.Now;
firstDate = now.ToString("dd.MM.yyyy HH.mm.ss");
lastDate = now.ToString("dd.MM.yyyy HH.mm.ss");
}
toolStripPD.Text = receiptsCount.ToString();
toolStripZisk.Text = priceSum.ToString() + " €";
obratAmount = priceSum;
toolTaxBaseBasic.Text = sumTaxBaseBasic.ToString("N2") + " €";
toolVatBaseBasic.Text = sumBasicVatAmount.ToString("N2") + " €";
toolTaxBaseReduced.Text = sumTaxBaseReduced.ToString("N2") + " €";
toolVarBaseReduced.Text = sumReducedVatAmount.ToString("N2") + " €";
toolTaxFree.Text = sumTaxFreeAmount.ToString("N2") + " €";
toolPayCash.Text = sumPaycash.ToString("N2") + " €";
toolPayCard.Text = sumPaycard.ToString("N2") + " €";
}
async public void CreateDatabase()
{
if (folderBrowserDialog.ShowDialog() == DialogResult.OK)
{
SqlDriver sqlDriver = new SqlDriver();
sqlDriver.CreateDatabase();
stopProcess = false;
panel.Visible = true;
textBoxLog.Text = "Nová databáza vytvorená: /n " + Program.DB_PATH;
string path = folderBrowserDialog.SelectedPath;
string[] files = Directory.GetFiles(path, "*sent.xml");
double totalFiles = files.Length;
double filesDone = 0;
labelDone.Text = "0";
labelLeft.Text = "0";
labelPer.Text = "0%";
progressBarProcess.Value = 0;
labelAll.Text = totalFiles.ToString();
foreach (string file in Directory.EnumerateFiles(path, "*sent.xml"))
{
if (stopProcess)
{
break;
}
if (file.Contains("sent"))
{
await Task.Delay(10);
filesDone++;
labelDone.Text = filesDone.ToString();
labelLeft.Text = (totalFiles - filesDone).ToString();
labelPer.Text = ((filesDone / totalFiles) * 100).ToString("N2") + "%";
progressBarProcess.Value = Int32.Parse(Math.Ceiling((filesDone / totalFiles) * 100).ToString());
Console.WriteLine(file);
textBoxLog.AppendText("\nSpracovanie: " + file);
textBoxLog.ScrollToCaret();
string xml = File.ReadAllText(file);
XmlHandler xmlHandler = new XmlHandler(xml);
if (xmlHandler.ReadXML())
{
textBoxLog.SelectionColor = Color.Green;
textBoxLog.AppendText("\nOK");
textBoxLog.SelectionColor = Color.Black;
}
else
{
textBoxLog.SelectionColor = Color.Red;
textBoxLog.AppendText("\nERROR:");
textBoxLog.SelectionColor = Color.Black;
}
Dictionary <string, string> data = new Dictionary <string, string>();
data.Add("uid", XmlHandler.OKPValue);
data.Add("date", XmlHandler.DateValue);
data.Add("amount", XmlHandler.AmountValue);
data.Add("receiptnumber", String.Empty);
data.Add("intreceiptnumber", XmlHandler.ReceiptNumberValue);
data.Add("mod", "ONLINE");
data.Add("paycard", XmlHandler.payment[1]);
data.Add("paycash", XmlHandler.payment[0]);
data.Add("paystr", XmlHandler.payment[2]);
data.Add("payvmp", XmlHandler.payment[3]);
data.Add("xmldata", xml);
data.Add("receipttype", XmlHandler.ReceiptTypeValue);
data.Add("invoicenumber", XmlHandler.InvoiceNumberValue);
data.Add("taxbasebasic", XmlHandler.TaxBaseBasicValue);
data.Add("taxbasereduced", XmlHandler.TaxBaseReducedValue);
data.Add("basicvatamount", XmlHandler.BasicVatAmountValue);
data.Add("reducedvatamount", XmlHandler.ReducedVatAmountValue);
data.Add("taxfreeamount", XmlHandler.TaxFreeAmountValue);
SqlDriver driver = new SqlDriver();
string lastid = driver.InsertReceipt(data);
driver.InsertReceiptItems(XmlHandler.items, lastid);
}
}
if (totalFiles == filesDone)
{
textBoxLog.SelectionColor = Color.Green;
textBoxLog.AppendText("\nDOKONČENÉ");
textBoxLog.SelectionColor = Color.Black;
textBoxLog.ScrollToCaret();
}
LoadGridData();
buttonOk.Enabled = true;
}
}