public void GetProjectPartners_Success_Test()
{
// Arrange
R_ProjectPartner projectPartner = SampleProjectPartner(1);
IList <R_ProjectPartner> list = new List <R_ProjectPartner>();
list.Add(projectPartner);
// create mock for repository
var mock = new Mock <IProjectPartnerRepository>();
mock.Setup(s => s.GetProjectPartners()).Returns(list);
// service
ProjectPartnerService projectPartnerService = new ProjectPartnerService();
ProjectPartnerService.Repository = mock.Object;
// Act
var resultList = projectPartnerService.GetProjectPartners();
ProjectPartnerDTO result = resultList.FirstOrDefault();
// Assert
Assert.IsNotNull(result);
Assert.AreEqual(1, result.ProjectPartnerId);
}
// example data
public static R_ProjectPartner SampleProjectPartner(int id = 1)
{
R_ProjectPartner projectPartner = new R_ProjectPartner();
// int
projectPartner.ProjectPartnerId = id;
// int
projectPartner.ProjectId = 1;
// int
projectPartner.PartnerId = 1;
// double?
projectPartner.GrantValue = 1;
// bool
projectPartner.IsDeleted = false;
// int?
projectPartner.CreateBy = 1;
// System.DateTime?
projectPartner.CreateOn = new System.DateTime();
// int?
projectPartner.UpdateBy = 1;
// System.DateTime?
projectPartner.UpdateOn = new System.DateTime();
return(projectPartner);
}
public void UpdateProjectPartner(R_ProjectPartner t)
{
//Requires.NotNull(t);
//Requires.PropertyNotNegative(t, "ProjectPartnerId");
t.Update();
}
public ProjectPartnerDTO GetProjectPartner(int projectPartnerId)
{
try
{
//Requires.NotNegative("projectPartnerId", projectPartnerId);
log.Debug("projectPartnerId: " + projectPartnerId + " ");
// get
R_ProjectPartner t = Repository.GetProjectPartner(projectPartnerId);
ProjectPartnerDTO dto = new ProjectPartnerDTO(t);
log.Debug(ProjectPartnerDTO.FormatProjectPartnerDTO(dto));
return(dto);
}
catch (System.Exception e)
{
// error
log.Error(e.ToString());
throw;
}
}
public int AddProjectPartner(ProjectPartnerDTO dto)
{
int id = 0;
try
{
log.Debug(ProjectPartnerDTO.FormatProjectPartnerDTO(dto));
R_ProjectPartner t = ProjectPartnerDTO.ConvertDTOtoEntity(dto);
// add
id = Repository.AddProjectPartner(t);
dto.ProjectPartnerId = id;
log.Debug("result: 'success', id: " + id);
}
catch (System.Exception e)
{
// error
log.Error(e.ToString());
throw;
}
return(id);
}
public R_ProjectPartner GetProjectPartner(int projectPartnerId)
{
//Requires.NotNegative("projectPartnerId", projectPartnerId);
R_ProjectPartner t = R_ProjectPartner.SingleOrDefault(projectPartnerId);
return(t);
}
public ProjectPartnerDTO(R_ProjectPartner projectPartner)
{
ProjectPartnerId = projectPartner.ProjectPartnerId;
ProjectId = projectPartner.ProjectId;
PartnerId = projectPartner.PartnerId;
GrantValue = projectPartner.GrantValue;
IsDeleted = projectPartner.IsDeleted;
CreateBy = projectPartner.CreateBy;
CreateOn = projectPartner.CreateOn;
UpdateBy = projectPartner.UpdateBy;
UpdateOn = projectPartner.UpdateOn;
}
public IList <R_ProjectPartner> GetProjectPartners(string searchTerm, int pageIndex, int pageSize)
{
IList <R_ProjectPartner> results = null;
var sql = PetaPoco.Sql.Builder
.Select("*")
.From("R_ProjectPartner")
.Where("IsDeleted = 0")
;
results = R_ProjectPartner.Fetch(pageIndex, pageSize, sql);
return(results);
}
public IEnumerable <R_ProjectPartner> GetProjectPartners()
{
IEnumerable <R_ProjectPartner> results = null;
var sql = PetaPoco.Sql.Builder
.Select("*")
.From("R_ProjectPartner")
.Where("IsDeleted = 0")
;
results = R_ProjectPartner.Query(sql);
return(results);
}
public static R_ProjectPartner ConvertDTOtoEntity(ProjectPartnerDTO dto)
{
R_ProjectPartner projectPartner = new R_ProjectPartner();
projectPartner.ProjectPartnerId = dto.ProjectPartnerId;
projectPartner.ProjectId = dto.ProjectId;
projectPartner.PartnerId = dto.PartnerId;
projectPartner.GrantValue = dto.GrantValue;
projectPartner.IsDeleted = dto.IsDeleted;
projectPartner.CreateBy = dto.CreateBy;
projectPartner.CreateOn = dto.CreateOn;
projectPartner.UpdateBy = dto.UpdateBy;
projectPartner.UpdateOn = dto.UpdateOn;
return(projectPartner);
}
public void DeleteProjectPartner(ProjectPartnerDTO dto)
{
try
{
log.Debug(ProjectPartnerDTO.FormatProjectPartnerDTO(dto));
R_ProjectPartner t = ProjectPartnerDTO.ConvertDTOtoEntity(dto);
// delete
Repository.DeleteProjectPartner(t);
dto.IsDeleted = t.IsDeleted;
log.Debug("result: 'success'");
}
catch (System.Exception e)
{
// error
log.Error(e.ToString());
throw;
}
}
public IEnumerable <R_ProjectPartner> GetProjectPartnerListAdvancedSearch(
int?projectId
, int?partnerId
, double?grantValue
)
{
IEnumerable <R_ProjectPartner> results = null;
var sql = PetaPoco.Sql.Builder
.Select("*")
.From("R_ProjectPartner")
.Where("IsDeleted = 0"
+ (projectId != null ? " and ProjectId = " + projectId : "")
+ (partnerId != null ? " and PartnerId = " + partnerId : "")
+ (grantValue != null ? " and GrantValue like '%" + grantValue + "%'" : "")
)
;
results = R_ProjectPartner.Query(sql);
return(results);
}
public void GetProjectPartner_Success_Test()
{
// Arrange
int id = 1;
R_ProjectPartner projectPartner = SampleProjectPartner(id);
// create mock for repository
var mock = new Mock <IProjectPartnerRepository>();
mock.Setup(s => s.GetProjectPartner(Moq.It.IsAny <int>())).Returns(projectPartner);
// service
ProjectPartnerService projectPartnerService = new ProjectPartnerService();
ProjectPartnerService.Repository = mock.Object;
// Act
ProjectPartnerDTO result = projectPartnerService.GetProjectPartner(id);
// Assert
Assert.IsNotNull(result);
Assert.AreEqual(1, result.ProjectPartnerId);
}
public void UpdateProjectPartner(ProjectPartnerDTO dto)
{
try
{
//Requires.NotNull(t);
//Requires.PropertyNotNegative(t, "ProjectPartnerId");
log.Debug(ProjectPartnerDTO.FormatProjectPartnerDTO(dto));
R_ProjectPartner t = ProjectPartnerDTO.ConvertDTOtoEntity(dto);
// update
Repository.UpdateProjectPartner(t);
log.Debug("result: 'success'");
}
catch (System.Exception e)
{
// error
log.Error(e.ToString());
throw;
}
}
public void DeleteProjectPartner(R_ProjectPartner t)
{
t.IsDeleted = true;
t.Update();
}
public int AddProjectPartner(R_ProjectPartner t)
{
int id = (int)t.Insert();
return(id);
}
