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