private async void LoadDataFromFile()
{
_maxRedniBroj = IraItems.Count > 0 ? IraItems.Max(y => y.RedniBroj) : 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)
{
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 async void SaveToDatabase()
{
IEnumerable <BookIraModel> primke = IraItems.Where(x => x.RedniBroj > _maxRedniBroj);
var list = new List <BookIraModel>(primke);
IsLoading = true;
await _bookIraEndpoint.PostPrimke(list);
_loaded = false;
LoadIra();
}
private async void SaveToDatabase()
{
IEnumerable <BookIraModel> primke = IraItems.Where(x => x.RedniBroj > _maxRedniBroj);
var list = new List <BookIraModel>(primke);
StatusMessage = "Zapisujem u bazu podataka...";
await _bookIraEndpoint.PostPrimke(list);
StatusMessage = "";;
_loaded = false;
LoadIra();
}
private void AddDataToList(DataRow val)
{
IraItems.Add(new BookIraModel
{
RedniBroj = int.Parse(val[1].ToString()),
BrojRacuna = val[2].ToString(),
Storno = val[3].ToString() == "1",
IzRacuna = int.Parse(val[4].ToString()),
Datum = DateTime.Parse(val[5].ToString()),
Dospijece = DateTime.Parse(val[6].ToString()),
DatumZadnjeUplate = val[7].ToString() == "" ? null : DateTime.Parse(val[7].ToString()),
NazivISjedisteKupca = val[8].ToString(),
Oib = val[9].ToString(),
IznosSPdv = decimal.Parse(val[10].ToString()),
OslobodjenoPdvEU = decimal.Parse(val[11].ToString()),
OslobodjenoPdvOstalo = decimal.Parse(val[12].ToString()),
ProlaznaStavka = decimal.Parse(val[13].ToString()),
PoreznaOsnovica0 = decimal.Parse(val[14].ToString()),
PoreznaOsnovica5 = decimal.Parse(val[15].ToString()),
Pdv5 = decimal.Parse(val[16].ToString()),
PoreznaOsnovica10 = decimal.Parse(val[17].ToString()),
Pdv10 = decimal.Parse(val[18].ToString()),
PoreznaOsnovica13 = decimal.Parse(val[19].ToString()),
Pdv13 = decimal.Parse(val[20].ToString()),
PoreznaOsnovica23 = decimal.Parse(val[21].ToString()),
Pdv23 = decimal.Parse(val[22].ToString()),
PoreznaOsnovica25 = decimal.Parse(val[23].ToString()),
Pdv25 = decimal.Parse(val[24].ToString()),
UkupniPdv = decimal.Parse(val[25].ToString()),
UkupnoUplaceno = decimal.Parse(val[26].ToString()),
PreostaloZaUplatit = decimal.Parse(val[27].ToString()),
NapomenaORacunu = val[28].ToString(),
ZaprimljenUHzzo = val[29].ToString() == "" ? null : DateTime.Parse(val[29].ToString()),
DanaOdZaprimanja = int.Parse(val[30].ToString()),
DanaNeplacanja = int.Parse(val[31].ToString())
});
}
private void LoadDataFromFile()
{
_maxRedniBroj = IraItems.Count > 0 ? IraItems.Max(y => y.RedniBroj) : 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;
}
}
}
