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);
}
}
