public IEnumerable <R_Tutorial> GetTutorialListAdvancedSearch(
string name
, string description
, string location
, bool?isOnlineTutorial
, string language
, bool?active
)
{
IEnumerable <R_Tutorial> results = null;
var sql = PetaPoco.Sql.Builder
.Select("*")
.From("R_Tutorial")
.Where("IsDeleted = 0"
+ (name != null ? " and Name like '%" + name + "%'" : "")
+ (description != null ? " and Description like '%" + description + "%'" : "")
+ (location != null ? " and Location like '%" + location + "%'" : "")
+ (isOnlineTutorial != null ? " and IsOnlineTutorial = " + (isOnlineTutorial == true ? "1" : "0") : "")
+ (language != null ? " and Language like '%" + language + "%'" : "")
+ (active != null ? " and Active = " + (active == true ? "1" : "0") : "")
)
;
results = R_Tutorial.Query(sql);
return(results);
}
public void UpdateTutorial(R_Tutorial t)
{
//Requires.NotNull(t);
//Requires.PropertyNotNegative(t, "TutorialId");
t.Update();
}
// example data
public static R_Tutorial SampleTutorial(int id = 1)
{
R_Tutorial tutorial = new R_Tutorial();
// int
tutorial.TutorialId = id;
// string
tutorial.Name = "NameTestValue";
// string
tutorial.Description = "DescriptionTestValue";
// string
tutorial.Location = "LocationTestValue";
// bool
tutorial.IsOnlineTutorial = false;
// string
tutorial.Language = "LanguageTestValue";
// bool
tutorial.Active = false;
// bool
tutorial.IsDeleted = false;
// int?
tutorial.CreateBy = 1;
// System.DateTime?
tutorial.CreateOn = new System.DateTime();
// int?
tutorial.UpdateBy = 1;
// System.DateTime?
tutorial.UpdateOn = new System.DateTime();
return(tutorial);
}
public TutorialDTO GetTutorial(int tutorialId)
{
try
{
//Requires.NotNegative("tutorialId", tutorialId);
log.Debug("tutorialId: " + tutorialId + " ");
// get
R_Tutorial t = Repository.GetTutorial(tutorialId);
TutorialDTO dto = new TutorialDTO(t);
log.Debug(TutorialDTO.FormatTutorialDTO(dto));
return(dto);
}
catch (System.Exception e)
{
// error
log.Error(e.ToString());
throw;
}
}
public void GetTutorials_Success_Test()
{
// Arrange
R_Tutorial tutorial = SampleTutorial(1);
IList <R_Tutorial> list = new List <R_Tutorial>();
list.Add(tutorial);
// create mock for repository
var mock = new Mock <ITutorialRepository>();
mock.Setup(s => s.GetTutorials()).Returns(list);
// service
TutorialService tutorialService = new TutorialService();
TutorialService.Repository = mock.Object;
// Act
var resultList = tutorialService.GetTutorials();
TutorialDTO result = resultList.FirstOrDefault();
// Assert
Assert.IsNotNull(result);
Assert.AreEqual(1, result.TutorialId);
}
public int AddTutorial(TutorialDTO dto)
{
int id = 0;
try
{
log.Debug(TutorialDTO.FormatTutorialDTO(dto));
R_Tutorial t = TutorialDTO.ConvertDTOtoEntity(dto);
// add
id = Repository.AddTutorial(t);
dto.TutorialId = id;
log.Debug("result: 'success', id: " + id);
}
catch (System.Exception e)
{
// error
log.Error(e.ToString());
throw;
}
return(id);
}
public R_Tutorial GetTutorial(int tutorialId)
{
//Requires.NotNegative("tutorialId", tutorialId);
R_Tutorial t = R_Tutorial.SingleOrDefault(tutorialId);
return(t);
}
public IEnumerable <R_Tutorial> GetTutorials()
{
IEnumerable <R_Tutorial> results = null;
var sql = PetaPoco.Sql.Builder
.Select("*")
.From("R_Tutorial")
.Where("IsDeleted = 0")
;
results = R_Tutorial.Query(sql);
return(results);
}
public TutorialDTO(R_Tutorial tutorial)
{
TutorialId = tutorial.TutorialId;
Name = tutorial.Name;
Description = tutorial.Description;
Location = tutorial.Location;
IsOnlineTutorial = tutorial.IsOnlineTutorial;
Language = tutorial.Language;
Active = tutorial.Active;
IsDeleted = tutorial.IsDeleted;
CreateBy = tutorial.CreateBy;
CreateOn = tutorial.CreateOn;
UpdateBy = tutorial.UpdateBy;
UpdateOn = tutorial.UpdateOn;
}
public static R_Tutorial ConvertDTOtoEntity(TutorialDTO dto)
{
R_Tutorial tutorial = new R_Tutorial();
tutorial.TutorialId = dto.TutorialId;
tutorial.Name = dto.Name;
tutorial.Description = dto.Description;
tutorial.Location = dto.Location;
tutorial.IsOnlineTutorial = dto.IsOnlineTutorial;
tutorial.Language = dto.Language;
tutorial.Active = dto.Active;
tutorial.IsDeleted = dto.IsDeleted;
tutorial.CreateBy = dto.CreateBy;
tutorial.CreateOn = dto.CreateOn;
tutorial.UpdateBy = dto.UpdateBy;
tutorial.UpdateOn = dto.UpdateOn;
return(tutorial);
}
public IList <R_Tutorial> GetTutorials(string searchTerm, int pageIndex, int pageSize)
{
IList <R_Tutorial> results = null;
var sql = PetaPoco.Sql.Builder
.Select("*")
.From("R_Tutorial")
.Where("IsDeleted = 0")
.Where(
"Name like '%" + searchTerm + "%'"
+ " or " + "Description like '%" + searchTerm + "%'"
+ " or " + "Location like '%" + searchTerm + "%'"
+ " or " + "Language like '%" + searchTerm + "%'"
)
;
results = R_Tutorial.Fetch(pageIndex, pageSize, sql);
return(results);
}
public void DeleteTutorial(TutorialDTO dto)
{
try
{
log.Debug(TutorialDTO.FormatTutorialDTO(dto));
R_Tutorial t = TutorialDTO.ConvertDTOtoEntity(dto);
// delete
Repository.DeleteTutorial(t);
dto.IsDeleted = t.IsDeleted;
log.Debug("result: 'success'");
}
catch (System.Exception e)
{
// error
log.Error(e.ToString());
throw;
}
}
public void GetTutorial_Success_Test()
{
// Arrange
int id = 1;
R_Tutorial tutorial = SampleTutorial(id);
// create mock for repository
var mock = new Mock <ITutorialRepository>();
mock.Setup(s => s.GetTutorial(Moq.It.IsAny <int>())).Returns(tutorial);
// service
TutorialService tutorialService = new TutorialService();
TutorialService.Repository = mock.Object;
// Act
TutorialDTO result = tutorialService.GetTutorial(id);
// Assert
Assert.IsNotNull(result);
Assert.AreEqual(1, result.TutorialId);
}
public void UpdateTutorial(TutorialDTO dto)
{
try
{
//Requires.NotNull(t);
//Requires.PropertyNotNegative(t, "TutorialId");
log.Debug(TutorialDTO.FormatTutorialDTO(dto));
R_Tutorial t = TutorialDTO.ConvertDTOtoEntity(dto);
// update
Repository.UpdateTutorial(t);
log.Debug("result: 'success'");
}
catch (System.Exception e)
{
// error
log.Error(e.ToString());
throw;
}
}
public void DeleteTutorial(R_Tutorial t)
{
t.IsDeleted = true;
t.Update();
}
public int AddTutorial(R_Tutorial t)
{
int id = (int)t.Insert();
return(id);
}
