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