private async void LoadDataFromFile() { _maxPrimka = UraPrimke.Count > 0 ? UraPrimke.Max(y => y.BrojUKnjiziUra) : 0; OpenFileDialog ofd = new OpenFileDialog { Filter = "Xlsx Files *.xlsx|*.xlsx|Xls Files *.xls|*.xls|Csv files *.csv|*.csv", FilterIndex = 1, Multiselect = false }; bool?result = ofd.ShowDialog(); if (result != null && result == true) { IsLoading = true; FilePath = ofd.FileName; var data = _xlsFileReader.Convert(FilePath, _bookName); if (data != null) { FromStringToList(data); _loaded = true; } await Application.Current.Dispatcher.BeginInvoke(new Action(DatagridLoaded), DispatcherPriority.ContextIdle, null); } }
private void AddDataToList(DataRow val) { UraPrimke.Add(new BookUraPrimkaModel { DatumKnjizenja = DateTime.Parse(val[1].ToString()), BrojPrimke = int.Parse(val[2].ToString()), Storno = val[3].ToString() == "*", MaloprodajnaVrijednost = decimal.Parse(val[4].ToString()), NazivDobavljaca = val[5].ToString(), BrojRacuna = val[6].ToString(), DatumRacuna = DateTime.Parse(val[7].ToString()), Otpremnica = val[8].ToString() == "DA", DospijecePlacanja = DateTime.Parse(val[9].ToString()), FakturnaVrijednost = decimal.Parse(val[10].ToString()), MaloprodajnaMarza = decimal.Parse(val[11].ToString()), IznosPdv = decimal.Parse(val[12].ToString()), VrijednostBezPoreza = decimal.Parse(val[13].ToString()), NabavnaVrijednost = decimal.Parse(val[14].ToString()), MaloprodajniRabat = decimal.Parse(val[15].ToString()), NettoNabavnaVrijednost = decimal.Parse(val[16].ToString()), Pretporez = decimal.Parse(val[17].ToString()), VeleprodajniRabat = decimal.Parse(val[18].ToString()), CassaSconto = decimal.Parse(val[19].ToString()), NettoRuc = decimal.Parse(val[20].ToString()), PovratnaNaknada = decimal.Parse(val[21].ToString()), PorezniBroj = val[22].ToString(), BrojUKnjiziUra = int.Parse(val[23].ToString()) }); }
private async void SaveToDatabase() { IEnumerable <BookUraPrimkaReproModel> primke = UraPrimke.Where(x => x.BrojUKnjiziUra > _maxPrimka); var list = new List <BookUraPrimkaReproModel>(primke); IsLoading = true; await _bookUraEndpoint.PostPrimke(list); _loaded = false; LoadPrimke(); }
private async void SaveToDatabase() { IEnumerable <BookUraPrimkaModel> primke = UraPrimke.Where(x => x.BrojUKnjiziUra > _maxPrimka); var list = new List <BookUraPrimkaModel>(primke); StatusMessage = "Zapisujem u bazu podataka..."; await _bookUraEndpoint.PostPrimke(list); StatusMessage = "";; _loaded = false; LoadPrimke(); }
private void LoadDataFromFile() { _maxPrimka = UraPrimke.Count > 0 ? UraPrimke.Max(y => y.BrojUKnjiziUra) : 0; OpenFileDialog ofd = new OpenFileDialog { Filter = "Xlsx Files *.xlsx|*.xlsx|Xls Files *.xls|*.xls|Csv files *.csv|*.csv", FilterIndex = 1, Multiselect = false }; Nullable <bool> result = ofd.ShowDialog(); if (result != null && result == true) { FilePath = ofd.FileName; var data = _xlsFileReader.Convert(FilePath, _bookName); if (data != null) { FromStringToList(data); _loaded = true; } } }