public bool UpdatePerson(PersonsEntity entity) { try { bool bOpDoneSuccessfully; using (var repository = new PersonsRepository()) { bOpDoneSuccessfully = repository.Update(entity); } return(bOpDoneSuccessfully); } catch (Exception ex) { //Log exception error _loggingHandler.LogEntry(ExceptionHandler.GetExceptionMessageFormatted(ex), true); throw new Exception("BusinessLogic:PersonsBusiness::UpdatePerson::Error occured.", ex); } }
public PersonsEntity ReadOne(int _id) { PersonsEntity persons = new PersonsEntity(); const string _procedure = "READ_Persons_one"; var(_connection, _command, _transaction) = new ConnectionManager().CreateConnection(_procedure); _command.Parameters.Add(new SqlParameter("@_id", _id)); using (_connection) { try { using (SqlDataReader _dataReader = _command.ExecuteReader()) { while (_dataReader.Read()) { PersonsEntity _person = new PersonsEntity { Id = _dataReader.GetInt32("id"), Name = _dataReader.GetString("name"), Surname = _dataReader.GetString("surname"), Address = _dataReader.GetString("address"), Phone = _dataReader.GetString("phone"), }; persons = _person; } _dataReader.Close(); //_transaction.Commit(); } } catch (Exception ex) { Debug.Write(ex.Message); //_transaction.Rollback(); } } return(persons); }
private void UpdatePerson(int personsid, string firstname, string surname, string gender, string emailaddress, string phonenumber) { try { using (var Persons = new PersonsBusiness()) { var entity = new PersonsEntity(); entity.PersonId = personsid; entity.Firstname = firstname; entity.Surname = surname; entity.Gender = gender; entity.EmailAddress = emailaddress; entity.PhoneNumber = phonenumber; var opSuccessful = Persons.InsertPerson(entity); } } catch (Exception ex) { //Log exception error _loggingHandler.LogEntry(ExceptionHandler.GetExceptionMessageFormatted(ex), true); } }
public IEnumerable <PersonsEntity> Read() { List <PersonsEntity> persons = new List <PersonsEntity>(); const string _procedure = "READ_Persons"; var(_connection, _command, _transaction) = new ConnectionManager().CreateConnection(_procedure); using (_connection) { try { using (SqlDataReader _dataReader = _command.ExecuteReader()) { while (_dataReader.Read()) { PersonsEntity _person = new PersonsEntity { Id = _dataReader.GetInt32("id"), Name = _dataReader.GetString("name"), Surname = _dataReader.GetString("surname"), Address = _dataReader.GetString("address"), Phone = _dataReader.GetString("phone"), }; persons.Add(_person); } _dataReader.Close(); //_transaction.Commit(); } } catch (Exception ex) { Debug.Write(ex.Message); //_transaction.Rollback(); } } return(persons); }