private async void frmUplate_Load(object sender, EventArgs e)
{
await LoadTeretane();
var result = await _PlacanjeClanarinaService.Get <List <Model.PlacanjeClanarine> >(null);
dgvUplate.AutoGenerateColumns = false;
dgvUplate.DataSource = result;
}
private async Task Loadfrm()
{
var search = new KorisniciSearchRequest()
{
Ime = txtPretrazi.Text
};
var korisnici = await _services.Get <List <Model.Korisnici> >(search);
dgvKorisnici.AutoGenerateColumns = false;
dgvKorisnici.DataSource = korisnici;
}
private async Task Loadfrm()
{
var search = new ClanSearchRequest()
{
Ime = txtPretrazi.Text
};
var clanovi = await _clanService.Get <List <Model.Clanovi> >(search);
dgvClanovi.AutoGenerateColumns = false;
dgvClanovi.DataSource = clanovi;
}
private async Task Loadfrm(bool?odobreni = false)
{
TreningZahtjevSearchRequest odobren = new TreningZahtjevSearchRequest();
TreningDodatniSearchRequest prihvacen = new TreningDodatniSearchRequest();
if (odobreni == true)
{
odobren = new TreningZahtjevSearchRequest()
{
odobren = true
};
prihvacen = new TreningDodatniSearchRequest()
{
Prihvacen = true
};
}
var zahtjevi = await _treningZahtjevServices.Get <List <Model.TreningZahtjev> >(odobren);
var dodatni = await _treningDodatniServices.Get <List <Model.TreningDodatni> >(prihvacen);
dgvTreningZhatjev.Columns[4].DefaultCellStyle.Format = "dd.MM.yyyy";
dgvTreningZhatjev.Columns[2].DefaultCellStyle.Format = "HH:mm";
dgvTreningZhatjev.Columns[3].DefaultCellStyle.Format = "HH:mm";
for (int n = 0; n < dgvTreningZhatjev.ColumnCount - 1; n++)
{
dgvTreningZhatjev.Columns[n].ReadOnly = true;
}
dgvTreningZhatjev.AutoGenerateColumns = false;
dgvTreningZhatjev.DataSource = zahtjevi;
dgvTreningDodatni.Columns[3].DefaultCellStyle.Format = "dd.MM.yyyy";
dgvTreningDodatni.Columns[2].DefaultCellStyle.Format = "HH:mm";
dgvTreningDodatni.Columns[1].DefaultCellStyle.Format = "HH:mm";
for (int i = 0; i < dgvTreningDodatni.ColumnCount - 1; i++)
{
dgvTreningDodatni.Columns[i].ReadOnly = true;
}
dgvTreningDodatni.Columns["brojRezervacija"].ReadOnly = false;
dgvTreningDodatni.AutoGenerateColumns = false;
dgvTreningDodatni.DataSource = dodatni;
}
private async void LoadStatus()
{
k = new esp_KorisnikByID_Result();
var response = await _apiService.Get <esp_KorisnikByID_Result>(korisnikID);
if (response != null)
{
k = response;
}
txtAdresa.Text = k.Adresa;
txtIme.Text = k.Ime;
txtMail.Text = k.Mail;
txtPrezime.Text = k.Prezime;
txtTelefon.Text = k.Telefon;
cbcNaselja.SelectedValue = k.NaseljeID;
if (k.Status.Value)
{
labelAktivnost.Text = "Aktivan";
linkLabel1.Text = "Deaktiviraj korisnika";
}
else
{
labelAktivnost.Text = "Neaktivan";
linkLabel1.Text = "Aktiviraj korisnika";
}
}
private async void frmTreneri_Load(object sender, EventArgs e)
{
await Loadfrm();
var ulogeList = await _UlogeService.Get <List <Model.Uloge> >(null);
var licenceList = await _LicenceService.Get <List <Model.Licenca> >(null);
clbUloge.DataSource = ulogeList;
clbUloge.DisplayMember = "Naziv";
clbLicence.DataSource = licenceList;
clbLicence.DisplayMember = "Tip";
if (_id.HasValue)
{
var korisnik = await _services.GetById <Model.Korisnici>(_id);
txtEmail.Text = korisnik.Email;
txtIme.Text = korisnik.Ime;
txtPrezime.Text = korisnik.Prezime;
txtEmail.Text = korisnik.Email;
txtTel.Text = korisnik.Telefon;
txtKorisnickoIme.Text = korisnik.KorisnickoIme;
}
}
private async void btnNajposjecenijiTreneri_Click(object sender, EventArgs e)
{
var treninzi = await _TreningDetalji.Get <List <Model.TreningDetalji> >(null);
var clanovi = await _clanService.Get <List <Model.Clanovi> >(null);
var brojac = 0;
List <IzvjestajNajlojalnijiClanovi> lista = new List <IzvjestajNajlojalnijiClanovi>();
foreach (var clan in clanovi)
{
foreach (var trening in treninzi)
{
if (trening.ClanId == clan.ClanId)
{
brojac++;
}
}
lista.Add(new IzvjestajNajlojalnijiClanovi()
{
Ime = clan.Ime, Email = clan.Email, KorisnickoIme = clan.KorisnickoIme, Prezime = clan.Prezime, brojRezervacija = brojac
});
}
lista.OrderBy(c => c.brojRezervacija);
dgvClanovi.AutoGenerateColumns = false;
dgvClanovi.DataSource = lista;
}
private async void btnNajposjecenijiTreneri_Click(object sender, EventArgs e)
{
var treninzi = await _treningService.Get <List <Model.Trening> >(null);
var treneri = await _services.Get <List <Korisnici> >(null);
var brojac = 0;
List <IzvjestajNajposjecenijiTreneri> lista = new List <IzvjestajNajposjecenijiTreneri>();
foreach (var trener in treneri)
{
foreach (var trening in treninzi)
{
if (trening.KorisnikId == trener.KorisnikId)
{
brojac++;
}
}
lista.Add(new IzvjestajNajposjecenijiTreneri()
{
brojRezervacija = brojac, Email = trener.Email, ImePrezime = trener.ImePrezime, KorisnickoIme = trener.KorisnickoIme, Telefon = trener.Telefon
});
}
lista.OrderBy(c => c.brojRezervacija);
dgvKorisnici.AutoGenerateColumns = false;
dgvKorisnici.DataSource = lista;
}
private async Task TeretaneLoad()
{
var result = await _teretane.Get <List <Model.Teretane> >(null);
result.Insert(0, new Model.Teretane());
cmbTeretane.DisplayMember = "Naziv";
cmbTeretane.ValueMember = "TeretanaId";
cmbTeretane.DataSource = result;
}
private async Task LoadGradovi()
{
var result = await _gradovi.Get <List <Model.Grad> >(null);
result.Insert(0, new Model.Grad());
cmbGradovi.DisplayMember = "Naziv";
cmbGradovi.ValueMember = "GradId";
cmbGradovi.DataSource = result;
}
private async Task LoadLicence()
{
var licence = await _licenceService.Get <List <Model.Licenca> >(null);
licence.Insert(0, new Model.Licenca());
cmbLicence.DisplayMember = "Tip";
cmbLicence.ValueMember = "LicencaId";
cmbLicence.DataSource = licence;
}
public async Task LoadTeretane()
{
var result = await _teretaneService.Get <List <Model.Teretane> >(null);
result.Insert(0, new Model.Teretane());
cmbPrikazTeretane.DisplayMember = "Naziv";
cmbPrikazTeretane.ValueMember = "TeretanaId";
cmbPrikazTeretane.DataSource = result;
}
public async Task PopuniGradove()
{
var list = await _gradovi.Get <IEnumerable <Grad> >(null);
GradoviList.Clear();
foreach (var item in list)
{
GradoviList.Add(item);
}
}
public async Task PopuniKorisnike()
{
var list = await _korisnici.Get <IEnumerable <Korisnici> >(null);
KorisniciList.Clear();
foreach (var item in list)
{
KorisniciList.Add(item);
}
}
public async Task PopuniTipoveClanarina()
{
var list = await _tipClanarineService.Get <IEnumerable <TipClanarine> >(null);
TipoviClanarina.Clear();
foreach (var item in list)
{
TipoviClanarina.Add(item);
}
}
private async Task TreneriLoad()
{
var result = await _treneri.Get <List <Model.Korisnici> >(null);
result.Insert(0, new Model.Korisnici());
cmbTreneri.DisplayMember = "ImePrezime";
cmbTreneri.ValueMember = "KorisnikId";
cmbTreneri.DataSource = result;
}
public async Task Init()
{
TeretanaSearchRequest search = new TeretanaSearchRequest();
IEnumerable <Teretane> list;
var clan = await _clanService.GetById <Clanovi>(APIServices.ClanId);
search.GradId = clan.GradId;
if (Search != String.Empty)
{
search.Naziv = Search;
list = await _teretanaServices.Get <IEnumerable <Teretane> >(search);
}
else
{
list = await _teretanaServices.Get <IEnumerable <Teretane> >(search);
}
TeretaneList.Clear();
foreach (var teretane in list)
{
TeretaneList.Add(teretane);
}
}
private async void ZahtjevSlanje_OnClicked(object sender, EventArgs e)
{
var TreningList = await _treningServices.Get <List <Trening> >(null);
try
{
if (model.Korisnik == null)
{
await DisplayAlert("Greška", "Niste unjeli trenera!", "OK");
}
else
{
var postoji = false;
foreach (var trening in TreningList)
{
if (trening.DatumOdrzavanja.Date.Equals(model.Datum.Date) &&
trening.PocetakTreninga.Hour.Equals(model.PocetakTime.Hours) &&
trening.PocetakTreninga.Minute.Equals(model.PocetakTime.Minutes) &&
trening.KrajTreninga.Hour.Equals(model.KrajTime.Hours) &&
trening.KrajTreninga.Minute.Equals(model.KrajTime.Minutes))
{
await DisplayAlert("Termin postoji", "Provjerite da li termin vec ima u ponudi", "OK");
postoji = true;
}
}
if (postoji == false)
{
var pocetak = model.PocetakTime.ToString();
var kraj = model.KrajTime.ToString();
TreningDodatniUpsertRequest input = new TreningDodatniUpsertRequest()
{
ClanId = APIServices.ClanId,
KorisnikId = model.Korisnik.KorisnikId,
TeretanaId = model.Teretana.TeretanaId,
DatumOdrzavanja = model.Datum.Date,
PocetakTreninga = DateTime.ParseExact(pocetak, "HH:mm:ss", null),
KrajTreninga = DateTime.ParseExact(kraj, "HH:mm:ss", null),
Prihvacen = false
};
await _treningDodatniServices.Insert <TreningDodatni>(input);
await DisplayAlert("Potvrda", "Poslali ste zahtjev za dodatni termin", "OK");
}
}
}
catch
{
await DisplayAlert("Greška", "Došlo je do greške. Pokušajte ponovo", "OK");
}
}
private async Task Loadfrm(int?id = null)
{
await LoadGradovi();
var result = await _teretane.Get <List <Model.Teretane> >(null);
dgvTeretanePrikaz.AutoGenerateColumns = false;
dgvTeretanePrikaz.Columns[3].DefaultCellStyle.Format = "HH:mm";
dgvTeretanePrikaz.Columns[4].DefaultCellStyle.Format = "HH:mm";
dgvTeretanePrikaz.DataSource = result;
if (id.HasValue)
{
var teretana = await _teretane.GetById <Model.Teretane>(_id);
txtNaziv.Text = teretana.Naziv;
txtAdresa.Text = teretana.Adresa;
timePickerOD.Value = teretana.PocetakRadnoVrijeme;
timePickerDO.Value = teretana.KrajRadnoVrijeme;
cmbGradovi.SelectedItem = teretana.GradId;
}
}
public async Task PopuniKupone()
{
var kuponi = await _kuponiService.Get <IEnumerable <KuponPopusti> >(null);
NovaLista.Clear();
foreach (var item in kuponi)
{
if (item.PocetakDatum >= DatumOD && item.KrajDatum <= DatumDO)
{
NovaLista.Add(item);
Ukupno = Ukupno + item.Postotak;
}
}
}
private async void btnPrikaz_Click(object sender, EventArgs e)
{
var idTeretana = cmbPrikazTeretane.SelectedValue;
if (int.TryParse(idTeretana.ToString(), out int teretanaID))
{
request.TeretanaId = teretanaID;
}
var result = await _kuponService.Get <List <Model.KuponPopusti> >(request);
dgvKuponiPrikaz.AutoGenerateColumns = false;
dgvKuponiPrikaz.DataSource = result;
}
public async Task Init()
{
TreningDetaljiSearchRequest search = new TreningDetaljiSearchRequest();
search.clanId = APIServices.ClanId;
var TreningDetalji = await _treningDetaljiServices.Get <IEnumerable <TreningDetalji> >(search);
TreningDetaljiList.Clear();
foreach (var trening in TreningDetalji)
{
var tr = await _treningServices.GetById <Trening>(trening.TreningId);
TreningDetaljiList.Add(tr);
}
}
public async Task PopuniKupone()
{
KuponSearchRequest search = new KuponSearchRequest()
{
TeretanaId = Teretana.TeretanaId
};
var list = await _KuponService.Get <IEnumerable <KuponPopusti> >(search);
Kuponi.Clear();
foreach (var item in list)
{
if (item.Aktivan == true && item.PocetakDatum < DateTime.Now && item.KrajDatum > DateTime.Now)
{
Kuponi.Add(item);
}
}
}
private async void ListView_OnItemSelected(object sender, SelectedItemChangedEventArgs e)
{
var item = e.SelectedItem as Trening;
TreningDetaljiSearchRequest search = new TreningDetaljiSearchRequest()
{
treningId = item.TreningId
};
var treninzi = await _treningDetaljiServices.Get <List <TreningDetalji> >(search);
if (treninzi.Count() >= item.BrojRezervacija)
{
var ans = await DisplayAlert("Broj mjesta popunjen", "Želite li poslati zahtjev za ovaj termin?", "Da", "Ne");
if (ans == true)
{
TreningZahtjevUpsertRequest unos = new TreningZahtjevUpsertRequest()
{
ClanId = APIServices.ClanId,
TreningId = item.TreningId,
Odobren = false
};
await _treningZahtjevServices.Insert <Model.TreningZahtjev>(unos);
await DisplayAlert("Potvrda", "Uspješno ste poslali zahtjev!", "OK");
}
}
else
{
var ans = await DisplayAlert("Potvrda", "Da li želite rezervisati trening?", "Da", "Ne");
if (ans == true)
{
TreningDetaljiUpsertRequest unos = new TreningDetaljiUpsertRequest()
{
ClanId = APIServices.ClanId,
Otkazan = false,
TreningId = item.TreningId
};
await _treningDetaljiServices.Insert <TreningDetalji>(unos);
await DisplayAlert("Obavijest", "Uspješno ste rezervisali trening!", "OK");
}
}
}
private async void ListView_OnItemSelected(object sender, SelectedItemChangedEventArgs e)
{
var Teretana = e.SelectedItem as Teretane;
var clanarina = await _PlacanjeclanarineService.Get <List <PlacanjeClanarine> >(null);
foreach (var placene in clanarina)
{
if (placene.Clanarina.DatumIsteka < DateTime.Now)
{
if (placene.Clanarina.TeretanaId == Teretana.TeretanaId && placene.Clanarina.ClanId == APIServices.ClanId)
{
await Navigation.PushAsync(new TreningPage(Teretana));
return;
}
}
}
await Navigation.PushAsync(new PlacanjePage(Teretana));
}
protected async override void OnAppearing()
{
base.OnAppearing();
var list = await _PlacanjeclanarineService.Get <List <PlacanjeClanarine> >(null);
foreach (var placene in list)
{
if (placene.Clanarina.ClanId == APIServices.ClanId && model.Teretana.TeretanaId == placene.Clanarina.TeretanaId)
{
if (placene.Clanarina.DatumIsteka > DateTime.Now)
{
await Navigation.PushAsync(new TreningPage(model.Teretana));
return;
}
}
}
await model.PopuniTipoveClanarina();
await model.PopuniKupone();
}
private async void IzmjenaJela_Load(object sender, EventArgs e)
{
LoadVrsta();
loadRestoran();
var response = await _apiServiceJelaID.Get <esp_JeloByJeloID2_Result>(jeloID);
if (response != null)
{
j = response;
}
textBox5.Text = j.Opis;
textBox6.Text = j.Naziv;
cbxVrsteJela.SelectedValue = j.VrsteJelaID;
cbxRestoran.SelectedValue = j.RestoranID;
txtSlika.Text = "Možete odabrati novu sliku za izmjenu";
var ms = new MemoryStream(j.Slika);
Image thumbImage = Image.FromStream(ms);
pictureBox1.Image = thumbImage;
}
async Task Login()
{
if (await Validacija())
{
await Application.Current.MainPage.DisplayAlert("Greška", "Unesite tražena polja!", "OK");
}
else
{
IsBusy = true;
APIServices.Username = Username;
APIServices.Password = Password;
try
{
var allUsers = await _clanServices.Get <List <Model.Clanovi> >(null);
foreach (var u in allUsers)
{
if (u.KorisnickiNalog.Username == Username)
{
APIServices.NalogId = u.KorisnickiNalogId;
APIServices.ClanId = u.ClanId;
}
}
if (APIServices.ClanId == 0)
{
await Application.Current.MainPage.DisplayAlert("Greška!", "Niste unijeli tacnu lozinku ili username", "OK");
}
else
{
Application.Current.MainPage = new MainPage();
}
}
catch
{
await Application.Current.MainPage.DisplayAlert("Greška!", "Niste unijeli tacnu lozinku ili username", "OK");
}
}
}
public async Task Init()
{
var date = _date.Date.ToString("yyyy-MM-dd HH:mm:ss.fffffff");
var list = await _treningServices.GetByDateGym <IEnumerable <Trening> >(date, Teretana.TeretanaId, 0);
var listDetalji = await _treningDetaljiServices.Get <IEnumerable <TreningDetalji> >(null);
TreningList.Clear();
foreach (var trening in list)
{
var i = 0;
foreach (var detalji in listDetalji)
{
if (trening.TreningId == detalji.TreningId)
{
i++;
}
}
trening.TrenutnoRezervisanih = i;
TreningList.Add(trening);
}
}
public async Task <object> DeleteEmployeesById(int empId)
{
object str = await APIServices.Get <object>($"/api/home/DeleteEmployeesById?empId={empId}");
return(str);
}
