public static void kreirajCelije() { var connectionString = "mongodb://localhost/?safe=true"; var server = MongoServer.Create(connectionString); var database = server.GetDatabase("sistemzatvora"); var collection1 = database.GetCollection <Celija>("celije"); Celija c1 = new Celija { Blok = "A", Broj = 123, Kapacitet = 3, Popunjenost = 0, ZatvorID = "5c609bde28d5b30f60daba9e" }; Celija c2 = new Celija { Blok = "B", Broj = 233, Kapacitet = 2, Popunjenost = 0, ZatvorID = "5c609bde28d5b30f60daba9e" }; Celija c3 = new Celija { Blok = "C", Broj = 341, Kapacitet = 4, Popunjenost = 0, ZatvorID = "5c609bde28d5b30f60daba9e" }; Celija c4 = new Celija { Blok = "D", Broj = 82, Kapacitet = 2, Popunjenost = 0, ZatvorID = "5c609bde28d5b30f60daba9e" }; collection1.Insert(c1); collection1.Insert(c2); collection1.Insert(c3); collection1.Insert(c4); }
public static Celija VratiCeliju(String ID) { var connectionString = "mongodb://localhost/?safe=true"; var server = MongoServer.Create(connectionString); var database = server.GetDatabase("sistemzatvora"); var collection1 = database.GetCollection <Celija>("celije"); var query = Query.EQ("_id", ObjectId.Parse(ID)); Celija c = collection1.FindOne(query); return(c); }
public static void AzurirajBrojPopunjenostiCelije(String celijaID) { var connectionString = "mongodb://localhost/?safe=true"; var server = MongoServer.Create(connectionString); var database = server.GetDatabase("sistemzatvora"); var collection1 = database.GetCollection <Celija>("celije"); //pronalazi zadatu celiju var query = Query.EQ("_id", ObjectId.Parse(celijaID)); Celija c = collection1.FindOne(query); c.Popunjenost += 1; var update = MongoDB.Driver.Builders.Update.Set("Popunjenost", BsonValue.Create(c.Popunjenost)); collection1.Update(query, update); }
public static List <Zatvorenik> VratiZatvorenikePoBloku(String blok, String zatvorID) { List <Zatvorenik> zatvorenici = new List <Zatvorenik>(); var connectionString = "mongodb://localhost/?safe=true"; var server = MongoServer.Create(connectionString); var database = server.GetDatabase("sistemzatvora"); var collection1 = database.GetCollection <Zatvorenik>("zatvorenici"); //svi zatvorenici u tom zatvoru var query = Query.EQ("ZatvorID", zatvorID); foreach (Zatvorenik z in collection1.Find(query).ToList()) { Celija c = VratiCeliju(z.CelijaID); if (c.Blok == blok) { zatvorenici.Add(z); } } return(zatvorenici); }
public void popuniListu() { listViewStrazari.Items.Clear(); //za svaki blok se trazi lista zatvorenika u tom bloku for (int i = 0; i < Radnik.Blokovi.Count; i++) { //ispis zatvorenika u listView foreach (Zatvorenik z in DataManager.VratiZatvorenikePoBloku(Radnik.Blokovi[i], Radnik.ZatvorID)) { Celija c = DataManager.VratiCeliju(z.CelijaID); ListViewItem item = new ListViewItem(new string[] { z.Id.ToString(), z.Ime, z.Prezime, c.Broj.ToString(), c.Blok }); listViewStrazari.Items.Add(item); } } listViewStrazari.Refresh(); }