public void TestChangePath() { string name = "Test before"; int number = 42; string newpath = TEST_DIRECTORY + "testChangePathNew.txt"; using (Repository<TestObject> manager = new Repository<TestObject>(TEST_DIRECTORY + "testChangePath.txt")) { TestObject data = manager.GetData(); data.Name = name; data.Number = number; manager.Save(); manager.ChangePath(newpath); Assert.IsTrue(File.Exists(newpath)); Assert.AreEqual(Path.GetFullPath(newpath), manager.Path); TestObject loadData = manager.GetData(); Assert.AreEqual(name, loadData.Name); Assert.AreEqual(number, loadData.Number); } using (Repository<TestObject> manager = new Repository<TestObject>(newpath)) { TestObject loadData = manager.GetData(); Assert.AreEqual(name, loadData.Name); Assert.AreEqual(number, loadData.Number); } }
public List <ComentarioDto> GetAllComentariosById(int Id) { object parameters = new { Id }; IEnumerable <Comentario> comentarios = comentarioRepository.GetData(ComentarioQueries.GET_COMENTARIOS_BY_ID, parameters); List <ComentarioDto> comentariosDto = mapper.ListEntityToListDto(comentarios); return(comentariosDto); }
private void DownloadData(int observatoryId, int instrumentId, int dataTypeId, DateTime dateTime) { int fileFound = 0; try { using (Stream downloadStream = Repository.GetData(observatoryId, instrumentId, dataTypeId, dateTime)) { var list = Repository.GetDataToDownload(observatoryId, instrumentId, dataTypeId, dateTime); string[] allFiles = Directory.GetFiles(list[0]); foreach (var item in allFiles) { if (item.Contains(list[1])) { if (!item.Contains(".jpg") && !item.Contains(".png") && !item.Contains(".bmp")) { fileFound++; FileInfo file = new FileInfo(item); Response.Clear(); Response.AddHeader("Content-Disposition", "attachment; filename=" + file.Name); Response.AddHeader("Content-Length", file.Length.ToString()); Response.ContentType = "multipart/form-data"; Response.Flush(); Response.TransmitFile(file.FullName); Response.End(); } } } string path = list[0].Substring(0, list[0].LastIndexOf("\\")); string[] allFilesUpDir = Directory.GetFiles(path); foreach (var item in allFilesUpDir) { if (item.Contains(list[1])) { if (!item.Contains(".jpg") && !item.Contains(".png") && !item.Contains(".bmp")) { fileFound++; FileInfo file = new FileInfo(item); Response.Clear(); Response.AddHeader("Content-Disposition", "attachment; filename=" + file.Name); Response.AddHeader("Content-Length", file.Length.ToString()); Response.ContentType = "multipart/form-data"; Response.Flush(); Response.TransmitFile(file.FullName); Response.End(); } } } if (fileFound == 0) { ActionStatus.Text = string.Format("Data not found or data has not been loaded yet"); } } } catch { ActionStatus.Text = string.Format("Data not found or data has not been loaded yet"); } }
public List <string> GetPartTime() { using (var context = new TestDbEntities()) { var rep = new Repository(); return(rep.GetData(context.PTContractors.AsQueryable())); } }
public void GetUserInfoFromRepoTest() { _repo = new Repository <ToolkitUser>(); var userInfo = _repo.GetData(); Assert.AreEqual(userInfo.Name, "MOMA"); Assert.AreEqual(userInfo.Password, ""); Assert.AreEqual(userInfo.Domain, "NCDMZ"); }
public void GetData_OK() { Func <Entities> contextCreator = () => new Entities(); Repository <Firm> instance = new Repository <Firm>(dbContextCreator: contextCreator); Expression <Func <Firm, bool> > filter = a => a.FirmId == "00000000-0000-0000-0000-000000000000"; IEnumerable <Firm> result = instance.GetData(filter); Assert.IsNotNull(result); Assert.IsTrue(result.Count() == 0); }
public IEnumerable <GetGamesListDto> Execute(GetGamesListQuery query) { var result = Repository.GetData <GetGamesListDto>().OrderByDescending(x => x.GameDate).Skip(query.Skip); if (query.Take > 0) { result = result.Take(query.Take); } return(result.ToList()); }
public void Add_Null_EmptyList() { //arrange Repository rep = new Repository(); Author a = null; //act rep.Add(a); //assert Assert.Equal(new List <Unit>(), rep.GetData()); }
public AvaliacaoUsuarioDto GetAllAvaliacaoUsuariosByCursoId(int CursoIdAvaliacao) { object parameters = new { CursoIdAvaliacao }; IEnumerable <AvaliacaoUsuario> avaliacaoUsuarios = avaliacaoUsuarioRepository.GetData(AvaliacaoUsuarioQueries.GET_AVALIACAOUSUARIO_BY_CURSO_ID, parameters); if (avaliacaoUsuarios.Count() == 0) { return(null); } int soma = 0; int somaQualidade = 0; int somaInfra = 0; int somaOrg = 0; int count = 0; AvaliacaoUsuarioDto avaliacoesUsuario = new AvaliacaoUsuarioDto(); foreach (var avaliacao in avaliacaoUsuarios) { if (count == 0) { avaliacoesUsuario.CursoId = avaliacao.CursoIdAvaliacao; avaliacoesUsuario.Id = avaliacao.AvaliacaoUsuarioId; } soma += avaliacao.Nota; somaQualidade += avaliacao.QualidadeMaterial; somaInfra += avaliacao.InfraestruturaPoloApoio; somaOrg += avaliacao.OrganizacaoVirtual; count++; } soma /= count; somaQualidade /= count; somaInfra /= count; somaOrg /= count; avaliacoesUsuario.Nota = soma; avaliacoesUsuario.OrganizacaoVirtual = somaOrg; avaliacoesUsuario.QualidadeMaterial = somaQualidade; avaliacoesUsuario.InfraestruturaPoloApoio = somaInfra; return(avaliacoesUsuario); }
static void Main(string[] args) { var repo = new Repository(); var teacher = repo.GetData(); foreach (var course in teacher.Courses) { foreach (var student in course.Students) { Console.WriteLine($"The student {student.Name} is in {course.Name} course, imparted by {teacher.Name}"); } } Console.ReadLine(); }
/// <summary> Get name of language by source language Id and current user language Id. </summary> public string GetLanguageNameById(int srcLangId, int userLangId) { // Check if (srcLangId < 1) { throw new CoreException("Invalid source language id was specified."); } if (userLangId < 1) { throw new CoreException("Invalid user language id was specified."); } // Create query XQuery q = new XQuery() .Select().Column <LanguageData>(ld => ld.Label) .From <LanguageData>() .Where().Column <LanguageData>(ld => ld.LanguageSrcId).Equals().Value(srcLangId) .And().Column <LanguageData>(ld => ld.LanguageId).Equals().Value(userLangId).End(); // Fetch QueryResult qr = repository.GetData(q); return(qr.ConvertToEnumerable <string>().FirstOrDefault()); }
public void Remove_ExceedIndex_Nothing() { //arrange Repository rep = new Repository(); Author a1 = new Author("A"); Author a2 = new Author("B"); int ind = 2; //act rep.Add(a1); rep.Add(a2); rep.Remove(ind); //assert Assert.Equal(a2.fName, (rep.GetData().Last() as Author).fName); }
public void SaveAndGetUserInfoToRepoTest() { _repo = new Repository <ToolkitUser>(); var userInfo = new ToolkitUser { Name = "Testname", Password = @"o_v2\J;CRpiR/mx:hx1/3d=PveE&LijSr,+k@PXL'UTH)" }; var success = _repo.SaveData(userInfo); var retrievedUser = _repo.GetData(); Assert.IsTrue(success); Assert.AreEqual(userInfo.Name, retrievedUser.Name); Assert.AreEqual(userInfo.Password, retrievedUser.Password); }
public void Remove_NegativeIndex_RemoveBehind() { //arrange Repository rep = new Repository(); Author a1 = new Author("A"); Author a2 = new Author("B"); int ind = -1; //act rep.Add(a1); rep.Add(a2); rep.Remove(ind); //assert var r = (rep.GetData().Last() as Author).fName; Assert.Equal(a1.fName, r); }
public IHttpActionResult TopBuyer() { var customers = Repository .GetData() // ReSharper disable once RedundantTypeArgumentsOfMethod - rrequired by build.cmd .ContinueWith <IOrderedQueryable <Customer> >(Customer.GetTopBuyer) .Result .ToArray(); if (!customers.Any()) { return(NotFound()); } return(Ok(customers.First())); }
public void ProcessRequest(HttpContext context) { try { // Get input parameters. DateTime dateTime = ImageHandler.GetParameter <DateTime>(context, ImageHandler.DateTimeParameterName); int observatoryId = ImageHandler.GetParameter <int>(context, ImageHandler.ObservatoryIdParameterName); int instrumentId = ImageHandler.GetParameter <int>(context, ImageHandler.InstrumentIdParameterName); int dataTypeId = ImageHandler.GetParameter <int>(context, ImageHandler.DataTypeIdParameterName); // Return data plot. using (Stream imageStream = Repository.GetData(observatoryId, instrumentId, dataTypeId, dateTime)) { context.Response.ContentType = "image/png"; imageStream.CopyTo(context.Response.OutputStream); } } catch { // Return 'Data Unavailable' image. context.Response.ContentType = "image/jpg"; LocalizedText.NoData.Save(context.Response.OutputStream, ImageFormat.Jpeg); } }
public void TestInvalidFileOverride() { string path = TEST_DIRECTORY + "testInvalidFileOverride.txt"; string fileContent = "}!Invalid file!{"; using (StreamWriter writer = new StreamWriter(path)) { writer.Write(fileContent); } using (Repository<TestObject> manager = new Repository<TestObject>(path, true)) { TestObject loadData = manager.GetData(); loadData.Name = "Testing one two"; loadData.Number = 42; manager.Save(); } using (StreamReader reader = new StreamReader(path)) { Assert.AreNotEqual(fileContent, reader.ReadToEnd()); } }
public int Execute(GetPlayerCountByNameQuery query) { return(Repository.GetData <GetPlayerCountByNameDto>().Count(x => x.PlayerName.ToUpper() == query.PlayerName.ToUpper())); }
public void TestSaving() { string path = TEST_DIRECTORY + "testSaving.txt"; string name = "Test"; int number = 42; Repository<TestObject> manager = null; using (manager = new Repository<TestObject>(path)) { TestObject data = manager.GetData(); data.Name = name; data.Number = number; manager.Save(); TestObject loadData1 = manager.GetData(); Assert.AreEqual(name, loadData1.Name); Assert.AreEqual(number, loadData1.Number); } using (manager = new Repository<TestObject>(path)) { TestObject loadData2 = manager.GetData(); Assert.AreEqual(name, loadData2.Name); Assert.AreEqual(number, loadData2.Number); } }
public void TestReset() { using (Repository<TestObject> manager = new Repository<TestObject>(TEST_DIRECTORY + "testReset.txt")) { string name = "Test before"; int number = 42; TestObject data = manager.GetData(); data.Name = name; data.Number = number; manager.Save(); manager.Reset(); TestObject loadData = manager.GetData(); Assert.AreNotEqual(loadData.Name, name); Assert.AreNotEqual(loadData.Number, number); } }
public void TestReference() { using (Repository<TestObjectReference> manager = new Repository<TestObjectReference>(TEST_DIRECTORY + "testReference.txt")) { int value1 = 1; int value2 = 2; TestObjectReference data1 = manager.GetData(); TestObjectReference data2 = new TestObjectReference(); data1.Reference = data2; data1.Value = value1; data2.Reference = data1; data2.Value = value2; manager.Save(); TestObjectReference result = manager.GetData(); Assert.AreEqual(value1, result.Value); Assert.AreEqual(value2, result.Reference.Value); Assert.AreEqual(value1, result.Reference.Reference.Value); } }
public ActionResult Index() { var foo = repo.GetData(); return(View(foo)); }
public async Task <IResultsContainer <T> > GetData <T>(params KeyValuePair <string, string>[] parameters) where T : IBdoBase { var data = await Repository.GetData <T>(parameters); return(data); }
public IEnumerable <GetPlayersDto> Execute(GetPlayersQuery query) { return(Repository.GetData <GetPlayersDto>().OrderByDescending(x => x.GamesPlayed).ToList()); }
public IEnumerable <GetGamePlayersDto> Execute(GetGamePlayersQuery query) { return(Repository.GetData <GetGamePlayersDto>().Where(x => x.GameId == query.GameId).ToList()); }
public List <CursoDto> GetCursoFiltered(CursoDto curso = null, string nomeFaculdade = null) { int faculdadeId = 0; if (nomeFaculdade != null) { var faculdade = faculdadeBusiness.GetFaculdadeByNome(nomeFaculdade); faculdadeId = faculdade == null ? faculdadeId : faculdade.Id; } object parameters = BuildParameters(curso); if (faculdadeId != 0) { curso.FaculdadeId = faculdadeId; } string query = BuildQuery(curso); if (parameters != null) { List <CursoDto> listaCursos = mapper.ListEntityToListDto(cursoDapperRepository.GetData(query, parameters)); if (faculdadeId != 0) { listaCursos = listaCursos.FindAll(x => x.FaculdadeId == faculdadeId); } foreach (var curs in listaCursos) { curs.Faculdade = faculdadeBusiness.GetFaculdadeById(curs.FaculdadeId); curs.TipoCurso = tipoCursoBusiness.GetTipoCursoById(curs.TipoId); curs.AvaliacaoUsuario = avaliacaoUsuarioBusiness.GetAllAvaliacaoUsuariosByCursoId(curs.Id); } if (curso.TipoId != 0) { return(listaCursos.FindAll(x => x.TipoId == curso.TipoId)); } return(listaCursos); } else { if (faculdadeId != 0) { var cursoFinal = mapper.ListEntityToListDto(cursoDapperRepository.GetData(query, null)).FindAll(x => x.FaculdadeId == faculdadeId); foreach (var cursoIndividual in cursoFinal) { cursoIndividual.Faculdade = faculdadeBusiness.GetFaculdadeByNome(nomeFaculdade); cursoIndividual.AvaliacaoUsuario = avaliacaoUsuarioBusiness.GetAllAvaliacaoUsuariosByCursoId(cursoIndividual.Id); cursoIndividual.TipoCurso = tipoCursoBusiness.GetTipoCursoById(cursoIndividual.TipoId); } if (curso.TipoId != 0) { return(cursoFinal.FindAll(x => x.TipoId == curso.TipoId)); } return(cursoFinal); } else { var cursos = mapper.ListEntityToListDto(cursoDapperRepository.GetData(query, null)); foreach (var curs in cursos) { curs.Faculdade = faculdadeBusiness.GetFaculdadeById(curs.FaculdadeId); curs.TipoCurso = tipoCursoBusiness.GetTipoCursoById(curs.TipoId); curs.AvaliacaoUsuario = avaliacaoUsuarioBusiness.GetAllAvaliacaoUsuariosByCursoId(curs.Id); } if (curso.TipoId != 0) { return(cursos.FindAll(x => x.TipoId == curso.TipoId)); } return(cursos); } } }
public int Execute(GetGameCountByDateQuery query) { return(Repository.GetData <GetGameCountByDateDto>().Count(x => x.GameYear == query.GameDate.Year && x.GameMonth == query.GameDate.Month && x.GameDay == query.GameDate.Day)); }