private void button2_Click(object sender, EventArgs e)
{
ISession s = DataLayer.GetSession();
Clanak c = s.Load <Clanak>(clanak.LiteraturaId);
c.Naziv = textBox2.Text;
c.ISSN = textBox3.Text;
try
{
c.Godina = Int32.Parse(textBox4.Text);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
c.NazivCasopisa = textBox5.Text;
try
{
c.BrojCasopisa = Int32.Parse(textBox6.Text);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
s.Update(c);
s.Flush();
s.Close();
}
private void button7_Click(object sender, EventArgs e)
{
try
{
ISession s = DataLayer.GetSession();
Literatura l = new Literatura
{
Id = int.Parse(textBox10.Text),
Naslov = textBox9.Text,
GodinaIzdavanja = int.Parse(textBox8.Text)
};
Clanak c = new Clanak
{
ISSN = textBox7.Text,
Broj_casopisa = int.Parse(textBox6.Text),
Literatura = l
};
c.Id = int.Parse(textBox5.Text);
Crud <Literatura> .Update(s, l);
Crud <Clanak> .Update(s, c);
s.Close();
neaktivno();
}
catch (Exception ex)
{
}
}
public static void AddItemsToLvClanak(ListViewItem lvi, Clanak clanak)
{
lvi.SubItems.Add(clanak.Naziv);
lvi.SubItems.Add(clanak.NazivCasopisa);
lvi.SubItems.Add(clanak.ISSN);
Form1.lv.Items.Add(lvi);
}
private void button2_Click(object sender, EventArgs e)
{
ISession s = DataLayer.GetSession();
Clanak c = new Clanak();
c.Naziv = textBox1.Text;
c.ISSN = textBox2.Text;
try
{
c.Godina = Int32.Parse(textBox3.Text);
}
catch (Exception ex)
{
MessageBox.Show("Godina mora biti ceo broj." + ex.Message);
}
c.NazivCasopisa = textBox4.Text;
try
{
c.BrojCasopisa = Int32.Parse(textBox5.Text);
}
catch (Exception ex)
{
MessageBox.Show("Broj casopisa mora biti ceo broj." + ex.Message);
}
c.Tip = "CLANAK";
c.Pisao = (Autor)comboBox1.SelectedItem;
c.Projekti.Add((Projekat)comboBox2.SelectedItem);
s.Save(c);
s.Flush();
s.Close();
Close();
}
public IActionResult Dodaj(int ID)
{
Korisnik a = _db.Korisnik.Where(x => x.KorisnikId == HttpContext.GetLogiraniKorisnik().KorisnikId).FirstOrDefault();
ClanakDodaj model = new ClanakDodaj
{
ClanciKategorija = _db.ClanciKategorija.Select(i => new SelectListItem {
Value = i.ClanciKategorijaID.ToString(), Text = i.Naziv
}).ToList(),
KorisnikId = a.KorisnikId,
Korisnik = a.Ime,
DatumObjave = DateTime.Now,
};
if (ID != 0)
{
Clanak t = _db.Clank.Find(ID);
model.ClanakID = t.ClanakID;
model.Naslov = t.Naslov;
model.TekstClanka = t.TekstClanka;
model.ClanciKategorijaID = t.ClanciKategorijaID;
model.KorisnikId = t.KorisnikId;
model.Podnaslov = t.Podnaslov;
model.DatumObjave = t.DatumObjave;
}
return(View(model));
}
private void button4_Click(object sender, EventArgs e)
{
try
{
ISession s = DataLayer.GetSession();
Literatura l = new Literatura
{
Naslov = "NHibernate",
GodinaIzdavanja = 2015
};
Clanak k = new Clanak
{
ISSN = "4835691532353513",
Broj_casopisa = 57,
Literatura = l
};
s.Save(l);
s.Save(k);
s.Flush();
s.Close();
}
catch (Exception ec)
{
MessageBox.Show(ec.Message);
}
}
private void button3_Click(object sender, EventArgs e)
{
try
{
ISession s = DataLayer.GetSession();
Clanak c = s.Load <Clanak>(43);
if (c != null)
{
MessageBox.Show(c.Literatura.Naslov);
}
else
{
MessageBox.Show("Ne postoji clanak sa zadatim identifikatorom");
}
s.Close();
}
catch (Exception ec)
{
MessageBox.Show(ec.Message);
}
}
private void button1_Click(object sender, EventArgs e)
{
Literatura l = new Literatura
{
Naslov = textBox1.Text,
GodinaIzdavanja = int.Parse(textBox2.Text),
Autori = listaAutora
};
Clanak c = new Clanak
{
Broj_casopisa = int.Parse(textBox3.Text),
ISSN = textBox4.Text,
Literatura = l
};
ISession s = DataLayer.GetSession();
Crud <Literatura> .Create(s, l);
Crud <Clanak> .Create(s, c);
s.Close();
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox4.Text = "";
dataGridView1.DataSource = null;
dataGridView1.Update();
dataGridView1.Refresh();
}
// GET api/clanak/5
public Clanak Get(int id)
{
Clanak Clanak = Crud <Clanak> .Read(sesija, id);
Clanak.Literatura = null;
return(Clanak);
}
public IActionResult ObrisiClanak(int Id)
{
Clanak c = db.clanak.Find(Id);
db.Remove(c);
db.SaveChanges();
return(RedirectToAction("Index", "Home"));
}
public UrediClanak(Clanak clanak)
{
InitializeComponent();
BindingContext = model = new UrediClanakViewModel()
{
Clanak = clanak
};
}
public OcijeniClanakPreporukaPage(Clanak c)
{
InitializeComponent();
BindingContext = model = new OcijeniClanakViewModel {
Clanak = c
};
clanak = c;
}
public IActionResult Detalji(int id)
{
Clanak model = _db.Clank.Where(x => x.ClanakID == id).Include(x => x.Korisnik).Include(x => x.ClanciKategorija).FirstOrDefault();
ViewData["path"] = "data:image;base64," + Convert.ToBase64String(model.Slika);
return(View(model));
}
public UrediClanak(Clanak Clanak)
{
this.InitializeComponent();
this.BindingContext = model = new UrediClanakViewModel {
clanak = Clanak
};
c = Clanak;
}
public ClanakView(Clanak c)
{
this.Id = c.Id;
this.Naziv = c.Naziv;
this.ISSN = c.ISSN;
this.Godine = c.Godina;
this.NazivCasopisa = c.NazivCasopisa;
this.BrojCasopisa = c.BrojCasopisa;
}
public void PosaljiClanak(Clanak clanak)
{
var rootDir = HttpContext.Current.Server.MapPath("~/App_Data/DMS/");
using (var s = File.Create(rootDir + Guid.NewGuid().ToString("N") + ".rtf"))
{
s.Write(clanak.Raw, 0, clanak.Raw.Length);
}
}
public NovostiDetailPage(Clanak _clanak)
{
InitializeComponent();
BindingContext = novostiDetail = new NovostiDetailViewModel()
{
clanak = _clanak
};
c = _clanak;
}
public IActionResult Obrisi(int ID)
{
Clanak x = _db.Clank.Find(ID);
_db.Clank.Remove(x);
_db.SaveChanges();
return(Redirect("/Clanak/Index"));
}
// PUT api/clanak/5
public void Put(int id, [FromBody] Clanak Clanak)
{
//linija je dodata da bi mogli da testiramo sa objektima koje dobijemo kao rezultat
//kontrolera ge. Potavlja se objekat iz baze, zbog toga sto je u odgovarajucoj tabeli spoljni kljuc obavezan
Clanak.Literatura = new Literatura()
{
Id = 81
};
Crud <Clanak> .Update(sesija, Clanak);
}
public ClanakDetalji(Clanak clanak)
{
InitializeComponent();
BindingContext = model = new ClanakDetaljiViewModel()
{
Clanak = clanak
};
int clanakId = clanak.ClanakId;
DodajPregledClanka(clanakId);
}
public IActionResult ViewClanak(int Id)
{
Clanak c = db.clanak.Find(Id);
ViewClanakVM model = new ViewClanakVM()
{
ID = c.ClanakID,
Naslov = c.Naslov,
Sadrzaj = c.Sadrzaj,
DatumObjave = c.DatumObjave.ToShortDateString(),
Slika = c.SlikaPath
};
return(View(model));
}
public IActionResult ObjaviClanak(int Id)
{
AddEditClanakVM model = new AddEditClanakVM();
if (Id != 0)
{
Clanak c = db.clanak.Find(Id);
model.ID = c.ClanakID;
model.Naslov = c.Naslov;
model.Sadrzaj = c.Sadrzaj;
model.SlikaPath = c.SlikaPath;
}
return(View(model));
}
public static DTClanak GetClanak(int idClanak)
{
DTClanak clanak = new DTClanak();
try
{
ISession session = DataLayer.GetSession();
Clanak c = session.Load <Clanak>(idClanak);
clanak = new DTClanak(c.Id, c.Naziv, c.ISSN, c.Godina, c.NazivCasopisa, c.BrojCasopisa);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
return(clanak);
}
public int AddClanak(Clanak c)
{
try
{
ISession s = DataLayer.GetSession();
c.Tip = "CLANAK";
s.Save(c);
s.Flush();
s.Close();
return(1);
}
catch (Exception)
{
return(-1);
}
}
public int RemoveClanak(int id)
{
try
{
ISession s = DataLayer.GetSession();
Clanak c = s.Load <Clanak>(id);
s.Delete(c);
s.Flush();
s.Close();
return(1);
}
catch (Exception)
{
return(-1);
}
}
public ClanakView GetClanakView(int id)
{
try
{
ISession s = DataLayer.GetSession();
Clanak c = s.Load <Clanak>(id);
if (c == null)
{
return(new ClanakView());
}
return(new ClanakView(c));
}
catch (Exception)
{
return(new ClanakView());
}
}
public async Task <IActionResult> Spremi(AddEditClanakVM model)
{
if (ModelState.IsValid)
{
var user = await userManager.GetUserAsync(HttpContext.User);
if (model.ID == 0)
{
Clanak c = new Clanak()
{
Naslov = model.Naslov,
Sadrzaj = model.Sadrzaj,
ApotekarID = user.Id,
DatumObjave = DateTime.Now,
SlikaPath = await fileManager.SaveImage(model.Slika)
};
db.Add(c);
}
else
{
Clanak c = db.clanak.Find(model.ID);
c.Naslov = model.Naslov;
c.Sadrzaj = model.Sadrzaj;
if (c.SlikaPath == null)
{
c.SlikaPath = await fileManager.SaveImage(model.Slika);
}
else
{
fileManager.DeleteImage(c.SlikaPath);
c.SlikaPath = await fileManager.SaveImage(model.Slika);
}
}
db.SaveChanges();
return(RedirectToAction("Index", "Home"));
}
return(View("ObjaviClanak", model));
}
public int UpdateClanak(int id, Clanak c)
{
try
{
ISession s = DataLayer.GetSession();
Clanak clanak = s.Load <Clanak>(id);
clanak.ISSN = c.ISSN;
clanak.Naziv = c.Naziv;
clanak.NazivCasopisa = c.NazivCasopisa;
clanak.Godina = c.Godina;
s.Update(clanak);
s.Flush();
s.Close();
return(1);
}
catch (Exception)
{
return(-1);
}
}
public IActionResult Snimi(ClanakDodaj vm)
{
if (!ModelState.IsValid)
{
vm.ClanciKategorija = _db.ClanciKategorija.Select(i => new SelectListItem {
Value = i.ClanciKategorijaID.ToString(), Text = i.Naziv
}).ToList();
return(View("Dodaj", vm));
}
string uniqueFileName = null;
if (vm.ClanakID == 0)
{
Clanak novi = new Clanak();
if (vm.Photo != null)
{
//Upload slike
string uploadsFolder = Path.Combine(_hostingEnvironment.WebRootPath, "images");
uniqueFileName = Guid.NewGuid().ToString() + "_" + vm.Photo.FileName;
string filePath = Path.Combine(uploadsFolder, uniqueFileName);
if (vm.Photo.Length > 0)
{
using (var ms = new MemoryStream())
{
vm.Photo.CopyTo(ms);
var fileBytes = ms.ToArray();
string s = Convert.ToBase64String(fileBytes);
novi.Slika = fileBytes;
}
}
}
novi.Naslov = vm.Naslov;
novi.TekstClanka = vm.TekstClanka;
novi.DatumObjave = vm.DatumObjave;
novi.Podnaslov = vm.Podnaslov;
novi.ClanciKategorijaID = vm.ClanciKategorijaID;
novi.KorisnikId = vm.KorisnikId;
_db.Clank.Add(novi);
}
else
{
Clanak t = _db.Clank.Find(vm.ClanakID);
IFormFile photo = vm.Photo;
byte[] array = t.Slika;
if (vm.Photo != null)
{
string uploadsFolder = Path.Combine(_hostingEnvironment.WebRootPath, "images");
uniqueFileName = Guid.NewGuid().ToString() + "_" + vm.Photo.FileName;
string filePath = Path.Combine(uploadsFolder, uniqueFileName);
if (vm.Photo.Length > 0)
{
using (var ms = new MemoryStream())
{
vm.Photo.CopyTo(ms);
var fileBytes = ms.ToArray();
string s = Convert.ToBase64String(fileBytes);
array = fileBytes;
}
}
}
t.ClanakID = vm.ClanakID;
t.Naslov = vm.Naslov;
t.TekstClanka = vm.TekstClanka;
t.DatumObjave = vm.DatumObjave;
t.Podnaslov = vm.Podnaslov;
t.ClanciKategorijaID = vm.ClanciKategorijaID;
t.KorisnikId = vm.KorisnikId;
t.Slika = array;
}
_db.SaveChanges();
return(Redirect("/Clanak/Index"));
}
// To delete item which is selected in listView
private void obrisiBtn_Click(object sender, EventArgs e)
{
ISession _session;
switch (this.LastLoadedData)
{
case 0: // Projekat
try
{
_session = DataLayer.GetSession();
Projekat projekat = _session.Load <Projekat>(Int32.Parse(listProjekti.SelectedItems[0].SubItems[0].Text));
MessageBox.Show(projekat.Naziv);
_session.Delete(projekat);
_session.Flush();
_session.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
break;
case 1: // Predmet
try
{
_session = DataLayer.GetSession();
Predmet predmet = _session.Load <Predmet>(Int32.Parse(listProjekti.SelectedItems[0].SubItems[0].Text));
MessageBox.Show(predmet.Naziv);
_session.Delete(predmet);
_session.Flush();
_session.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
break;
case 2: // Nastavnik
try
{
_session = DataLayer.GetSession();
Nastavnik n = _session.Load <Nastavnik>(Int32.Parse(listProjekti.SelectedItems[0].SubItems[0].Text));
MessageBox.Show(n.Ime);
_session.Delete(n);
_session.Flush();
_session.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
break;
case 3: //Clanak
try
{
_session = DataLayer.GetSession();
Clanak c = _session.Load <Clanak>(Int32.Parse(listProjekti.SelectedItems[0].SubItems[0].Text));
MessageBox.Show(c.Naziv);
_session.Delete(c);
_session.Flush();
_session.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
break;
case 4: // Rad
try
{
_session = DataLayer.GetSession();
Rad r = _session.Load <Rad>(Int32.Parse(listProjekti.SelectedItems[0].SubItems[0].Text));
MessageBox.Show(r.Id.ToString());
_session.Delete(r);
_session.Flush();
_session.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
break;
case 5: // Knjiga
_session = DataLayer.GetSession();
Knjiga k = _session.Load <Knjiga>(Int32.Parse(listProjekti.SelectedItems[0].SubItems[0].Text));
MessageBox.Show(k.Naslov);
_session.Delete(k);
_session.Flush();
_session.Close();
break;
case 6: // Autor
_session = DataLayer.GetSession();
Autor a = _session.Load <Autor>(Int32.Parse(listProjekti.SelectedItems[0].SubItems[0].Text));
MessageBox.Show(a.Ime + " " + a.Prezime);
_session.Delete(a);
_session.Flush();
_session.Close();
break;
case 7: // Student
_session = DataLayer.GetSession();
Student s = _session.Load <Student>(Int32.Parse(listProjekti.SelectedItems[0].SubItems[0].Text));
MessageBox.Show(s.Ime + " " + s.Prezime);
_session.Delete(s);
_session.Flush();
_session.Close();
break;
case 8: // Grupe
_session = DataLayer.GetSession();
Grupa g = _session.Load <Grupa>(Int32.Parse(listProjekti.SelectedItems[0].SubItems[0].Text));
MessageBox.Show(g.Naziv);
_session.Delete(g);
_session.Flush();
_session.Close();
break;
case 9: // Izvestaji
_session = DataLayer.GetSession();
//ITransaction t = _session.BeginTransaction();
Izvestaj i = _session.Load <Izvestaj>(Int32.Parse(listProjekti.SelectedItems[0].SubItems[0].Text));
MessageBox.Show(i.Opis);
_session.Delete(i);
_session.Flush();
_session.Close();
UpdateListViewIzvestaji();
break;
case 10: // Web Stranice
_session = DataLayer.GetSession();
WebStranice w = _session.Load <WebStranice>(Int32.Parse(listProjekti.SelectedItems[0].SubItems[0].Text));
MessageBox.Show(w.Link);
_session.Delete(w);
_session.Flush();
_session.Close();
break;
}
}
