public void UpdateDeliveryReportMessageType(R_DeliveryReportMessageType t) { //Requires.NotNull(t); //Requires.PropertyNotNegative(t, "DeliveryReportMessageTypeId"); t.Update(); }
// example data public static R_DeliveryReportMessageType SampleDeliveryReportMessageType(int id = 1) { R_DeliveryReportMessageType deliveryReportMessageType = new R_DeliveryReportMessageType(); // int deliveryReportMessageType.DeliveryReportMessageTypeId = id; // string deliveryReportMessageType.Name = "NameTestValue"; // string deliveryReportMessageType.Description = "DescriptionTestValue"; // bool deliveryReportMessageType.Active = false; // bool deliveryReportMessageType.IsDeleted = false; // int? deliveryReportMessageType.CreateBy = 1; // System.DateTime? deliveryReportMessageType.CreateOn = new System.DateTime(); // int? deliveryReportMessageType.UpdateBy = 1; // System.DateTime? deliveryReportMessageType.UpdateOn = new System.DateTime(); return(deliveryReportMessageType); }
public DeliveryReportMessageTypeDTO GetDeliveryReportMessageType(int deliveryReportMessageTypeId) { try { //Requires.NotNegative("deliveryReportMessageTypeId", deliveryReportMessageTypeId); log.Debug("deliveryReportMessageTypeId: " + deliveryReportMessageTypeId + " "); // get R_DeliveryReportMessageType t = Repository.GetDeliveryReportMessageType(deliveryReportMessageTypeId); DeliveryReportMessageTypeDTO dto = new DeliveryReportMessageTypeDTO(t); log.Debug(DeliveryReportMessageTypeDTO.FormatDeliveryReportMessageTypeDTO(dto)); return(dto); } catch (System.Exception e) { // error log.Error(e.ToString()); throw; } }
public int AddDeliveryReportMessageType(DeliveryReportMessageTypeDTO dto) { int id = 0; try { log.Debug(DeliveryReportMessageTypeDTO.FormatDeliveryReportMessageTypeDTO(dto)); R_DeliveryReportMessageType t = DeliveryReportMessageTypeDTO.ConvertDTOtoEntity(dto); // add id = Repository.AddDeliveryReportMessageType(t); dto.DeliveryReportMessageTypeId = id; log.Debug("result: 'success', id: " + id); } catch (System.Exception e) { // error log.Error(e.ToString()); throw; } return(id); }
public void GetDeliveryReportMessageTypes_Success_Test() { // Arrange R_DeliveryReportMessageType deliveryReportMessageType = SampleDeliveryReportMessageType(1); IList <R_DeliveryReportMessageType> list = new List <R_DeliveryReportMessageType>(); list.Add(deliveryReportMessageType); // create mock for repository var mock = new Mock <IDeliveryReportMessageTypeRepository>(); mock.Setup(s => s.GetDeliveryReportMessageTypes()).Returns(list); // service DeliveryReportMessageTypeService deliveryReportMessageTypeService = new DeliveryReportMessageTypeService(); DeliveryReportMessageTypeService.Repository = mock.Object; // Act var resultList = deliveryReportMessageTypeService.GetDeliveryReportMessageTypes(); DeliveryReportMessageTypeDTO result = resultList.FirstOrDefault(); // Assert Assert.IsNotNull(result); Assert.AreEqual(1, result.DeliveryReportMessageTypeId); }
public R_DeliveryReportMessageType GetDeliveryReportMessageType(int deliveryReportMessageTypeId) { //Requires.NotNegative("deliveryReportMessageTypeId", deliveryReportMessageTypeId); R_DeliveryReportMessageType t = R_DeliveryReportMessageType.SingleOrDefault(deliveryReportMessageTypeId); return(t); }
public DeliveryReportMessageTypeDTO(R_DeliveryReportMessageType deliveryReportMessageType) { DeliveryReportMessageTypeId = deliveryReportMessageType.DeliveryReportMessageTypeId; Name = deliveryReportMessageType.Name; Description = deliveryReportMessageType.Description; Active = deliveryReportMessageType.Active; IsDeleted = deliveryReportMessageType.IsDeleted; CreateBy = deliveryReportMessageType.CreateBy; CreateOn = deliveryReportMessageType.CreateOn; UpdateBy = deliveryReportMessageType.UpdateBy; UpdateOn = deliveryReportMessageType.UpdateOn; }
public IEnumerable <R_DeliveryReportMessageType> GetDeliveryReportMessageTypes() { IEnumerable <R_DeliveryReportMessageType> results = null; var sql = PetaPoco.Sql.Builder .Select("*") .From("R_DeliveryReportMessageType") .Where("IsDeleted = 0") ; results = R_DeliveryReportMessageType.Query(sql); return(results); }
public static R_DeliveryReportMessageType ConvertDTOtoEntity(DeliveryReportMessageTypeDTO dto) { R_DeliveryReportMessageType deliveryReportMessageType = new R_DeliveryReportMessageType(); deliveryReportMessageType.DeliveryReportMessageTypeId = dto.DeliveryReportMessageTypeId; deliveryReportMessageType.Name = dto.Name; deliveryReportMessageType.Description = dto.Description; deliveryReportMessageType.Active = dto.Active; deliveryReportMessageType.IsDeleted = dto.IsDeleted; deliveryReportMessageType.CreateBy = dto.CreateBy; deliveryReportMessageType.CreateOn = dto.CreateOn; deliveryReportMessageType.UpdateBy = dto.UpdateBy; deliveryReportMessageType.UpdateOn = dto.UpdateOn; return(deliveryReportMessageType); }
public IList <R_DeliveryReportMessageType> GetDeliveryReportMessageTypes(string searchTerm, int pageIndex, int pageSize) { IList <R_DeliveryReportMessageType> results = null; var sql = PetaPoco.Sql.Builder .Select("*") .From("R_DeliveryReportMessageType") .Where("IsDeleted = 0") .Where( "Name like '%" + searchTerm + "%'" + " or " + "Description like '%" + searchTerm + "%'" ) ; results = R_DeliveryReportMessageType.Fetch(pageIndex, pageSize, sql); return(results); }
public IEnumerable <R_DeliveryReportMessageType> GetDeliveryReportMessageTypeListAdvancedSearch( string name , string description , bool?active ) { IEnumerable <R_DeliveryReportMessageType> results = null; var sql = PetaPoco.Sql.Builder .Select("*") .From("R_DeliveryReportMessageType") .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_DeliveryReportMessageType.Query(sql); return(results); }
public void DeleteDeliveryReportMessageType(DeliveryReportMessageTypeDTO dto) { try { log.Debug(DeliveryReportMessageTypeDTO.FormatDeliveryReportMessageTypeDTO(dto)); R_DeliveryReportMessageType t = DeliveryReportMessageTypeDTO.ConvertDTOtoEntity(dto); // delete Repository.DeleteDeliveryReportMessageType(t); dto.IsDeleted = t.IsDeleted; log.Debug("result: 'success'"); } catch (System.Exception e) { // error log.Error(e.ToString()); throw; } }
public void GetDeliveryReportMessageType_Success_Test() { // Arrange int id = 1; R_DeliveryReportMessageType deliveryReportMessageType = SampleDeliveryReportMessageType(id); // create mock for repository var mock = new Mock <IDeliveryReportMessageTypeRepository>(); mock.Setup(s => s.GetDeliveryReportMessageType(Moq.It.IsAny <int>())).Returns(deliveryReportMessageType); // service DeliveryReportMessageTypeService deliveryReportMessageTypeService = new DeliveryReportMessageTypeService(); DeliveryReportMessageTypeService.Repository = mock.Object; // Act DeliveryReportMessageTypeDTO result = deliveryReportMessageTypeService.GetDeliveryReportMessageType(id); // Assert Assert.IsNotNull(result); Assert.AreEqual(1, result.DeliveryReportMessageTypeId); }
public void UpdateDeliveryReportMessageType(DeliveryReportMessageTypeDTO dto) { try { //Requires.NotNull(t); //Requires.PropertyNotNegative(t, "DeliveryReportMessageTypeId"); log.Debug(DeliveryReportMessageTypeDTO.FormatDeliveryReportMessageTypeDTO(dto)); R_DeliveryReportMessageType t = DeliveryReportMessageTypeDTO.ConvertDTOtoEntity(dto); // update Repository.UpdateDeliveryReportMessageType(t); log.Debug("result: 'success'"); } catch (System.Exception e) { // error log.Error(e.ToString()); throw; } }
public void DeleteDeliveryReportMessageType(R_DeliveryReportMessageType t) { t.IsDeleted = true; t.Update(); }
public int AddDeliveryReportMessageType(R_DeliveryReportMessageType t) { int id = (int)t.Insert(); return(id); }