public void GetEnergySources_Success_Test() { // Arrange R_EnergySource energySource = SampleEnergySource(1); IList <R_EnergySource> list = new List <R_EnergySource>(); list.Add(energySource); // create mock for repository var mock = new Mock <IEnergySourceRepository>(); mock.Setup(s => s.GetEnergySources()).Returns(list); // service EnergySourceService energySourceService = new EnergySourceService(); EnergySourceService.Repository = mock.Object; // Act var resultList = energySourceService.GetEnergySources(); EnergySourceDTO result = resultList.FirstOrDefault(); // Assert Assert.IsNotNull(result); Assert.AreEqual(1, result.EnergySourceId); }
// example data public static R_EnergySource SampleEnergySource(int id = 1) { R_EnergySource energySource = new R_EnergySource(); // int energySource.EnergySourceId = id; // string energySource.Name = "NameTestValue"; // string energySource.Description = "DescriptionTestValue"; // bool energySource.Active = false; // bool energySource.IsDeleted = false; // int? energySource.CreateBy = 1; // System.DateTime? energySource.CreateOn = new System.DateTime(); // int? energySource.UpdateBy = 1; // System.DateTime? energySource.UpdateOn = new System.DateTime(); return(energySource); }
public void UpdateEnergySource(R_EnergySource t) { //Requires.NotNull(t); //Requires.PropertyNotNegative(t, "EnergySourceId"); t.Update(); }
public EnergySourceDTO GetEnergySource(int energySourceId) { try { //Requires.NotNegative("energySourceId", energySourceId); log.Debug("energySourceId: " + energySourceId + " "); // get R_EnergySource t = Repository.GetEnergySource(energySourceId); EnergySourceDTO dto = new EnergySourceDTO(t); log.Debug(EnergySourceDTO.FormatEnergySourceDTO(dto)); return(dto); } catch (System.Exception e) { // error log.Error(e.ToString()); throw; } }
public int AddEnergySource(EnergySourceDTO dto) { int id = 0; try { log.Debug(EnergySourceDTO.FormatEnergySourceDTO(dto)); R_EnergySource t = EnergySourceDTO.ConvertDTOtoEntity(dto); // add id = Repository.AddEnergySource(t); dto.EnergySourceId = id; log.Debug("result: 'success', id: " + id); } catch (System.Exception e) { // error log.Error(e.ToString()); throw; } return(id); }
public R_EnergySource GetEnergySource(int energySourceId) { //Requires.NotNegative("energySourceId", energySourceId); R_EnergySource t = R_EnergySource.SingleOrDefault(energySourceId); return(t); }
public EnergySourceDTO(R_EnergySource energySource) { EnergySourceId = energySource.EnergySourceId; Name = energySource.Name; Description = energySource.Description; Active = energySource.Active; IsDeleted = energySource.IsDeleted; CreateBy = energySource.CreateBy; CreateOn = energySource.CreateOn; UpdateBy = energySource.UpdateBy; UpdateOn = energySource.UpdateOn; }
public IEnumerable <R_EnergySource> GetEnergySources() { IEnumerable <R_EnergySource> results = null; var sql = PetaPoco.Sql.Builder .Select("*") .From("R_EnergySource") .Where("IsDeleted = 0") ; results = R_EnergySource.Query(sql); return(results); }
public static R_EnergySource ConvertDTOtoEntity(EnergySourceDTO dto) { R_EnergySource energySource = new R_EnergySource(); energySource.EnergySourceId = dto.EnergySourceId; energySource.Name = dto.Name; energySource.Description = dto.Description; energySource.Active = dto.Active; energySource.IsDeleted = dto.IsDeleted; energySource.CreateBy = dto.CreateBy; energySource.CreateOn = dto.CreateOn; energySource.UpdateBy = dto.UpdateBy; energySource.UpdateOn = dto.UpdateOn; return(energySource); }
public IList <R_EnergySource> GetEnergySources(string searchTerm, int pageIndex, int pageSize) { IList <R_EnergySource> results = null; var sql = PetaPoco.Sql.Builder .Select("*") .From("R_EnergySource") .Where("IsDeleted = 0") .Where( "Name like '%" + searchTerm + "%'" + " or " + "Description like '%" + searchTerm + "%'" ) ; results = R_EnergySource.Fetch(pageIndex, pageSize, sql); return(results); }
public void DeleteEnergySource(EnergySourceDTO dto) { try { log.Debug(EnergySourceDTO.FormatEnergySourceDTO(dto)); R_EnergySource t = EnergySourceDTO.ConvertDTOtoEntity(dto); // delete Repository.DeleteEnergySource(t); dto.IsDeleted = t.IsDeleted; log.Debug("result: 'success'"); } catch (System.Exception e) { // error log.Error(e.ToString()); throw; } }
public IEnumerable <R_EnergySource> GetEnergySourceListAdvancedSearch( string name , string description , bool?active ) { IEnumerable <R_EnergySource> results = null; var sql = PetaPoco.Sql.Builder .Select("*") .From("R_EnergySource") .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_EnergySource.Query(sql); return(results); }
public void GetEnergySource_Success_Test() { // Arrange int id = 1; R_EnergySource energySource = SampleEnergySource(id); // create mock for repository var mock = new Mock <IEnergySourceRepository>(); mock.Setup(s => s.GetEnergySource(Moq.It.IsAny <int>())).Returns(energySource); // service EnergySourceService energySourceService = new EnergySourceService(); EnergySourceService.Repository = mock.Object; // Act EnergySourceDTO result = energySourceService.GetEnergySource(id); // Assert Assert.IsNotNull(result); Assert.AreEqual(1, result.EnergySourceId); }
public void UpdateEnergySource(EnergySourceDTO dto) { try { //Requires.NotNull(t); //Requires.PropertyNotNegative(t, "EnergySourceId"); log.Debug(EnergySourceDTO.FormatEnergySourceDTO(dto)); R_EnergySource t = EnergySourceDTO.ConvertDTOtoEntity(dto); // update Repository.UpdateEnergySource(t); log.Debug("result: 'success'"); } catch (System.Exception e) { // error log.Error(e.ToString()); throw; } }
public void DeleteEnergySource(R_EnergySource t) { t.IsDeleted = true; t.Update(); }
public int AddEnergySource(R_EnergySource t) { int id = (int)t.Insert(); return(id); }