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