public void Should_ConvertPersonObject_ToString() { Person person = new Person(); Parser parser = new Parser(); person.Id = 1; person.CityId = 8; person.FIO = "Ivanov Petr Olegovich"; string res = parser.AddPersonEncode(person); Assert.AreEqual(res,"#12#1#8#Ivanov Petr Olegovich"); }
public string SendPerson() { Person person = new Person(); DBActions dbActions = new DBActions(); string msg = ""; string table = "People"; int lastId = dbActions.LastId(table); person = dbActions.GetPerson(lastId); msg = dbActions.PersonAdd(person); string delRes = dbActions.DeleteLocal(lastId, table); if (delRes != Resources.Success) { msg = string.Concat("Deletion from local DB failed: ", delRes); } DBActions.CheckPeopleEmptiness(); return msg; }
private void AddPeopleButton_Click(object sender, EventArgs e) { InputSanitizer inputSanitizer = new InputSanitizer(); Person addedPerson = new Person(); addedPerson.FIO = inputSanitizer.Names(FIOTextBox.Text); try { addedPerson.CityId = Convert.ToInt32(inputSanitizer.DigitsOnly(CityIDTextBox.Text)); DBActions dbActions = new DBActions(); string res = dbActions.PersonAdd(addedPerson); MessageBox.Show(res, "Client message"); } catch (Exception ex) { MessageBox.Show(Resources.IdIncorrect + ex.Message); } }
private void ChangePersonButton_Click(object sender, EventArgs e) { Person changedPerson = new Person(); DBActions dbActions = new DBActions(); InputSanitizer inputSanitizer = new InputSanitizer(); try { changedPerson.Id = Convert.ToInt32(inputSanitizer.DigitsOnly(IDTexbBox.Text)); changedPerson.CityId = Convert.ToInt32(inputSanitizer.DigitsOnly(CityIDTextBox.Text)); changedPerson.FIO = inputSanitizer.Names(FIOTextBox.Text); string msg = dbActions.PersonEdit(changedPerson); MessageBox.Show(msg, "Client message"); } catch(Exception ex) { MessageBox.Show(Resources.IdIncorrect + ex.Message); } }
public string PersonEdit(Person changedPerson) { string msg = ""; if (ConnectionCheck()) { msg = connectionEstablisherClient.MakeConnect(parser.EditPersonEncode(changedPerson),goodIP); } else { msg = Resources.NoConnectionToServer; } return msg; }
public string PersonAdd(Person addedPerson) { string msg = ""; if (ConnectionCheck()) { msg = connectionEstablisherClient.MakeConnect(parser.AddPersonEncode(addedPerson),goodIP); } else { using (OleDbConnection localConn = new OleDbConnection(ConnString)) { string sql = "insert into People(Id, CityId, FIO) values (?,?,?)"; int newID = LastId("People") + 1; using (OleDbCommand command = new OleDbCommand(sql, localConn)) { localConn.Open(); command.Parameters.AddWithValue("Id", newID); command.Parameters.AddWithValue("CityId", addedPerson.CityId.ToString()); command.Parameters.AddWithValue("FIO", addedPerson.FIO); command.ExecuteNonQuery(); newID++; msg = Resources.Success; } } } return msg; }
public Person GetPerson(int id) { Person person = new Person(); string sql = "select top 1 Id, CityId, Fio from People where id=@id"; using (OleDbConnection connection = new OleDbConnection(ConnString)) { using (OleDbCommand command = new OleDbCommand(sql, connection)) { connection.Open(); command.Parameters.AddWithValue("@id", id); using (OleDbDataReader dataReader = command.ExecuteReader()) { while (dataReader.Read()) { person.Id = (int) dataReader[0]; person.CityId = (int) dataReader[1]; person.FIO = (string) dataReader[2]; } } } } return person; }
public string EditPersonEncode(Person person) { string ret = string.Concat("#13#", person.Id.ToString(), delimiter, person.CityId.ToString(), delimiter, person.FIO); return ret; }