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