private void button52_Click(object sender, EventArgs e)
{
try
{
ISession s = DataLayer.GetSession();
Objekat o = s.Load <Objekat>(2);
//originalna sesija se zatvara i raskida se veza izmedju objekta i sesije
//objekat se modifikuje potpuno nezavisno od sesije
o.Povrsina = 300.55;
//otvara se nova sesija
//poziva se Update i objekat se povezuje sa novom sesijom
s.Update(o);
s.Flush();
s.Close();
}
catch (Exception ec)
{
MessageBox.Show(ec.Message);
}
}
public static ObjekatView VratiObjekat(int objekatId)
{
try
{
ISession s = DataLayer.GetSession();
Objekat o = s.Get <Objekat>(objekatId);
if (o == null)
{
return(null);
}
var objekat = new ObjekatView(o);
objekat.Alarmi = o.Alarmi.Select(a => new AlarmniSistemView(a)).ToList();
objekat.Intervencije = o.Intervencije.Select(i => new IntervencijaView(i)).ToList();
objekat.PolicijskaStanica = new PolicijskaStanicaView(o.PolicijskaStanica);
return(objekat);
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}
public static void DodajObjekat(ObjekatView o)
{
try
{
ISession s = DataLayer.GetSession();
var objekat = new Objekat();
var policijskastanica = s.Get <PolicijskaStanica>(o.PolicijskaStanica.StanicaId);
objekat.PolicijskaStanica = policijskastanica;
objekat.Adresa = o.Adresa;
objekat.Broj = o.Broj;
objekat.Ime = o.Ime;
objekat.Prezime = o.Prezime;
objekat.Povrsina = o.Povrsina;
objekat.TipObjekta = o.TipObjekta;
s.Save(objekat);
s.Flush();
s.Close();
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}
private void odradi(String y)
{
objekti = new List <Objekat>();
foreach (Tune element in mojaBiblioteka)
{
Objekat a = new Objekat();
if (y == "u")
{
a.naziv = element.Artist;
}
else if (y == "a")
{
a.naziv = element.Album;
}
else if (y == "z")
{
a.naziv = element.Genre;
}
a.cijena = element.Price;
if (objekti.Find(x => x.naziv == a.naziv) == null)
{
objekti.Add(a);
}
else
{
objekti.Find(x => x.naziv == a.naziv).cijena += a.cijena;
}
}
}
public IActionResult Snimi(ObjekatDodajVM input)
{
if (!ModelState.IsValid)
{
GenerisiMjesto(input);
GenerisiKlijenta(input);
return(View("Dodaj", input));
}
var noviObjekat = new Objekat()
{
Naziv = input.Naziv,
Ulica = input.Ulica,
KontaktOsoba = input.KontaktOsoba,
KontaktBrojFiksni = input.KontaktBrojFiksni,
KontaktBrojMobitel = input.KontaktBrojMobitel,
KontaktEmail = input.KontaktEmail,
ObjekatStatus = true,
KlijentId = input.KlijentId,
MjestoId = input.MjestoId
};
_context.Objekti.Add(noviObjekat);
_context.SaveChanges();
return(RedirectToAction("Index"));
}
private void button19_Click(object sender, EventArgs e)
{
try
{
ISession s = DataLayer.GetSession();
Patrola p = s.Load <Patrola>(1);
Objekat o = s.Load <Objekat>(1);
Intervencija i = new Intervencija();
i.Datum = DateTime.Now;
i.Objekat = o;
i.Patrola = p;
i.Vreme = "20:35H";
i.Opis = "Lagana prica";
o.ImaoIntervencije.Add(i);
p.ImalaIntervencije.Add(i);
s.Save(i);
s.Flush();
s.Close();
}
catch (Exception ec)
{
MessageBox.Show(ec.Message);
}
}
public void ucitajObjekte()
{
try
{
Objekti = new List <Objekat>();
String query = "SELECT * FROM Objekat;";
DBConnectionString s = new DBConnectionString();
using (SqlConnection con = new SqlConnection(s.GetString()))
{
con.Open();
if (con.State == System.Data.ConnectionState.Open)
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = query;
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Objekat a = new Objekat(Convert.ToInt32(reader.GetString(0)), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4), reader.GetString(5), reader.GetString(6), reader.GetString(7), reader.GetString(8));
DBJelo dbj = new DBJelo();
dbj.ucitajJelaObjekta(a.id);
a.jela = dbj.jelaObjekta;
Objekti.Add(a);
}
}
con.Close();
}
}
catch (Exception e)
{
Debug.WriteLine("Exception: " + e.Message);
}
}
public int brisiObjekat(Objekat a)
{
try
{
String query = "DELETE FROM Objekat WHERE id = @id;";
DBConnectionString s = new DBConnectionString();
using (SqlConnection con = new SqlConnection(s.GetString()))
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = query;
SqlParameter id = new SqlParameter();
id.Value = Convert.ToString(a.id);
id.ParameterName = "id";
cmd.Parameters.Add(id);
con.Open();
int r = 0;
if (con.State == System.Data.ConnectionState.Open)
{
r = cmd.ExecuteNonQuery();
}
con.Close();
return(r);
}
}
catch (Exception e)
{
Debug.WriteLine("Exception: " + e.Message);
return(0);
}
}
public async Task <ActionResult> ChangePassword(ChangePasswordViewModel model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
var result = await UserManager.ChangePasswordAsync(User.Identity.GetUserId(), model.OldPassword, model.NewPassword);
if (result.Succeeded)
{
var user = await UserManager.FindByIdAsync(User.Identity.GetUserId());
if (user != null)
{
Kupac k = getKupac(db.Kupci, User.Identity.GetUserName());
Objekat o = getObjekat(db.Objekti, User.Identity.GetUserName());
if (k != null)
{
db.Kupci.Find(k.id).password = model.NewPassword;
}
else if (o != null)
{
db.Objekti.Find(o.id).password = model.NewPassword;
}
await SignInManager.SignInAsync(user, isPersistent : false, rememberBrowser : false);
}
return(RedirectToAction("Index", new { Message = ManageMessageId.ChangePasswordSuccess }));
}
AddErrors(result);
return(View(model));
}
public async Task <IHttpActionResult> PutObjekat(int id, Objekat objekat)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != objekat.id)
{
return(BadRequest());
}
db.Entry(objekat).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ObjekatExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ServiceResult <Objekat> Delete(Objekat objekat)
{
_objekatRepository.Delete(objekat);
_objekatRepository.SaveChanges();
return(new ServiceResult <Objekat>(true, "Objekat uspesno izbrisan."));
}
public ServiceResult <Objekat> Update(Objekat objekat)
{
_objekatRepository.Update(objekat);
_objekatRepository.SaveChanges();
return(new ServiceResult <Objekat>(true, "Objekat uspesno izmenjen.", objekat));
}
public ServiceResult <Objekat> Add(Objekat objekat)
{
_objekatRepository.Add(objekat);
_objekatRepository.SaveChanges();
return(new ServiceResult <Objekat>(true, "Objekat uspesno dodat.", objekat));
}
public ActionResult DeleteConfirmed(int id)
{
Objekat objekat = db.Objekti.Find(id);
db.Objekti.Remove(objekat);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ObjekatView(Objekat o)
{
ObjekatId = o.ObjekatId;
Adresa = o.Adresa;
Povrsina = o.Povrsina;
TipObjekta = o.TipObjekta;
Ime = o.Ime;
Prezime = o.Prezime;
Broj = o.Broj;
}
public ActionResult Edit([Bind(Include = "id,ime,prezime,adresa,telefon,email,grad,naziv")] Objekat objekat)
{
if (ModelState.IsValid)
{
db.Entry(objekat).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index", "Home"));
}
return(View(objekat));
}
public async Task <IHttpActionResult> GetObjekat(int id)
{
Objekat objekat = await db.Objekat.FindAsync(id);
if (objekat == null)
{
return(NotFound());
}
return(Ok(objekat));
}
public ActionResult Create([Bind(Include = "id,ime,prezime,adresa,telefon,email,password,grad,naziv")] Objekat objekat)
{
if (ModelState.IsValid)
{
db.Objekti.Add(objekat);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(objekat));
}
public async Task <IHttpActionResult> PostObjekat(Objekat objekat)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Objekat.Add(objekat);
await db.SaveChangesAsync();
return(CreatedAtRoute("DefaultApi", new { id = objekat.id }, objekat));
}
public ActionResult Create(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Objekat o = new Objekat();
o.IDPolisa = (int)id;
ViewBag.IDPolisa = (int)id;
return(View(o));
}
// GET: Objekat/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Objekat objekat = db.Objekti.Find(id);
if (objekat == null)
{
return(HttpNotFound());
}
return(View(objekat));
}
public void ObrisiObjekat(String username)
{
DBObjekat DB = new DBObjekat();
VMObjekat v;
v = new VMObjekat();
List <Objekat> temp = v.UčitavanjeObjekata();
Objekat k = temp.FirstOrDefault(x => x.username == username);
if (k != null)
{
DB.brisiObjekat(k);
}
}
private Objekat getObjekat(DbSet <Objekat> kupci, string mail)
{
Objekat pom = new Objekat();
List <Objekat> objekti = kupci.ToList();
for (int i = 0; i < objekti.Count(); i++)
{
if (objekti.ElementAt(i).email == mail)
{
pom = objekti.ElementAt(i);
}
}
return(pom);
}
public async Task <IHttpActionResult> DeleteObjekat(int id)
{
Objekat objekat = await db.Objekat.FindAsync(id);
if (objekat == null)
{
return(NotFound());
}
db.Objekat.Remove(objekat);
await db.SaveChangesAsync();
return(Ok(objekat));
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Objekat o = db.Objekats.Find(id);
if (o == null)
{
return(HttpNotFound());
}
return(View(o));
}
public IActionResult Post([FromBody] Objekat objekat)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var result = _objekatService.Add(objekat);
if (result.Success)
{
return(Ok(result));
}
return(BadRequest(result));
}
public ActionResult Create(Objekat o, int id)
{
if (ModelState.IsValid)
{
o.IDPolisa = id;
db.Objekats.Add(o);
try
{
db.SaveChanges();
}
catch (Exception)
{
}
}
return(RedirectToAction("Details", "Polisa", new { id = o.IDPolisa }));
}
private void button55_Click(object sender, EventArgs e)
{
try
{
ISession s = DataLayer.GetSession();
Objekat o = s.Load <Objekat>(9);
//brise se objekat iz baze ali ne i instanca objekta u memroiji
s.Delete(o);
//s.Delete("from Odeljenje");
s.Flush();
s.Close();
}
catch (Exception ec)
{
MessageBox.Show(ec.Message);
}
}
public async Task <ActionResult> EditObjekat(ManageMessageId?message)
{
ViewBag.StatusMessage =
message == ManageMessageId.ChangePasswordSuccess ? "Your password has been changed."
: message == ManageMessageId.SetPasswordSuccess ? "Your password has been set."
: message == ManageMessageId.SetTwoFactorSuccess ? "Your two-factor authentication provider has been set."
: message == ManageMessageId.Error ? "An error has occurred."
: message == ManageMessageId.AddPhoneSuccess ? "Your phone number was added."
: message == ManageMessageId.RemovePhoneSuccess ? "Your phone number was removed."
: "";
Objekat o = getObjekat(db.Objekti, User.Identity.GetUserName());
if (o == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
return(View(o));
}
private void button8_Click(object sender, EventArgs e)
{
try
{
ISession s = DataLayer.GetSession();
Objekat o = s.Load <Objekat>(2);
MessageBox.Show((o.Ime).ToString());
MessageBox.Show((o.Povrsina).ToString());
MessageBox.Show((o.PripadaPolicjkojStanica.StanicaId).ToString());
MessageBox.Show((o.PripadaPolicjkojStanica.Opstina).ToString());
s.Close();
}
catch (Exception exception)
{
MessageBox.Show(exception.Message);
Console.WriteLine(exception);
throw;
}
}
