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);
}
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 IEnumerable <R_Beneficiary> GetBeneficiaryListAdvancedSearch(
string name
, int?number
, int?addressId
, int?numberOfAdults
, int?numberOfChildren
, int?numberOfTupperware
, int?numberOfSoups
, string description
, bool?active
)
{
IEnumerable <R_Beneficiary> results = null;
var sql = PetaPoco.Sql.Builder
.Select("*")
.From("R_Beneficiary")
.Where("IsDeleted = 0"
+ (name != null ? " and Name like '%" + name + "%'" : "")
+ (number != null ? " and Number like '%" + number + "%'" : "")
+ (addressId != null ? " and AddressId like '%" + addressId + "%'" : "")
+ (numberOfAdults != null ? " and NumberOfAdults like '%" + numberOfAdults + "%'" : "")
+ (numberOfChildren != null ? " and NumberOfChildren like '%" + numberOfChildren + "%'" : "")
+ (numberOfTupperware != null ? " and NumberOfTupperware like '%" + numberOfTupperware + "%'" : "")
+ (numberOfSoups != null ? " and NumberOfSoups like '%" + numberOfSoups + "%'" : "")
+ (description != null ? " and Description like '%" + description + "%'" : "")
+ (active != null ? " and Active = " + (active == true ? "1" : "0") : "")
)
;
results = R_Beneficiary.Query(sql);
return(results);
}
public void UpdateBeneficiary(R_Beneficiary t)
{
//Requires.NotNull(t);
//Requires.PropertyNotNegative(t, "BeneficiaryId");
t.Update();
}
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);
}
public R_Beneficiary GetBeneficiary(int beneficiaryId)
{
//Requires.NotNegative("beneficiaryId", beneficiaryId);
R_Beneficiary t = R_Beneficiary.SingleOrDefault(beneficiaryId);
return(t);
}
public IEnumerable <R_Beneficiary> GetBeneficiarys()
{
IEnumerable <R_Beneficiary> results = null;
var sql = PetaPoco.Sql.Builder
.Select("*")
.From("R_Beneficiary")
.Where("IsDeleted = 0")
;
results = R_Beneficiary.Query(sql);
return(results);
}
public IList <R_Beneficiary> GetBeneficiarys(string searchTerm, int pageIndex, int pageSize)
{
IList <R_Beneficiary> results = null;
var sql = PetaPoco.Sql.Builder
.Select("*")
.From("R_Beneficiary")
.Where("IsDeleted = 0")
.Where(
"Name like '%" + searchTerm + "%'"
+ " or " + "Description like '%" + searchTerm + "%'"
)
;
results = R_Beneficiary.Fetch(pageIndex, pageSize, sql);
return(results);
}
public BeneficiaryDTO(R_Beneficiary beneficiary)
{
BeneficiaryId = beneficiary.BeneficiaryId;
Name = beneficiary.Name;
Number = beneficiary.Number;
AddressId = beneficiary.AddressId;
NumberOfAdults = beneficiary.NumberOfAdults;
NumberOfChildren = beneficiary.NumberOfChildren;
NumberOfTupperware = beneficiary.NumberOfTupperware;
NumberOfSoups = beneficiary.NumberOfSoups;
Description = beneficiary.Description;
Active = beneficiary.Active;
IsDeleted = beneficiary.IsDeleted;
CreateBy = beneficiary.CreateBy;
CreateOn = beneficiary.CreateOn;
UpdateBy = beneficiary.UpdateBy;
UpdateOn = beneficiary.UpdateOn;
}
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 static R_Beneficiary ConvertDTOtoEntity(BeneficiaryDTO dto)
{
R_Beneficiary beneficiary = new R_Beneficiary();
beneficiary.BeneficiaryId = dto.BeneficiaryId;
beneficiary.Name = dto.Name;
beneficiary.Number = dto.Number;
beneficiary.AddressId = dto.AddressId;
beneficiary.NumberOfAdults = dto.NumberOfAdults;
beneficiary.NumberOfChildren = dto.NumberOfChildren;
beneficiary.NumberOfTupperware = dto.NumberOfTupperware;
beneficiary.NumberOfSoups = dto.NumberOfSoups;
beneficiary.Description = dto.Description;
beneficiary.Active = dto.Active;
beneficiary.IsDeleted = dto.IsDeleted;
beneficiary.CreateBy = dto.CreateBy;
beneficiary.CreateOn = dto.CreateOn;
beneficiary.UpdateBy = dto.UpdateBy;
beneficiary.UpdateOn = dto.UpdateOn;
return(beneficiary);
}
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);
}
// example data
public static R_Beneficiary SampleBeneficiary(int id = 1)
{
R_Beneficiary beneficiary = new R_Beneficiary();
// 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;
}
}
public void DeleteBeneficiary(R_Beneficiary t)
{
t.IsDeleted = true;
t.Update();
}
public int AddBeneficiary(R_Beneficiary t)
{
int id = (int)t.Insert();
return(id);
}
