public void UpdateDeliveryReportMessage(R_DeliveryReportMessage t) { //Requires.NotNull(t); //Requires.PropertyNotNegative(t, "DeliveryReportMessageId"); t.Update(); }
public DeliveryReportMessageDTO GetDeliveryReportMessage(int deliveryReportMessageId) { try { //Requires.NotNegative("deliveryReportMessageId", deliveryReportMessageId); log.Debug("deliveryReportMessageId: " + deliveryReportMessageId + " "); // get R_DeliveryReportMessage t = Repository.GetDeliveryReportMessage(deliveryReportMessageId); DeliveryReportMessageDTO dto = new DeliveryReportMessageDTO(t); log.Debug(DeliveryReportMessageDTO.FormatDeliveryReportMessageDTO(dto)); return(dto); } catch (System.Exception e) { // error log.Error(e.ToString()); throw; } }
public void GetDeliveryReportMessages_Success_Test() { // Arrange R_DeliveryReportMessage deliveryReportMessage = SampleDeliveryReportMessage(1); IList <R_DeliveryReportMessage> list = new List <R_DeliveryReportMessage>(); list.Add(deliveryReportMessage); // create mock for repository var mock = new Mock <IDeliveryReportMessageRepository>(); mock.Setup(s => s.GetDeliveryReportMessages()).Returns(list); // service DeliveryReportMessageService deliveryReportMessageService = new DeliveryReportMessageService(); DeliveryReportMessageService.Repository = mock.Object; // Act var resultList = deliveryReportMessageService.GetDeliveryReportMessages(); DeliveryReportMessageDTO result = resultList.FirstOrDefault(); // Assert Assert.IsNotNull(result); Assert.AreEqual(1, result.DeliveryReportMessageId); }
public int AddDeliveryReportMessage(DeliveryReportMessageDTO dto) { int id = 0; try { log.Debug(DeliveryReportMessageDTO.FormatDeliveryReportMessageDTO(dto)); R_DeliveryReportMessage t = DeliveryReportMessageDTO.ConvertDTOtoEntity(dto); // add id = Repository.AddDeliveryReportMessage(t); dto.DeliveryReportMessageId = id; log.Debug("result: 'success', id: " + id); } catch (System.Exception e) { // error log.Error(e.ToString()); throw; } return(id); }
public R_DeliveryReportMessage GetDeliveryReportMessage(int deliveryReportMessageId) { //Requires.NotNegative("deliveryReportMessageId", deliveryReportMessageId); R_DeliveryReportMessage t = R_DeliveryReportMessage.SingleOrDefault(deliveryReportMessageId); return(t); }
public DeliveryReportMessageDTO(R_DeliveryReportMessage deliveryReportMessage) { DeliveryReportMessageId = deliveryReportMessage.DeliveryReportMessageId; DeliveryReportMessageTypeId = deliveryReportMessage.DeliveryReportMessageTypeId; Message = deliveryReportMessage.Message; IsDeleted = deliveryReportMessage.IsDeleted; CreateBy = deliveryReportMessage.CreateBy; CreateOn = deliveryReportMessage.CreateOn; UpdateBy = deliveryReportMessage.UpdateBy; UpdateOn = deliveryReportMessage.UpdateOn; }
public IEnumerable <R_DeliveryReportMessage> GetDeliveryReportMessages() { IEnumerable <R_DeliveryReportMessage> results = null; var sql = PetaPoco.Sql.Builder .Select("*") .From("R_DeliveryReportMessage") .Where("IsDeleted = 0") ; results = R_DeliveryReportMessage.Query(sql); return(results); }
public static R_DeliveryReportMessage ConvertDTOtoEntity(DeliveryReportMessageDTO dto) { R_DeliveryReportMessage deliveryReportMessage = new R_DeliveryReportMessage(); deliveryReportMessage.DeliveryReportMessageId = dto.DeliveryReportMessageId; deliveryReportMessage.DeliveryReportMessageTypeId = dto.DeliveryReportMessageTypeId; deliveryReportMessage.Message = dto.Message; deliveryReportMessage.IsDeleted = dto.IsDeleted; deliveryReportMessage.CreateBy = dto.CreateBy; deliveryReportMessage.CreateOn = dto.CreateOn; deliveryReportMessage.UpdateBy = dto.UpdateBy; deliveryReportMessage.UpdateOn = dto.UpdateOn; return(deliveryReportMessage); }
public IList <R_DeliveryReportMessage> GetDeliveryReportMessages(string searchTerm, int pageIndex, int pageSize) { IList <R_DeliveryReportMessage> results = null; var sql = PetaPoco.Sql.Builder .Select("*") .From("R_DeliveryReportMessage") .Where("IsDeleted = 0") .Where( "Message like '%" + searchTerm + "%'" ) ; results = R_DeliveryReportMessage.Fetch(pageIndex, pageSize, sql); return(results); }
public IEnumerable <R_DeliveryReportMessage> GetDeliveryReportMessageListAdvancedSearch( int?deliveryReportMessageTypeId , string message ) { IEnumerable <R_DeliveryReportMessage> results = null; var sql = PetaPoco.Sql.Builder .Select("*") .From("R_DeliveryReportMessage") .Where("IsDeleted = 0" + (deliveryReportMessageTypeId != null ? " and DeliveryReportMessageTypeId = " + deliveryReportMessageTypeId : "") + (message != null ? " and Message like '%" + message + "%'" : "") ) ; results = R_DeliveryReportMessage.Query(sql); return(results); }
public void DeleteDeliveryReportMessage(DeliveryReportMessageDTO dto) { try { log.Debug(DeliveryReportMessageDTO.FormatDeliveryReportMessageDTO(dto)); R_DeliveryReportMessage t = DeliveryReportMessageDTO.ConvertDTOtoEntity(dto); // delete Repository.DeleteDeliveryReportMessage(t); dto.IsDeleted = t.IsDeleted; log.Debug("result: 'success'"); } catch (System.Exception e) { // error log.Error(e.ToString()); throw; } }
public void GetDeliveryReportMessage_Success_Test() { // Arrange int id = 1; R_DeliveryReportMessage deliveryReportMessage = SampleDeliveryReportMessage(id); // create mock for repository var mock = new Mock <IDeliveryReportMessageRepository>(); mock.Setup(s => s.GetDeliveryReportMessage(Moq.It.IsAny <int>())).Returns(deliveryReportMessage); // service DeliveryReportMessageService deliveryReportMessageService = new DeliveryReportMessageService(); DeliveryReportMessageService.Repository = mock.Object; // Act DeliveryReportMessageDTO result = deliveryReportMessageService.GetDeliveryReportMessage(id); // Assert Assert.IsNotNull(result); Assert.AreEqual(1, result.DeliveryReportMessageId); }
// example data public static R_DeliveryReportMessage SampleDeliveryReportMessage(int id = 1) { R_DeliveryReportMessage deliveryReportMessage = new R_DeliveryReportMessage(); // int deliveryReportMessage.DeliveryReportMessageId = id; // int deliveryReportMessage.DeliveryReportMessageTypeId = 1; // string deliveryReportMessage.Message = "MessageTestValue"; // bool deliveryReportMessage.IsDeleted = false; // int? deliveryReportMessage.CreateBy = 1; // System.DateTime? deliveryReportMessage.CreateOn = new System.DateTime(); // int? deliveryReportMessage.UpdateBy = 1; // System.DateTime? deliveryReportMessage.UpdateOn = new System.DateTime(); return(deliveryReportMessage); }
public void UpdateDeliveryReportMessage(DeliveryReportMessageDTO dto) { try { //Requires.NotNull(t); //Requires.PropertyNotNegative(t, "DeliveryReportMessageId"); log.Debug(DeliveryReportMessageDTO.FormatDeliveryReportMessageDTO(dto)); R_DeliveryReportMessage t = DeliveryReportMessageDTO.ConvertDTOtoEntity(dto); // update Repository.UpdateDeliveryReportMessage(t); log.Debug("result: 'success'"); } catch (System.Exception e) { // error log.Error(e.ToString()); throw; } }
public void DeleteDeliveryReportMessage(R_DeliveryReportMessage t) { t.IsDeleted = true; t.Update(); }
public int AddDeliveryReportMessage(R_DeliveryReportMessage t) { int id = (int)t.Insert(); return(id); }