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