public CalendarEventDTO GetCalendarEvent(int calendarEventId)
{
try
{
//Requires.NotNegative("calendarEventId", calendarEventId);
log.Debug("calendarEventId: " + calendarEventId + " ");
// get
R_CalendarEvent t = Repository.GetCalendarEvent(calendarEventId);
CalendarEventDTO dto = new CalendarEventDTO(t);
log.Debug(CalendarEventDTO.FormatCalendarEventDTO(dto));
return(dto);
}
catch (System.Exception e)
{
// error
log.Error(e.ToString());
throw;
}
}
public int AddCalendarEvent(CalendarEventDTO dto)
{
int id = 0;
try
{
log.Debug(CalendarEventDTO.FormatCalendarEventDTO(dto));
R_CalendarEvent t = CalendarEventDTO.ConvertDTOtoEntity(dto);
// add
id = Repository.AddCalendarEvent(t);
dto.CalendarEventId = id;
log.Debug("result: 'success', id: " + id);
}
catch (System.Exception e)
{
// error
log.Error(e.ToString());
throw;
}
return(id);
}
public void GetCalendarEvents_Success_Test()
{
// Arrange
R_CalendarEvent calendarEvent = SampleCalendarEvent(1);
IList <R_CalendarEvent> list = new List <R_CalendarEvent>();
list.Add(calendarEvent);
// create mock for repository
var mock = new Mock <ICalendarEventRepository>();
mock.Setup(s => s.GetCalendarEvents()).Returns(list);
// service
CalendarEventService calendarEventService = new CalendarEventService();
CalendarEventService.Repository = mock.Object;
// Act
var resultList = calendarEventService.GetCalendarEvents();
CalendarEventDTO result = resultList.FirstOrDefault();
// Assert
Assert.IsNotNull(result);
Assert.AreEqual(1, result.CalendarEventId);
}
// example data
public static R_CalendarEvent SampleCalendarEvent(int id = 1)
{
R_CalendarEvent calendarEvent = new R_CalendarEvent();
// int
calendarEvent.CalendarEventId = id;
// int?
calendarEvent.NucleoId = 1;
// string
calendarEvent.Name = "NameTestValue";
// string
calendarEvent.Description = "DescriptionTestValue";
// System.DateTime
calendarEvent.StartDate = new System.DateTime();
// System.DateTime
calendarEvent.EndDate = new System.DateTime();
// bool
calendarEvent.Active = false;
// bool
calendarEvent.IsDeleted = false;
// int?
calendarEvent.CreateBy = 1;
// System.DateTime?
calendarEvent.CreateOn = new System.DateTime();
// int?
calendarEvent.UpdateBy = 1;
// System.DateTime?
calendarEvent.UpdateOn = new System.DateTime();
return(calendarEvent);
}
public void UpdateCalendarEvent(R_CalendarEvent t)
{
//Requires.NotNull(t);
//Requires.PropertyNotNegative(t, "CalendarEventId");
t.Update();
}
public IEnumerable <R_CalendarEvent> GetCalendarEventListAdvancedSearch(
int?nucleoId
, string name
, string description
, System.DateTime?startDateFrom
, System.DateTime?startDateTo
, System.DateTime?endDateFrom
, System.DateTime?endDateTo
, bool?active
)
{
IEnumerable <R_CalendarEvent> results = null;
var sql = PetaPoco.Sql.Builder
.Select("*")
.From("R_CalendarEvent")
.Where("IsDeleted = 0"
+ (nucleoId != null ? " and NucleoId like '%" + nucleoId + "%'" : "")
+ (name != null ? " and Name like '%" + name + "%'" : "")
+ (description != null ? " and Description like '%" + description + "%'" : "")
+ (startDateFrom != null ? " and StartDate >= '" + startDateFrom.Value.ToShortDateString() + "'" : "")
+ (startDateTo != null ? " and StartDate <= '" + startDateTo.Value.ToShortDateString() + "'" : "")
+ (endDateFrom != null ? " and EndDate >= '" + endDateFrom.Value.ToShortDateString() + "'" : "")
+ (endDateTo != null ? " and EndDate <= '" + endDateTo.Value.ToShortDateString() + "'" : "")
+ (active != null ? " and Active = " + (active == true ? "1" : "0") : "")
)
;
results = R_CalendarEvent.Query(sql);
return(results);
}
public R_CalendarEvent GetCalendarEvent(int calendarEventId)
{
//Requires.NotNegative("calendarEventId", calendarEventId);
R_CalendarEvent t = R_CalendarEvent.SingleOrDefault(calendarEventId);
return(t);
}
public CalendarEventDTO(R_CalendarEvent calendarEvent)
{
CalendarEventId = calendarEvent.CalendarEventId;
NucleoId = calendarEvent.NucleoId;
Name = calendarEvent.Name;
Description = calendarEvent.Description;
StartDate = calendarEvent.StartDate;
EndDate = calendarEvent.EndDate;
Active = calendarEvent.Active;
IsDeleted = calendarEvent.IsDeleted;
CreateBy = calendarEvent.CreateBy;
CreateOn = calendarEvent.CreateOn;
UpdateBy = calendarEvent.UpdateBy;
UpdateOn = calendarEvent.UpdateOn;
}
public IEnumerable <R_CalendarEvent> GetCalendarEvents()
{
IEnumerable <R_CalendarEvent> results = null;
var sql = PetaPoco.Sql.Builder
.Select("*")
.From("R_CalendarEvent")
.Where("IsDeleted = 0")
;
results = R_CalendarEvent.Query(sql);
return(results);
}
public IList <R_CalendarEvent> GetCalendarEvents(string searchTerm, int pageIndex, int pageSize)
{
IList <R_CalendarEvent> results = null;
var sql = PetaPoco.Sql.Builder
.Select("*")
.From("R_CalendarEvent")
.Where("IsDeleted = 0")
.Where(
"Name like '%" + searchTerm + "%'"
+ " or " + "Description like '%" + searchTerm + "%'"
)
;
results = R_CalendarEvent.Fetch(pageIndex, pageSize, sql);
return(results);
}
public static R_CalendarEvent ConvertDTOtoEntity(CalendarEventDTO dto)
{
R_CalendarEvent calendarEvent = new R_CalendarEvent();
calendarEvent.CalendarEventId = dto.CalendarEventId;
calendarEvent.NucleoId = dto.NucleoId;
calendarEvent.Name = dto.Name;
calendarEvent.Description = dto.Description;
calendarEvent.StartDate = dto.StartDate;
calendarEvent.EndDate = dto.EndDate;
calendarEvent.Active = dto.Active;
calendarEvent.IsDeleted = dto.IsDeleted;
calendarEvent.CreateBy = dto.CreateBy;
calendarEvent.CreateOn = dto.CreateOn;
calendarEvent.UpdateBy = dto.UpdateBy;
calendarEvent.UpdateOn = dto.UpdateOn;
return(calendarEvent);
}
public void DeleteCalendarEvent(CalendarEventDTO dto)
{
try
{
log.Debug(CalendarEventDTO.FormatCalendarEventDTO(dto));
R_CalendarEvent t = CalendarEventDTO.ConvertDTOtoEntity(dto);
// delete
Repository.DeleteCalendarEvent(t);
dto.IsDeleted = t.IsDeleted;
log.Debug("result: 'success'");
}
catch (System.Exception e)
{
// error
log.Error(e.ToString());
throw;
}
}
public void GetCalendarEvent_Success_Test()
{
// Arrange
int id = 1;
R_CalendarEvent calendarEvent = SampleCalendarEvent(id);
// create mock for repository
var mock = new Mock <ICalendarEventRepository>();
mock.Setup(s => s.GetCalendarEvent(Moq.It.IsAny <int>())).Returns(calendarEvent);
// service
CalendarEventService calendarEventService = new CalendarEventService();
CalendarEventService.Repository = mock.Object;
// Act
CalendarEventDTO result = calendarEventService.GetCalendarEvent(id);
// Assert
Assert.IsNotNull(result);
Assert.AreEqual(1, result.CalendarEventId);
}
public void UpdateCalendarEvent(CalendarEventDTO dto)
{
try
{
//Requires.NotNull(t);
//Requires.PropertyNotNegative(t, "CalendarEventId");
log.Debug(CalendarEventDTO.FormatCalendarEventDTO(dto));
R_CalendarEvent t = CalendarEventDTO.ConvertDTOtoEntity(dto);
// update
Repository.UpdateCalendarEvent(t);
log.Debug("result: 'success'");
}
catch (System.Exception e)
{
// error
log.Error(e.ToString());
throw;
}
}
public void DeleteCalendarEvent(R_CalendarEvent t)
{
t.IsDeleted = true;
t.Update();
}
public int AddCalendarEvent(R_CalendarEvent t)
{
int id = (int)t.Insert();
return(id);
}
