// GET: api/Alerts
public IQueryable<AlertModel> GetAlerts()
{
HashSet<AlertModel> alerts = new HashSet<AlertModel>
{
new AlertModel
{
CreatedAt = DateTime.Now.AddMinutes(-3),
DigitalOutput = 1,
OutputText = "Camera1"
},
new AlertModel
{
CreatedAt = DateTime.Now.AddMinutes(-2),
DigitalOutput = 2,
OutputText = "Camera2"
},
new AlertModel
{
CreatedAt = DateTime.Now.AddMinutes(-1),
DigitalOutput = 3,
OutputText = "Camera3"
},
new AlertModel
{
CreatedAt = DateTime.Now,
DigitalOutput = 4,
OutputText = "Camera4"
}
};
return alerts.AsQueryable();
}
/// <summary>
/// Получить все годы, за которые есть покупи
/// </summary>
/// <returns></returns>
public IQueryable <int> SelectAllYears()
{
HashSet <int> years = new HashSet <int>();
_purchaseList.ForEach(p =>
{
int year = p.Date.Year;
if (!years.Contains(year))
{
years.Add(year);
}
});
return(years.AsQueryable());
}
public void ReturnNull_WhenRequestedIdIsNull()
{
// Arrange
var dbContext = new Mock <ICarAdvertsSystemDbContext>();
var entities = new Mock <DbSet <MockDbModel> >();
dbContext.Setup(c => c.Set <MockDbModel>()).Returns(entities.Object);
var efGenericRepository = new EfGenericRepository <MockDbModel>(dbContext.Object);
var fakeData = new HashSet <MockDbModel>()
{
new MockDbModel()
{
Id = 1
},
new MockDbModel()
{
Id = 2
},
new MockDbModel()
{
Id = 3
},
new MockDbModel()
{
Id = 4
},
new MockDbModel()
{
Id = 5
}
};
var fakeDataQueryable = fakeData.AsQueryable();
entities.As <IQueryable>().Setup(e => e.GetEnumerator()).Returns(fakeDataQueryable.GetEnumerator());
entities.As <IQueryable>().Setup(e => e.ElementType).Returns(fakeDataQueryable.ElementType);
entities.As <IQueryable>().Setup(e => e.Expression).Returns(fakeDataQueryable.Expression);
entities.As <IQueryable>().Setup(e => e.Provider).Returns(fakeDataQueryable.Provider);
// Act
var actualReturnedTEntity = efGenericRepository.GetById(null);
// Assert
Assert.That(actualReturnedTEntity, Is.Null);
}
public HttpResponseMessage GetAll()
{
var httpResponse = this.PerformOperation(() =>
{
var schoolEntities = this.unitOfWork.SchoolsRepository.GetAll().ToList();
var schoolModels = new HashSet<SchoolModel>();
foreach (var schoolEntity in schoolEntities)
{
schoolModels.Add(SchoolsMapper.ToSchoolModel(schoolEntity));
}
return schoolModels.AsQueryable<SchoolModel>();
});
return httpResponse;
}
/// <summary>
/// Получить все годы, за которые есть покупки
/// </summary>
/// <returns></returns>
public IQueryable <int> SelectAllYears()
{
var years = new HashSet <int>();
var t = Purchase.ForEachAsync(p =>
{
int year = p.Date.Year;
if (!years.Contains(year))
{
years.Add(year);
}
});
t.Wait();
return(years.AsQueryable <int>());
}
public async Task <IQueryable <TrademarkDto> > Handle(Query message)
{
var protectionDocSimilarities = await _context.RequestProtectionDocSimilarities
.Where(x => x.RequestId == message.RequestId)
.ToListAsync();
var requests = protectionDocSimilarities.Select(pd => pd.ProtectionDoc);
var imageDtos = new HashSet <TrademarkDto>();
foreach (var request in requests)
{
imageDtos.Add(_mapper.Map <TrademarkDto>(request));
}
return(imageDtos.AsQueryable());
}
public HttpResponseMessage Get(string subject, double value)
{
var httpResponse = this.PerformOperation(() =>
{
var studentEntities = this.unitOfWork.StudentsRepository
.GetBySubjectAndMark(subject, value).ToList();
var studentModels = new HashSet<StudentModel>();
foreach (var studentEntity in studentEntities)
{
studentModels.Add(StudentsMapper.ToStudentModel(studentEntity));
}
return studentModels.AsQueryable<StudentModel>();
});
return httpResponse;
}
public void Index_ShouldReturnViewWithAllPublicMoules()
{
var samplePublicModules = new HashSet <Module>
{
new Module {
Id = 1, IsPublic = true
},
new Module {
Id = 2, IsPublic = true
},
new Module {
Id = 3, IsPublic = true
}
};
var simpleViewModels = new HashSet <ModuleViewModel>
{
new ModuleViewModel {
Id = 1
},
new ModuleViewModel {
Id = 2
},
new ModuleViewModel {
Id = 3
}
};
this.modulesDataServiceMock.Setup(x => x.AllPublicWithQuestionsWithCorrectAnswer()).Returns(() => samplePublicModules.AsQueryable());
this.mappingServiceMock.Setup(x => x.MapCollection <ModuleViewModel>(It.IsAny <IQueryable <Module> >(), null))
.Returns(() => simpleViewModels.AsQueryable());
var result = this.modulesController.Index();
Assert.IsType <ViewResult>(result);
var castResult = result.As <ViewResult>();
var model = castResult.ViewData.Model.As <IEnumerable <ModuleViewModel> >();
Assert.NotNull(model);
Assert.NotEmpty(model);
Assert.Equal(3, model.Count());
}
/// <summary>
/// Получение задач
/// ПЕЙДЖИНГА ТУТ БЫТЬ НЕ ДОЛЖНО
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
public List <ITask> Get(TaskFilter filter)
{
using (new ReadLock(filter.BoardId))
{
HashSet <ITask> allTasks = GetTasksCache(filter.BoardId);
if (allTasks == null)
{
List <ITask> tasks = Repository.Tasks.Get(filter).ToList();
return(tasks);
}
else
{
// данные по такому фильтру получали, по этому берем из кеша
IQueryable <ITask> tasks = allTasks.AsQueryable();
IOrderedQueryable <ITask> ordered = filter.Order(filter.Where(tasks));
return(ordered.ToList());
}
}
}
public InMemoryDbSet(
IEnumerable <T> data = null,
Func <HashSet <T>, object[], T> find = null,
Action <string, IEnumerable <T> > include = null,
Func <string, object[], DbSqlQuery <T> > sqlQuery = null)
{
_data = data == null ? new HashSet <T>() : new HashSet <T>(data);
_query = new InMemoryAsyncQueryable <T>(_data.AsQueryable(), (p, d) =>
{
var asEntityEnumerable = d as IEnumerable <T>;
if (include != null &&
asEntityEnumerable != null)
{
include(p, asEntityEnumerable);
}
});
_find = find;
_include = include;
_sqlQuery = sqlQuery;
}
public void AddNewCarswithDuplicatedName_ShoudlNotBeAdded()
{
//arrange
var user = new User {
DisplayName = "user1"
};
var mock = new Mock <IRepository <Car> >();
var mockUser = new Mock <IUserService>();
var carService = new CarService(mock.Object, mockUser.Object);
Car c1 = new Car("Same Name");
Car c2 = new Car("Same Name");
var collection = new HashSet <Car>();
mock.Setup(x => x.Add(It.IsAny <Car>()))
.Callback <Car>((c) => {
collection.Add(c);
});
mockUser.Setup(x => x.CurrentUser).Returns(user);
mock.Setup(x => x.Query(It.IsAny <Func <Car, bool> >()))
.Returns(collection.AsQueryable());
//act
carService.Add(c1);
//assert
var ex = Assert.Throws <Exception>(() => {
carService.Add(c2);
});
ex.Message.ShouldEqual("This name has been used already.");
var cars = carService.All();
cars.ShouldContain(c1);
cars.ShouldNotContain(c2);
}
protected virtual IQueryable <string> GetAssemblyFilesToReference(ISitecoreConnectionSettings settings)
{
var list = new List <Assembly>
{
Assembly.Load(new AssemblyName("Sitecore.ContentSearch")),
Assembly.Load(new AssemblyName("Sitecore.ContentSearch.Linq")),
typeof(IQueryable).Assembly
};
var selectedType = settings.SearchResultType.GetSelectedType();
if (selectedType != null)
{
list.Add(selectedType.Assembly);
}
var assemblies = new HashSet <Assembly>();
foreach (var assembly in list)
{
this.AddAssemblyFiles(assembly, assemblies);
}
return(from a in assemblies.AsQueryable <Assembly>() select a.Location);
}
public void AddTwoCarsWithDuplicateName_Failed()
{
var mock = new Mock <IRepository <Car> >();
var user = new User {
DisplayName = "user1"
};
var mockUser = new Mock <IUserService>();
mockUser.Setup(u => u.CurrentUser).Returns(user);
var s = new CarService(mock.Object, mockUser.Object);
var c1 = new Car("Jazz")
{
Owner = user
};
var c2 = new Car("Jazz")
{
Owner = user
};
var collection = new HashSet <Car>();
mock.Setup(repo => repo.Add(It.IsAny <Car>()))
.Callback <Car>((c) => {
collection.Add(c);
});
mock.Setup(repo => repo.Query(It.IsAny <Func <Car, bool> >()))
.Returns(collection.AsQueryable());
s.Add(c1);
var ex = Assert.Throws <Exception>(() => {
s.Add(c2);
});
ex.Message.ShouldEqual("This name has been used already.");
mock.Verify(r => r.Add(c1), Times.Once);
}
public FakeDbSet()
{
_data = new HashSet <T>();
_query = _data.AsQueryable();
}
public void CallContextSaveChanges_WhenInvoked()
{
// Arrange
var songRepo = new Mock <IEfContextWrapper <Song> >();
var artistRepo = new Mock <IEfContextWrapper <Artist> >();
var albumRepo = new Mock <IEfContextWrapper <Album> >();
var genreRepo = new Mock <IEfContextWrapper <Genre> >();
var context = new Mock <ISaveContext>();
var id = Guid.NewGuid();
int?duration = 5;
var lyrics = "Lyrics";
var videoUrl = "VideoUrl";
var coverUrl = "CoverUrl";
var genres = new List <string>()
{
"Genre Name"
};
var songTitle = "Song Title";
var songCollection = new List <Song>()
{
new Song()
{
Title = songTitle,
Id = id
}
};
var artistName = "Artist Name";
var artistCollection = new List <Artist>()
{
new Artist()
{
Name = artistName
}
};
var albumTitle = "Album Title";
var albumCollection = new List <Album>()
{
new Album()
{
Title = albumTitle
}
};
var genreName = "Genre Name";
var genreCollection = new HashSet <Genre>()
{
new Genre()
{
Name = genreName
}
};
genreRepo.Setup(x => x.All).Returns(() => genreCollection.AsQueryable());
albumRepo.Setup(x => x.All).Returns(() => albumCollection.AsQueryable());
artistRepo.Setup(x => x.All).Returns(() => artistCollection.AsQueryable());
songRepo.Setup(x => x.All).Returns(() => songCollection.AsQueryable());
songRepo.Setup(x => x.Update(It.IsAny <Song>()));
context.Setup(x => x.SaveChanges());
var sut = new SongModifyService(
songRepo.Object,
artistRepo.Object,
albumRepo.Object,
genreRepo.Object,
context.Object);
// Act
sut.UpdateSong(id, songTitle, artistName, albumTitle, duration, genres, lyrics, videoUrl, coverUrl);
// Assert
context.Verify(x => x.SaveChanges());
}
private MockDbSet(IEnumerable <T> data)
{
_data = new HashSet <T>(data);
_query = _data.AsQueryable();
}
public IQueryable <IMarketData> SearchFor(Expression <Func <IMarketData, bool> > predicate)
{
return(_storage.AsQueryable().Where(predicate));
}
public void AssingSongPropertiesCorrectly_WhenInvoked()
{
// Arrange
var songRepo = new Mock <IEfContextWrapper <Song> >();
var artistRepo = new Mock <IEfContextWrapper <Artist> >();
var albumRepo = new Mock <IEfContextWrapper <Album> >();
var genreRepo = new Mock <IEfContextWrapper <Genre> >();
var context = new Mock <ISaveContext>();
var id = Guid.NewGuid();
int?duration = 5;
var lyrics = "Lyrics";
var videoUrl = "VideoUrl";
var coverUrl = "CoverUrl";
var genres = new List <string>()
{
"Genre Name"
};
var songTitle = "Song Title";
var songCollection = new List <Song>()
{
new Song()
{
Title = songTitle,
Id = id
}
};
var artistName = "Artist Name";
var artistCollection = new List <Artist>()
{
new Artist()
{
Name = artistName
}
};
var albumTitle = "Album Title";
var albumCollection = new List <Album>()
{
new Album()
{
Title = albumTitle
}
};
var genreName = "Genre Name";
var genreCollection = new HashSet <Genre>()
{
new Genre()
{
Name = genreName
}
};
genreRepo.Setup(x => x.All).Returns(() => genreCollection.AsQueryable());
albumRepo.Setup(x => x.All).Returns(() => albumCollection.AsQueryable());
artistRepo.Setup(x => x.All).Returns(() => artistCollection.AsQueryable());
songRepo.Setup(x => x.All).Returns(() => songCollection.AsQueryable());
var sut = new SongModifyService(
songRepo.Object,
artistRepo.Object,
albumRepo.Object,
genreRepo.Object,
context.Object);
// Act
sut.UpdateSong(id, songTitle, artistName, albumTitle, duration, genres, lyrics, videoUrl, coverUrl);
// Assert
var song = songRepo.Object.All.FirstOrDefault();
Assert.AreEqual(id, song.Id);
Assert.AreEqual(songTitle, song.Title);
Assert.AreEqual(artistName, song.Artist.Name);
Assert.AreEqual(albumTitle, song.Album.Title);
Assert.AreEqual(duration, song.Duration);
// TODO: Fix unknown problem with genre assign
//Assert.AreEqual(genres[0], song.Genres.FirstOrDefault().Name);
Assert.AreEqual(lyrics, song.Lyrics);
Assert.AreEqual(videoUrl, song.VideoUrl);
Assert.AreEqual(coverUrl, song.Album.CoverUrl);
}
public InMemoryQueryableSet(IEnumerable <TEntity> entities)
{
_set = new HashSet <TEntity>(entities);
_queryableSet = _set.AsQueryable();
}
public async Task <GameSession[]> FindGameSessions(Func <GameSession, bool> filter)
{
var results = filter != null?cache.Where(filter) : cache.AsQueryable();
return(await Task.FromResult(results.ToArray()));
}
public TestDataSet()
{
entities = new HashSet <TEntity> ();
query = entities.AsQueryable();
}
public override IQueryable <RedirectRule> GetAll() => _redirectsHashSet.AsQueryable();
public FakeObjectSet(IEnumerable <T> initialData)
{
_data = new HashSet <T>(initialData);
_query = _data.AsQueryable();
}
public IQueryable <T> Query(Func <T, bool> criteria)
{
return(items.AsQueryable());
}
public IQueryable<StudentsModel> Get(string subject, double value)
{
var httpResponse = this.PerformOperationAndHandleExceptions(() =>
{
var studentEntities = this
.GetBySubjectAndMark(subject, value).ToList();
var studentModels = new HashSet<StudentsModel>();
foreach (var studentEntity in studentEntities)
{
studentModels.Add(
new StudentsModel()
{
FirstName = studentEntity.FirstName,
LastName = studentEntity.LastName,
Age = studentEntity.Age,
Grade = studentEntity.Grade
});
}
return studentModels.AsQueryable<StudentsModel>();
});
return httpResponse;
}
public GenericFakeDbSet(Func <T, TKey> keySelector)
{
_hash = new HashSet <T>();
_query = _hash.AsQueryable();
_keySelector = keySelector;
}
public InMemoryDbSet()
{
data = new HashSet <T>();
query = data.AsQueryable();
}
public FakeDbSet(Func <T, object[], bool> findSelector)
{
_findSelector = findSelector;
data = new HashSet <T>();
query = data.AsQueryable();
}
public FakeObjectSet(IEnumerable <TEntity> testData)
{
_data = new HashSet <TEntity>(testData);
_query = _data.AsQueryable();
}
public InMemoryDbSet()
{
_data = new HashSet <T>();
_query = _data.AsQueryable();
}
public void GenerateExcel_Success()
{
var packinglistmodel = new GarmentPackingListModel("", "", "DL", 1, "", DateTimeOffset.Now, "", "", DateTimeOffset.Now, "", 1, "", "", "", "USA", "", DateTimeOffset.Now, DateTimeOffset.Now, DateTimeOffset.Now, true, true, "", "", "", null, 1, 1, 1, 1, null, "", "", "", "", "", "", "", true, true, 1, "", GarmentPackingListStatusEnum.CREATED, "", false, "")
{
Id = 1
};
var invoiceItemModels = new HashSet <GarmentShippingInvoiceItemModel>
{
new GarmentShippingInvoiceItemModel("ro", "scno", 1, "buyerbrandname", 10, 1, "comocode", "comoname", "comodesc", "comodesc", "comodesc", "comodesc", 1, "PCS", 10, 10, 100, "usd", 1, "unitcode", 3, 1)
{
GarmentShippingInvoiceId = 1
},
new GarmentShippingInvoiceItemModel("ro", "scno", 1, "buyerbrandname", 15, 2, "comocode2", "comoname2", "comodesc2", "comodesc", "comodesc", "comodesc", 2, "SETS", 20, 20, 300, "usd", 1, "unitcode", 3, 2)
{
GarmentShippingInvoiceId = 1
},
new GarmentShippingInvoiceItemModel("ro", "scno", 2, "buyerbrandname2", 10, 1, "comocode", "comoname", "comodesc", "comodesc", "comodesc", "comodesc", 1, "PCS", 10, 10, 100, "usd", 1, "unitcode", 3, 3)
{
GarmentShippingInvoiceId = 1
},
new GarmentShippingInvoiceItemModel("ro", "scno", 2, "buyerbrandname2", 15, 2, "comocode2", "comoname2", "comodesc2", "comodesc", "comodesc", "comodesc", 2, "SETS", 20, 20, 300, "usd", 1, "unitcode", 3, 4)
{
GarmentShippingInvoiceId = 1
}
};
var invoiceUnitModels = new HashSet <GarmentShippingInvoiceUnitModel> {
new GarmentShippingInvoiceUnitModel(1, "unitcode", 3, 1)
{
Id = 1
}
};
var invoiceModel = new GarmentShippingInvoiceModel(1, "invoiceno", DateTimeOffset.Now, "from", "to", 1, "buyercode", "buyername", "consignee", "lcno", "issuedby", 1, "sectioncode", "shippingper", DateTimeOffset.Now, "confNo", 1, "staff", 1, "cottn", 1, "mandiri", 10, "", DateTimeOffset.Now, "", DateTimeOffset.Now, "", "", invoiceItemModels, 1000, "23", "dsdsds", "memo", false, "", DateTimeOffset.Now, "", DateTimeOffset.Now, "", DateTimeOffset.Now, null, 100000, "aa", "aa", invoiceUnitModels)
{
Id = 1,
};
var repoMock = new Mock <IGarmentShippingInvoiceRepository>();
repoMock.Setup(s => s.ReadAll())
.Returns(new List <GarmentShippingInvoiceModel>()
{
invoiceModel
}.AsQueryable());
var repoMock1 = new Mock <IGarmentShippingInvoiceItemRepository>();
repoMock1.Setup(s => s.ReadAll())
.Returns(invoiceItemModels.AsQueryable());
var repoMock2 = new Mock <IGarmentPackingListRepository>();
repoMock2.Setup(s => s.ReadAll())
.Returns(new List <GarmentPackingListModel>()
{
packinglistmodel
}.AsQueryable());
var service = GetService(GetServiceProvider(repoMock.Object, repoMock1.Object, repoMock2.Object).Object);
var result = service.GetReportData(packinglistmodel.TruckingDate.Year);
Assert.NotNull(result);
}
public IQueryable <TEntity> Query()
{
return(entities.AsQueryable <TEntity> ());
}
public InMemoryQueryableSet()
{
_set = new HashSet <TEntity>();
_queryableSet = _set.AsQueryable();
}
public IQueryable <T> GetQuery(bool TrackingChanges = true)
{
return(database.AsQueryable());
}
protected virtual IQueryable<string> GetAssemblyFilesToReference(ISitecoreConnectionSettings settings)
{
var list = new List<Assembly>
{
Assembly.Load(new AssemblyName("Sitecore.ContentSearch")),
Assembly.Load(new AssemblyName("Sitecore.ContentSearch.Linq")),
typeof(IQueryable).Assembly
};
var selectedType = settings.SearchResultType.GetSelectedType();
if (selectedType != null)
{
list.Add(selectedType.Assembly);
}
var assemblies = new HashSet<Assembly>();
foreach (var assembly in list)
{
this.AddAssemblyFiles(assembly, assemblies);
}
return (from a in assemblies.AsQueryable<Assembly>() select a.Location);
}
