public void Apply(object parametar)
{
using (var db = new dbContext.Parking())
{
foreach (Model.Account a in db.account)
{
if (a.Email() == parent.e)
{
foreach (Model.Parking p in db.parking)
{
if (p.Accid == a.id)
{
p.freePlaces = Int32.Parse(freeS);
p.Price = Int32.Parse(pr);
p.startTime = Int32.Parse(fr);
p.endTime = Int32.Parse(un);
db.Entry(p).State = EntityState.Modified;
db.SaveChanges();
return;
}
}
}
}
}
}
public System()
{
using (var db = new dbContext.Parking())
{
parkings = db.parking.ToList <Model.Parking>();
users = db.user.ToList <Model.User>();
//admins = db.admin.ToList<Model.Admin>();
acc = db.account.ToList <Model.Account>();
//pmodels = db.pmodels.ToList<Model.ParkingModel>();
locations = db.location.ToList <Model.Location>();
//inbox = db.inbox.ToList<Model.Message>();
pmanager = db.pmanager.ToList <Model.ParkingManager>();
}
LoginGosta = new RelayCommand <object>(openGuestForm, check);
Login = new RelayCommand <object>(openLoginForm, check);
register = new RelayCommand <object>(openReg, check);
confirm = new RelayCommand <object>(addUser, check);
regParking = new RelayCommand <object>(openRegParking, check);
forgotpass = new RelayCommand <object>(forgotpassform, check);
cancel = new RelayCommand <object>(Cancel, check);
send = new RelayCommand <object>(Send, check);
sendcode = new RelayCommand <object>(SendCode, check);
addparking = new RelayCommand <object>(AddParking, check);
cancelAddEdit = new RelayCommand <object>(CancelAddEdit, check);
saveAddEdit = new RelayCommand <object>(SaveAddEdit, check);
openAddEdit = new RelayCommand <object>(OpenAddEdit, check);
deleteMessage = new RelayCommand <object>(DeleteMessage, check);
cancelEdit = new RelayCommand <object>(Cancel, check);
NavigationService = new NavigationService();
}
public static void Initialize(dbContext.Parking context)
{
Model.ParkingModel test = new Model.ParkingModel(12, 32);
//Model.Parking te = new Model.Parking(100, "te", "test", "test", 51, 23, 44, 5, 14, 3, test);
//te.id = 1;
//context.parking.AddRange(te);
Model.Location t = new Model.Location(12f, 125f);
t.id = 245;
context.location.AddRange(t);
context.SaveChanges();
}
public void addUser(object parametar)
{
using (var db = new dbContext.Parking())
{
var ac = new Model.Account(fn, ln, em, MD5.ComputeMD5(pw), "user");
db.account.Add(ac);
db.SaveChanges();
var us = new Model.User
{
accid = ac.id
};
db.user.Add(us);
db.SaveChanges();
firstname = string.Empty;
lastname = string.Empty;
Email = string.Empty;
pasw = string.Empty;
cb = false;
rpasw = string.Empty;
}
}
//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();
}
}
