internal bool AddPerson(Person addedPerson)
{
string personAddSQL = @"insert into People (CityId, FIO) values (?,?)";
try
{
using (SqlConnection connection = new SqlConnection(SQLConnStr))
{
using (SqlCommand command = new SqlCommand(personAddSQL,connection))
{
connection.Open();
command.Parameters.AddWithValue("CityId", addedPerson.CityId);
command.Parameters.AddWithValue("FIO", addedPerson.FIO);
command.ExecuteNonQuery();
}
}
return true;
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
return false;
}
}
internal bool EditPerson(int id, Person changedPerson)
{
string personEditSQL = string.Concat("update People set CityId=@CityId, FIO=@FIO where Id=",id.ToString());
try
{
using (SqlConnection connection = new SqlConnection(SQLConnStr))
{
using (SqlCommand command = new SqlCommand(personEditSQL,connection))
{
connection.Open();
command.Parameters.AddWithValue("@CityId", changedPerson.CityId);
command.Parameters.AddWithValue("@FIO", changedPerson.FIO);
command.ExecuteNonQuery();
}
}
return true;
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
return false;
}
}
public Person DecodePerson(string personInput)
{
Person person = new Person();
string[] personInputSplit = personInput.Split(delimiter);
person.Id = Convert.ToInt32(personInputSplit[2]);
person.CityId = Convert.ToInt32(personInputSplit[3]);
person.FIO = personInputSplit[4];
return person;
}