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