public async Task <ActionResult <object> > PostLogin(Predavac p)
{
var predavac = await _context.Predavaci.Where(x => x.Username == p.Username && x.Password == p.Password)
.FirstOrDefaultAsync();
if (predavac != null)
{
return new { id = predavac.Id, tip = "predavac" }
}
;
var ucenik = await _context.Ucenik.Where(x => x.Username == p.Username && x.Password == p.Password)
.FirstOrDefaultAsync();
if (ucenik != null)
{
return new { id = ucenik.Id, tip = "ucenik" }
}
;
var admin = await _context.Admin.Where(x => x.Username == p.Username && x.Password == p.Password)
.FirstOrDefaultAsync();
if (admin != null)
{
return new { id = admin.Id, tip = "admin" }
}
;
return(NotFound());
}
public HttpResponseMessage UpdatePredavac([FromBody] Predavac predavac)
{
using (var connection = new SqlConnection(ConnectionString))
{
try
{
using (var sqlCmd = new SqlCommand("UPDATE Predavac.Predavac SET DatumRodjenjaPredavaca=@DatumRodjenjaPredavaca, KatedraPredavaca=@KatedraPredavaca, MestoRodjenjaPredavaca=@MestoRodjenjaPredavaca, ZvanjePredavacaID=@ZvanjePredavacaID, KorisnikID=@KorisnikID, DepartmanID=@DepartmanID WHERE PredavacID=@id"))
{
connection.Open();
sqlCmd.Connection = connection;
sqlCmd.Parameters.AddWithValue("DatumRodjenjaPredavaca", predavac.DatumRodjenjaPredavaca);
sqlCmd.Parameters.AddWithValue("KatedraPredavaca", predavac.KatedraPredavaca);
sqlCmd.Parameters.AddWithValue("MestoRodjenjaPredavaca", predavac.MestoRodjenjaPredavaca);
sqlCmd.Parameters.AddWithValue("ZvanjePredavacaID", predavac.ZvanjePredavacaID);
sqlCmd.Parameters.AddWithValue("KorisnikID", predavac.KorisnikID);
sqlCmd.Parameters.AddWithValue("DepartmanID", predavac.DepartmanID);
sqlCmd.Parameters.AddWithValue("id", predavac.PredavacID);
int rowAffected = sqlCmd.ExecuteNonQuery();
if (rowAffected == 0)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Error 400 BadRequest"));
}
}
}
catch (Exception)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Error 400 Bad Request"));
}
}
return(Request.CreateResponse(HttpStatusCode.OK, "Updated Successfully"));
}
public async Task <IActionResult> Edit(int id, [Bind("IdPredavac,Ime,Prezime")] Predavac predavac)
{
if (id != predavac.IdPredavac)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(predavac);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!PredavacExists(predavac.IdPredavac))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(predavac));
}
private void btnPromeni_Click(object sender, EventArgs e)
{
Predavac predavac = new Predavac();
predavac.ime = txtIme.Text;
predavac.prezime = txtPrezime.Text;
predavac.obrazovanje = txtObrazovanje.Text;
predavac.iskustvo = txtIskustvo.Text;
Dictionary <string, object> queryDict = new Dictionary <string, object>();
queryDict.Add("ime", predavac.ime);
queryDict.Add("prezime", predavac.prezime);
queryDict.Add("obrazovanje", predavac.obrazovanje);
queryDict.Add("iskustvo", predavac.iskustvo);
try
{
var query = new Neo4jClient.Cypher.CypherQuery("MATCH (n:Predavac {ime : {ime}, prezime: {prezime}, obrazovanje: {obrazovanje}} ) SET n.iskustvo = {iskustvo} return n", queryDict, CypherResultMode.Set);
((IRawGraphClient)client).ExecuteCypher(query);
txtIme.Text = "";
txtPrezime.Text = "";
txtObrazovanje.Text = "";
txtIskustvo.Text = "";
groupBox1.Text = "";
MessageBox.Show("Uspešno ste izmenili iskustvo predavača.");
}
catch (Exception exc)
{
MessageBox.Show(exc.Message);
}
}
private void btnDodaj_Click(object sender, EventArgs e)
{
Predavac predavac = this.createPredavac();
Dictionary <string, object> queryDict = new Dictionary <string, object>();
queryDict.Add("ime", predavac.ime);
queryDict.Add("prezime", predavac.prezime);
queryDict.Add("obrazovanje", predavac.obrazovanje);
queryDict.Add("iskustvo", predavac.iskustvo);
var query = new Neo4jClient.Cypher.CypherQuery("CREATE (n:Predavac {ime : {ime}, prezime : {prezime}, obrazovanje : {obrazovanje}, iskustvo: {iskustvo} }) return n",
queryDict, CypherResultMode.Set);
List <Predavac> predavaci = ((IRawGraphClient)client).ExecuteGetCypherResults <Predavac>(query).ToList();
foreach (Predavac n in predavaci)
{
MessageBox.Show(n.ime);
}
this.Close();
}
public async Task <IActionResult> PutPredavac(int id, Predavac predavac)
{
if (id != predavac.Id)
{
return(BadRequest());
}
_context.Entry(predavac).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!PredavacExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
private void btnPredaje_Click(object sender, EventArgs e)
{
if (txtIme.Text != "" && comboBox1.Text != "")
{
Predavac predavac = new Predavac();
Kurs kurs = new Kurs();
predavac.ime = txtIme.Text;
kurs.id = comboBox1.Text;
Dictionary <string, object> queryDict = new Dictionary <string, object>();
queryDict.Add("ime", predavac.ime);
queryDict.Add("id", kurs.id);
var query = new Neo4jClient.Cypher.CypherQuery("MATCH (a:Kurs), (b:Predavac) WHERE a.id = {id} and b.ime= {ime} CREATE (a) - [r:PREDAJE] -> (b)", queryDict, CypherResultMode.Set);
((IRawGraphClient)client).ExecuteCypher(query);
}
txtIme.Text = "";
txtPrezime.Text = "";
txtObrazovanje.Text = "";
txtIskustvo.Text = "";
comboBox1.Text = "";
groupBox1.Text = "";
}
public ActionResult DeleteConfirmed(int id)
{
Predavac predavac = db.Predavac.Find(id);
db.Predavac.Remove(predavac);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,Ime,Prezime,Tema,Datum,BrStudent,KolegijId")] Predavac predavac)
{
if (ModelState.IsValid)
{
db.Entry(predavac).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.KolegijId = new SelectList(db.Kolegij, "Id", "Naziv", predavac.KolegijId);
return(View(predavac));
}
private Predavac createPredavac()
{
Predavac n = new Predavac();
n.ime = txtIme.Text;
n.prezime = txtPrezime.Text;
n.obrazovanje = txtObrazovanje.Text;
n.iskustvo = txtIskustvo.Text;
return(n);
}
public async Task <IActionResult> Create([Bind("IdPredavac,Ime,Prezime")] Predavac predavac)
{
if (ModelState.IsValid)
{
_context.Add(predavac);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(predavac));
}
public ActionResult Create([Bind(Include = "Id,Ime,Prezime,Tema,Datum,BrStudent,KolegijId")] Predavac predavac)
{
if (ModelState.IsValid)
{
db.Predavac.Add(predavac);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.KolegijId = new SelectList(db.Kolegij, "Id", "Naziv", predavac.KolegijId);
return(View(predavac));
}
// GET: Predavacs/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Predavac predavac = db.Predavac.Find(id);
if (predavac == null)
{
return(HttpNotFound());
}
return(View(predavac));
}
// GET: Predavacs/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Predavac predavac = db.Predavac.Find(id);
if (predavac == null)
{
return(HttpNotFound());
}
ViewBag.KolegijId = new SelectList(db.Kolegij, "Id", "Naziv", predavac.KolegijId);
return(View(predavac));
}
private void btnObrisiPredavaca_Click(object sender, EventArgs e)
{
if (txtObrisiPredavaca.Text != "")
{
Predavac predavac = new Predavac();
predavac.ime = txtObrisiPredavaca.Text;
Dictionary <string, object> queryDict = new Dictionary <string, object>();
queryDict.Add("ime", predavac.ime);
var query = new Neo4jClient.Cypher.CypherQuery("match (p:Predavac{ime:{ime}}) detach delete p", queryDict, CypherResultMode.Set);
((IRawGraphClient)client).ExecuteCypher(query);
}
txtObrisiPredavaca.Text = "";
MessageBox.Show("Uspsesno ste izbrisali predavaca.");
}
public HttpResponseMessage GetByDepartmanID(int id)
{
List <Predavac> result = new List <Predavac>();
using (var connection = new SqlConnection(ConnectionString))
{
SqlCommand sqlCmd = new SqlCommand("select * from Predavac.Predavac where DepartmanID=" + id, connection)
{
CommandType = CommandType.Text
};
try
{
connection.Open();
using (SqlDataReader dataReader = sqlCmd.ExecuteReader())
{
while (dataReader.Read())
{
var predavac = new Predavac
{
PredavacID = Convert.ToInt32(dataReader["PredavacID"]),
DatumRodjenjaPredavaca = Convert.ToDateTime(dataReader["DatumRodjenjaPredavaca"]),
MestoRodjenjaPredavaca = Convert.ToString(dataReader["MestoRodjenjaPredavaca"]),
KatedraPredavaca = Convert.ToString(dataReader["KatedraPredavaca"]),
ZvanjePredavacaID = Convert.ToInt32(dataReader["ZvanjePredavacaID"]),
KorisnikID = Convert.ToInt32(dataReader["KorisnikID"]),
DepartmanID = Convert.ToInt32(dataReader["DepartmanID"])
};
result.Add(predavac);
}
}
if (result == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Error 404 Found"));
}
}
catch (Exception)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Error retrieving data"));
}
}
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
public async Task <ActionResult <Predavac> > PostPredavac(Predavac predavac)
{
var p = await _context.Predavaci.Where(x => x.Username == predavac.Username).ToListAsync();
var u = await _context.Ucenik.Where(x => x.Username == predavac.Username).ToListAsync();
var a = await _context.Admin.Where(x => x.Username == predavac.Username).ToListAsync();
if (p.Count != 0 || u.Count != 0 || a.Count != 0)
{
return(BadRequest());
}
_context.Predavaci.Add(predavac);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetPredavac", new { id = predavac.Id }, predavac));
}
public HttpResponseMessage CreatePredavac([FromBody] Predavac predavac)
{
using (var connection = new SqlConnection(ConnectionString))
{
SqlCommand sqlCmd = new SqlCommand("INSERT INTO Predavac.Predavac VALUES(@DatumRodjenjaPredavaca, @KatedraPredavaca, @MestoRodjenjaPredavaca, @ZvanjePredavacaID, @KorisnikID, @DepartmanID)", connection);
sqlCmd.Parameters.AddWithValue("DatumRodjenjaPredavaca", predavac.DatumRodjenjaPredavaca);
sqlCmd.Parameters.AddWithValue("KatedraPredavaca", predavac.KatedraPredavaca);
sqlCmd.Parameters.AddWithValue("MestoRodjenjaPredavaca", predavac.MestoRodjenjaPredavaca);
sqlCmd.Parameters.AddWithValue("ZvanjePredavacaID", predavac.ZvanjePredavacaID);
sqlCmd.Parameters.AddWithValue("KorisnikID", predavac.KorisnikID);
sqlCmd.Parameters.AddWithValue("DepartmanID", predavac.DepartmanID);
try
{
connection.Open();
int i = sqlCmd.ExecuteNonQuery();
SqlCommand sqlUniverzitet = new SqlCommand("SELECT TOP 1 * FROM Predavac.Predavac ORDER BY PredavacID DESC", connection);
Predavac last = new Predavac();
using (SqlDataReader predavacRead = sqlUniverzitet.ExecuteReader())
{
while (predavacRead.Read())
{
last.PredavacID = Convert.ToInt32(predavacRead["PredavacID"]);
last.DatumRodjenjaPredavaca = Convert.ToDateTime(predavacRead["DatumRodjenjaPredavaca"]);
last.MestoRodjenjaPredavaca = Convert.ToString(predavacRead["MestoRodjenjaPredavaca"]);
last.KatedraPredavaca = Convert.ToString(predavacRead["KatedraPredavaca"]);
last.ZvanjePredavacaID = Convert.ToInt32(predavacRead["ZvanjePredavacaID"]);
last.KorisnikID = Convert.ToInt32(predavacRead["KorisnikID"]);
last.DepartmanID = Convert.ToInt32(predavacRead["DepartmanID"]);
}
}
var response = Request.CreateResponse(HttpStatusCode.Created, last);
response.Headers.Location = new Uri(Request.RequestUri + "/" + last.PredavacID);
return(response);
}
catch (Exception)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Error 404 Bad request"));
}
}
}
private void txtIme_TextChanged(object sender, EventArgs e)
{
Predavac predavac = new Predavac();
predavac.ime = txtIme.Text;
Dictionary <string, object> queryDict = new Dictionary <string, object>();
queryDict.Add("ime", predavac.ime);
var query = new Neo4jClient.Cypher.CypherQuery("MATCH (n:Predavac {ime : {ime}} ) return n", queryDict, CypherResultMode.Set);
List <Predavac> predavaci = ((IRawGraphClient)client).ExecuteGetCypherResults <Predavac>(query).ToList();
foreach (Predavac p in predavaci)
{
txtPrezime.Text = p.prezime;
txtObrazovanje.Text = p.obrazovanje;
txtIskustvo.Text = p.iskustvo;
}
groupBox1.Text = txtIme.Text;
}
