public void Create(Person p) { database.ListRightPush("Id", p.Id); database.ListRightPush("Fname", p.Fname); database.ListRightPush("Lname", p.Lname); database.ListRightPush("Age", p.Age); }
private void grid_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex == 4) { var id = int.Parse(grid.Rows[e.RowIndex].Cells[0].Value.ToString()); var lname = grid.Rows[e.RowIndex].Cells[1].Value.ToString(); var fname = grid.Rows[e.RowIndex].Cells[2].Value.ToString(); var age = int.Parse(grid.Rows[e.RowIndex].Cells[3].Value.ToString()); var p = new Person(id, lname, fname, age); var formEdit = new fEdit(); formEdit.P = p; formEdit.pd = pd; formEdit.mv = this; formEdit.ShowDialog(); } else { if (e.ColumnIndex == 5) { var id = int.Parse(grid.Rows[e.RowIndex].Cells[0].Value.ToString()); var lname = grid.Rows[e.RowIndex].Cells[1].Value.ToString(); var fname = grid.Rows[e.RowIndex].Cells[2].Value.ToString(); var age = int.Parse(grid.Rows[e.RowIndex].Cells[3].Value.ToString()); var p = new Person(id, lname, fname, age); var formDelete = new fDelete(); formDelete.P = p; formDelete.pd = pd; formDelete.mv = this; formDelete.ShowDialog(); } } ShowData(pd.Read()); }
public void Create(Person p) { var newUser = new Person {Id = p.Id, Fname = p.Fname, Age = p.Age, Lname = p.Lname}; client.Cypher .Create("(person:Person {newUser})") .WithParam("newUser", newUser) .ExecuteWithoutResults(); }
public void Delete(Person p) { client.Cypher .Match("(person:Person)") .Where((Person person) => person.Id == p.Id) .Delete("person") .ExecuteWithoutResults(); }
public void Update(Person p) { client.Cypher .Match("(person:Person)") .Where((Person person) => person.Id == p.Id) .Set("person = {Person}") .WithParam("Person", new Person {Id = p.Id, Fname = p.Fname, Age = p.Age, Lname = p.Lname}) .ExecuteWithoutResults(); }
public void Update(Person p) { _connection.Open(); var sql = string.Format("Update persons Set lname = '{0}', fname = '{1}', age = '{2}' Where id = '{3}'", p.Lname, p.Fname, p.Age, p.Id); using (var cmd = new SqlCommand(sql, _connection)) { cmd.ExecuteNonQuery(); } }
public void Update(Person p) { var ids = database.ListRange("Id"); for (var i = 0; i < ids.Length; i++) { if (int.Parse(ids[i].ToString()) == p.Id) { database.ListSetByIndex("Fname", i, p.Fname); database.ListSetByIndex("Lname", i, p.Lname); database.ListSetByIndex("Age", i, p.Age); } } }
public void Create(Person p) { try { _connection.Open(); var query = "insert into persons(id, last_name, first_name, age) values('" + p.Id + "','" + p.Lname + "','" + p.Fname + "','" + p.Age + "');"; var myCommand = new MySqlCommand(query, _connection); myCommand.ExecuteReader(); } catch (Exception ex) { MessageBox.Show(ex.Message); } _connection.Close(); }
public void Create(Person p) { _connection.Open(); var sql = string.Format("Insert Into persons" + "(id, lname, fname, age) Values(@id, @lname, @fname, @age)"); using (var cmd = new SqlCommand(sql, _connection)) { cmd.Parameters.AddWithValue("@id", p.Id); cmd.Parameters.AddWithValue("@lname", p.Lname); cmd.Parameters.AddWithValue("@fname", p.Fname); cmd.Parameters.AddWithValue("@age", p.Age); cmd.ExecuteNonQuery(); } }
public void Delete(Person p) { _connection.Open(); var sql = string.Format("Delete from persons where id = '{0}'", p.Id); using (var cmd = new SqlCommand(sql, _connection)) { try { cmd.ExecuteNonQuery(); } catch (SqlException ex) { var error = new Exception("К сожалению ошибка.", ex); throw error; } } }
public void Delete(Person p) { var ids = database.ListRange("Id"); var firstNames = database.ListRange("Fname"); var lastNames = database.ListRange("Lname"); var ages = database.ListRange("Age"); for (var i = 0; i < ids.Length; i++) { if (int.Parse(ids[i].ToString()) == p.Id) { database.ListRemove("Id", ids[i]); database.ListRemove("Fname", firstNames[i]); database.ListRemove("Lname", lastNames[i]); database.ListRemove("Age", ages[i]); } } }
public void Delete(Person p) { try { var query = "delete from persons where id='" + p.Id + "';"; var myCommand = new MySqlCommand(query, _connection); _connection.Open(); var myReader = myCommand.ExecuteReader(); while (myReader.Read()) { } _connection.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public List<Person> Read() { var list = new List<Person>(); var Query = "SELECT * FROM persons"; _connection.Close(); var myCommand = new MySqlCommand(Query, _connection); _connection.Open(); var reader = myCommand.ExecuteReader(); while (reader.Read()) { var p = new Person { Id = Convert.ToInt32(reader["id"].ToString()), Lname = reader["last_name"].ToString(), Fname = reader["first_name"].ToString(), Age = Convert.ToInt32(reader["age"].ToString()) }; list.Add(p); } _connection.Close(); return list; }
/// <summary> /// Adds a positive vote for a connection /// </summary> /// <param name="raaPerson">a Person object from Riksantikvarieämbetet</param> /// <param name="librisPerson">a Person object from Libris</param> public void AddPositiveVote(Person raaPerson, Person librisPerson) { if (!CheckMatchForVoting(raaPerson, librisPerson)) { InsertMatch(raaPerson, librisPerson); } const string sql = "UPDATE votecount SET PositiveVotes = PositiveVotes + 1 WHERE RAAId = @raaId and LibrisId = @LibrisId"; MySqlCommand command = new MySqlCommand { Connection = mySqlConnection, CommandText = sql }; command.Parameters.AddWithValue("@raaId", raaPerson.URI); command.Parameters.AddWithValue("@LibrisId", librisPerson.URI); try { mySqlConnection.Open(); command.ExecuteNonQuery(); } finally { mySqlConnection.Close(); } }
public void Create(Person p) { _session.Execute("insert into person(id, lname, fname, age) values(" + p.Id + ",'" + p.Lname + "','" + p.Fname + "'," + p.Age + ");"); }
public void Delete(Person p) { _session.Execute("DELETE FROM person WHERE id = " + p.Id + ";"); }
public void Update(Person p) { _session.Execute("update person set lname = '" + p.Lname + "', fname = '" + p.Fname + "', age = " + p.Age + " where id = " + p.Id + ";"); }
/// <summary> /// Inserts two URIs in the database as a triplet, whith the predicate SameAs /// </summary> /// <param name="raaPerson">a Person object from Riksantikvarieämbetet</param> /// <param name="librisPerson">a Person object from Libris</param> public void CreateLink(Person raaPerson, Person librisPerson) { const string sql = "insert into content set objecturi = @URI, createdate = @createdate, username = @username, applicationid = @applicationid , relationtype = 'sameAs', relatedto = @relatedto, updatedate = @createdate"; MySqlCommand command = new MySqlCommand { Connection = mySqlConnection, CommandText = sql }; command.Parameters.AddWithValue("@RAAId", raaPerson.URI); command.Parameters.AddWithValue("@URI", raaPerson.URI); command.Parameters.AddWithValue("@createdate", DateTime.Now); command.Parameters.AddWithValue("@username", "UUStudenter"); command.Parameters.AddWithValue("@applicationid", 1212); command.Parameters.AddWithValue("@relatedto", librisPerson.URI); try { mySqlConnection.Open(); command.ExecuteNonQuery(); } finally { mySqlConnection.Close(); RemoveVotes(raaPerson.URI, librisPerson.URI); } }
public void Update(Person p) { var query = Builders<Person>.Filter.Eq("Id", p.Id); var update = Builders<Person>.Update.Set("Lname", p.Lname).Set("Fname", p.Fname).Set("Age", p.Age); _collection.UpdateOne(query, update); }
/// <summary> /// checks if a couple of URIs has bean handled before /// </summary> /// <param name="raaPerson">a Person object from Riksantikvarieämbetet</param> /// <param name="librisPerson">a Person object from Libris</param> /// <returns>true if a match is found</returns> private bool CheckMatchForVoting(Person raaPerson, Person librisPerson) { bool exists = false; const string sql = "SELECT * FROM votecount WHERE RAAId = @raaId && LibrisId = @LibrisId"; MySqlCommand command = new MySqlCommand { Connection = mySqlConnection, CommandText = sql }; command.Parameters.AddWithValue("@raaId", raaPerson.URI); command.Parameters.AddWithValue("@LibrisId", librisPerson.URI); try { mySqlConnection.Open(); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { exists = true; } reader.Close(); } finally { mySqlConnection.Close(); } return exists; }
/// <summary> /// Gets the vote count for a pair of URIs /// </summary> /// <param name="raaPerson">a Person object from Riksantikvarieämbetet</param> /// <param name="librisPerson">a Person object from Libris</param> /// <returns>the nr of votes in a VOTE object</returns> public Votes GetVotes(Person raaPerson, Person librisPerson) { Votes vote = new Votes(); const string sql = "select PositiveVotes, NegativeVotes from votecount where RAAId = @raaId and LibrisId = @librisId "; MySqlCommand command = new MySqlCommand { Connection = mySqlConnection, CommandText = sql }; command.Parameters.AddWithValue("@raaId", raaPerson.URI); command.Parameters.AddWithValue("@librisId", librisPerson.URI); try { mySqlConnection.Open(); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { vote = new Votes(reader.GetInt32(0), reader.GetInt32(1)); } reader.Close(); } catch (MySqlException) { vote = new Votes(); } finally { mySqlConnection.Close(); } return vote; }
/// <summary> /// Gets the list of URIs that are listed as not the same /// </summary> /// <returns>A list of person objects with only URI and sameAs properties</returns> public List<Person> GetListOfNotTheSamePersons() { List<Person> list = new List<Person>(); const string sql = "SELECT RaaId,LibrisId FROM notcorrect"; MySqlCommand command = new MySqlCommand { Connection = mySqlConnection, CommandText = sql }; try { mySqlConnection.Open(); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Person p = new Person { URI = reader.GetString(0), SameAs = new Person { URI = reader.GetString(1) } }; list.Add(p); } reader.Close(); } finally { mySqlConnection.Close(); } return list; }
/// <summary> /// Get a list of all linked entities /// </summary> /// <returns>a List of persons containing libris and RAA URIs</returns> public List<Person> GetListOfLinkedPersons() { List<Person> list = new List<Person>(); const string sql = "select objecturi, relatedto from content"; MySqlCommand command = new MySqlCommand { Connection = mySqlConnection, CommandText = sql }; try { mySqlConnection.Open(); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Person person = new Person { URI = reader.GetString(0) }; Person samePerson = new Person { URI = reader.GetString(1) }; person.SameAs = samePerson; list.Add(person); } reader.Close(); } catch (MySqlException) { list = null; } finally { mySqlConnection.Close(); } return list; }
public void Create(Person p) { _collection.InsertOne(p); }
public void Delete(Person p) { var filter = Builders<Person>.Filter.Eq("Id", p.Id); _collection.DeleteOne(filter); }
/// <summary> /// Adds a connection between two URIs for further voting /// </summary> /// <param name="raaPerson">a Person object from Riksantikvarieämbetet</param> /// <param name="librisPerson">a Person object from Libris</param> private void InsertMatch(Person raaPerson, Person librisPerson) { const string sql = "INSERT into votecount (RAAId, LibrisId) VALUES (@raaId, @LibrisId)"; MySqlCommand command = new MySqlCommand { Connection = mySqlConnection, CommandText = sql }; command.Parameters.AddWithValue("@raaId", raaPerson.URI); command.Parameters.AddWithValue("@LibrisId", librisPerson.URI); try { mySqlConnection.Open(); command.ExecuteNonQuery(); } finally { mySqlConnection.Close(); } }
/// <summary> /// Adds a vote for a couple of URIs as not the same /// </summary> /// <param name="raaPerson">a Person object from Riksantikvarieämbetet</param> /// <param name="librisPerson">a Person object from Libris</param> public void ReportMisstake(Person raaPerson, Person librisPerson) { if (IsLinkReported(raaPerson.URI)) { AddToMisstakeCount(raaPerson.URI); } else { InsertIntoReportedfaults(raaPerson.URI, librisPerson.URI); } }
public void Update(Person p) { try { var query = "update persons set id='" + p.Id + "',last_name='" + p.Lname + "',first_name='" + p.Fname + "',age='" + p.Age + "' where id='" + p.Id + "';"; var myCommand = new MySqlCommand(query, _connection); _connection.Open(); var myReader = myCommand.ExecuteReader(); while (myReader.Read()) { } _connection.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }