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