public void UpdatePartnershipType(R_PartnershipType t)
{
//Requires.NotNull(t);
//Requires.PropertyNotNegative(t, "PartnershipTypeId");
t.Update();
}
// example data
public static R_PartnershipType SamplePartnershipType(int id = 1)
{
R_PartnershipType partnershipType = new R_PartnershipType();
// int
partnershipType.PartnershipTypeId = id;
// string
partnershipType.Name = "NameTestValue";
// string
partnershipType.Description = "DescriptionTestValue";
// string
partnershipType.ActivityType = "ActivityTypeTestValue";
// bool
partnershipType.Active = false;
// bool
partnershipType.IsDeleted = false;
// int?
partnershipType.CreateBy = 1;
// System.DateTime?
partnershipType.CreateOn = new System.DateTime();
// int?
partnershipType.UpdateBy = 1;
// System.DateTime?
partnershipType.UpdateOn = new System.DateTime();
return(partnershipType);
}
public PartnershipTypeDTO GetPartnershipType(int partnershipTypeId)
{
try
{
//Requires.NotNegative("partnershipTypeId", partnershipTypeId);
log.Debug("partnershipTypeId: " + partnershipTypeId + " ");
// get
R_PartnershipType t = Repository.GetPartnershipType(partnershipTypeId);
PartnershipTypeDTO dto = new PartnershipTypeDTO(t);
log.Debug(PartnershipTypeDTO.FormatPartnershipTypeDTO(dto));
return(dto);
}
catch (System.Exception e)
{
// error
log.Error(e.ToString());
throw;
}
}
public void GetPartnershipTypes_Success_Test()
{
// Arrange
R_PartnershipType partnershipType = SamplePartnershipType(1);
IList <R_PartnershipType> list = new List <R_PartnershipType>();
list.Add(partnershipType);
// create mock for repository
var mock = new Mock <IPartnershipTypeRepository>();
mock.Setup(s => s.GetPartnershipTypes()).Returns(list);
// service
PartnershipTypeService partnershipTypeService = new PartnershipTypeService();
PartnershipTypeService.Repository = mock.Object;
// Act
var resultList = partnershipTypeService.GetPartnershipTypes();
PartnershipTypeDTO result = resultList.FirstOrDefault();
// Assert
Assert.IsNotNull(result);
Assert.AreEqual(1, result.PartnershipTypeId);
}
public int AddPartnershipType(PartnershipTypeDTO dto)
{
int id = 0;
try
{
log.Debug(PartnershipTypeDTO.FormatPartnershipTypeDTO(dto));
R_PartnershipType t = PartnershipTypeDTO.ConvertDTOtoEntity(dto);
// add
id = Repository.AddPartnershipType(t);
dto.PartnershipTypeId = id;
log.Debug("result: 'success', id: " + id);
}
catch (System.Exception e)
{
// error
log.Error(e.ToString());
throw;
}
return(id);
}
public R_PartnershipType GetPartnershipType(int partnershipTypeId)
{
//Requires.NotNegative("partnershipTypeId", partnershipTypeId);
R_PartnershipType t = R_PartnershipType.SingleOrDefault(partnershipTypeId);
return(t);
}
public PartnershipTypeDTO(R_PartnershipType partnershipType)
{
PartnershipTypeId = partnershipType.PartnershipTypeId;
Name = partnershipType.Name;
Description = partnershipType.Description;
ActivityType = partnershipType.ActivityType;
Active = partnershipType.Active;
IsDeleted = partnershipType.IsDeleted;
CreateBy = partnershipType.CreateBy;
CreateOn = partnershipType.CreateOn;
UpdateBy = partnershipType.UpdateBy;
UpdateOn = partnershipType.UpdateOn;
}
public IEnumerable <R_PartnershipType> GetPartnershipTypes()
{
IEnumerable <R_PartnershipType> results = null;
var sql = PetaPoco.Sql.Builder
.Select("*")
.From("R_PartnershipType")
.Where("IsDeleted = 0")
;
results = R_PartnershipType.Query(sql);
return(results);
}
public static R_PartnershipType ConvertDTOtoEntity(PartnershipTypeDTO dto)
{
R_PartnershipType partnershipType = new R_PartnershipType();
partnershipType.PartnershipTypeId = dto.PartnershipTypeId;
partnershipType.Name = dto.Name;
partnershipType.Description = dto.Description;
partnershipType.ActivityType = dto.ActivityType;
partnershipType.Active = dto.Active;
partnershipType.IsDeleted = dto.IsDeleted;
partnershipType.CreateBy = dto.CreateBy;
partnershipType.CreateOn = dto.CreateOn;
partnershipType.UpdateBy = dto.UpdateBy;
partnershipType.UpdateOn = dto.UpdateOn;
return(partnershipType);
}
public IList <R_PartnershipType> GetPartnershipTypes(string searchTerm, int pageIndex, int pageSize)
{
IList <R_PartnershipType> results = null;
var sql = PetaPoco.Sql.Builder
.Select("*")
.From("R_PartnershipType")
.Where("IsDeleted = 0")
.Where(
"Name like '%" + searchTerm + "%'"
+ " or " + "Description like '%" + searchTerm + "%'"
+ " or " + "ActivityType like '%" + searchTerm + "%'"
)
;
results = R_PartnershipType.Fetch(pageIndex, pageSize, sql);
return(results);
}
public void DeletePartnershipType(PartnershipTypeDTO dto)
{
try
{
log.Debug(PartnershipTypeDTO.FormatPartnershipTypeDTO(dto));
R_PartnershipType t = PartnershipTypeDTO.ConvertDTOtoEntity(dto);
// delete
Repository.DeletePartnershipType(t);
dto.IsDeleted = t.IsDeleted;
log.Debug("result: 'success'");
}
catch (System.Exception e)
{
// error
log.Error(e.ToString());
throw;
}
}
public void GetPartnershipType_Success_Test()
{
// Arrange
int id = 1;
R_PartnershipType partnershipType = SamplePartnershipType(id);
// create mock for repository
var mock = new Mock <IPartnershipTypeRepository>();
mock.Setup(s => s.GetPartnershipType(Moq.It.IsAny <int>())).Returns(partnershipType);
// service
PartnershipTypeService partnershipTypeService = new PartnershipTypeService();
PartnershipTypeService.Repository = mock.Object;
// Act
PartnershipTypeDTO result = partnershipTypeService.GetPartnershipType(id);
// Assert
Assert.IsNotNull(result);
Assert.AreEqual(1, result.PartnershipTypeId);
}
public IEnumerable <R_PartnershipType> GetPartnershipTypeListAdvancedSearch(
string name
, string description
, string activityType
, bool?active
)
{
IEnumerable <R_PartnershipType> results = null;
var sql = PetaPoco.Sql.Builder
.Select("*")
.From("R_PartnershipType")
.Where("IsDeleted = 0"
+ (name != null ? " and Name like '%" + name + "%'" : "")
+ (description != null ? " and Description like '%" + description + "%'" : "")
+ (activityType != null ? " and ActivityType like '%" + activityType + "%'" : "")
+ (active != null ? " and Active = " + (active == true ? "1" : "0") : "")
)
;
results = R_PartnershipType.Query(sql);
return(results);
}
public void UpdatePartnershipType(PartnershipTypeDTO dto)
{
try
{
//Requires.NotNull(t);
//Requires.PropertyNotNegative(t, "PartnershipTypeId");
log.Debug(PartnershipTypeDTO.FormatPartnershipTypeDTO(dto));
R_PartnershipType t = PartnershipTypeDTO.ConvertDTOtoEntity(dto);
// update
Repository.UpdatePartnershipType(t);
log.Debug("result: 'success'");
}
catch (System.Exception e)
{
// error
log.Error(e.ToString());
throw;
}
}
public void DeletePartnershipType(R_PartnershipType t)
{
t.IsDeleted = true;
t.Update();
}
public int AddPartnershipType(R_PartnershipType t)
{
int id = (int)t.Insert();
return(id);
}
