//ParkingRegister
public void AddParking(object parametar)
{
using (var db = new dbContext.Parking())
{
var pm = new Model.ParkingModel(brojp);
db.pmodels.Add(pm);
db.SaveChanges();
var lc = new Model.Location
{
//x = ?;
//y = ?;
};
db.location.Add(lc);
db.SaveChanges();
int tmp = 0;
foreach (Model.Account ac in acc)
{
if (ac.Email() == _email)
{
tmp = ac.id;
}
}
var pa = new Model.Parking(tmp, parkingname, grad, drzava, lc.id, (float)Double.Parse(cijena), Int32.Parse(starttime), Int32.Parse(endtime), Int32.Parse(kapacitet), Int32.Parse(freeplaces), pm.id, 0);
db.parking.Add(pa);
db.SaveChanges();
IMobileServiceTable <AzureTabela.Parking> userTableObj = App.MobileService.GetTable <AzureTabela.Parking>();
try
{
AzureTabela.Parking par = new AzureTabela.Parking();
par.Accid = tmp;
par.Name = parkingname;
par.City = grad;
par.Country = drzava;
par.pLocation = lc.id;
par.Price = (float)Double.Parse(cijena);
par.startTime = Int32.Parse(starttime);
par.endTime = Int32.Parse(endtime);
par.Capacity = Int32.Parse(kapacitet);
par.freePlaces = Int32.Parse(freeplaces);
par.Model = pm.id;
par.approved = 0;
userTableObj.InsertAsync(par);
MessageDialog msgDialog = new MessageDialog("Uspješno ste unijeli novi parking.");
msgDialog.ShowAsync();
}
catch (Exception ex)
{
MessageDialog msgDialogError = new MessageDialog("Error : " + ex.ToString());
msgDialogError.ShowAsync();
}
var mess = new Model.Message("Add parking Request...", tmp, DateTime.Now);
db.inbox.Add(mess);
db.SaveChanges();
}
firstname = string.Empty;
lastname = string.Empty;
Email = string.Empty;
pasw = string.Empty;
cb = false;
rpasw = string.Empty;
}
public static void Initialize(dbContext.Parking context)
{
if (!context.location.Any())
{
context.location.AddRange(
new Model.Location()
{
x = 43.856f,
y = 18.39f
}
);
context.SaveChanges();
}
if (!context.account.Any())
{
context.account.AddRange(
new Model.Account("Niko", "Nikic", "*****@*****.**", "202cb962ac59075b964b07152d234b70", "parking"),
new Model.Account("Nikolija", "Nikolic", "*****@*****.**", "202cb962ac59075b964b07152d234b70", "user"),
new Model.Account("Himzo", "Polovina", "*****@*****.**", "202cb962ac59075b964b07152d234b70", "admin"));
context.SaveChanges();
}
/*if (!context.pmodels.Any())
* {
* context.pmodels.AddRange(
* new Model.ParkingModel(6));
* context.SaveChanges();
* }*/
if (!context.parking.Any())
{
context.parking.AddRange(
new Model.Parking(1, "Test", "Sarajevo", "Bosna i Hercegovina", 1, 1f, 7, 20, 6, 6, 1, 1));
IMobileServiceTable <AzureTabela.Parking> userTableObj = App.MobileService.GetTable <AzureTabela.Parking>();
AzureTabela.Parking p = new AzureTabela.Parking(1, "Test", "Sarajevo", "Bosna i Hercegovina", 1, 1f, 7, 20, 6, 6, 1, 1);
try
{
userTableObj.InsertAsync(p);
MessageDialog msgDialog = new MessageDialog("Uspješno.");
msgDialog.ShowAsync();
}
catch (Exception ex)
{
MessageDialog msgDialogError = new MessageDialog("Error : " + ex.ToString());
msgDialogError.ShowAsync();
}
context.SaveChanges();
}
if (!context.pmanager.Any())
{
context.pmanager.AddRange(
new Model.ParkingManager(0));
context.SaveChanges();
}
if (!context.account.Any())
{
context.account.AddRange(
new Model.Account("Nikolija", "Nikolic", "*****@*****.**", "202cb962ac59075b964b07152d234b70", "user"));
context.SaveChanges();
}
if (!context.account.Any())
{
context.account.AddRange(
new Model.Account("Himzo", "Polovina", "*****@*****.**", "202cb962ac59075b964b07152d234b70", "admin"));
context.SaveChanges();
}
if (!context.user.Any())
{
Model.User u = new Model.User();
u.locationid = 1;
u.accid = 2;
context.user.AddRange(
u
);
context.SaveChanges();
}
}
