public void Getinfo()
{
List <string> bills = Sqlader.getColumn("Brutto");
List <float> fbills = new List <float>();
float x;
foreach (string item in bills)
{
if (float.TryParse(item, out _))
{
fbills.Add(float.Parse(item));
}
;
}
List <string> netto = Sqlader.getColumn("Netto");
List <float> fnetto = new List <float>();
foreach (string item in netto)
{
if (float.TryParse(item, out _))
{
fnetto.Add(float.Parse(item));
}
;
}
label2.Text = bills.Count.ToString();
label6.Text = (fbills.Sum() / fbills.Count).ToString();
label8.Text = (fbills.Sum() - fnetto.Sum()).ToString();
}
private void buttonSearch_Click(object sender, EventArgs e)
{
restbuttonclick();
paneldateparrent.Controls.Clear();
List <string> name = Sqlader.getValue("Dokument", "Dokument", textBoxSearchBill.Text);
List <string> price = Sqlader.getValue("Brutto", "Dokument", textBoxSearchBill.Text);
List <string> dateW = Sqlader.getValue("Data_wystawienia", "Dokument", textBoxSearchBill.Text);
List <string> dateS = Sqlader.getValue("Data_sprzedazy", "Dokument", textBoxSearchBill.Text);
List <string> netto = Sqlader.getValue("Netto", "Dokument", textBoxSearchBill.Text);
List <string> nip = Sqlader.getValue("NIP", "Dokument", textBoxSearchBill.Text);
List <string> vat = Sqlader.getValue("Vat", "Dokument", textBoxSearchBill.Text);
List <string> addres = Sqlader.getValue("Adres", "Dokument", textBoxSearchBill.Text);
List <string> country = Sqlader.getValue("Kraj", "Dokument", textBoxSearchBill.Text);
List <string> paymethond = Sqlader.getValue("Sposob_platnosci", "Dokument", textBoxSearchBill.Text);
List <string> postcode = Sqlader.getValue("Kod_pocztowy", "Dokument", textBoxSearchBill.Text);
List <string> fname = Sqlader.getValue("Imie", "Dokument", textBoxSearchBill.Text);
List <string> lname = Sqlader.getValue("Nazwisko", "Dokument", textBoxSearchBill.Text);
List <string> city = Sqlader.getValue("Miasto", "Dokument", textBoxSearchBill.Text);
for (int i = 0; i < name.Count; i++)
{
CreateOnebilltest(name[i], price[i], dateW[i], dateS[i], netto[i], fname[i], lname[i], nip[i], addres[i], postcode[i], city[i], vat[i], country[i], paymethond[i]);
}
textBoxSearchBill.Text = "";
}
private void buttonsortprice_Click(object sender, EventArgs e)
{
restbuttonclick();
if (priceclick == 0)
{
paneldateparrent.Controls.Clear();
List <string> name = Sqlader.getColumnSort("Dokument", "Brutto");
List <string> price = Sqlader.getColumnSort("Brutto", "Brutto");
List <string> dateW = Sqlader.getColumnSort("Data_wystawienia", "Brutto");
List <string> dateS = Sqlader.getColumnSort("Data_sprzedazy", "Brutto");
List <string> netto = Sqlader.getColumnSort("Netto", "Brutto");
List <string> nip = Sqlader.getColumnSort("NIP", "Brutto");
List <string> vat = Sqlader.getColumnSort("Vat", "Brutto");
List <string> addres = Sqlader.getColumnSort("Adres", "Brutto");
List <string> country = Sqlader.getColumnSort("Kraj", "Brutto");
List <string> paymethond = Sqlader.getColumnSort("Sposob_platnosci", "Brutto");
List <string> postcode = Sqlader.getColumnSort("Kod_pocztowy", "Brutto");
List <string> fname = Sqlader.getColumnSort("Imie", "Brutto");
List <string> lname = Sqlader.getColumnSort("Nazwisko", "Brutto");
List <string> city = Sqlader.getColumnSort("Miasto", "Brutto");
buttonsortprice.Text = "Cena ^";
for (int i = 0; i < name.Count; i++)
{
CreateOnebilltest(name[i], price[i], dateW[i], dateS[i], netto[i], fname[i], lname[i], nip[i], addres[i], postcode[i], city[i], vat[i], country[i], paymethond[i]);
}
priceclick++;
}
else
{
paneldateparrent.Controls.Clear();
List <string> name = Sqlader.getColumnSort("Dokument", "Brutto", "DESC");
List <string> price = Sqlader.getColumnSort("Brutto", "Brutto", "DESC");
List <string> dateW = Sqlader.getColumnSort("Data_wystawienia", "Brutto", "DESC");
List <string> dateS = Sqlader.getColumnSort("Data_sprzedazy", "Brutto", "DESC");
List <string> netto = Sqlader.getColumnSort("Netto", "Brutto", "DESC");
List <string> nip = Sqlader.getColumnSort("NIP", "Brutto", "DESC");
List <string> vat = Sqlader.getColumnSort("Vat", "Brutto", "DESC");
List <string> addres = Sqlader.getColumnSort("Adres", "Brutto", "DESC");
List <string> country = Sqlader.getColumnSort("Kraj", "Brutto", "DESC");
List <string> paymethond = Sqlader.getColumnSort("Sposob_platnosci", "Brutto", "DESC");
List <string> postcode = Sqlader.getColumnSort("Kod_pocztowy", "Brutto", "DESC");
List <string> fname = Sqlader.getColumnSort("Imie", "Brutto", "DESC");
List <string> lname = Sqlader.getColumnSort("Nazwisko", "Brutto", "DESC");
List <string> city = Sqlader.getColumnSort("Miasto", "Brutto", "DESC");
buttonsortprice.Text = "Cena ˅";
for (int i = 0; i < name.Count; i++)
{
CreateOnebilltest(name[i], price[i], dateW[i], dateS[i], netto[i], fname[i], lname[i], nip[i], addres[i], postcode[i], city[i], vat[i], country[i], paymethond[i]);
}
priceclick = 0;
}
}
private void button1_Click(object sender, EventArgs e)
{
OpenFileDialog ofd = new OpenFileDialog();
ofd.Filter = "CSV|*.csv";
if (ofd.ShowDialog() == DialogResult.OK)
{
label1.Text = ofd.FileName;
using (var read = new StreamReader(ofd.SafeFileName))
using (var csv = new CsvReader(read, CultureInfo.InvariantCulture))
{
var records = csv.GetRecords <getBiilmodel>().ToList();
foreach (getBiilmodel item in records)
{
Sqlader.SaveBillv2(item);
}
}
MessageBox.Show("Import udany.");
}
}
private void button4_Click(object sender, EventArgs e)
{
Stream myStream;
SaveFileDialog saveFileDialog1 = new SaveFileDialog();
saveFileDialog1.Filter = "plik csv (*.csv)|*.csv|Wszystkie pliki (*.*)|*.*";
saveFileDialog1.FilterIndex = 2;
saveFileDialog1.RestoreDirectory = true;
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
if ((myStream = saveFileDialog1.OpenFile()) != null)
{
using (var writer = new StreamWriter(myStream))
using (var csv = new CsvWriter(writer, CultureInfo.InvariantCulture))
{
csv.WriteRecords(Sqlader.getQuery());
}
MessageBox.Show("Plik został utworzony");
myStream.Close();
}
}
}
public void Createallbill()
{
//////////////////
///Get data from database by query getBillmodel
//////////////////
/*
* paneldateparrent.Controls.Clear();
* List<getBiilmodel> x = Sqlader.getQuery();
* foreach (getBiilmodel item in x)
* {
* CreateOnebill(item.Dokument, item.Brutto.ToString().Insert(item.Brutto.ToString().Length-2,","), item.Data_wystawienia);
* }
*/
paneldateparrent.Controls.Clear();
List <string> name = Sqlader.getColumn("Dokument");
List <string> price = Sqlader.getColumn("Brutto");
List <string> dateW = Sqlader.getColumn("Data_wystawienia");
List <string> dateS = Sqlader.getColumn("Data_sprzedazy");
List <string> netto = Sqlader.getColumn("Netto");
List <string> nip = Sqlader.getColumn("NIP");
List <string> vat = Sqlader.getColumn("Vat");
List <string> addres = Sqlader.getColumn("Adres");
List <string> country = Sqlader.getColumn("Kraj");
List <string> paymethond = Sqlader.getColumn("Sposob_platnosci");
List <string> postcode = Sqlader.getColumn("Kod_pocztowy");
List <string> fname = Sqlader.getColumn("Imie");
List <string> lname = Sqlader.getColumn("Nazwisko");
List <string> city = Sqlader.getColumn("Miasto");
for (int i = 0; i < name.Count; i++)
{
CreateOnebilltest(name[i], price[i], dateW[i], dateS[i], netto[i], fname[i], lname[i], nip[i], addres[i], postcode[i], city[i], vat[i], country[i], paymethond[i]);
}
}
public void Add(BillModel bill)
{
Sqlader.SaveBill(bill);
}
