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(); } }