public void UpdatePartnershipType(R_PartnershipType t) { //Requires.NotNull(t); //Requires.PropertyNotNegative(t, "PartnershipTypeId"); t.Update(); }
// example data public static R_PartnershipType SamplePartnershipType(int id = 1) { R_PartnershipType partnershipType = new R_PartnershipType(); // int partnershipType.PartnershipTypeId = id; // string partnershipType.Name = "NameTestValue"; // string partnershipType.Description = "DescriptionTestValue"; // string partnershipType.ActivityType = "ActivityTypeTestValue"; // bool partnershipType.Active = false; // bool partnershipType.IsDeleted = false; // int? partnershipType.CreateBy = 1; // System.DateTime? partnershipType.CreateOn = new System.DateTime(); // int? partnershipType.UpdateBy = 1; // System.DateTime? partnershipType.UpdateOn = new System.DateTime(); return(partnershipType); }
public PartnershipTypeDTO GetPartnershipType(int partnershipTypeId) { try { //Requires.NotNegative("partnershipTypeId", partnershipTypeId); log.Debug("partnershipTypeId: " + partnershipTypeId + " "); // get R_PartnershipType t = Repository.GetPartnershipType(partnershipTypeId); PartnershipTypeDTO dto = new PartnershipTypeDTO(t); log.Debug(PartnershipTypeDTO.FormatPartnershipTypeDTO(dto)); return(dto); } catch (System.Exception e) { // error log.Error(e.ToString()); throw; } }
public void GetPartnershipTypes_Success_Test() { // Arrange R_PartnershipType partnershipType = SamplePartnershipType(1); IList <R_PartnershipType> list = new List <R_PartnershipType>(); list.Add(partnershipType); // create mock for repository var mock = new Mock <IPartnershipTypeRepository>(); mock.Setup(s => s.GetPartnershipTypes()).Returns(list); // service PartnershipTypeService partnershipTypeService = new PartnershipTypeService(); PartnershipTypeService.Repository = mock.Object; // Act var resultList = partnershipTypeService.GetPartnershipTypes(); PartnershipTypeDTO result = resultList.FirstOrDefault(); // Assert Assert.IsNotNull(result); Assert.AreEqual(1, result.PartnershipTypeId); }
public int AddPartnershipType(PartnershipTypeDTO dto) { int id = 0; try { log.Debug(PartnershipTypeDTO.FormatPartnershipTypeDTO(dto)); R_PartnershipType t = PartnershipTypeDTO.ConvertDTOtoEntity(dto); // add id = Repository.AddPartnershipType(t); dto.PartnershipTypeId = id; log.Debug("result: 'success', id: " + id); } catch (System.Exception e) { // error log.Error(e.ToString()); throw; } return(id); }
public R_PartnershipType GetPartnershipType(int partnershipTypeId) { //Requires.NotNegative("partnershipTypeId", partnershipTypeId); R_PartnershipType t = R_PartnershipType.SingleOrDefault(partnershipTypeId); return(t); }
public PartnershipTypeDTO(R_PartnershipType partnershipType) { PartnershipTypeId = partnershipType.PartnershipTypeId; Name = partnershipType.Name; Description = partnershipType.Description; ActivityType = partnershipType.ActivityType; Active = partnershipType.Active; IsDeleted = partnershipType.IsDeleted; CreateBy = partnershipType.CreateBy; CreateOn = partnershipType.CreateOn; UpdateBy = partnershipType.UpdateBy; UpdateOn = partnershipType.UpdateOn; }
public IEnumerable <R_PartnershipType> GetPartnershipTypes() { IEnumerable <R_PartnershipType> results = null; var sql = PetaPoco.Sql.Builder .Select("*") .From("R_PartnershipType") .Where("IsDeleted = 0") ; results = R_PartnershipType.Query(sql); return(results); }
public static R_PartnershipType ConvertDTOtoEntity(PartnershipTypeDTO dto) { R_PartnershipType partnershipType = new R_PartnershipType(); partnershipType.PartnershipTypeId = dto.PartnershipTypeId; partnershipType.Name = dto.Name; partnershipType.Description = dto.Description; partnershipType.ActivityType = dto.ActivityType; partnershipType.Active = dto.Active; partnershipType.IsDeleted = dto.IsDeleted; partnershipType.CreateBy = dto.CreateBy; partnershipType.CreateOn = dto.CreateOn; partnershipType.UpdateBy = dto.UpdateBy; partnershipType.UpdateOn = dto.UpdateOn; return(partnershipType); }
public IList <R_PartnershipType> GetPartnershipTypes(string searchTerm, int pageIndex, int pageSize) { IList <R_PartnershipType> results = null; var sql = PetaPoco.Sql.Builder .Select("*") .From("R_PartnershipType") .Where("IsDeleted = 0") .Where( "Name like '%" + searchTerm + "%'" + " or " + "Description like '%" + searchTerm + "%'" + " or " + "ActivityType like '%" + searchTerm + "%'" ) ; results = R_PartnershipType.Fetch(pageIndex, pageSize, sql); return(results); }
public void DeletePartnershipType(PartnershipTypeDTO dto) { try { log.Debug(PartnershipTypeDTO.FormatPartnershipTypeDTO(dto)); R_PartnershipType t = PartnershipTypeDTO.ConvertDTOtoEntity(dto); // delete Repository.DeletePartnershipType(t); dto.IsDeleted = t.IsDeleted; log.Debug("result: 'success'"); } catch (System.Exception e) { // error log.Error(e.ToString()); throw; } }
public void GetPartnershipType_Success_Test() { // Arrange int id = 1; R_PartnershipType partnershipType = SamplePartnershipType(id); // create mock for repository var mock = new Mock <IPartnershipTypeRepository>(); mock.Setup(s => s.GetPartnershipType(Moq.It.IsAny <int>())).Returns(partnershipType); // service PartnershipTypeService partnershipTypeService = new PartnershipTypeService(); PartnershipTypeService.Repository = mock.Object; // Act PartnershipTypeDTO result = partnershipTypeService.GetPartnershipType(id); // Assert Assert.IsNotNull(result); Assert.AreEqual(1, result.PartnershipTypeId); }
public IEnumerable <R_PartnershipType> GetPartnershipTypeListAdvancedSearch( string name , string description , string activityType , bool?active ) { IEnumerable <R_PartnershipType> results = null; var sql = PetaPoco.Sql.Builder .Select("*") .From("R_PartnershipType") .Where("IsDeleted = 0" + (name != null ? " and Name like '%" + name + "%'" : "") + (description != null ? " and Description like '%" + description + "%'" : "") + (activityType != null ? " and ActivityType like '%" + activityType + "%'" : "") + (active != null ? " and Active = " + (active == true ? "1" : "0") : "") ) ; results = R_PartnershipType.Query(sql); return(results); }
public void UpdatePartnershipType(PartnershipTypeDTO dto) { try { //Requires.NotNull(t); //Requires.PropertyNotNegative(t, "PartnershipTypeId"); log.Debug(PartnershipTypeDTO.FormatPartnershipTypeDTO(dto)); R_PartnershipType t = PartnershipTypeDTO.ConvertDTOtoEntity(dto); // update Repository.UpdatePartnershipType(t); log.Debug("result: 'success'"); } catch (System.Exception e) { // error log.Error(e.ToString()); throw; } }
public void DeletePartnershipType(R_PartnershipType t) { t.IsDeleted = true; t.Update(); }
public int AddPartnershipType(R_PartnershipType t) { int id = (int)t.Insert(); return(id); }