public async Task <IEnumerable <UserActionGetDetailDTO> > GetUserActionsByDate(DateTime dateTime) { // convert date to string because SQLite doesn't have DateTime type string dateTimeStr = dateTime.Date.ToString(dateTimeFormat); // according to string format of dateTime in SQLite first part of dateTimeStr will be "yyyy-MM-dd" string dateStr = dateTimeStr.Split(' ')[0]; IEnumerable <UserAction> userActions = await UserActionRepository.GetByDate(dateStr); var UserActionDTOs = AMapper.Mapper.Map <IEnumerable <UserAction>, IEnumerable <UserActionGetDetailDTO> >(userActions); return(UserActionDTOs); }