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);
}
