public ObservableCollection<Mesto> DajSvaMesta()
{
try
{
LavDataClassesDataContext _baza = new LavDataClassesDataContext(konekcioniString);
if (_baza.DatabaseExists())
{
IQueryable<Mesto> _upit = (from p in _baza.Mestos
//where p.MestoID == -1
select p).OrderBy(w => w.MestoID);
ObservableCollection<Mesto> _lista = new ObservableCollection<Mesto>(_upit.ToList());
return _lista;
}
else
{
return null;
}
}
catch (Exception ex)
{
throw ex;
}
}
public ObservableCollection<PoreskaStopa> DajSvePoreskeStope()
{
try
{
LavDataClassesDataContext _baza = new LavDataClassesDataContext(konekcioniString);
if (_baza.DatabaseExists())
{
IQueryable<PoreskaStopa> _upit = (from p in _baza.PoreskaStopas
select p).OrderBy(w => w.PoreskaStopaID);
ObservableCollection<PoreskaStopa> _lista = new ObservableCollection<PoreskaStopa>(_upit.ToList());
return _lista;
}
else
{
throw new Exception("Baza ne postoji.");
}
}
catch (Exception ex)
{
throw ex;
}
}
public KorisnikPrograma DajKorisnikPrograma()
{
try
{
LavDataClassesDataContext _baza = new LavDataClassesDataContext(konekcioniString);
if (_baza.DatabaseExists())
{
IQueryable<KorisnikPrograma> _upit = (from p in _baza.KorisnikProgramas
select p).OrderBy(w => w.KorisnikProgramaID).Take(1);
ObservableCollection<KorisnikPrograma> _lista = new ObservableCollection<KorisnikPrograma>(_upit.ToList());
if (_lista.Count().Equals(1))
{
return _lista.First();
}
else
{
return null;
}
}
else
{
throw new Exception("Baza ne postoji.");
}
}
catch (Exception ex)
{
throw ex;
}
}
public ObservableCollection<RadniNalog> NadjiRadniNalog(string vrstaPartnera, string radniNalogID, DateTime? datumOd, DateTime? datumDo, string partner, bool? neZavrsene, int? radnikID, int radniNalogStatusIDZavrsen)
{
//return new ObservableCollection<RadniNalog>();
try
{
LavDataClassesDataContext _baza = new LavDataClassesDataContext(konekcioniString);
if (_baza.DatabaseExists())
{
IQueryable<RadniNalog> _upit = (from p in _baza.RadniNalogs
where p.Status.ToString() != "D"
select p).OrderBy(w => w.RadniNalogID);
if (neZavrsene != null && (bool)neZavrsene)
{
_upit = (from u in _upit
join su in _baza.StavkaUslugas
on u.RadniNalogID equals su.RadniNalogID
join surn in _baza.RadniNalogStavkaUslugas
on su.StavkaUslugaID equals surn.RadniNalogStavkaUslugaID
where (surn.Status.ToString() != "D" && surn.RadniNalogStatusID != radniNalogStatusIDZavrsen)
select u);
}
if (vrstaPartnera != "")
{
if (vrstaPartnera == "Poslovni partner")
{
_upit = from u in _upit
where u.ServisnaKnjizica.PoslovniPartnerID != null
select u;
}
else if (vrstaPartnera == "Fizičko lice")
{
_upit = from u in _upit
where u.ServisnaKnjizica.FizickoLiceID != null
select u;
}
}
if (radniNalogID != "")
{
if (radniNalogID.StartsWith("*") && radniNalogID.EndsWith("*"))
{
_upit = from u in _upit
where u.RadniNalogID.ToString().Contains(radniNalogID.Substring(1, radniNalogID.Length - 2))
select u;
}
else if (radniNalogID.StartsWith("*"))
{
_upit = from u in _upit
where u.RadniNalogID.ToString().EndsWith(radniNalogID.Substring(1, radniNalogID.Length - 1))
select u;
}
else if (radniNalogID.EndsWith("*"))
{
_upit = from u in _upit
where u.RadniNalogID.ToString().StartsWith(radniNalogID.Substring(0, radniNalogID.Length - 1))
select u;
}
else
{
_upit = from u in _upit
where u.RadniNalogID.ToString().Equals(radniNalogID)
select u;
}
}
if (datumOd != null || datumDo != null)
{
if (datumOd != null && datumDo == null)
{
_upit = from u in _upit
where u.Vreme >= datumOd
select u;
}
else if (datumOd == null && datumDo != null)
{
_upit = from u in _upit
where u.Vreme <= datumDo
select u;
}
else if (datumOd != null && datumDo != null)
{
_upit = from u in _upit
where u.Vreme >= datumOd && u.Vreme <= datumDo
select u;
}
}
if (partner != "")
{
if (partner.StartsWith("*") && partner.EndsWith("*"))
{
_upit = from u in _upit
where u.ServisnaKnjizica.PoslovniPartner.SkracenNaziv.Contains(partner.Substring(1, partner.Length - 2)) ||
u.ServisnaKnjizica.FizickoLice.Ime.Contains(partner.Substring(1, partner.Length - 2))
select u;
}
else if (partner.StartsWith("*"))
{
_upit = from u in _upit
where u.ServisnaKnjizica.PoslovniPartner.SkracenNaziv.EndsWith(partner.Substring(1, partner.Length - 1)) ||
u.ServisnaKnjizica.FizickoLice.Ime.EndsWith(partner.Substring(1, partner.Length - 1))
select u;
}
else if (partner.EndsWith("*"))
{
_upit = from u in _upit
where u.ServisnaKnjizica.PoslovniPartner.SkracenNaziv.StartsWith(partner.Substring(0, partner.Length - 1)) ||
u.ServisnaKnjizica.FizickoLice.Ime.StartsWith(partner.Substring(0, partner.Length - 1))
select u;
}
else
{
_upit = from u in _upit
where u.ServisnaKnjizica.PoslovniPartner.SkracenNaziv.Equals(partner) ||
u.ServisnaKnjizica.FizickoLice.Ime.Equals(partner)
select u;
}
}
if (radnikID != null)
{
_upit = from u in _upit
where u.RadnikID == radnikID
select u;
}
ObservableCollection<RadniNalog> _lista = new ObservableCollection<RadniNalog>(_upit.Distinct().ToList());
return _lista;
}
else
{
throw new Exception("Baza ne postoji.");
}
}
catch (Exception ex)
{
throw ex;
}
}
public ObservableCollection<Proizvodjac> DajSveProizvodjac()
{
try
{
LavDataClassesDataContext _baza = new LavDataClassesDataContext(konekcioniString);
if (_baza.DatabaseExists())
{
IQueryable<Proizvodjac> _upit = (from p in _baza.Proizvodjacs
join m in _baza.ModelAutomobilas
on p.Proizvodjac_ID equals m.Proizvodjac_ID
select p).Distinct().OrderBy(w => w.Naziv);
ObservableCollection<Proizvodjac> _lista = new ObservableCollection<Proizvodjac>(_upit.ToList());
return _lista;
}
else
{
throw new Exception("Baza ne postoji.");
}
}
catch (Exception ex)
{
throw ex;
}
}
public ObservableCollection<RadnoMesto> DajSvaRadnaMesta()
{
try
{
LavDataClassesDataContext _baza = new LavDataClassesDataContext(konekcioniString);
if (_baza.DatabaseExists())
{
IQueryable<RadnoMesto> _upit = (from p in _baza.RadnoMestos
select p).OrderBy(w => w.RadnoMestoID);
ObservableCollection<RadnoMesto> _lista = new ObservableCollection<RadnoMesto>(_upit.ToList());
return _lista;
}
else
{
throw new Exception("Baza ne postoji.");
}
}
catch (Exception ex)
{
throw ex;
}
}
public ObservableCollection<PadajucaListaSezonaGumaRoban> DajPadajucuListuSezonaGumaRoban()
{
try
{
LavDataClassesDataContext _baza = new LavDataClassesDataContext(konekcioniString);
if (_baza.DatabaseExists())
{
ObservableCollection<PadajucaListaSezonaGumaRoban> _lista = new ObservableCollection<PadajucaListaSezonaGumaRoban>(_baza.uspDajPadajucuListuSezonaGumaRoban().ToList());
return _lista;
}
else
{
throw new Exception("Baza ne postoji.");
}
}
catch (Exception ex)
{
throw ex;
}
}
public ObservableCollection<Artikal> NadjiGumuRoban(int? proizvodjacID, string namena, string sezona, string dimenzija)
{
try
{
LavDataClassesDataContext _baza = new LavDataClassesDataContext(konekcioniString);
if (_baza.DatabaseExists())
{
ObservableCollection<Artikal> _artikli = new ObservableCollection<Artikal>(_baza.uspNadjiGumu(proizvodjacID, namena, sezona, dimenzija).ToList());
return _artikli;
}
else
{
throw new Exception("Baza ne postoji.");
}
}
catch (Exception ex)
{
throw ex;
}
}
public ObservableCollection<Artikal> NadjiUljeRoban(int? proizvodjacID, string viskozitet)
{
try
{
LavDataClassesDataContext _baza = new LavDataClassesDataContext(konekcioniString);
DataLoadOptions _dlo = new DataLoadOptions();
if (_baza.DatabaseExists())
{
ObservableCollection<Artikal> _artikli = new ObservableCollection<Artikal>(_baza.uspNadjiUlje(proizvodjacID, viskozitet).ToList());
return _artikli;
}
else
{
throw new Exception("Baza ne postoji.");
}
}
catch (Exception ex)
{
throw ex;
}
}
public ObservableCollection<Artikal> NadjiArtikal(string brojZaPretragu, bool slicnoTrazenje, bool samoSaCenom, bool biloKojiBroj,
bool brojProizvodjaca, bool oeBroj, bool korisceniBroj, bool uporedniBroj, bool eanBroj)
{
List<int> _vrstaBrojaZaPretragu = new List<int>();
#region vrstaBrojaZaPretragu
if (!biloKojiBroj)
{
if (brojProizvodjaca)
{
_vrstaBrojaZaPretragu.Add(1);
}
if (oeBroj)
{
_vrstaBrojaZaPretragu.Add(3);
}
if (korisceniBroj)
{
_vrstaBrojaZaPretragu.Add(2);
}
if (uporedniBroj)
{
_vrstaBrojaZaPretragu.Add(4);
}
if (eanBroj)
{
_vrstaBrojaZaPretragu.Add(5);
}
}
#endregion
try
{
LavDataClassesDataContext _baza = new LavDataClassesDataContext(konekcioniString);
////Da bi izbegao load podataka za tabelu NajpovoljnijiDobavljac koja ne postoji u Bazi
////prvo gasim dlo za sve tabele
//_baza.DeferredLoadingEnabled = false;
////a onda dodajem dlo za one koje mi trebaju
//DataLoadOptions _dlo = new DataLoadOptions();
//_dlo.LoadWith<Artikal>(p => p.Proizvodjac);
//_dlo.LoadWith<Artikal>(p => p.OpisTabela);
//_dlo.LoadWith<Artikal>(p => p.VezaArtikalBrojZaPretragus);
//_dlo.LoadWith<Artikal>(p => p.VezaArtikalDobavljacs);
//_dlo.LoadWith<VezaArtikalDobavljac>(p => p.PoslovniPartner);
//_dlo.LoadWith<VezaArtikalDobavljac>(p => p.KorisnikPrograma);
//_baza.LoadOptions = _dlo;
if (_baza.DatabaseExists())
{
ObservableCollection<Artikal> _lista = new ObservableCollection<Artikal>(_baza.uspNadjiArtikal(brojZaPretragu, slicnoTrazenje, samoSaCenom, biloKojiBroj, brojProizvodjaca, oeBroj, korisceniBroj, uporedniBroj, eanBroj).ToList());
//IQueryable<Artikal> _upit = (from a in _baza.Artikals
// select a).OrderBy(w => w.Artikal_ID);
//if (samoSaCenom)
//{
// _upit = (from u in _upit
// join c in _baza.VezaArtikalDobavljacs
// on u.Artikal_ID equals c.ArtikalID
// select u);
//}
//if (slicnoTrazenje)
//{
// if (_vrstaBrojaZaPretragu.Count().Equals(0))
// {
// _upit = (from u in _upit
// join v in _baza.VezaArtikalBrojZaPretragus
// on u.Artikal_ID equals v.Artikal_ID
// where v.BrojZaPretragu.Contains(brojZaPretragu)
// select u);
// }
// else if (_vrstaBrojaZaPretragu.Count().Equals(1))
// {
// _upit = (from u in _upit
// join v in _baza.VezaArtikalBrojZaPretragus
// on u.Artikal_ID equals v.Artikal_ID
// where v.BrojZaPretragu.Contains(brojZaPretragu) & _vrstaBrojaZaPretragu[0].Equals(v.VrstaBrojaZaPretragu_ID)
// select u);
// }
// else
// {
// _upit = (from u in _upit
// join v in _baza.VezaArtikalBrojZaPretragus
// on u.Artikal_ID equals v.Artikal_ID
// where v.BrojZaPretragu.Contains(brojZaPretragu) & _vrstaBrojaZaPretragu.Contains(v.VrstaBrojaZaPretragu_ID)
// select u);
// }
//}
//else
//{
// if (_vrstaBrojaZaPretragu.Count().Equals(0))
// {
// _upit = (from u in _upit
// join v in _baza.VezaArtikalBrojZaPretragus
// on u.Artikal_ID equals v.Artikal_ID
// where v.BrojZaPretragu.Equals(brojZaPretragu)
// select u);
// }
// else if (_vrstaBrojaZaPretragu.Count().Equals(1))
// {
// _upit = (from u in _upit
// join v in _baza.VezaArtikalBrojZaPretragus
// on u.Artikal_ID equals v.Artikal_ID
// where v.BrojZaPretragu.Equals(brojZaPretragu) & _vrstaBrojaZaPretragu[0].Equals(v.VrstaBrojaZaPretragu_ID)
// select u);
// }
// else
// {
// _upit = (from u in _upit
// join v in _baza.VezaArtikalBrojZaPretragus
// on u.Artikal_ID equals v.Artikal_ID
// where v.BrojZaPretragu.Equals(brojZaPretragu) & _vrstaBrojaZaPretragu.Contains(v.VrstaBrojaZaPretragu_ID)
// select u);
// }
//}
//_upit = (from u in _upit
// select u).Take(200);//.Distinct().Take(100);
return _lista;
}
else
{
throw new Exception("Baza ne postoji.");
}
}
catch (Exception ex)
{
throw ex;
}
}
public ObservableCollection<ServisnaKnjizica> NadjiServisnuKnjizicu(string imeKolone, string uslov, string vrstaPartnera)
{
try
{
LavDataClassesDataContext _baza = new LavDataClassesDataContext(konekcioniString);
if (_baza.DatabaseExists())
{
IQueryable<ServisnaKnjizica> _upit = (from p in _baza.ServisnaKnjizicas
select p).OrderBy(w => w.ServisnaKnjizicaID);
switch (vrstaPartnera)
{
case "PoslovniPartner":
_upit = from u in _upit
where u.PoslovniPartnerID != null
select u;
break;
case "FizickoLice":
_upit = from u in _upit
where u.FizickoLiceID != null
select u;
break;
default:
throw new Exception("Nepoznata vrsta partnera.");
}
switch (imeKolone)
{
case "ID":
if (uslov.StartsWith("*") && uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.ServisnaKnjizicaID.ToString().Contains(uslov.Substring(1, uslov.Length - 2))
select u;
}
else if (uslov.StartsWith("*"))
{
_upit = from u in _upit
where u.ServisnaKnjizicaID.ToString().EndsWith(uslov.Substring(1, uslov.Length - 1))
select u;
}
else if (uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.ServisnaKnjizicaID.ToString().StartsWith(uslov.Substring(0, uslov.Length - 1))
select u;
}
else
{
_upit = from u in _upit
where u.ServisnaKnjizicaID.ToString().Equals(uslov)
select u;
}
break;
case "Šifra":
if (uslov.StartsWith("*") && uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.Sifra.Contains(uslov.Substring(1, uslov.Length - 2))
select u;
}
else if (uslov.StartsWith("*"))
{
_upit = from u in _upit
where u.Sifra.EndsWith(uslov.Substring(1, uslov.Length - 1))
select u;
}
else if (uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.Sifra.StartsWith(uslov.Substring(0, uslov.Length - 1))
select u;
}
else
{
_upit = from u in _upit
where u.Sifra.Equals(uslov)
select u;
}
break;
case "Partner":
if (uslov.StartsWith("*") && uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.FizickoLice.Ime.Contains(uslov.Substring(1, uslov.Length - 2))
|| u.PoslovniPartner.SkracenNaziv.Contains(uslov.Substring(1, uslov.Length - 2))
select u;
}
else if (uslov.StartsWith("*"))
{
_upit = from u in _upit
where u.FizickoLice.Ime.EndsWith(uslov.Substring(1, uslov.Length - 1)) ||
u.PoslovniPartner.SkracenNaziv.EndsWith(uslov.Substring(1, uslov.Length - 1))
select u;
}
else if (uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.FizickoLice.Ime.StartsWith(uslov.Substring(0, uslov.Length - 1))
|| u.PoslovniPartner.SkracenNaziv.StartsWith(uslov.Substring(0, uslov.Length - 1))
select u;
}
else
{
_upit = from u in _upit
where u.FizickoLice.Ime.Equals(uslov)
|| u.PoslovniPartner.SkracenNaziv.Equals(uslov)
select u;
}
break;
case "Tip":
if (uslov.StartsWith("*") && uslov.EndsWith("*"))
{
//_upit = from u in _upit
// where
// u.TipAutomobila.ModelAutomobila.Proizvodjac.Naziv.Contains(uslov.Substring(1, uslov.Length - 2))
// || u.TipAutomobila.ModelAutomobila.OpisTabela.Opis.Contains(uslov.Substring(1, uslov.Length - 2))
// || u.TipAutomobila.OpisTabela.Opis.Contains(uslov.Substring(1, uslov.Length - 2))
// select u;
_upit = from u in _upit
where (
u.TipAutomobila.ModelAutomobila.Proizvodjac.Naziv
+ u.TipAutomobila.ModelAutomobila.OpisTabela.Opis
+ u.TipAutomobila.OpisTabela.Opis
).Contains(uslov.Substring(1, uslov.Length - 2))
select u;
}
else if (uslov.StartsWith("*"))
{
//_upit = from u in _upit
// where
// u.TipAutomobila.ModelAutomobila.Proizvodjac.Naziv.EndsWith(uslov.Substring(1, uslov.Length - 1))
// || u.TipAutomobila.ModelAutomobila.OpisTabela.Opis.EndsWith(uslov.Substring(1, uslov.Length - 1))
// || u.TipAutomobila.OpisTabela.Opis.EndsWith(uslov.Substring(1, uslov.Length - 1))
// select u;
_upit = from u in _upit
where (
u.TipAutomobila.ModelAutomobila.Proizvodjac.Naziv
+ u.TipAutomobila.ModelAutomobila.OpisTabela.Opis
+ u.TipAutomobila.OpisTabela.Opis
).EndsWith(uslov.Substring(1, uslov.Length - 1))
select u;
}
else if (uslov.EndsWith("*"))
{
//_upit = from u in _upit
// where
// u.TipAutomobila.ModelAutomobila.Proizvodjac.Naziv.StartsWith(uslov.Substring(0, uslov.Length - 1))
// || u.TipAutomobila.ModelAutomobila.OpisTabela.Opis.StartsWith(uslov.Substring(0, uslov.Length - 1))
// || u.TipAutomobila.OpisTabela.Opis.StartsWith(uslov.Substring(0, uslov.Length - 1))
// select u;
_upit = from u in _upit
where (
u.TipAutomobila.ModelAutomobila.Proizvodjac.Naziv
+ u.TipAutomobila.ModelAutomobila.OpisTabela.Opis
+ u.TipAutomobila.OpisTabela.Opis
).StartsWith(uslov.Substring(0, uslov.Length - 1))
select u;
}
else
{
//_upit = from u in _upit
// where
// u.TipAutomobila.ModelAutomobila.Proizvodjac.Naziv.Equals(uslov)
// || u.TipAutomobila.ModelAutomobila.OpisTabela.Opis.Equals(uslov)
// || u.TipAutomobila.OpisTabela.Opis.Equals(uslov)
// select u;
_upit = from u in _upit
where (
u.TipAutomobila.ModelAutomobila.Proizvodjac.Naziv
+ u.TipAutomobila.ModelAutomobila.OpisTabela.Opis
+ u.TipAutomobila.OpisTabela.Opis
).Equals(uslov)
select u;
}
break;
case "Broj šasije":
if (uslov.StartsWith("*") && uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.BrojSasije.Contains(uslov.Substring(1, uslov.Length - 2))
select u;
}
else if (uslov.StartsWith("*"))
{
_upit = from u in _upit
where u.BrojSasije.EndsWith(uslov.Substring(1, uslov.Length - 1))
select u;
}
else if (uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.BrojSasije.StartsWith(uslov.Substring(0, uslov.Length - 1))
select u;
}
else
{
_upit = from u in _upit
where u.BrojSasije.Equals(uslov)
select u;
}
break;
case "Broj motora":
if (uslov.StartsWith("*") && uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.BrojMotora.Contains(uslov.Substring(1, uslov.Length - 2))
select u;
}
else if (uslov.StartsWith("*"))
{
_upit = from u in _upit
where u.BrojMotora.EndsWith(uslov.Substring(1, uslov.Length - 1))
select u;
}
else if (uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.BrojMotora.StartsWith(uslov.Substring(0, uslov.Length - 1))
select u;
}
else
{
_upit = from u in _upit
where u.BrojMotora.Equals(uslov)
select u;
}
break;
case "Godište":
if (uslov.StartsWith("*") && uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.Godiste.ToString().Contains(uslov.Substring(1, uslov.Length - 2))
select u;
}
else if (uslov.StartsWith("*"))
{
_upit = from u in _upit
where u.Godiste.ToString().EndsWith(uslov.Substring(1, uslov.Length - 1))
select u;
}
else if (uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.Godiste.ToString().StartsWith(uslov.Substring(0, uslov.Length - 1))
select u;
}
else
{
_upit = from u in _upit
where u.Godiste.ToString().Equals(uslov)
select u;
}
break;
case "Kilometraža":
if (uslov.StartsWith("*") && uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.Kilometraza.ToString().Contains(uslov.Substring(1, uslov.Length - 2))
select u;
}
else if (uslov.StartsWith("*"))
{
_upit = from u in _upit
where u.Kilometraza.ToString().EndsWith(uslov.Substring(1, uslov.Length - 1))
select u;
}
else if (uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.Kilometraza.ToString().StartsWith(uslov.Substring(0, uslov.Length - 1))
select u;
}
else
{
_upit = from u in _upit
where u.Kilometraza.ToString().Equals(uslov)
select u;
}
break;
case "Registarski broj":
if (uslov.StartsWith("*") && uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.RegistarskiBroj.Contains(uslov.Substring(1, uslov.Length - 2))
select u;
}
else if (uslov.StartsWith("*"))
{
_upit = from u in _upit
where u.RegistarskiBroj.EndsWith(uslov.Substring(1, uslov.Length - 1))
select u;
}
else if (uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.RegistarskiBroj.StartsWith(uslov.Substring(0, uslov.Length - 1))
select u;
}
else
{
_upit = from u in _upit
where u.RegistarskiBroj.Equals(uslov)
select u;
}
break;
case "Dimenzija guma":
if (uslov.StartsWith("*") && uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.DimenzijaGuma.Contains(uslov.Substring(1, uslov.Length - 2))
select u;
}
else if (uslov.StartsWith("*"))
{
_upit = from u in _upit
where u.DimenzijaGuma.EndsWith(uslov.Substring(1, uslov.Length - 1))
select u;
}
else if (uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.DimenzijaGuma.StartsWith(uslov.Substring(0, uslov.Length - 1))
select u;
}
else
{
_upit = from u in _upit
where u.DimenzijaGuma.Equals(uslov)
select u;
}
break;
case "Napomena":
if (uslov.StartsWith("*") && uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.Napomena.Contains(uslov.Substring(1, uslov.Length - 2))
select u;
}
else if (uslov.StartsWith("*"))
{
_upit = from u in _upit
where u.Napomena.EndsWith(uslov.Substring(1, uslov.Length - 1))
select u;
}
else if (uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.Napomena.StartsWith(uslov.Substring(0, uslov.Length - 1))
select u;
}
else
{
_upit = from u in _upit
where u.Napomena.Equals(uslov)
select u;
}
break;
default:
throw new Exception("Nepoznata kolona.");
}
ObservableCollection<ServisnaKnjizica> _lista = new ObservableCollection<ServisnaKnjizica>(_upit.ToList());
return _lista;
}
else
{
throw new Exception("Baza ne postoji.");
}
}
catch (Exception ex)
{
throw ex;
}
}
public ObservableCollection<ServisnaKnjizica> OsveziServisnaKnjizica(ObservableCollection<ServisnaKnjizica> servisnaKnjizica)
{
try
{
LavDataClassesDataContext _baza = new LavDataClassesDataContext(konekcioniString);
List<int> _trenutnoPrikazani = new List<int>();
foreach (ServisnaKnjizica item in servisnaKnjizica)
{
_trenutnoPrikazani.Add(item.ServisnaKnjizicaID);
}
if (_baza.DatabaseExists())
{
IQueryable<ServisnaKnjizica> _upit = (from p in _baza.ServisnaKnjizicas
where _trenutnoPrikazani.Contains(p.ServisnaKnjizicaID)
select p).OrderBy(w => w.ServisnaKnjizicaID);
ObservableCollection<ServisnaKnjizica> _lista = new ObservableCollection<ServisnaKnjizica>(_upit.ToList());
return _lista;
}
else
{
throw new Exception("Baza ne postoji.");
}
}
catch (Exception ex)
{
throw ex;
}
}
public ObservableCollection<Radnik> NadjiRadnike(string imeKolone, string uslov)
{
try
{
LavDataClassesDataContext _baza = new LavDataClassesDataContext(konekcioniString);
if (_baza.DatabaseExists())
{
IQueryable<Radnik> _upit = (from p in _baza.Radniks
select p).OrderBy(w => w.RadnikID);
switch (imeKolone)
{
case "ID":
if (uslov.StartsWith("*") && uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.RadnikID.ToString().Contains(uslov.Substring(1, uslov.Length - 2))
select u;
}
else if (uslov.StartsWith("*"))
{
_upit = from u in _upit
where u.RadnikID.ToString().EndsWith(uslov.Substring(1, uslov.Length - 1))
select u;
}
else if (uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.RadnikID.ToString().StartsWith(uslov.Substring(0, uslov.Length - 1))
select u;
}
else
{
_upit = from u in _upit
where u.RadnikID.ToString().Equals(uslov)
select u;
}
break;
case "Šifra":
if (uslov.StartsWith("*") && uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.Sifra.Contains(uslov.Substring(1, uslov.Length - 2))
select u;
}
else if (uslov.StartsWith("*"))
{
_upit = from u in _upit
where u.Sifra.EndsWith(uslov.Substring(1, uslov.Length - 1))
select u;
}
else if (uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.Sifra.StartsWith(uslov.Substring(0, uslov.Length - 1))
select u;
}
else
{
_upit = from u in _upit
where u.Sifra.Equals(uslov)
select u;
}
break;
case "Ime":
if (uslov.StartsWith("*") && uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.Ime.Contains(uslov.Substring(1, uslov.Length - 2))
select u;
}
else if (uslov.StartsWith("*"))
{
_upit = from u in _upit
where u.Ime.EndsWith(uslov.Substring(1, uslov.Length - 1))
select u;
}
else if (uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.Ime.StartsWith(uslov.Substring(0, uslov.Length - 1))
select u;
}
else
{
_upit = from u in _upit
where u.Ime.Equals(uslov)
select u;
}
break;
case "Prezime":
if (uslov.StartsWith("*") && uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.Prezime.ToString().Contains(uslov.Substring(1, uslov.Length - 2))
select u;
}
else if (uslov.StartsWith("*"))
{
_upit = from u in _upit
where u.Prezime.ToString().EndsWith(uslov.Substring(1, uslov.Length - 1))
select u;
}
else if (uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.Prezime.ToString().StartsWith(uslov.Substring(0, uslov.Length - 1))
select u;
}
else
{
_upit = from u in _upit
where u.Prezime.ToString().Equals(uslov)
select u;
}
break;
case "Ime oca":
if (uslov.StartsWith("*") && uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.ImeOca.Contains(uslov.Substring(1, uslov.Length - 2))
select u;
}
else if (uslov.StartsWith("*"))
{
_upit = from u in _upit
where u.ImeOca.EndsWith(uslov.Substring(1, uslov.Length - 1))
select u;
}
else if (uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.ImeOca.StartsWith(uslov.Substring(0, uslov.Length - 1))
select u;
}
else
{
_upit = from u in _upit
where u.ImeOca.Equals(uslov)
select u;
}
break;
case "Nadimak":
if (uslov.StartsWith("*") && uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.Nadimak.Contains(uslov.Substring(1, uslov.Length - 2))
select u;
}
else if (uslov.StartsWith("*"))
{
_upit = from u in _upit
where u.Nadimak.EndsWith(uslov.Substring(1, uslov.Length - 1))
select u;
}
else if (uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.Nadimak.StartsWith(uslov.Substring(0, uslov.Length - 1))
select u;
}
else
{
_upit = from u in _upit
where u.Nadimak.Equals(uslov)
select u;
}
break;
case "JMBG":
if (uslov.StartsWith("*") && uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.JMBG.ToString().Contains(uslov.Substring(1, uslov.Length - 2))
select u;
}
else if (uslov.StartsWith("*"))
{
_upit = from u in _upit
where u.JMBG.ToString().EndsWith(uslov.Substring(1, uslov.Length - 1))
select u;
}
else if (uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.JMBG.ToString().StartsWith(uslov.Substring(0, uslov.Length - 1))
select u;
}
else
{
_upit = from u in _upit
where u.JMBG.ToString().Equals(uslov)
select u;
}
break;
//case "Datum rođenja":
// if (uslov.StartsWith("*") && uslov.EndsWith("*"))
// {
// _upit = from u in _upit
// where u.DatumRodjenja.ToString().Contains(uslov.Substring(1, uslov.Length - 2))
// select u;
// }
// else if (uslov.StartsWith("*"))
// {
// _upit = from u in _upit
// where u.DatumRodjenja.ToString().EndsWith(uslov.Substring(1, uslov.Length - 1))
// select u;
// }
// else if (uslov.EndsWith("*"))
// {
// _upit = from u in _upit
// where u.DatumRodjenja.ToString().StartsWith(uslov.Substring(0, uslov.Length - 1))
// select u;
// }
// else
// {
// _upit = from u in _upit
// where u.DatumRodjenja.ToString().Equals(uslov)
// select u;
// }
// break;
case "Mesto":
if (uslov.StartsWith("*") && uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.Mesto.Naziv.Contains(uslov.Substring(1, uslov.Length - 2))
select u;
}
else if (uslov.StartsWith("*"))
{
_upit = from u in _upit
where u.Mesto.Naziv.EndsWith(uslov.Substring(1, uslov.Length - 1))
select u;
}
else if (uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.Mesto.Naziv.StartsWith(uslov.Substring(0, uslov.Length - 1))
select u;
}
else
{
_upit = from u in _upit
where u.Mesto.Naziv.Equals(uslov)
select u;
}
break;
case "Adresa":
if (uslov.StartsWith("*") && uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.Adresa.Contains(uslov.Substring(1, uslov.Length - 2))
select u;
}
else if (uslov.StartsWith("*"))
{
_upit = from u in _upit
where u.Adresa.EndsWith(uslov.Substring(1, uslov.Length - 1))
select u;
}
else if (uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.Adresa.StartsWith(uslov.Substring(0, uslov.Length - 1))
select u;
}
else
{
_upit = from u in _upit
where u.Adresa.Equals(uslov)
select u;
}
break;
case "Telefon":
if (uslov.StartsWith("*") && uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.Telefon.Contains(uslov.Substring(1, uslov.Length - 2))
select u;
}
else if (uslov.StartsWith("*"))
{
_upit = from u in _upit
where u.Telefon.EndsWith(uslov.Substring(1, uslov.Length - 1))
select u;
}
else if (uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.Telefon.StartsWith(uslov.Substring(0, uslov.Length - 1))
select u;
}
else
{
_upit = from u in _upit
where u.Telefon.Equals(uslov)
select u;
}
break;
//case "Zaposlen Od":
// if (uslov.StartsWith("*") && uslov.EndsWith("*"))
// {
// _upit = from u in _upit
// where u.ZaposlenOd.ToString().Contains(uslov.Substring(1, uslov.Length - 2))
// select u;
// }
// else if (uslov.StartsWith("*"))
// {
// _upit = from u in _upit
// where u.ZaposlenOd.ToString().EndsWith(uslov.Substring(1, uslov.Length - 1))
// select u;
// }
// else if (uslov.EndsWith("*"))
// {
// _upit = from u in _upit
// where u.ZaposlenOd.ToString().StartsWith(uslov.Substring(0, uslov.Length - 1))
// select u;
// }
// else
// {
// _upit = from u in _upit
// where u.ZaposlenOd.ToString().Equals(uslov)
// select u;
// }
// break;
case "Raspored":
if (uslov.StartsWith("*") && uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.Raspored.Contains(uslov.Substring(1, uslov.Length - 2))
select u;
}
else if (uslov.StartsWith("*"))
{
_upit = from u in _upit
where u.Raspored.EndsWith(uslov.Substring(1, uslov.Length - 1))
select u;
}
else if (uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.Raspored.StartsWith(uslov.Substring(0, uslov.Length - 1))
select u;
}
else
{
_upit = from u in _upit
where u.Raspored.Equals(uslov)
select u;
}
break;
default:
throw new Exception("Nepoznata kolona.");
}
ObservableCollection<Radnik> _lista = new ObservableCollection<Radnik>(_upit.ToList());
return _lista;
}
else
{
throw new Exception("Baza ne postoji.");
}
}
catch (Exception ex)
{
throw ex;
}
}
public ObservableCollection<ServisnaKnjizica> DajSveServisnaKnjizica(string vrstaPartnera)
{
try
{
LavDataClassesDataContext _baza = new LavDataClassesDataContext(konekcioniString);
if (_baza.DatabaseExists())
{
IQueryable<ServisnaKnjizica> _upit = (from p in _baza.ServisnaKnjizicas
select p).OrderBy(w => w.ServisnaKnjizicaID);
switch (vrstaPartnera)
{
case "PoslovniPartner":
_upit = from u in _upit
where u.PoslovniPartnerID != null
select u;
break;
case "FizickoLice":
_upit = from u in _upit
where u.FizickoLiceID != null
select u;
break;
default:
throw new Exception("Nepoznata vrsta partnera.");
}
ObservableCollection<ServisnaKnjizica> _lista = new ObservableCollection<ServisnaKnjizica>(_upit.ToList());
return _lista;
}
else
{
throw new Exception("Baza ne postoji.");
}
}
catch (Exception ex)
{
throw ex;
}
}
public TipAutomobila DajTipAutomobila(int tipAutomobilaID)
{
try
{
LavDataClassesDataContext _baza = new LavDataClassesDataContext(konekcioniString);
if (_baza.DatabaseExists())
{
IQueryable<TipAutomobila> _upit = (from p in _baza.TipAutomobilas
where p.TipAutomobila_ID == tipAutomobilaID
select p).OrderBy(w => w.OpisTabela.Opis).Take(1);
return _upit.ToList().First();
}
else
{
throw new Exception("Baza ne postoji.");
}
}
catch (Exception ex)
{
throw ex;
}
}
public ObservableCollection<TipAutomobila> DajTipAutomobilaZaModel(int modelAutomobilaID)
{
try
{
LavDataClassesDataContext _baza = new LavDataClassesDataContext(konekcioniString);
if (_baza.DatabaseExists())
{
IQueryable<TipAutomobila> _upit = (from p in _baza.TipAutomobilas
where p.ModelAutomobila_ID == modelAutomobilaID
select p).OrderBy(w => w.OpisTabela.Opis);
ObservableCollection<TipAutomobila> _lista = new ObservableCollection<TipAutomobila>(_upit.ToList());
return _lista;
}
else
{
throw new Exception("Baza ne postoji.");
}
}
catch (Exception ex)
{
throw ex;
}
}
public ObservableCollection<ModelAutomobila> DajModelAutomobilaZaProizvodjac(int proizvodjacID)
{
try
{
LavDataClassesDataContext _baza = new LavDataClassesDataContext(konekcioniString);
if (_baza.DatabaseExists())
{
IQueryable<ModelAutomobila> _upit = (from p in _baza.ModelAutomobilas
join t in _baza.TipAutomobilas
on p.ModelAutomobila_ID equals t.ModelAutomobila_ID
where p.Proizvodjac_ID == proizvodjacID
select p).Distinct().OrderBy(w => w.OpisTabela.Opis);
ObservableCollection<ModelAutomobila> _lista = new ObservableCollection<ModelAutomobila>(_upit.ToList());
return _lista;
}
else
{
throw new Exception("Baza ne postoji.");
}
}
catch (Exception ex)
{
throw ex;
}
}
public ObservableCollection<ServisnaKnjizica> NadjiServisnuKnjizicu(int servisnaKnjizicaID)
{
try
{
LavDataClassesDataContext _baza = new LavDataClassesDataContext(konekcioniString);
if (_baza.DatabaseExists())
{
IQueryable<ServisnaKnjizica> _upit = (from p in _baza.ServisnaKnjizicas
where p.ServisnaKnjizicaID == servisnaKnjizicaID
select p).OrderBy(w => w.ServisnaKnjizicaID);
ObservableCollection<ServisnaKnjizica> _lista = new ObservableCollection<ServisnaKnjizica>(_upit.ToList());
return _lista;
}
else
{
throw new Exception("Baza ne postoji.");
}
}
catch (Exception ex)
{
throw ex;
}
}
public ObservableCollection<Proizvodjac> DajPadajucuListuProizvodjacRobeRoban()
{
try
{
LavDataClassesDataContext _baza = new LavDataClassesDataContext(konekcioniString);
if (_baza.DatabaseExists())
{
IQueryable<Proizvodjac> _upit = (from a in _baza.Artikals
join b in _baza.Proizvodjacs
on a.Proizvodjac_ID equals b.Proizvodjac_ID
where a.IzvorPodatakaID == 2 || a.IzvorPodatakaID == 3
select b).Distinct().OrderBy(o => o.Naziv);
ObservableCollection<Proizvodjac> _lista = new ObservableCollection<Proizvodjac>(_upit.ToList());
return _lista;
}
else
{
throw new Exception("Baza ne postoji.");
}
}
catch (Exception ex)
{
throw ex;
}
}
public ObservableCollection<VezaArtikalBrojZaPretragu> DajBrojeveZaArtikal(int artikalID)
{
try
{
LavDataClassesDataContext _baza = new LavDataClassesDataContext(konekcioniString);
if (_baza.DatabaseExists())
{
IQueryable<VezaArtikalBrojZaPretragu> _upit = (from a in _baza.VezaArtikalBrojZaPretragus
where a.Artikal_ID == artikalID
select a).Distinct().OrderBy(w => w.VrstaBrojaZaPretragu_ID);
ObservableCollection<VezaArtikalBrojZaPretragu> _lista = new ObservableCollection<VezaArtikalBrojZaPretragu>(_upit.ToList());
return _lista;
}
else
{
throw new Exception("Baza ne postoji.");
}
}
catch (Exception ex)
{
throw ex;
}
}
public ObservableCollection<Artikal> NadjiArtikal(string brojProizvodjaca, string proizvodjacNaziv)
{
try
{
LavDataClassesDataContext _baza = new LavDataClassesDataContext(konekcioniString);
if (_baza.DatabaseExists())
{
ObservableCollection<Artikal> _lista = new ObservableCollection<Artikal>(_baza.uspNadjiArtikal_1(brojProizvodjaca, proizvodjacNaziv).ToList());
return _lista;
}
else
{
throw new Exception("Baza ne postoji.");
}
}
catch (Exception ex)
{
throw ex;
}
}
public ObservableCollection<Ponuda> NadjiPonude(string vrstaPartnera, string ponudaID, DateTime? datumOd, DateTime? datumDo, string partner, bool? neZavrsene, int? radnikID)
{
try
{
LavDataClassesDataContext _baza = new LavDataClassesDataContext(konekcioniString);
if (_baza.DatabaseExists())
{
IQueryable<Ponuda> _upit = (from p in _baza.Ponudas
where p.Status.ToString() != "D"
select p).OrderBy(w => w.PonudaID);
if (vrstaPartnera != "")
{
if (vrstaPartnera == "Poslovni partner")
{
_upit = from u in _upit
where u.ServisnaKnjizica.PoslovniPartnerID != null
select u;
}
else if (vrstaPartnera == "Fizičko lice")
{
_upit = from u in _upit
where u.ServisnaKnjizica.FizickoLiceID != null
select u;
}
}
if (ponudaID != "")
{
if (ponudaID.StartsWith("*") && ponudaID.EndsWith("*"))
{
_upit = from u in _upit
where u.PonudaID.ToString().Contains(ponudaID.Substring(1, ponudaID.Length - 2))
select u;
}
else if (ponudaID.StartsWith("*"))
{
_upit = from u in _upit
where u.PonudaID.ToString().EndsWith(ponudaID.Substring(1, ponudaID.Length - 1))
select u;
}
else if (ponudaID.EndsWith("*"))
{
_upit = from u in _upit
where u.PonudaID.ToString().StartsWith(ponudaID.Substring(0, ponudaID.Length - 1))
select u;
}
else
{
_upit = from u in _upit
where u.PonudaID.ToString().Equals(ponudaID)
select u;
}
}
if (datumOd != null || datumDo != null)
{
if (datumOd != null && datumDo == null)
{
_upit = from u in _upit
where u.Vreme >= datumOd
select u;
}
else if (datumOd == null && datumDo != null)
{
_upit = from u in _upit
where u.Vreme <= datumDo
select u;
}
else if (datumOd != null && datumDo != null)
{
_upit = from u in _upit
where u.Vreme >= datumOd && u.Vreme <= datumDo
select u;
}
}
if (partner != "")
{
if (partner.StartsWith("*") && partner.EndsWith("*"))
{
_upit = from u in _upit
where u.ServisnaKnjizica.PoslovniPartner.SkracenNaziv.Contains(partner.Substring(1, partner.Length - 2)) ||
u.ServisnaKnjizica.FizickoLice.Ime.Contains(partner.Substring(1, partner.Length - 2))
select u;
}
else if (partner.StartsWith("*"))
{
_upit = from u in _upit
where u.ServisnaKnjizica.PoslovniPartner.SkracenNaziv.EndsWith(partner.Substring(1, partner.Length - 1)) ||
u.ServisnaKnjizica.FizickoLice.Ime.EndsWith(partner.Substring(1, partner.Length - 1))
select u;
}
else if (partner.EndsWith("*"))
{
_upit = from u in _upit
where u.ServisnaKnjizica.PoslovniPartner.SkracenNaziv.StartsWith(partner.Substring(0, partner.Length - 1)) ||
u.ServisnaKnjizica.FizickoLice.Ime.StartsWith(partner.Substring(0, partner.Length - 1))
select u;
}
else
{
_upit = from u in _upit
where u.ServisnaKnjizica.PoslovniPartner.SkracenNaziv.Equals(partner) ||
u.ServisnaKnjizica.FizickoLice.Ime.Equals(partner)
select u;
}
}
if (neZavrsene != null && (bool)neZavrsene)
{
_upit = from u in _upit
where(u.StavkaUslugas.Where(f => f.Status != 'D').Count().Equals(0)) ||
(u.PreuzimaLicno && u.PreuzeoLicnoU == null) ||
(u.ObavestiTelefonom && u.ObavestenTelefonomU == null) ||
(u.PosaljiEMail && u.PoslatEMailU == null) ||
(u.PosaljiSMSObavestenje && u.PoslatoSMSObavestenjeU == null)
select u;
}
if (radnikID != null)
{
_upit = from u in _upit
where u.RadnikID == radnikID
select u;
}
ObservableCollection<Ponuda> _lista = new ObservableCollection<Ponuda>(_upit.Distinct().ToList());
return _lista;
}
else
{
throw new Exception("Baza ne postoji.");
}
}
catch (Exception ex)
{
throw ex;
}
}
public ObservableCollection<Artikal> NadjiAkumulatorRoban(int? proizvodjacID, int? amperaza)
{
try
{
LavDataClassesDataContext _baza = new LavDataClassesDataContext(konekcioniString);
if (_baza.DatabaseExists())
{
ObservableCollection<Artikal> _artikli = new ObservableCollection<Artikal>(_baza.uspNadjiAkumulator(proizvodjacID, amperaza).ToList());
return _artikli;
}
else
{
throw new Exception("Baza ne postoji.");
}
}
catch (Exception ex)
{
throw ex;
}
}
public ObservableCollection<RadniNalog> DajSveRadneNalogeZaPartnera(int partnerID, string vrstaPartnera)
{
try
{
LavDataClassesDataContext _baza = new LavDataClassesDataContext(konekcioniString);
if (_baza.DatabaseExists())
{
IQueryable<RadniNalog> _upit = (from p in _baza.RadniNalogs
where p.Status.ToString() != "D"
select p).OrderBy(w => w.RadniNalogID);
switch (vrstaPartnera)
{
case "PoslovniPartner":
_upit = from u in _upit
where u.ServisnaKnjizica.PoslovniPartnerID == partnerID
select u;
break;
case "FizickoLice":
_upit = from u in _upit
where u.ServisnaKnjizica.FizickoLiceID == partnerID
select u;
break;
default:
throw new Exception("Nepoznata vrsta partnera.");
}
ObservableCollection<RadniNalog> _lista = new ObservableCollection<RadniNalog>(_upit.ToList());
return _lista;
}
else
{
throw new Exception("Baza ne postoji.");
}
}
catch (Exception ex)
{
throw ex;
}
}
public ObservableCollection<Artikal> NadjiRobuRoban(Int16? proizvodjacID, string sifra, string naziv)
{
try
{
LavDataClassesDataContext _baza = new LavDataClassesDataContext(konekcioniString);
if (_baza.DatabaseExists())
{
ObservableCollection<Artikal> _artikli = new ObservableCollection<Artikal>(_baza.uspNadjiRobu(proizvodjacID, sifra, naziv).ToList());
return _artikli;
}
else
{
throw new Exception("Baza ne postoji.");
}
}
catch (Exception ex)
{
throw ex;
}
}
public ObservableCollection<PoslovniPartner> OsveziPoslovniPartner(ObservableCollection<PoslovniPartner> poslovniPartner)
{
try
{
LavDataClassesDataContext _baza = new LavDataClassesDataContext(konekcioniString);
DataLoadOptions _dlo = new DataLoadOptions();
_dlo.LoadWith<PoslovniPartner>(p => p.Mesto);
_dlo.LoadWith<PoslovniPartner>(p => p.NacinOrganizacijeFirme);
_baza.LoadOptions = _dlo;
List<int> _trenutnoPrikazani = new List<int>();
foreach (PoslovniPartner item in poslovniPartner)
{
_trenutnoPrikazani.Add(item.PoslovniPartnerID);
}
if (_baza.DatabaseExists())
{
IQueryable<PoslovniPartner> _upit = (from p in _baza.PoslovniPartners
where _trenutnoPrikazani.Contains(p.PoslovniPartnerID)
select p).OrderBy(w => w.PoslovniPartnerID);
ObservableCollection<PoslovniPartner> _lista = new ObservableCollection<PoslovniPartner>(_upit.ToList());
return _lista;
}
else
{
throw new Exception("Baza ne postoji.");
}
}
catch (Exception ex)
{
throw ex;
}
}
public Radnik DajRadnika(string korisnickiNalog, string lozinka)
{
try
{
LavDataClassesDataContext _baza = new LavDataClassesDataContext(konekcioniString);
if (_baza.DatabaseExists())
{
IQueryable<Radnik> _upit = (from p in _baza.Radniks
join k in _baza.VezaRadnikKorisnickiNalogs
on p.RadnikID equals k.RadnikID
where k.KorisnickiNalog == korisnickiNalog &&
k.Lozinka == lozinka
select p).Take(1);
ObservableCollection<Radnik> _lista = new ObservableCollection<Radnik>(_upit.ToList());
if (_lista.Count.Equals(1))
{
return _lista.First();
}
else
{
return null;
}
}
else
{
throw new Exception("Baza ne postoji.");
}
}
catch (Exception ex)
{
throw ex;
}
}
public ObservableCollection<RadniNalog> OsveziRadniNalog(ObservableCollection<RadniNalog> radniNalog)
{
try
{
LavDataClassesDataContext _baza = new LavDataClassesDataContext(konekcioniString);
List<int> _trenutnoPrikazani = new List<int>();
foreach (RadniNalog item in radniNalog)
{
_trenutnoPrikazani.Add(item.RadniNalogID);
}
if (_baza.DatabaseExists())
{
IQueryable<RadniNalog> _upit = (from p in _baza.RadniNalogs
where _trenutnoPrikazani.Contains(p.RadniNalogID) &&
p.Status.ToString() != "D"
select p).OrderBy(w => w.RadniNalogID);
ObservableCollection<RadniNalog> _lista = new ObservableCollection<RadniNalog>(_upit.ToList());
return _lista;
}
else
{
throw new Exception("Baza ne postoji.");
}
}
catch (Exception ex)
{
throw ex;
}
}
public ObservableCollection<RadniNalog> DajSveRadneNalogeZaServisnuKnjizicu(int servisnaKnjizicaID)
{
try
{
LavDataClassesDataContext _baza = new LavDataClassesDataContext(konekcioniString);
if (_baza.DatabaseExists())
{
IQueryable<RadniNalog> _upit = (from p in _baza.RadniNalogs
where p.Status.ToString() != "D" &&
p.ServisnaKnjizicaID == servisnaKnjizicaID
select p).OrderBy(w => w.RadniNalogID);
ObservableCollection<RadniNalog> _lista = new ObservableCollection<RadniNalog>(_upit.ToList());
return _lista;
}
else
{
throw new Exception("Baza ne postoji.");
}
}
catch (Exception ex)
{
throw ex;
}
}
public ObservableCollection<PoslovniPartner> NadjiPoslovniPartner(string imeKolone, string uslov)
{
try
{
LavDataClassesDataContext _baza = new LavDataClassesDataContext(konekcioniString);
DataLoadOptions _dlo = new DataLoadOptions();
_dlo.LoadWith<PoslovniPartner>(p => p.Mesto);
_dlo.LoadWith<PoslovniPartner>(p => p.NacinOrganizacijeFirme);
_baza.LoadOptions = _dlo;
if (_baza.DatabaseExists())
{
IQueryable<PoslovniPartner> _upit = (from p in _baza.PoslovniPartners
select p).OrderBy(w => w.PoslovniPartnerID);
switch (imeKolone)
{
case "ID":
if (uslov.StartsWith("*") && uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.PoslovniPartnerID.ToString().Contains(uslov.Substring(1, uslov.Length - 2))
select u;
}
else if (uslov.StartsWith("*"))
{
_upit = from u in _upit
where u.PoslovniPartnerID.ToString().EndsWith(uslov.Substring(1, uslov.Length - 1))
select u;
}
else if (uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.PoslovniPartnerID.ToString().StartsWith(uslov.Substring(0, uslov.Length - 1))
select u;
}
else
{
_upit = from u in _upit
where u.PoslovniPartnerID.ToString().Equals(uslov)
select u;
}
break;
case "Šifra":
if (uslov.StartsWith("*") && uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.Sifra.Contains(uslov.Substring(1, uslov.Length - 2))
select u;
}
else if (uslov.StartsWith("*"))
{
_upit = from u in _upit
where u.Sifra.EndsWith(uslov.Substring(1, uslov.Length - 1))
select u;
}
else if (uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.Sifra.StartsWith(uslov.Substring(0, uslov.Length - 1))
select u;
}
else
{
_upit = from u in _upit
where u.Sifra.Equals(uslov)
select u;
}
break;
case "Skraćen naziv":
if (uslov.StartsWith("*") && uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.SkracenNaziv.Contains(uslov.Substring(1, uslov.Length - 2))
select u;
}
else if (uslov.StartsWith("*"))
{
_upit = from u in _upit
where u.SkracenNaziv.EndsWith(uslov.Substring(1, uslov.Length - 1))
select u;
}
else if (uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.SkracenNaziv.StartsWith(uslov.Substring(0, uslov.Length - 1))
select u;
}
else
{
_upit = from u in _upit
where u.SkracenNaziv.Equals(uslov)
select u;
}
break;
case "Pun naziv":
if (uslov.StartsWith("*") && uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.PunNaziv.Contains(uslov.Substring(1, uslov.Length - 2))
select u;
}
else if (uslov.StartsWith("*"))
{
_upit = from u in _upit
where u.PunNaziv.EndsWith(uslov.Substring(1, uslov.Length - 1))
select u;
}
else if (uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.PunNaziv.StartsWith(uslov.Substring(0, uslov.Length - 1))
select u;
}
else
{
_upit = from u in _upit
where u.PunNaziv.Equals(uslov)
select u;
}
break;
case "Način organizacije firme":
if (uslov.StartsWith("*") && uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.NacinOrganizacijeFirme.Naziv.Contains(uslov.Substring(1, uslov.Length - 2))
select u;
}
else if (uslov.StartsWith("*"))
{
_upit = from u in _upit
where u.NacinOrganizacijeFirme.Naziv.EndsWith(uslov.Substring(1, uslov.Length - 1))
select u;
}
else if (uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.NacinOrganizacijeFirme.Naziv.StartsWith(uslov.Substring(0, uslov.Length - 1))
select u;
}
else
{
_upit = from u in _upit
where u.NacinOrganizacijeFirme.Naziv.Equals(uslov)
select u;
}
break;
case "PIB":
if (uslov.StartsWith("*") && uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.PIB.ToString().Contains(uslov.Substring(1, uslov.Length - 2))
select u;
}
else if (uslov.StartsWith("*"))
{
_upit = from u in _upit
where u.PIB.ToString().EndsWith(uslov.Substring(1, uslov.Length - 1))
select u;
}
else if (uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.PIB.ToString().StartsWith(uslov.Substring(0, uslov.Length - 1))
select u;
}
else
{
_upit = from u in _upit
where u.PIB.ToString().Equals(uslov)
select u;
}
break;
case "Matični broj":
if (uslov.StartsWith("*") && uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.MaticniBroj.ToString().Contains(uslov.Substring(1, uslov.Length - 2))
select u;
}
else if (uslov.StartsWith("*"))
{
_upit = from u in _upit
where u.MaticniBroj.ToString().EndsWith(uslov.Substring(1, uslov.Length - 1))
select u;
}
else if (uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.MaticniBroj.ToString().StartsWith(uslov.Substring(0, uslov.Length - 1))
select u;
}
else
{
_upit = from u in _upit
where u.MaticniBroj.ToString().Equals(uslov)
select u;
}
break;
case "Žiro račun":
if (uslov.StartsWith("*") && uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.ZiroRacun.Contains(uslov.Substring(1, uslov.Length - 2))
select u;
}
else if (uslov.StartsWith("*"))
{
_upit = from u in _upit
where u.ZiroRacun.EndsWith(uslov.Substring(1, uslov.Length - 1))
select u;
}
else if (uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.ZiroRacun.StartsWith(uslov.Substring(0, uslov.Length - 1))
select u;
}
else
{
_upit = from u in _upit
where u.ZiroRacun.Equals(uslov)
select u;
}
break;
case "Mesto":
if (uslov.StartsWith("*") && uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.Mesto.Naziv.Contains(uslov.Substring(1, uslov.Length - 2))
select u;
}
else if (uslov.StartsWith("*"))
{
_upit = from u in _upit
where u.Mesto.Naziv.EndsWith(uslov.Substring(1, uslov.Length - 1))
select u;
}
else if (uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.Mesto.Naziv.StartsWith(uslov.Substring(0, uslov.Length - 1))
select u;
}
else
{
_upit = from u in _upit
where u.Mesto.Naziv.Equals(uslov)
select u;
}
break;
case "Adresa":
if (uslov.StartsWith("*") && uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.Adresa.Contains(uslov.Substring(1, uslov.Length - 2))
select u;
}
else if (uslov.StartsWith("*"))
{
_upit = from u in _upit
where u.Adresa.EndsWith(uslov.Substring(1, uslov.Length - 1))
select u;
}
else if (uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.Adresa.StartsWith(uslov.Substring(0, uslov.Length - 1))
select u;
}
else
{
_upit = from u in _upit
where u.Adresa.Equals(uslov)
select u;
}
break;
case "Kontakt osoba":
if (uslov.StartsWith("*") && uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.KontaktOsoba1.Contains(uslov.Substring(1, uslov.Length - 2))
|| u.KontaktOsoba2.Contains(uslov.Substring(1, uslov.Length - 2))
select u;
}
else if (uslov.StartsWith("*"))
{
_upit = from u in _upit
where u.KontaktOsoba1.EndsWith(uslov.Substring(1, uslov.Length - 1))
|| u.KontaktOsoba2.EndsWith(uslov.Substring(1, uslov.Length - 1))
select u;
}
else if (uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.KontaktOsoba1.StartsWith(uslov.Substring(0, uslov.Length - 1))
|| u.KontaktOsoba2.StartsWith(uslov.Substring(0, uslov.Length - 1))
select u;
}
else
{
_upit = from u in _upit
where u.KontaktOsoba1.Equals(uslov)
|| u.KontaktOsoba2.Equals(uslov)
select u;
}
break;
case "Telefon":
if (uslov.StartsWith("*") && uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.Telefon1.Contains(uslov.Substring(1, uslov.Length - 2))
|| u.Telefon2.Contains(uslov.Substring(1, uslov.Length - 2))
select u;
}
else if (uslov.StartsWith("*"))
{
_upit = from u in _upit
where u.Telefon1.EndsWith(uslov.Substring(1, uslov.Length - 1))
|| u.Telefon2.EndsWith(uslov.Substring(1, uslov.Length - 1))
select u;
}
else if (uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.Telefon1.StartsWith(uslov.Substring(0, uslov.Length - 1))
|| u.Telefon2.StartsWith(uslov.Substring(0, uslov.Length - 1))
select u;
}
else
{
_upit = from u in _upit
where u.Telefon1.Equals(uslov)
|| u.Telefon2.Equals(uslov)
select u;
}
break;
case "E-mail":
if (uslov.StartsWith("*") && uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.EMail1.Contains(uslov.Substring(1, uslov.Length - 2))
|| u.EMail2.Contains(uslov.Substring(1, uslov.Length - 2))
select u;
}
else if (uslov.StartsWith("*"))
{
_upit = from u in _upit
where u.EMail1.EndsWith(uslov.Substring(1, uslov.Length - 1))
|| u.EMail2.EndsWith(uslov.Substring(1, uslov.Length - 1))
select u;
}
else if (uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.EMail1.StartsWith(uslov.Substring(0, uslov.Length - 1))
|| u.EMail2.StartsWith(uslov.Substring(0, uslov.Length - 1))
select u;
}
else
{
_upit = from u in _upit
where u.EMail1.Equals(uslov)
|| u.EMail2.Equals(uslov)
select u;
}
break;
case "Faks":
if (uslov.StartsWith("*") && uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.Faks.Contains(uslov.Substring(1, uslov.Length - 2))
select u;
}
else if (uslov.StartsWith("*"))
{
_upit = from u in _upit
where u.Faks.EndsWith(uslov.Substring(1, uslov.Length - 1))
select u;
}
else if (uslov.EndsWith("*"))
{
_upit = from u in _upit
where u.Faks.StartsWith(uslov.Substring(0, uslov.Length - 1))
select u;
}
else
{
_upit = from u in _upit
where u.Faks.Equals(uslov)
select u;
}
break;
default:
throw new Exception("Nepoznata kolona.");
}
ObservableCollection<PoslovniPartner> _lista = new ObservableCollection<PoslovniPartner>(_upit.ToList());
return _lista;
}
else
{
throw new Exception("Baza ne postoji.");
}
}
catch (Exception ex)
{
throw ex;
}
}
