public List <Model.Kupci> Get(KupciSearchRequest request) { var query = _context.Kupci.AsQueryable(); if (!string.IsNullOrWhiteSpace(request?.Ime)) { query = query.Where(x => x.Ime.StartsWith(request.Ime)); } if (!string.IsNullOrWhiteSpace(request?.KorisnickoIme)) { query = query.Where(x => x.KorisnickoIme.Equals(request.KorisnickoIme)); } if (!string.IsNullOrWhiteSpace(request?.Prezime)) { query = query.Where(x => x.Prezime.StartsWith(request.Prezime)); } /*if (request?.IsUlogeLoadingEnabled == true) * { * query = query.Include(x => x.KupciUloge); * }*/ var list = query.ToList(); return(_mapper.Map <List <Model.Kupci> >(list)); }
public async Task Init() { KupciSearchRequest trenutni = new KupciSearchRequest(); trenutni.KorisnickoIme = APIService.Username.ToString(); //trenutni.Prezime = null; APIService.Username = baza; APIService.Password = baza; VrstaAplikacijeInsert vrstaApp = new VrstaAplikacijeInsert(); vrstaApp.DesktopStatus = 0; await _serviceVrsta.Update <dynamic>(1, vrstaApp); APIService.Username = user; APIService.Password = pass; List <Model.Kupci> tk = await _kupciService.Get <List <Model.Kupci> >(trenutni); var list = await _racuniService.Get <IEnumerable <Racuni> >(null); RacuniList.Clear(); foreach (var racuni in list) { if (racuni.KupacId == tk[0].KupacId) { RacuniList.Add(racuni); } } }
public async Task Login() { APIService.Username = baza; APIService.Password = baza; VrstaAplikacijeInsert vrstaApp = new VrstaAplikacijeInsert(); vrstaApp.DesktopStatus = 0; await _serviceVrsta.Update <dynamic>(1, vrstaApp); APIService.Username = user; APIService.Password = pass; KupciSearchRequest trenutni = new KupciSearchRequest(); trenutni.KorisnickoIme = APIService.Username.ToString(); trenutni.Prezime = null; trenutni.Ime = null; List <Model.Kupci> tk = await _service.Get <List <Model.Kupci> >(trenutni); Ime = tk[0].Ime; Prezime = tk[0].Prezime; Rodjendan = tk[0].DatumRodjenja.Date; Jmbg = tk[0].Jmbg; Email = tk[0].Mail; //Rodjendan = tk[0].DatumRodjenja; }
private async void ButtonPrikazi_Click(object sender, EventArgs e) { KupciSearchRequest search = new KupciSearchRequest() { Ime = txtPretraga.Text }; var list = await _apiService.Get <List <Model.Kupci> >(search); dgvKupci.AutoGenerateColumns = false; dgvKupci.DataSource = list; }
public List <KupciVM> Get(KupciSearchRequest request) { var query = _context.Kupci.AsQueryable(); if (!string.IsNullOrWhiteSpace(request?.Ime)) { query = query.Where(x => x.Ime.StartsWith(request.Ime) || x.Prezime.StartsWith(request.Ime)); } var list = query.ToList(); return(_mapper.Map <List <KupciVM> >(list)); }
private async void btnPrikazi_Click(object sender, EventArgs e) { var search = new KupciSearchRequest() { Ime = txtIme.Text, Prezime = txtPrezime.Text, KorisnickoIme = txtKorisnickoIme.Text }; var result = await _kupciService.Get <List <Model.Kupci> >(search); dgvKupci.AutoGenerateColumns = false; dgvKupci.DataSource = result; }
public async Task Init() { KomentariSearchRequest search = new KomentariSearchRequest(); OcjeneSearchRequest search2 = new OcjeneSearchRequest(); search.FilmID = Filmovi.FilmID; search2.FilmID = Filmovi.FilmID; var komentariList = await _komentariService.Get <List <Komentari> >(search); var ocjeneList = await _ocjeneService.Get <List <Ocjene> >(search); KomentariList.Clear(); OcjeneList.Clear(); foreach (var komentar in komentariList.ToList()) { KomentariList.Add(komentar); } foreach (var ocjena in ocjeneList.ToList()) { OcjeneList.Add(ocjena); } KupciSearchRequest searchKupaca = new KupciSearchRequest(); searchKupaca.KorisnickoIme = APIService.Username; List <Kupci> lista = await _kupciService.Get <List <Kupci> >(searchKupaca); var kupac = lista.First(); Komentar = new Komentari() { FilmID = Filmovi.FilmID, VrijemeKreiranja = DateTime.Now, KupacID = kupac.KupacID }; Ocjena = new Ocjene() { FilmID = Filmovi.FilmID, KupacID = kupac.KupacID, }; if (OcjeneList.Count > 0) { ProsjecnaOcjena = OcjeneList.Average(x => x.Ocjena); BrojGlasova = "(" + OcjeneList.Count() + ")"; } }
public async Task Sacuvaj() { KupciSearchRequest trenutni = new KupciSearchRequest(); trenutni.KorisnickoIme = APIService.Username.ToString(); trenutni.Prezime = null; APIService.Username = baza; APIService.Password = baza; VrstaAplikacijeInsert vrstaApp = new VrstaAplikacijeInsert(); vrstaApp.DesktopStatus = 0; await _serviceVrsta.Update <dynamic>(1, vrstaApp); APIService.Username = user; APIService.Password = pass; List <Model.Kupci> tk = await _kupacService.Get <List <Model.Kupci> >(trenutni); Ugovori novi = new Ugovori(); novi.BrojUgovora = "NEODOBRENI"; novi.KupacId = tk[0].KupacId; if (SelectedTarifa == null) { Application.Current.MainPage.DisplayAlert("Greška", "Tarifu niste odabrali/Opis niste unijeli", "OK"); } else { novi.TarifniStavId = SelectedTarifa.TarifniStavId; novi.DatumSklapanja = DateTime.Today; novi.OsobljeId = 1; if (!string.IsNullOrWhiteSpace(Opis)) { await _ugovoriService.Insert <Model.Ugovori>(novi); Application.Current.MainPage.DisplayAlert("Uspjesno", "Novi zahtjev podnesen", "OK"); } else { Application.Current.MainPage.DisplayAlert("Greška", "Tarifu niste odabrali/Opis niste unijeli", "OK"); } } }
private async void txtPretraga_Click(object sender, EventArgs e) { var search = new KupciSearchRequest() { Ime = txtIme.Text, Prezime = txtPrezime.Text, DatumOd = dtpOd.Value, DatumDo = dtpDo.Value }; VrstaAplikacijeInsert vrstaApp = new VrstaAplikacijeInsert(); vrstaApp.DesktopStatus = 1; APIService.Username = baza; APIService.Password = baza; await _serviceVrsta.Update <dynamic>(1, vrstaApp); APIService.Username = user; APIService.Password = pass; var list = await _apiService.Get <List <ePostrojenje.Model.Kupci> >(search); if (list.Count > 0) { prikaziPritisnut = true; } else { prikaziPritisnut = false; } ePostrojenje.Model.Kupci zadnji = new ePostrojenje.Model.Kupci() { KupacId = list.Count, Ime = "", Prezime = "", Jmbg = "Ukupno", Mail = list.Count.ToString() }; list.Add(zadnji); dgvOsoblje.AutoGenerateColumns = false; dgvOsoblje.DataSource = list; dgvOsoblje.Rows[list.Count - 1].DefaultCellStyle.BackColor = Color.FromArgb(109, 122, 224); dgvOsoblje.Rows[list.Count - 1].DefaultCellStyle.ForeColor = Color.White; }
public async Task <bool> ZauzetoKorisnickoIme() { KupciSearchRequest searchRequest = new KupciSearchRequest(); searchRequest.KorisnickoIme = txtKorisnickoIme.Text; //APIService.Username = "******"; //APIService.Password = "******"; List <Kupci> lista = await _service.Get <List <Kupci> >(searchRequest); if (lista.Count > 0) { return(true); } else { return(false); } }
public async Task <bool> ZauzetoKorisnickoIme() { KupciSearchRequest searchRequest = new KupciSearchRequest(); searchRequest.KorisnickoIme = txtKorisnickoIme.Text; List <Kupci> lista = await _apiService.Get <List <Kupci> >(searchRequest); Kupci oznaceni = await _apiService.GetById <Kupci>(int.Parse(dgvOsoblje.SelectedRows[0].Cells[0].Value.ToString())); if (lista.Count > 0 && lista[0].KorisnickoIme != oznaceni.KorisnickoIme) { return(true); } else { return(false); } }
public async Task Init() { KupciSearchRequest searchKupaca = new KupciSearchRequest(); searchKupaca.KorisnickoIme = APIService.Username; List <Kupci> lista = await _kupciService.Get <List <Kupci> >(searchKupaca); var kupac = lista.First(); UlazniceSearchRequest search = new UlazniceSearchRequest(); search.KupacID = kupac.KupacID; var list = await _ulazniceService.Get <List <Ulaznice> >(search); UlazniceList.Clear(); foreach (var ulaznica in list) { UlazniceList.Add(ulaznica); } }
public List <Model.Kupci> Get(KupciSearchRequest search) { var query = _context.Kupci.AsQueryable(); if (!string.IsNullOrWhiteSpace(search?.Ime)) { query = query.Where(x => x.Ime.ToLower().StartsWith(search.Ime) || x.Ime.ToUpper().StartsWith(search.Ime)); } if (!string.IsNullOrWhiteSpace(search?.Prezime)) { query = query.Where(x => x.Prezime.ToLower().StartsWith(search.Prezime) || x.Prezime.ToUpper().StartsWith(search.Prezime)); } if (!string.IsNullOrWhiteSpace(search?.KorisnickoIme)) { query = query.Where(x => x.KorisnickoIme.ToLower().StartsWith(search.KorisnickoIme) || x.KorisnickoIme.ToUpper().StartsWith(search.KorisnickoIme)); } var list = query.ToList(); return(_mapper.Map <List <Model.Kupci> >(list)); }
public async Task Sacuvaj() { KupciSearchRequest trenutni = new KupciSearchRequest(); trenutni.KorisnickoIme = APIService.Username.ToString(); trenutni.Prezime = null; APIService.Username = baza; APIService.Password = baza; VrstaAplikacijeInsert vrstaApp = new VrstaAplikacijeInsert(); vrstaApp.DesktopStatus = 0; await _serviceVrsta.Update <dynamic>(1, vrstaApp); APIService.Username = user; APIService.Password = pass; List <Model.Kupci> tk = await _kupacService.Get <List <Model.Kupci> >(trenutni); ReklamacijeInsertRequest novi = new ReklamacijeInsertRequest(); novi.Naslov = Naslov; novi.KupacId = tk[0].KupacId; novi.DatumOtvaranja = DateTime.Today; novi.DatumZatvaranja = DateTime.Today; novi.Status = false; novi.OsobljeId = 1; novi.Opis = Opis; if (!string.IsNullOrWhiteSpace(Naslov) && !string.IsNullOrWhiteSpace(Opis)) { await _service.Insert <Model.Reklamacije>(novi); await Application.Current.MainPage.DisplayAlert("Uspjesno", "Nova reklamacija podnesena", "OK"); } else { await Application.Current.MainPage.DisplayAlert("Greška", "Naslov/Opis niste unijeli", "OK"); } }
public List <Model.Kupci> Get(KupciSearchRequest request) { var query = _context.Kupci.AsQueryable(); if (!string.IsNullOrWhiteSpace(request?.Ime)) { query = query.Where(x => x.Ime.StartsWith(request.Ime, StringComparison.CurrentCultureIgnoreCase)); } if (!string.IsNullOrWhiteSpace(request?.Prezime)) { query = query.Where(x => x.Prezime.StartsWith(request.Prezime, StringComparison.CurrentCultureIgnoreCase)); } if (!string.IsNullOrWhiteSpace(request?.KorisnickoIme)) { query = query.Where(x => x.KorisnickoIme.StartsWith(request.KorisnickoIme, StringComparison.CurrentCultureIgnoreCase)); } var list = query.ToList(); return(_mapper.Map <List <Model.Kupci> >(list)); }
public async Task Init() { try { KupciSearchRequest searchKupaca = new KupciSearchRequest(); searchKupaca.KorisnickoIme = APIService.Username; List <Kupci> lista = await _kupciService.Get <List <Kupci> >(searchKupaca); var kupac = lista.First(); var list = await _preporukeService.GetById <List <Filmovi> >(kupac.KupacID); FilmoviList.Clear(); foreach (var item in list) { FilmoviList.Add(item); } } catch (System.Exception) { FilmoviList = new ObservableCollection <Filmovi>(); } }
public async Task Sacuvaj() { KupciSearchRequest trenutni = new KupciSearchRequest(); trenutni.KorisnickoIme = APIService.Username.ToString(); trenutni.Prezime = null; APIService.Username = baza; APIService.Password = baza; VrstaAplikacijeInsert vrstaApp = new VrstaAplikacijeInsert(); vrstaApp.DesktopStatus = 0; await _serviceVrsta.Update <dynamic>(1, vrstaApp); APIService.Username = user; APIService.Password = pass; List <Model.Kupci> tk = await _service.Get <List <Model.Kupci> >(trenutni); tk[0].Ime = Ime; tk[0].Prezime = Prezime; tk[0].Mail = Email; tk[0].Jmbg = Jmbg; tk[0].DatumRodjenja = Rodjendan.Date; if (!string.IsNullOrWhiteSpace(Ime)) { await _service.Update <Model.Kupci>(tk[0].KupacId, tk[0]); await Application.Current.MainPage.DisplayAlert("Uspjesno", "Profil azuriran", "OK"); } else { await Application.Current.MainPage.DisplayAlert("Greška", "Ime niste unijeli", "OK"); } }
public List <Model.Kupci> Get([FromQuery] KupciSearchRequest request) { return(_service.Get(request)); }
public List <KupciVM> Get([FromQuery] KupciSearchRequest request) { return(_service.Get(request));; }