public int AddContributionType(ContributionTypeDTO dto) { int id = 0; try { log.Debug(ContributionTypeDTO.FormatContributionTypeDTO(dto)); R_ContributionType t = ContributionTypeDTO.ConvertDTOtoEntity(dto); // add id = Repository.AddContributionType(t); dto.ContributionTypeId = id; log.Debug("result: 'success', id: " + id); } catch (System.Exception e) { // error log.Error(e.ToString()); throw; } return(id); }
public ContributionTypeDTO GetContributionType(int contributionTypeId) { try { //Requires.NotNegative("contributionTypeId", contributionTypeId); log.Debug("contributionTypeId: " + contributionTypeId + " "); // get R_ContributionType t = Repository.GetContributionType(contributionTypeId); ContributionTypeDTO dto = new ContributionTypeDTO(t); log.Debug(ContributionTypeDTO.FormatContributionTypeDTO(dto)); return(dto); } catch (System.Exception e) { // error log.Error(e.ToString()); throw; } }
// example data public static R_ContributionType SampleContributionType(int id = 1) { R_ContributionType contributionType = new R_ContributionType(); // int contributionType.ContributionTypeId = id; // string contributionType.Name = "NameTestValue"; // string contributionType.Description = "DescriptionTestValue"; // bool contributionType.Active = false; // bool contributionType.IsDeleted = false; // int? contributionType.CreateBy = 1; // System.DateTime? contributionType.CreateOn = new System.DateTime(); // int? contributionType.UpdateBy = 1; // System.DateTime? contributionType.UpdateOn = new System.DateTime(); return(contributionType); }
public void GetContributionTypes_Success_Test() { // Arrange R_ContributionType contributionType = SampleContributionType(1); IList <R_ContributionType> list = new List <R_ContributionType>(); list.Add(contributionType); // create mock for repository var mock = new Mock <IContributionTypeRepository>(); mock.Setup(s => s.GetContributionTypes()).Returns(list); // service ContributionTypeService contributionTypeService = new ContributionTypeService(); ContributionTypeService.Repository = mock.Object; // Act var resultList = contributionTypeService.GetContributionTypes(); ContributionTypeDTO result = resultList.FirstOrDefault(); // Assert Assert.IsNotNull(result); Assert.AreEqual(1, result.ContributionTypeId); }
public R_ContributionType GetContributionType(int contributionTypeId) { //Requires.NotNegative("contributionTypeId", contributionTypeId); R_ContributionType t = R_ContributionType.SingleOrDefault(contributionTypeId); return(t); }
public ContributionTypeDTO(R_ContributionType contributionType) { ContributionTypeId = contributionType.ContributionTypeId; Name = contributionType.Name; Description = contributionType.Description; Active = contributionType.Active; IsDeleted = contributionType.IsDeleted; CreateBy = contributionType.CreateBy; CreateOn = contributionType.CreateOn; UpdateBy = contributionType.UpdateBy; UpdateOn = contributionType.UpdateOn; }
public IEnumerable <R_ContributionType> GetContributionTypes() { IEnumerable <R_ContributionType> results = null; var sql = PetaPoco.Sql.Builder .Select("*") .From("R_ContributionType") .Where("IsDeleted = 0") ; results = R_ContributionType.Query(sql); return(results); }
public static R_ContributionType ConvertDTOtoEntity(ContributionTypeDTO dto) { R_ContributionType contributionType = new R_ContributionType(); contributionType.ContributionTypeId = dto.ContributionTypeId; contributionType.Name = dto.Name; contributionType.Description = dto.Description; contributionType.Active = dto.Active; contributionType.IsDeleted = dto.IsDeleted; contributionType.CreateBy = dto.CreateBy; contributionType.CreateOn = dto.CreateOn; contributionType.UpdateBy = dto.UpdateBy; contributionType.UpdateOn = dto.UpdateOn; return(contributionType); }
public IList <R_ContributionType> GetContributionTypes(string searchTerm, int pageIndex, int pageSize) { IList <R_ContributionType> results = null; var sql = PetaPoco.Sql.Builder .Select("*") .From("R_ContributionType") .Where("IsDeleted = 0") .Where( "Name like '%" + searchTerm + "%'" + " or " + "Description like '%" + searchTerm + "%'" ) ; results = R_ContributionType.Fetch(pageIndex, pageSize, sql); return(results); }
public IEnumerable <R_ContributionType> GetContributionTypeListAdvancedSearch( string name , string description , bool?active ) { IEnumerable <R_ContributionType> results = null; var sql = PetaPoco.Sql.Builder .Select("*") .From("R_ContributionType") .Where("IsDeleted = 0" + (name != null ? " and Name like '%" + name + "%'" : "") + (description != null ? " and Description like '%" + description + "%'" : "") + (active != null ? " and Active = " + (active == true ? "1" : "0") : "") ) ; results = R_ContributionType.Query(sql); return(results); }
public void DeleteContributionType(ContributionTypeDTO dto) { try { log.Debug(ContributionTypeDTO.FormatContributionTypeDTO(dto)); R_ContributionType t = ContributionTypeDTO.ConvertDTOtoEntity(dto); // delete Repository.DeleteContributionType(t); dto.IsDeleted = t.IsDeleted; log.Debug("result: 'success'"); } catch (System.Exception e) { // error log.Error(e.ToString()); throw; } }
public void GetContributionType_Success_Test() { // Arrange int id = 1; R_ContributionType contributionType = SampleContributionType(id); // create mock for repository var mock = new Mock <IContributionTypeRepository>(); mock.Setup(s => s.GetContributionType(Moq.It.IsAny <int>())).Returns(contributionType); // service ContributionTypeService contributionTypeService = new ContributionTypeService(); ContributionTypeService.Repository = mock.Object; // Act ContributionTypeDTO result = contributionTypeService.GetContributionType(id); // Assert Assert.IsNotNull(result); Assert.AreEqual(1, result.ContributionTypeId); }
public void UpdateContributionType(ContributionTypeDTO dto) { try { //Requires.NotNull(t); //Requires.PropertyNotNegative(t, "ContributionTypeId"); log.Debug(ContributionTypeDTO.FormatContributionTypeDTO(dto)); R_ContributionType t = ContributionTypeDTO.ConvertDTOtoEntity(dto); // update Repository.UpdateContributionType(t); log.Debug("result: 'success'"); } catch (System.Exception e) { // error log.Error(e.ToString()); throw; } }
public void DeleteContributionType(R_ContributionType t) { t.IsDeleted = true; t.Update(); }
public int AddContributionType(R_ContributionType t) { int id = (int)t.Insert(); return(id); }