public void GetBeneficiarysPaged_Success_Test()
{
// Arrange
string searchTerm = "";
int pageIndex = 0;
int pageSize = 10;
// list
IList <R_Beneficiary> list = new List <R_Beneficiary>();
for (int i = 1; i <= pageSize; i++)
{
list.Add(SampleBeneficiary(i));
}
// create mock for repository
var mock = new Mock <IBeneficiaryRepository>();
mock.Setup(s => s.GetBeneficiarys(Moq.It.IsAny <string>(), Moq.It.IsAny <int>(), Moq.It.IsAny <int>())).Returns(list);
// service
BeneficiaryService beneficiaryService = new BeneficiaryService();
BeneficiaryService.Repository = mock.Object;
// Act
var resultList = beneficiaryService.GetBeneficiarys(searchTerm, pageIndex, pageSize);
BeneficiaryDTO result = resultList.FirstOrDefault();
// Assert
Assert.IsNotNull(result);
Assert.AreEqual(1, result.BeneficiaryId);
Assert.AreEqual(10, resultList.Count);
}
public BeneficiaryDTO GetBeneficiary(int beneficiaryId)
{
try
{
//Requires.NotNegative("beneficiaryId", beneficiaryId);
log.Debug("beneficiaryId: " + beneficiaryId + " ");
// get
R_Beneficiary t = Repository.GetBeneficiary(beneficiaryId);
BeneficiaryDTO dto = new BeneficiaryDTO(t);
log.Debug(BeneficiaryDTO.FormatBeneficiaryDTO(dto));
return(dto);
}
catch (System.Exception e)
{
// error
log.Error(e.ToString());
throw;
}
}
public void GetBeneficiarys_Success_Test()
{
// Arrange
R_Beneficiary beneficiary = SampleBeneficiary(1);
IList <R_Beneficiary> list = new List <R_Beneficiary>();
list.Add(beneficiary);
// create mock for repository
var mock = new Mock <IBeneficiaryRepository>();
mock.Setup(s => s.GetBeneficiarys()).Returns(list);
// service
BeneficiaryService beneficiaryService = new BeneficiaryService();
BeneficiaryService.Repository = mock.Object;
// Act
var resultList = beneficiaryService.GetBeneficiarys();
BeneficiaryDTO result = resultList.FirstOrDefault();
// Assert
Assert.IsNotNull(result);
Assert.AreEqual(1, result.BeneficiaryId);
}
private BeneficiaryDTO Create(BeneficiaryViewModel viewModel)
{
try
{
log.Debug(BeneficiaryViewModel.FormatBeneficiaryViewModel(viewModel));
BeneficiaryDTO beneficiary = new BeneficiaryDTO();
// copy values
viewModel.UpdateDTO(beneficiary, null); //RequestContext.Principal.Identity.GetUserId());
// audit
beneficiary.CreateBy = null; //RequestContext.Principal.Identity.GetUserId();
beneficiary.CreateOn = DateTime.UtcNow;
// add
log.Debug("_beneficiaryService.AddBeneficiary - " + BeneficiaryDTO.FormatBeneficiaryDTO(beneficiary));
int id = _beneficiaryService.AddBeneficiary(beneficiary);
beneficiary.BeneficiaryId = id;
log.Debug("result: 'success', id: " + id);
return(beneficiary);
}
catch (Exception e)
{
// error
log.Error(e.ToString());
throw;
}
}
public int AddBeneficiary(BeneficiaryDTO dto)
{
int id = 0;
try
{
log.Debug(BeneficiaryDTO.FormatBeneficiaryDTO(dto));
R_Beneficiary t = BeneficiaryDTO.ConvertDTOtoEntity(dto);
// add
id = Repository.AddBeneficiary(t);
dto.BeneficiaryId = id;
log.Debug("result: 'success', id: " + id);
}
catch (System.Exception e)
{
// error
log.Error(e.ToString());
throw;
}
return(id);
}
/// <summary>
/// Recupera los datos de un beneficiario.
/// </summary>
/// <param name="beneficiaryId"></param>
/// <returns></returns>
public ResultBM GetBeneficiary(int beneficiaryId)
{
try
{
AddressBLL addressBll = new AddressBLL();
ResultBM addressResult = null;
BeneficiaryDAL beneficiaryDal = new BeneficiaryDAL();
BeneficiaryBM beneficiaryBm = null;
BeneficiaryDTO beneficiaryDto = beneficiaryDal.GetBeneficiary(beneficiaryId);
if (beneficiaryDto != null)
{
addressResult = addressBll.GetAddress(beneficiaryDto.addressId);
//Si hubo algún problema o la dirección no existe, entonces hay que devolver el resultado o lanzar una excepción (debería eixstir)
if (!addressResult.IsValid())
{
return(addressResult);
}
if (addressResult.GetValue() == null)
{
throw new Exception(SessionHelper.GetTranslation("RETRIEVING_ERROR") + " addressId " + beneficiaryDto.addressId);
}
beneficiaryBm = new BeneficiaryBM(beneficiaryDto, addressResult.GetValue <AddressBM>());
}
return(new ResultBM(ResultBM.Type.OK, "Operación exitosa.", beneficiaryBm));
}
catch (Exception exception)
{
return(new ResultBM(ResultBM.Type.EXCEPTION, SessionHelper.GetTranslation("RETRIEVING_ERROR") + " " + exception.Message, exception));
}
}
/// <summary>
/// Crea un beneficiario.
/// </summary>
/// <param name="beneficieryBm"></param>
/// <returns></returns>
public ResultBM SaveBeneficiary(BeneficiaryBM beneficieryBm)
{
try
{
BeneficiaryDAL beneficiaryDal = new BeneficiaryDAL();
PersonBLL personBll = new PersonBLL();
PersonBM personBm = null;
ResultBM validationResult; //agregar validación
ResultBM personResult;
BeneficiaryDTO beneficiaryDto;
// El validador no es necesario porque los datos sustanciales pertenecen a la persona
personResult = personBll.SavePerson(beneficieryBm);
if (!personResult.IsValid())
{
return(personResult);
}
personBm = personResult.GetValue() as PersonBM;
beneficiaryDto = new BeneficiaryDTO(personBm.id, beneficieryBm.beneficiaryId, beneficieryBm.destination, beneficieryBm.ages, beneficieryBm.health, beneficieryBm.accessibility, beneficieryBm.majorProblem);
beneficiaryDal.SaveBeneficiary(beneficiaryDto);
beneficieryBm.beneficiaryId = beneficiaryDto.beneficiaryId;
return(new ResultBM(ResultBM.Type.OK, "Se ha creado el beneficiario " + beneficieryBm.name + " " + beneficieryBm.lastName + ".", beneficieryBm));
}
catch (Exception exception)
{
return(new ResultBM(ResultBM.Type.EXCEPTION, SessionHelper.GetTranslation("SAVING_ERROR") + " " + exception.Message, exception));
}
}
public BeneficiaryBM(BeneficiaryDTO beneficiaryDto, AddressBM address = null) : base(beneficiaryDto, address)
{
this.beneficiaryId = beneficiaryDto.beneficiaryId;
this.destination = beneficiaryDto.destination;
this.ages = beneficiaryDto.ages;
this.health = beneficiaryDto.health;
this.accessibility = beneficiaryDto.accessibility;
this.majorProblem = beneficiaryDto.majorProblem;
this.address = address;
}
public bool UpdateDonor(BeneficiaryDTO beneficiaryDto)
{
DBSql dbsql = new DBSql();
String sql;
sql = "UPDATE beneficiary SET ";
sql += "personId = " + beneficiaryDto.id + ", ";
sql += "destination = " + beneficiaryDto.destination + ", ";
sql += "ages = " + beneficiaryDto.ages + ", ";
sql += "health = " + beneficiaryDto.health + ", ";
sql += "accessibility = " + beneficiaryDto.accessibility + ", ";
sql += "majorProblem = " + beneficiaryDto.majorProblem + " ";
sql += "WHERE id = " + beneficiaryDto.beneficiaryId;
dbsql.ExecuteNonQuery(sql);
return(true);
}
public bool SaveBeneficiary(BeneficiaryDTO beneficiaryDto)
{
DBSql dbsql = new DBSql();
String sql;
sql = "INSERT INTO beneficiary (personId, destination, ages, health, accessibility, majorProblem) VALUES (";
sql += beneficiaryDto.id + ", ";
sql += beneficiaryDto.destination + ", ";
sql += beneficiaryDto.ages + ", ";
sql += beneficiaryDto.health + ", ";
sql += beneficiaryDto.accessibility + ", ";
sql += beneficiaryDto.majorProblem + " ";
sql += ");SELECT @@IDENTITY";
beneficiaryDto.beneficiaryId = dbsql.ExecuteNonQuery(sql);
return(true);
}
public BeneficiaryViewModel(BeneficiaryDTO t)
{
BeneficiaryId = t.BeneficiaryId;
Name = t.Name;
Number = t.Number;
AddressId = t.AddressId;
NumberOfAdults = t.NumberOfAdults;
NumberOfChildren = t.NumberOfChildren;
NumberOfTupperware = t.NumberOfTupperware;
NumberOfSoups = t.NumberOfSoups;
Description = t.Description;
Active = t.Active;
IsDeleted = t.IsDeleted;
CreateBy = t.CreateBy;
CreateOn = t.CreateOn;
UpdateBy = t.UpdateBy;
UpdateOn = t.UpdateOn;
}
private BeneficiaryDTO Resolve(List <String> item)
{
BeneficiaryDTO result = new BeneficiaryDTO();
result.id = int.Parse(item[0]);
result.name = item[1];
result.lastName = item[2];
result.birthdate = DateTime.Parse(item[3]);
result.email = item[4];
result.phone = item[5];
result.gender = Char.Parse(item[6]);
result.dni = int.Parse(item[7]);
result.addressId = int.Parse(item[8]);
result.beneficiaryId = int.Parse(item[9]);
result.destination = int.Parse(item[10]);
result.ages = int.Parse(item[11]);
result.health = int.Parse(item[12]);
result.accessibility = int.Parse(item[13]);
result.majorProblem = int.Parse(item[14]);
return(result);
}
public void UpdateBeneficiary_Success_Test()
{
// Arrange
BeneficiaryDTO dto = SampleBeneficiaryDTO(1);
// create mock for repository
var mock = new Mock <IBeneficiaryRepository>();
mock.Setup(s => s.UpdateBeneficiary(Moq.It.IsAny <R_Beneficiary>())).Verifiable();
// service
BeneficiaryService beneficiaryService = new BeneficiaryService();
BeneficiaryService.Repository = mock.Object;
// Act
beneficiaryService.UpdateBeneficiary(dto);
// Assert
Assert.IsNotNull(dto);
}
private BeneficiaryDTO Update(BeneficiaryViewModel viewModel)
{
try
{
log.Debug(BeneficiaryViewModel.FormatBeneficiaryViewModel(viewModel));
// get
log.Debug("_beneficiaryService.GetBeneficiary - beneficiaryId: " + viewModel.BeneficiaryId + " ");
var existingBeneficiary = _beneficiaryService.GetBeneficiary(viewModel.BeneficiaryId);
log.Debug("_beneficiaryService.GetBeneficiary - " + BeneficiaryDTO.FormatBeneficiaryDTO(existingBeneficiary));
if (existingBeneficiary != null)
{
// copy values
viewModel.UpdateDTO(existingBeneficiary, null); //RequestContext.Principal.Identity.GetUserId());
// update
log.Debug("_beneficiaryService.UpdateBeneficiary - " + BeneficiaryDTO.FormatBeneficiaryDTO(existingBeneficiary));
_beneficiaryService.UpdateBeneficiary(existingBeneficiary);
log.Debug("result: 'success'");
}
else
{
log.Error("existingBeneficiary: null, BeneficiaryId: " + viewModel.BeneficiaryId);
}
return(existingBeneficiary);
}
catch (Exception e)
{
// error
log.Error(e.ToString());
throw;
}
}
public void DeleteBeneficiary(BeneficiaryDTO dto)
{
try
{
log.Debug(BeneficiaryDTO.FormatBeneficiaryDTO(dto));
R_Beneficiary t = BeneficiaryDTO.ConvertDTOtoEntity(dto);
// delete
Repository.DeleteBeneficiary(t);
dto.IsDeleted = t.IsDeleted;
log.Debug("result: 'success'");
}
catch (System.Exception e)
{
// error
log.Error(e.ToString());
throw;
}
}
public void AddBeneficiary_Success_Test()
{
// Arrange
BeneficiaryDTO dto = SampleBeneficiaryDTO(1);
// create mock for repository
var mock = new Mock <IBeneficiaryRepository>();
mock.Setup(s => s.AddBeneficiary(Moq.It.IsAny <R_Beneficiary>())).Returns(1);
// service
BeneficiaryService beneficiaryService = new BeneficiaryService();
BeneficiaryService.Repository = mock.Object;
// Act
int id = beneficiaryService.AddBeneficiary(dto);
// Assert
Assert.AreEqual(1, id);
Assert.AreEqual(1, dto.BeneficiaryId);
}
public BeneficiaryDTO UpdateDTO(BeneficiaryDTO dto, int?updateBy)
{
if (dto != null)
{
dto.BeneficiaryId = this.BeneficiaryId;
dto.Name = this.Name;
dto.Number = this.Number;
dto.AddressId = this.AddressId;
dto.NumberOfAdults = this.NumberOfAdults;
dto.NumberOfChildren = this.NumberOfChildren;
dto.NumberOfTupperware = this.NumberOfTupperware;
dto.NumberOfSoups = this.NumberOfSoups;
dto.Description = this.Description;
dto.Active = this.Active;
dto.IsDeleted = this.IsDeleted;
dto.UpdateBy = updateBy;
dto.UpdateOn = System.DateTime.UtcNow;
}
return(dto);
}
public void GetBeneficiary_Success_Test()
{
// Arrange
int id = 1;
R_Beneficiary beneficiary = SampleBeneficiary(id);
// create mock for repository
var mock = new Mock <IBeneficiaryRepository>();
mock.Setup(s => s.GetBeneficiary(Moq.It.IsAny <int>())).Returns(beneficiary);
// service
BeneficiaryService beneficiaryService = new BeneficiaryService();
BeneficiaryService.Repository = mock.Object;
// Act
BeneficiaryDTO result = beneficiaryService.GetBeneficiary(id);
// Assert
Assert.IsNotNull(result);
Assert.AreEqual(1, result.BeneficiaryId);
}
public static BeneficiaryDTO SampleBeneficiaryDTO(int id = 1)
{
BeneficiaryDTO beneficiary = new BeneficiaryDTO();
// int
beneficiary.BeneficiaryId = id;
// string
beneficiary.Name = "NameTestValue";
// int?
beneficiary.Number = 1;
// int?
beneficiary.AddressId = 1;
// int?
beneficiary.NumberOfAdults = 1;
// int?
beneficiary.NumberOfChildren = 1;
// int?
beneficiary.NumberOfTupperware = 1;
// int?
beneficiary.NumberOfSoups = 1;
// string
beneficiary.Description = "DescriptionTestValue";
// bool
beneficiary.Active = false;
// bool
beneficiary.IsDeleted = false;
// int?
beneficiary.CreateBy = 1;
// System.DateTime?
beneficiary.CreateOn = new System.DateTime();
// int?
beneficiary.UpdateBy = 1;
// System.DateTime?
beneficiary.UpdateOn = new System.DateTime();
return(beneficiary);
}
public void UpdateBeneficiary(BeneficiaryDTO dto)
{
try
{
//Requires.NotNull(t);
//Requires.PropertyNotNegative(t, "BeneficiaryId");
log.Debug(BeneficiaryDTO.FormatBeneficiaryDTO(dto));
R_Beneficiary t = BeneficiaryDTO.ConvertDTOtoEntity(dto);
// update
Repository.UpdateBeneficiary(t);
log.Debug("result: 'success'");
}
catch (System.Exception e)
{
// error
log.Error(e.ToString());
throw;
}
}
//No está bueno esto, pero me permite recuperar las direcciones. Poco performante... pero no hay tiempo.
private AddressBM GetAddress(BeneficiaryDTO beneficiary)
{
ResultBM addressResult = new AddressBLL().GetAddress(beneficiary.addressId);
return(addressResult.GetValue <AddressBM>());
}
public void GetBeneficiaryListAdvancedSearch_Success_Test()
{
// Arrange
string name = null;
int? number = null;
int? addressId = null;
int? numberOfAdults = null;
int? numberOfChildren = null;
int? numberOfTupperware = null;
int? numberOfSoups = null;
string description = null;
bool? active = null;
//int pageIndex = 0;
int pageSize = 10;
// list
IList <R_Beneficiary> list = new List <R_Beneficiary>();
for (int i = 1; i <= pageSize; i++)
{
list.Add(SampleBeneficiary(i));
}
// create mock for repository
var mock = new Mock <IBeneficiaryRepository>();
mock.Setup(s => s.GetBeneficiaryListAdvancedSearch(
Moq.It.IsAny <string>() // name
, Moq.It.IsAny <int?>() // number
, Moq.It.IsAny <int?>() // addressId
, Moq.It.IsAny <int?>() // numberOfAdults
, Moq.It.IsAny <int?>() // numberOfChildren
, Moq.It.IsAny <int?>() // numberOfTupperware
, Moq.It.IsAny <int?>() // numberOfSoups
, Moq.It.IsAny <string>() // description
, Moq.It.IsAny <bool?>() // active
)).Returns(list);
// service
BeneficiaryService beneficiaryService = new BeneficiaryService();
BeneficiaryService.Repository = mock.Object;
// Act
var resultList = beneficiaryService.GetBeneficiaryListAdvancedSearch(
name
, number
, addressId
, numberOfAdults
, numberOfChildren
, numberOfTupperware
, numberOfSoups
, description
, active
);
BeneficiaryDTO result = resultList.FirstOrDefault();
// Assert
Assert.IsNotNull(result);
Assert.AreEqual(1, result.BeneficiaryId);
}
