private void myMap_MapElementClick(MapControl sender, MapElementClickEventArgs args)
{
MapIcon myClickedIcon = args.MapElements.FirstOrDefault(x => x is MapIcon) as MapIcon;
//Debug.WriteLine("Kliknuli ste na parking: " + myClickedIcon.Title);
using (var db = new SPARKDbContext())
{
/*choosenParking = db.Parkings
* .Where(b => b.Name == myClickedIcon.Title)
* .FirstOrDefault();
* cijenaPoSatu.Text = myClickedIcon.Title;*/
foreach (Parking p in Parkings)
{
if (p.Name == myClickedIcon.Title)
{
choosenParking = p;
globalNaziv.Text = choosenParking.Name;
cijenaPoSatu.Text = Convert.ToString(choosenParking.Price);
parkingZona.Text = Convert.ToString(choosenParking.Zone);
lokacija.Text = Convert.ToString(choosenParking.Address);
radnoVrijeme.Text = choosenParking.WorkingHours.Key.Hour + ":" + choosenParking.WorkingHours.Key.Minute + " - " + choosenParking.WorkingHours.Value.Hour + ":" + choosenParking.WorkingHours.Value.Minute;
if (choosenParking.Capacity == choosenParking.NumTakenSpaces)
{
statusParkinga.Text = "Zauzet";
//statusParkinga.Foreground = CRVENA
}
else
{
statusParkinga.Text = "Slobodan";
//statusParkinga.Foreground = 0081AF;
}
break;
}
}
//Debug.WriteLine(kliknuti.Name + kliknuti.Id);
/*cijenaPoSatu.Text = Convert.ToString(choosenParking.Price);
* parkingZona.Text = Convert.ToString(choosenParking.Zone);
* lokacija.Text = Convert.ToString(choosenParking.Address);
* radnoVrijeme.Text = Convert.ToString(choosenParking.WorkingHours);
* if (choosenParking.Capacity == choosenParking.NumTakenSpaces)
* statusParkinga.Text = "Zauzet";
* else statusParkinga.Text = "Slobodan";*/
}
UserViewModel.ClickedParking = choosenParking;
ShowRouteOnMap(lokacijaKorisnika, new BasicGeoposition {
Longitude = choosenParking.CoordY, Latitude = choosenParking.CoordX
});
}
public OwnerViewModel()
{
using (var db = new SPARKDbContext())
{
int trazeni_id = 1;
var u = db.Owner.Where(b => b.Id == trazeni_id).FirstOrDefault();
korisnik = new Owner();
korisnik.Name = u.Name;
korisnik.Surname = u.Surname;
korisnik.Id = u.Id;
korisnik.Password = u.Password;
korisnik.Username = u.Username;
korisnik.Email = u.Email;
}
NavigationService = new NavigationService();
FillWithUserData = new RelayCommand <object>(dodavanjeKomponente, showUserData);
}
private async void SubmitButton_Click(object sender, RoutedEventArgs e)
{
if (Model.Validator.RegistrationDetailsEmpty(TextBoxName.Text.ToString(), TextBoxSurname.Text.ToString(), TextBoxPassword.Password.ToString(), TextBoxUsername.Text.ToString(), TextBoxEmail.Text.ToString()))
{
throw new IOException("Nijedno polje ne smije biti prazno!");
}
if (!Model.Validator.EmailIsValid(TextBoxEmail.Text.ToString()))
{
throw new IOException("Neispravan Email format!");
}
try
{
using (var db = new SPARKDbContext())
{
List <Azure.User> lista = await App.MobileService.GetTable <Azure.User>().ToListAsync();
List <Azure.Owner> listaVlasnika = await App.MobileService.GetTable <Azure.Owner>().ToListAsync();
var user = new User();
if (UserView.userType == 0)
{
IMobileServiceTable <Azure.User> userTableObj = App.MobileService.GetTable <Azure.User>();
try
{
Azure.User obj = lista.Find(x => x.id == Convert.ToString(usr));
// await userTableObj.DeleteAsync(obj);
obj.Name = TextBoxName.Text.ToString();
obj.Surname = TextBoxSurname.Text.ToString();
obj.id = Convert.ToString(UserView.userID);
obj.Username = TextBoxUsername.Text.ToString();
obj.Password = TextBoxPassword.Password.ToString();
obj.Email = TextBoxEmail.Text.ToString();
await userTableObj.UpdateAsync(obj);
MessageDialog msgDialog = new MessageDialog("Uspješno ste ažurirali svoj profil.");
await msgDialog.ShowAsync();
}
catch (IOException ex)
{
MessageDialog msgDialogError = new MessageDialog("Greška : " + ex.Message);
await msgDialogError.ShowAsync();
}
}
else if (UserView.userType == 1)
{
IMobileServiceTable <Azure.Owner> userTableObj = App.MobileService.GetTable <Azure.Owner>();
try
{
Azure.Owner obj = listaVlasnika.Find(x => x.id == Convert.ToString(UserView.userID));
// await userTableObj.DeleteAsync(obj);
obj.Name = TextBoxName.Text.ToString();
obj.Surname = TextBoxSurname.Text.ToString();
obj.id = Convert.ToString(UserView.userID);
obj.Username = TextBoxUsername.Text.ToString();
obj.Password = TextBoxPassword.Password.ToString();
obj.Email = TextBoxEmail.Text.ToString();
await userTableObj.UpdateAsync(obj);
MessageDialog msgDialog = new MessageDialog("Uspješno ste ažurirali svoj profil.");
await msgDialog.ShowAsync();
}
catch (IOException ex)
{
MessageDialog msgDialogError = new MessageDialog("Greška : " + ex.Message);
await msgDialogError.ShowAsync();
}
}
}
}catch (IOException ee)
{
MessageDialog msgDialogError = new MessageDialog("Greška : " + ee.Message);
await msgDialogError.ShowAsync();
}
/* using (var db = new SPARKDbContext())
* {
* int trazeni_id = 6;
* var u = db.User.Where(b => b.Id == trazeni_id).FirstOrDefault();
* db.Database.ExecuteSqlCommand("delete from User where id=" + trazeni_id.ToString());
* u.Name = TextBoxName.Text;
* u.Surname = TextBoxSurname.Text;
* u.Password = TextBoxPassword.Text;
* u.Username = TextBoxUsername.Text;
* u.Email = TextBoxEmail.Text;
*
* db.User.Add(u);
* db.SaveChanges();
* }*/
var dialog = new MessageDialog("Vaš korisnički račun je uspješno izmijenjen!");
dialog.Commands.Add(new UICommand {
Label = "Ok"
});
await dialog.ShowAsync();
}
private async void SubmitButton_Click(object sender, RoutedEventArgs e)
{
try
{
if (Model.Validator.RegistrationDetailsEmpty(TextBoxName.Text.ToString(), TextBoxSurname.Text.ToString(), TextBoxPassword.Password.ToString(), TextBoxUsername.Text.ToString(), TextBoxEmail.Text.ToString()))
{
throw new IOException("Nijedno polje ne smije biti prazno!");
}
if (!Model.Validator.EmailIsValid(TextBoxEmail.Text.ToString()))
{
throw new IOException("Neispravan Email format!");
}
using (var db = new SPARKDbContext())
{
List <Azure.User> lista = await App.MobileService.GetTable <Azure.User>().ToListAsync();
List <Azure.Owner> listaVlasnika = await App.MobileService.GetTable <Azure.Owner>().ToListAsync();
var user = new User();
if (isUser)
{
/* user = new User
* {
* Name = TextBoxName.Text.ToString(),
* Surname = TextBoxSurname.Text.ToString(),
* Username = TextBoxUsername.Text.ToString(),
* Password = TextBoxPassword.Text.ToString(),
* Email = TextBoxEmail.Text.ToString()
* };*/
IMobileServiceTable <Azure.User> userTableObj = App.MobileService.GetTable <Azure.User>();
try
{
Azure.User obj = new Azure.User();
obj.Name = TextBoxName.Text.ToString();
obj.Surname = TextBoxSurname.Text.ToString();
obj.id = Convert.ToString(lista.Count + 1);
obj.Password = TextBoxPassword.Password.ToString();
obj.stanje_kredita = "0";
obj.Username = TextBoxUsername.Text.ToString();
if (lista.Find(x => x.Username == obj.Username) != null || listaVlasnika.Find(x => x.Username == obj.Username) != null)
{
throw new IOException("Korisničko ime već postoji!");
}
obj.Email = TextBoxEmail.Text.ToString();
await userTableObj.InsertAsync(obj);
MessageDialog msgDialog = new MessageDialog("Uspješno ste se registrovali na SPARK.");
await msgDialog.ShowAsync();
}
catch (IOException ex)
{
MessageDialog msgDialogError = new MessageDialog("Greška : " + ex.Message);
await msgDialogError.ShowAsync();
}
}
else
{
/* user = new Owner
* {
* Name = TextBoxName.Text.ToString(),
* Surname = TextBoxSurname.Text.ToString(),
* Username = TextBoxUsername.Text.ToString(),
* Password = TextBoxPassword.Text.ToString(),
* Email = TextBoxEmail.Text.ToString()
* };*/
IMobileServiceTable <Azure.Owner> userTableObj = App.MobileService.GetTable <Azure.Owner>();
try
{
Azure.Owner obj = new Azure.Owner();
obj.Name = TextBoxName.Text.ToString();
obj.Surname = TextBoxSurname.Text.ToString();
obj.id = Convert.ToString(listaVlasnika.Count + 1);
obj.Password = TextBoxPassword.Password.ToString();
obj.Username = TextBoxUsername.Text.ToString();
if (lista.Find(x => x.Username == obj.Username) != null || listaVlasnika.Find(x => x.Username == obj.Username) != null)
{
throw new IOException("Korisničko ime već postoji!");
}
obj.Email = TextBoxEmail.Text.ToString();
await userTableObj.InsertAsync(obj);
MessageDialog msgDialog = new MessageDialog("Uspješno ste unijeli novog vlasnika.");
await msgDialog.ShowAsync();
}
catch (IOException ex)
{
MessageDialog msgDialogError = new MessageDialog("Greška : " + ex.Message);
await msgDialogError.ShowAsync();
}
}
db.User.Add(user);
db.SaveChanges();
}
TextBoxName.Text = string.Empty;
TextBoxSurname.Text = string.Empty;
TextBoxUsername.Text = string.Empty;
TextBoxPassword.Password = string.Empty;
TextBoxEmail.Text = string.Empty;
}
catch (IOException ex)
{
MessageDialog msgDialogError = new MessageDialog("Greška : " + ex.Message);
msgDialogError.Commands.Add(new UICommand {
Label = "Ok"
});
await msgDialogError.ShowAsync();
}
}
