public static void kreirajZatvorenike() { var connectionString = "mongodb://localhost/?safe=true"; var server = MongoServer.Create(connectionString); var database = server.GetDatabase("sistemzatvora"); var collection1 = database.GetCollection <Zatvorenik>("zatvorenici"); Zatvorenik c1 = new Zatvorenik { Ime = "Zoran", Prezime = "Jovanovic", JMBG = "0709985743312", DatumRodjenja = "07.09.1985", DatumUlaska = "01.03.2015", DatumIzlaska = "01.03.2020", CelijaID = "5c60bb1628d5b32578b0528f", ZatvorID = "5c609bde28d5b30f60daba9e" }; Zatvorenik c2 = new Zatvorenik { Ime = "Jovan", Prezime = "Stojmenovic", JMBG = "0205980743211", DatumRodjenja = "02.05.1980", DatumUlaska = "01.08.2011", DatumIzlaska = "01.05.2025", CelijaID = "5c60bb1628d5b32578b0528f", ZatvorID = "5c609bde28d5b30f60daba9e" }; Zatvorenik c3 = new Zatvorenik { Ime = "Milos", Prezime = "Milosavljevic", JMBG = "0301988743515", DatumRodjenja = "03.01.1988", DatumUlaska = "01.07.2013", DatumIzlaska = "01.01.2024", CelijaID = "5c60bb1628d5b32578b0528f", ZatvorID = "5c609bde28d5b30f60daba9e" }; Zatvorenik c4 = new Zatvorenik { Ime = "Nemanja", Prezime = "Stefanovic", JMBG = "1211976741232", DatumRodjenja = "12.11.1976", DatumUlaska = "01.02.2014", DatumIzlaska = "01.06.2021", CelijaID = "5c60bb1628d5b32578b0528f", ZatvorID = "5c609bde28d5b30f60daba9e" }; collection1.Insert(c1); collection1.Insert(c2); collection1.Insert(c3); collection1.Insert(c4); }
public static void AddZatvorenik(Zatvorenik z) { var connectionString = "mongodb://localhost/?safe=true"; var server = MongoServer.Create(connectionString); var database = server.GetDatabase("sistemzatvora"); var collection = database.GetCollection <Zatvorenik>("zatvorenici"); collection.Insert(z); }
public static Zatvorenik GetZatvorenik(String jmbg) { var connectionString = "mongodb://localhost/?safe=true"; var server = MongoServer.Create(connectionString); var database = server.GetDatabase("sistemzatvora"); var collection = database.GetCollection <Zatvorenik>("zatvorenici"); Zatvorenik z = collection.FindOne(Query.EQ("JMBG", BsonValue.Create(jmbg))); return(z); }
private void buttonSave_Click(object sender, EventArgs e) { if (Tip == 0)//dodaj { if (validacija()) { DateTime dateTime = dateTimePickerRodjenje.Value; String dan = dateTime.Day.ToString(); String mesec = dateTime.Month.ToString(); String godina = dateTime.Year.ToString(); String datumRodjenja = mesec + "." + dan + "." + godina; DateTime dateTime1 = dateTimePickerUlazak.Value; String dan1 = dateTime1.Day.ToString(); String mesec1 = dateTime1.Month.ToString(); String godina1 = dateTime1.Year.ToString(); String datumUlaska = mesec1 + "." + dan1 + "." + godina1; String datumIzlaska = IzracunajDatumIzlaska(); String celijaID = DataManager.VratiSlobodnuCeliju(Admin.ZatvorID); DataManager.AzurirajBrojPopunjenostiCelije(celijaID); DataManager.AddZatvorenik(new Zatvorenik { Ime = textBoxIme.Text, Prezime = textBoxPrezime.Text, JMBG = textBoxJMBG.Text, DatumRodjenja = datumRodjenja, DatumUlaska = datumUlaska, DatumIzlaska = datumIzlaska, ZatvorID = Admin.ZatvorID, CelijaID = celijaID }); if (Lopov == null) { Zatvorenik z = DataManager.GetZatvorenik(textBoxJMBG.Text); foreach (KrivicnaDela k in this.Dela) { k.ZatvorenikID = z.Id.ToString(); } } DataManager.AddDela(Dela); this.Close(); DialogResult = DialogResult.OK; } } else if (Tip == 1)//azuriraj { DataManager.DeleteDela(Lopov); DataManager.AddDela(Dela); this.Close(); DialogResult = DialogResult.OK; } }
public static void DeleteDela(Zatvorenik z) { var connectionString = "mongodb://localhost/?safe=true"; var server = MongoServer.Create(connectionString); var database = server.GetDatabase("sistemzatvora"); var collection = database.GetCollection <KrivicnaDela>("krivicnadela"); var query = Query.EQ("ZatvorenikID", BsonValue.Create(z.Id.ToString())); collection.Remove(query); }
private void RetrieveInfo(Zatvorenik z) { textBoxID.Text = Lopov.Id.ToString(); textBoxIme.Text = Lopov.Ime; textBoxPrezime.Text = Lopov.Prezime; textBoxJMBG.Text = Lopov.JMBG; textBoxBrojCelije.Text = Lopov.CelijaID; dateTimePickerUlazak.Text = Lopov.DatumUlaska; dateTimePickerRodjenje.Text = Lopov.DatumRodjenja; dateTimePickerIzlazak.Text = Lopov.DatumIzlaska; }
public static List <KrivicnaDela> GetDela(Zatvorenik z) { var connectionString = "mongodb://localhost/?safe=true"; var server = MongoServer.Create(connectionString); var database = server.GetDatabase("sistemzatvora"); var collection = database.GetCollection <KrivicnaDela>("krivicnadela"); List <KrivicnaDela> kdl = collection.Find(Query.EQ("ZatvorenikID", BsonValue.Create(z.Id.ToString()))).ToList(); return(kdl); }
private void listViewZatvorenici_DoubleClick(object sender, EventArgs e) { Zatvorenik = DataManager.VratiZatvorenika(listViewZatvorenici.SelectedItems[0].SubItems[0].Text); FormZatvorenik f = new FormZatvorenik(); f.Tip = 1; f.Admin = this.Radnik; f.Lopov = this.Zatvorenik; if (DialogResult.OK == f.ShowDialog()) { this.popuniListu(); } }
public static Zatvorenik VratiZatvorenika(String id) { var connectionString = "mongodb://localhost/?safe=true"; var server = MongoServer.Create(connectionString); var database = server.GetDatabase("sistemzatvora"); var collection1 = database.GetCollection <Zatvorenik>("zatvorenici"); var query = Query.EQ("_id", ObjectId.Parse(id)); Zatvorenik c = collection1.FindOne(query); return(c); }
public Arhiv getById(int id) { try { MySqlCommand cmd = new MySqlCommand("select * from arhiv where idZatvorenici = @ID", con); cmd.Parameters.Add("@ID", MySqlDbType.Int32).Value = id; MySqlDataReader r = cmd.ExecuteReader(); r.Read(); Zatvorenik z = new Zatvorenik(r.GetString("ime"), r.GetString("prezime"), r.GetString("adresa"), (DateTime)r.GetDateTime("datum_rodjenja"), r.GetInt32("idZatvorenici"), Spol.Musko, r.GetString("napomene"), (Blok)(r.GetInt32("idOdjeli") - 1), r.GetInt32("br_celije"), (DateTime)r.GetDateTime("datum_dolaska"), (DateTime)r.GetDateTime("datum_izlaska"), new Image()); return(new Arhiv(z, (DateTime)r.GetDateTime("datum_arhiviranja"), r.GetString("razlog"))); } catch (Exception) { throw; } }
private void PrikaziSvaKrivicnaDela(Zatvorenik z) { Dela = DataManager.GetDela(z); foreach (var delo in Dela) { try { ListViewItem item = new ListViewItem(new string[] { delo.Id.ToString(), delo.NazivDela, delo.BrojDana.ToString() }); listViewKrivicnaDela.Items.Add(item); } catch (Exception e) { MessageBox.Show(e.Message); } } listViewKrivicnaDela.Refresh(); }
public List <Arhiv> dajUslovne() { try { MySqlCommand cmd = new MySqlCommand("select * from arhiv where razlog = 'Uslovno'", con); MySqlDataReader r = cmd.ExecuteReader(); List <Arhiv> a = new List <Arhiv>(); while (r.Read()) { Image i = DAL.dajSlikuOdBajta(10, r); Zatvorenik z = new Zatvorenik(r.GetString("ime"), r.GetString("prezime"), r.GetString("adresa"), (DateTime)r.GetDateTime("datum_rodjenja"), r.GetInt32("idZatvorenici"), Spol.Musko, r.GetString("napomene"), (Blok)(r.GetInt32("idOdjeli") - 1), r.GetInt32("br_celije"), (DateTime)r.GetDateTime("datum_dolaska"), (DateTime)r.GetDateTime("datum_izlaska"), i); Arhiv arhiv = new Arhiv(z, (DateTime)r.GetDateTime("datum_arhiviranja"), r.GetString("razlog")); a.Add(arhiv); } return(a); } catch (Exception) { throw; } }