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