public void UpdateAddress(R_Address t)
{
//Requires.NotNull(t);
//Requires.PropertyNotNegative(t, "AddressId");
t.Update();
}
public void GetAddresss_Success_Test()
{
// Arrange
R_Address address = SampleAddress(1);
IList <R_Address> list = new List <R_Address>();
list.Add(address);
// create mock for repository
var mock = new Mock <IAddressRepository>();
mock.Setup(s => s.GetAddresss()).Returns(list);
// service
AddressService addressService = new AddressService();
AddressService.Repository = mock.Object;
// Act
var resultList = addressService.GetAddresss();
AddressDTO result = resultList.FirstOrDefault();
// Assert
Assert.IsNotNull(result);
Assert.AreEqual(1, result.AddressId);
}
public AddressDTO GetAddress(int addressId)
{
try
{
//Requires.NotNegative("addressId", addressId);
log.Debug("addressId: " + addressId + " ");
// get
R_Address t = Repository.GetAddress(addressId);
AddressDTO dto = new AddressDTO(t);
log.Debug(AddressDTO.FormatAddressDTO(dto));
return(dto);
}
catch (System.Exception e)
{
// error
log.Error(e.ToString());
throw;
}
}
public int AddAddress(AddressDTO dto)
{
int id = 0;
try
{
log.Debug(AddressDTO.FormatAddressDTO(dto));
R_Address t = AddressDTO.ConvertDTOtoEntity(dto);
// add
id = Repository.AddAddress(t);
dto.AddressId = id;
log.Debug("result: 'success', id: " + id);
}
catch (System.Exception e)
{
// error
log.Error(e.ToString());
throw;
}
return(id);
}
public R_Address GetAddress(int addressId)
{
//Requires.NotNegative("addressId", addressId);
R_Address t = R_Address.SingleOrDefault(addressId);
return(t);
}
public IEnumerable <R_Address> GetAddresss()
{
IEnumerable <R_Address> results = null;
var sql = PetaPoco.Sql.Builder
.Select("*")
.From("R_Address")
.Where("IsDeleted = 0")
;
results = R_Address.Query(sql);
return(results);
}
public IList <R_Address> GetAddresss(string searchTerm, int pageIndex, int pageSize)
{
IList <R_Address> results = null;
var sql = PetaPoco.Sql.Builder
.Select("*")
.From("R_Address")
.Where("IsDeleted = 0")
.Where(
"Name like '%" + searchTerm + "%'"
+ " or " + "AddressFirstLine like '%" + searchTerm + "%'"
+ " or " + "AddressSecondLine like '%" + searchTerm + "%'"
+ " or " + "ZipCode like '%" + searchTerm + "%'"
)
;
results = R_Address.Fetch(pageIndex, pageSize, sql);
return(results);
}
public AddressDTO(R_Address address)
{
AddressId = address.AddressId;
Name = address.Name;
AddressFirstLine = address.AddressFirstLine;
AddressSecondLine = address.AddressSecondLine;
CountryId = address.CountryId;
DistrictId = address.DistrictId;
CountyId = address.CountyId;
ParishId = address.ParishId;
ZipCode = address.ZipCode;
Latitude = address.Latitude;
Longitude = address.Longitude;
Active = address.Active;
IsDeleted = address.IsDeleted;
CreateBy = address.CreateBy;
CreateOn = address.CreateOn;
UpdateBy = address.UpdateBy;
UpdateOn = address.UpdateOn;
}
// example data
public static R_Address SampleAddress(int id = 1)
{
R_Address address = new R_Address();
// int
address.AddressId = id;
// string
address.Name = "NameTestValue";
// string
address.AddressFirstLine = "AddressFirstLineTestValue";
// string
address.AddressSecondLine = "AddressSecondLineTestValue";
// int?
address.CountryId = 1;
// int?
address.DistrictId = 1;
// int?
address.CountyId = 1;
// int?
address.ParishId = 1;
// string
address.ZipCode = "ZipCodeTestValue";
// double?
address.Latitude = 1;
// double?
address.Longitude = 1;
// bool
address.Active = false;
// bool
address.IsDeleted = false;
// int?
address.CreateBy = 1;
// System.DateTime?
address.CreateOn = new System.DateTime();
// int?
address.UpdateBy = 1;
// System.DateTime?
address.UpdateOn = new System.DateTime();
return(address);
}
public void DeleteAddress(AddressDTO dto)
{
try
{
log.Debug(AddressDTO.FormatAddressDTO(dto));
R_Address t = AddressDTO.ConvertDTOtoEntity(dto);
// delete
Repository.DeleteAddress(t);
dto.IsDeleted = t.IsDeleted;
log.Debug("result: 'success'");
}
catch (System.Exception e)
{
// error
log.Error(e.ToString());
throw;
}
}
public IEnumerable <R_Address> GetAddressListAdvancedSearch(
string name
, string addressFirstLine
, string addressSecondLine
, int?countryId
, int?districtId
, int?countyId
, int?parishId
, string zipCode
, double?latitude
, double?longitude
, bool?active
)
{
IEnumerable <R_Address> results = null;
var sql = PetaPoco.Sql.Builder
.Select("*")
.From("R_Address")
.Where("IsDeleted = 0"
+ (name != null ? " and Name like '%" + name + "%'" : "")
+ (addressFirstLine != null ? " and AddressFirstLine like '%" + addressFirstLine + "%'" : "")
+ (addressSecondLine != null ? " and AddressSecondLine like '%" + addressSecondLine + "%'" : "")
+ (countryId != null ? " and CountryId like '%" + countryId + "%'" : "")
+ (districtId != null ? " and DistrictId like '%" + districtId + "%'" : "")
+ (countyId != null ? " and CountyId like '%" + countyId + "%'" : "")
+ (parishId != null ? " and ParishId like '%" + parishId + "%'" : "")
+ (zipCode != null ? " and ZipCode like '%" + zipCode + "%'" : "")
+ (latitude != null ? " and Latitude like '%" + latitude + "%'" : "")
+ (longitude != null ? " and Longitude like '%" + longitude + "%'" : "")
+ (active != null ? " and Active = " + (active == true ? "1" : "0") : "")
)
;
results = R_Address.Query(sql);
return(results);
}
public void GetAddress_Success_Test()
{
// Arrange
int id = 1;
R_Address address = SampleAddress(id);
// create mock for repository
var mock = new Mock <IAddressRepository>();
mock.Setup(s => s.GetAddress(Moq.It.IsAny <int>())).Returns(address);
// service
AddressService addressService = new AddressService();
AddressService.Repository = mock.Object;
// Act
AddressDTO result = addressService.GetAddress(id);
// Assert
Assert.IsNotNull(result);
Assert.AreEqual(1, result.AddressId);
}
public void UpdateAddress(AddressDTO dto)
{
try
{
//Requires.NotNull(t);
//Requires.PropertyNotNegative(t, "AddressId");
log.Debug(AddressDTO.FormatAddressDTO(dto));
R_Address t = AddressDTO.ConvertDTOtoEntity(dto);
// update
Repository.UpdateAddress(t);
log.Debug("result: 'success'");
}
catch (System.Exception e)
{
// error
log.Error(e.ToString());
throw;
}
}
public static R_Address ConvertDTOtoEntity(AddressDTO dto)
{
R_Address address = new R_Address();
address.AddressId = dto.AddressId;
address.Name = dto.Name;
address.AddressFirstLine = dto.AddressFirstLine;
address.AddressSecondLine = dto.AddressSecondLine;
address.CountryId = dto.CountryId;
address.DistrictId = dto.DistrictId;
address.CountyId = dto.CountyId;
address.ParishId = dto.ParishId;
address.ZipCode = dto.ZipCode;
address.Latitude = dto.Latitude;
address.Longitude = dto.Longitude;
address.Active = dto.Active;
address.IsDeleted = dto.IsDeleted;
address.CreateBy = dto.CreateBy;
address.CreateOn = dto.CreateOn;
address.UpdateBy = dto.UpdateBy;
address.UpdateOn = dto.UpdateOn;
return(address);
}
public void DeleteAddress(R_Address t)
{
t.IsDeleted = true;
t.Update();
}
public int AddAddress(R_Address t)
{
int id = (int)t.Insert();
return(id);
}
