public IActionResult kreirajZaposlenogIZAPOSLEN([FromBody] ZaposleniCreate z) { try { DataProvider.dodajZaposlenogSaVezom(z); return(Ok()); } catch (Exception ex) { return(BadRequest(ex.ToString())); } }
public static void dodajZaposlenogSaVezom(ZaposleniCreate zap) { Dictionary <string, object> queryDict = new Dictionary <string, object>(); queryDict.Add("id", DataProvider.getMaxId() + 1); queryDict.Add("ime", zap.ime); queryDict.Add("prezime", zap.prezime); queryDict.Add("starost", zap.starost); queryDict.Add("pol", zap.pol); queryDict.Add("idFirme", zap.idFirme); queryDict.Add("poz", zap.pozicija); queryDict.Add("datumOd", zap.datum_od); var query = new Neo4jClient.Cypher.CypherQuery("CREATE (n:Zaposleni {id:{id},ime: {ime}, prezime:{prezime},starost:{starost},pol:{pol}}) return n", queryDict, CypherResultMode.Set); Zaposleni z = ((IRawGraphClient)Session.Client).ExecuteGetCypherResults <Zaposleni>(query).FirstOrDefault(); //kreiranje veze var query2 = new Neo4jClient.Cypher.CypherQuery("MATCH (a:Zaposleni),(b:Firma)WHERE a.id = {id} AND b.id = {idFirme} CREATE(a) -[r: ZAPOSLEN { datum_od: {datumOd} ,datum_do: \'\',pozicija:{poz} }]->(b) RETURN a", queryDict, CypherResultMode.Set); ((IRawGraphClient)Session.Client).ExecuteGetCypherResults <Zaposleni>(query2); }