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