/// <summary>
/// Initializes the singleton application object. This is the first line of authored code
/// executed, and as such is the logical equivalent of main() or WinMain().
/// </summary>
public App()
{
this.InitializeComponent();
this.Suspending += OnSuspending;
using (var db = new SPARK.Model.SPARKDbContext())
{
db.Database.ApplyMigrations();
SPARK.Model.DefaultPodaci.Initialize(db);
}
}
private async void SubmitButton_Click(object sender, RoutedEventArgs e)
{
try
{
using (var db = new SPARK.Model.SPARKDbContext())
{
IMobileServiceTable <Azure.Parking> userTableObj = App.MobileService.GetTable <Azure.Parking>();
List <Azure.Parking> lista = await App.MobileService.GetTable <Azure.Parking>().ToListAsync();
try
{
Azure.Parking obj = lista.Find(x => x.id == IDparkinga);
obj.Name = TextBoxName.Text.ToString();
obj.WorkingFrom = Convert.ToString(openingTime.Time.Hours) + ":" + Convert.ToString(openingTime.Time.Minutes);
obj.WorkingTo = Convert.ToString(closingTime.Time.Hours) + ":" + Convert.ToString(closingTime.Time.Minutes);
try
{
obj.Capacity = Convert.ToInt32(TextBoxCapacity.Text.ToString());
}
catch (Exception ee)
{
throw new IOException("Neispravan kapacitet!");
}
try
{
obj.Zone = Convert.ToInt32(TextBoxParkingZone.Text);
}
catch (Exception ee)
{
throw new IOException("Neispravna zona!");
}
try
{
obj.MinCredits = Convert.ToInt32(TextBoxParkingMinCredits.Text.ToString());
}
catch (Exception ee)
{
throw new IOException("Neispravno napisan broj minimalnih kredita!");
}
try
{
obj.Price = Convert.ToDouble(TextBoxPrice.Text);
}
catch (Exception ee)
{
throw new IOException("Neispravno napisana cijena!");
}
obj.NumTakenSpaces = 0;
obj.TodaysProfit = 0;
obj.MonthlyProfit = 0;
await userTableObj.UpdateAsync(obj);
MessageDialog msgDialog = new MessageDialog("Uspješno ste ažurirali parking.");
await msgDialog.ShowAsync();
}
catch (IOException ex)
{
MessageDialog msgDialogError = new MessageDialog("Error : " + ex.Message);
await msgDialogError.ShowAsync();
}
TextBoxName.Text = string.Empty;
TextBoxParkingZone.Text = string.Empty;
TextBoxPrice.Text = string.Empty;
TextBoxAddress.Text = string.Empty;
TextBoxParkingMinCredits.Text = string.Empty;
TextBoxCapacity.Text = string.Empty;
}
}
catch (Exception izuzetak)
{
var dialog1 = new MessageDialog(izuzetak.Message);
dialog1.Commands.Add(new UICommand {
Label = "Ok"
});
await dialog1.ShowAsync();
}
}
private async void SubmitButton_Click(object sender, RoutedEventArgs e)
{
try
{
using (var db = new SPARK.Model.SPARKDbContext())
{
/* var parking = new SPARK.Model.Parking
* {
* Name = TextBoxName.Text,
* Zone = Convert.ToInt16(TextBoxParkingZone.Text),
* Price = Convert.ToDouble(TextBoxPrice.Text),
* Address = TextBoxAddress.Text,
* //working hours ???
* WorkingHours = new KeyValuePair<DateTime, DateTime>(Convert.ToDateTime("1.1.2017"), Convert.ToDateTime("5.2.2017")),
* CoordX = (double)lokacijaParkinga.Location.Position.Longitude,
* CoordY = (double)lokacijaParkinga.Location.Position.Longitude,
* };
* db.Parkings.Add(parking);
* db.SaveChanges();
*
* var dialog1 = new MessageDialog("Uspješno registrovan parking '" + TextBoxName.Text + "'");
* dialog1.Commands.Add(new UICommand { Label = "Ok" });
* await dialog1.ShowAsync();*/
IMobileServiceTable <Azure.Parking> userTableObj = App.MobileService.GetTable <Azure.Parking>();
List <Azure.Parking> lista = await App.MobileService.GetTable <Azure.Parking>().ToListAsync();
try
{
Azure.Parking obj = new Azure.Parking();
obj.Name = TextBoxName.Text.ToString();
obj.id = Convert.ToString(lista.Count + 1);
obj.Address = TextBoxAddress.Text;
obj.WorkingFrom = Convert.ToString(openingTime.Time.Hours) + ":" + Convert.ToString(openingTime.Time.Minutes);
obj.WorkingTo = Convert.ToString(closingTime.Time.Hours) + ":" + Convert.ToString(closingTime.Time.Minutes);
obj.CoordY = (double)lokacijaParkinga.Location.Position.Longitude;
obj.CoordX = (double)lokacijaParkinga.Location.Position.Latitude;
try
{
obj.Capacity = Convert.ToInt32(TextBoxCapacity.Text.ToString());
}catch (Exception ee)
{
throw new IOException("Neispravan kapacitet!");
}
try
{
obj.Zone = Convert.ToInt32(TextBoxParkingZone.Text);
}
catch (Exception ee)
{
throw new IOException("Neispravna zona!");
}
try
{
obj.MinCredits = Convert.ToInt32(TextBoxParkingMinCredits.Text.ToString());
}
catch (Exception ee)
{
throw new IOException("Neispravno napisan broj minimalnih kredita!");
}
try
{
obj.Price = Convert.ToDouble(TextBoxPrice.Text);
}
catch (Exception ee)
{
throw new IOException("Neispravno napisana cijena!");
}
obj.id_vlasnika = userID;
obj.NumTakenSpaces = 0;
obj.TodaysProfit = 0;
obj.MonthlyProfit = 0;
await userTableObj.InsertAsync(obj);
MessageDialog msgDialog = new MessageDialog("Uspješno ste unijeli novi parking.");
await msgDialog.ShowAsync();
}
catch (IOException ex)
{
MessageDialog msgDialogError = new MessageDialog("Error : " + ex.Message);
await msgDialogError.ShowAsync();
}
TextBoxName.Text = string.Empty;
TextBoxParkingZone.Text = string.Empty;
TextBoxPrice.Text = string.Empty;
TextBoxAddress.Text = string.Empty;
TextBoxParkingMinCredits.Text = string.Empty;
TextBoxCapacity.Text = string.Empty;
}
}
catch (Exception izuzetak)
{
var dialog1 = new MessageDialog(izuzetak.Message);
dialog1.Commands.Add(new UICommand {
Label = "Ok"
});
await dialog1.ShowAsync();
}
}
