private async void LoadDataFromFile()
{
_maxPrimka = UraRestInvoices.Count > 0 ? UraRestInvoices.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);
}
}
public async void LoadRetailInvoices()
{
await LoadInitialData();
var expenditures = UraRestInvoices.Where(x => x.BrojPrimke != 0).ToList();
UraRestInvoices = new ObservableCollection <BookUraRestModel>(expenditures);
FilterPrimke();
}
public async void LoadOnlyRestExpenditures()
{
await LoadInitialData();
var expenditures = UraRestInvoices.Where(x => (x.BrojPrimke == 0 && x.IznosSPorezom > 0 && !x.Storno) ||
(x.BrojPrimke == 0 && x.IznosSPorezom < 0 && x.Storno)).ToList();
UraRestInvoices = new ObservableCollection <BookUraRestModel>(expenditures);
FilterPrimke();
}
private async void SaveToDatabase()
{
IEnumerable <BookUraRestModel> primke = UraRestInvoices.Where(x => x.RedniBroj > _maxPrimka);
var list = new List <BookUraRestModel>(primke);
IsLoading = true;
await _bookUraEndpoint.PostPrimke(list);
_loaded = false;
LoadPrimke();
}
public async void LoadRetailInvoices()
{
IsLoading = true;
await LoadInitialData();
var expenditures = UraRestInvoices.Where(x => x.BrojPrimke != 0).ToList();
UraRestInvoices = new ObservableCollection <BookUraRestModel>(expenditures);
FilterPrimke();
await Application.Current.Dispatcher.BeginInvoke(new Action(DatagridLoaded), DispatcherPriority.ContextIdle, null);
}
public async void LoadOnlyRestExpenditures()
{
IsLoading = true;
await LoadInitialData();
var expenditures = UraRestInvoices.Where(x => (x.BrojPrimke == 0 && x.IznosSPorezom > 0 && !x.Storno) ||
(x.BrojPrimke == 0 && x.IznosSPorezom < 0 && x.Storno)).ToList();
UraRestInvoices = new ObservableCollection <BookUraRestModel>(expenditures);
FilterPrimke();
await Application.Current.Dispatcher.BeginInvoke(new Action(DatagridLoaded), DispatcherPriority.ContextIdle, null);
}
private async void SaveToDatabase()
{
IEnumerable <BookUraRestModel> primke = UraRestInvoices.Where(x => x.RedniBroj > _maxPrimka);
var list = new List <BookUraRestModel>(primke);
StatusMessage = "Zapisujem u bazu podataka...";
await _bookUraEndpoint.PostPrimke(list);
StatusMessage = "";;
_loaded = false;
LoadPrimke();
}
private void AddDataToList(DataRow val)
{
UraRestInvoices.Add(new BookUraRestModel
{
RedniBroj = int.Parse(val[1].ToString()),
Datum = DateTime.Parse(val[2].ToString()),
BrojRacuna = val[3].ToString(),
Storno = val[4].ToString() == "*",
StornoBroja = int.Parse(val[5].ToString()),
DatumRacuna = DateTime.Parse(val[6].ToString()),
StarostRacuna = int.Parse(val[7].ToString()),
Dospijece = DateTime.Parse(val[8].ToString()),
PlaniranaUplata = val[9].ToString() == "" ? 0 : decimal.Parse(val[9].ToString()),
DatumUplate = val[10].ToString() == "" ? null : DateTime.Parse(val[10].ToString()),
ZaUplatu = decimal.Parse(val[11].ToString()),
NazivDobavljaca = val[12].ToString(),
BrojPrimke = int.Parse(val[13].ToString()),
NapomenaORacunu = val[14].ToString(),
NettoNabavnaVrijednost = decimal.Parse(val[15].ToString()),
SjedisteDobavljaca = val[16].ToString(),
OIB = val[17].ToString(),
IznosSPorezom = decimal.Parse(val[18].ToString()),
PoreznaOsnovica0 = decimal.Parse(val[19].ToString()),
PoreznaOsnovica5 = decimal.Parse(val[20].ToString()),
PretporezT5 = decimal.Parse(val[21].ToString()),
PoreznaOsnovica10 = decimal.Parse(val[22].ToString()),
PretporezT10 = decimal.Parse(val[23].ToString()),
PoreznaOsnovica13 = decimal.Parse(val[24].ToString()),
PretporezT13 = decimal.Parse(val[25].ToString()),
PoreznaOsnovica23 = decimal.Parse(val[26].ToString()),
PretporezT23 = decimal.Parse(val[27].ToString()),
PoreznaOsnovica25 = decimal.Parse(val[28].ToString()),
PretporezT25 = decimal.Parse(val[29].ToString()),
UkupniPretporez = decimal.Parse(val[30].ToString()),
MozeSeOdbiti = decimal.Parse(val[31].ToString()),
NeMozeSeOdbiti = decimal.Parse(val[32].ToString()),
IznosBezPoreza = decimal.Parse(val[33].ToString()),
ProlaznaStavka = decimal.Parse(val[34].ToString()),
Neoporezivo = decimal.Parse(val[35].ToString()),
CassaScontoPercent = decimal.Parse(val[36].ToString()),
CassaSconto = decimal.Parse(val[37].ToString()),
BrojOdobrenja = val[38].ToString(),
OdobrenjaBezPDV = val[39].ToString(),
OdobreniPDV = decimal.Parse(val[40].ToString()),
DatumPodnosenja = val[41].ToString() == "" ? null : DateTime.Parse(val[41].ToString()),
DatumIzvrsenja = val[42].ToString() == "" ? null : DateTime.Parse(val[42].ToString()),
UkupnoUplaceno = decimal.Parse(val[43].ToString()),
PreostaloZaUplatit = decimal.Parse(val[44].ToString()),
DospijeceDana = int.Parse(val[45].ToString())
});
}
private void LoadDataFromFile()
{
_maxPrimka = UraRestInvoices.Count > 0 ? UraRestInvoices.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;
}
}
}
