public IQueryable <Worker> GetWorkers(WorkerSearch searchModel)
{
var result = Context.Workers.AsQueryable();
if (searchModel != null)
{
//if (searchModel.Id.HasValue)
// result = result.Where(x => x.Id == searchModel.Id);
//if (!string.IsNullOrEmpty(searchModel.Name))
// result = result.Where(x => x.Name.Contains(searchModel.Name));
//if (searchModel.PriceFrom.HasValue)
// result = result.Where(x => x.Price >= searchModel.PriceFrom);
//if (searchModel.PriceTo.HasValue)
// result = result.Where(x => x.Price <= searchModel.PriceTo);
if (!string.IsNullOrEmpty(searchModel.FirstName))
{
result = result.Where(x => x.FirstName.Contains(searchModel.FirstName));
}
if (!string.IsNullOrEmpty(searchModel.LastName))
{
result = result.Where(x => x.LastName.Contains(searchModel.LastName));
}
}
return(result);
}
public void CreateData1()
{
using (var session = _documentStore.OpenSession())
{
var search1 = new WorkerSearch()
{
Date = new DateTime(2011, 10, 5),
Title = "Programador Javascript",
Description = "Se necesita un programador de javascript que conozca de arriba a abajo jQuery.",
Skills = new List <string> {
"Javascript", "jQuery", "C#"
}
};
session.Store(search1);
session.Store(new WorkerSearch()
{
Date = new DateTime(2011, 11, 15),
Title = "Experto en COBOL",
Description = "Se necesita un programador de COBOL.",
Skills = new List <string> {
"COBOL", "OTRONOMBRE1"
}
});
session.Store(new WorkerSearch()
{
Date = new DateTime(2011, 11, 20),
Title = "Programador FORTRAN",
Description = "Se necesita alguien que conozca al menos algo de FORTRAN 77.",
Skills = new List <string> {
"FORTRAN", "OTRONOMBRE2"
}
});
session.Store(new WorkerSearch()
{
Date = new DateTime(2011, 11, 20),
Title = "Che Pibe",
Description = "Se necesita alquien que ayude con cualquier cosa, no es necesario que sepa programar"
});
var advert1 = new Advertisement()
{
Content =
"¿Sos un experto en jQuery y te gustaría trabajar en una empresa divertida, dinámica y con el mejor sueldo? Envianos tu curriculum!",
Start = new DateTime(2011, 10, 20),
End = new DateTime(2011, 11, 10),
MediaName = "Diario La Capital",
WorkerSearchId = search1.Id
};
session.Store(advert1);
var applicant1 = new Applicant()
{
Name = "Juan Perez",
Country = "Argentina",
City = "Mar del Plata",
Address = "Calle Falsa 123",
BirthDate = new DateTime(1978, 1, 1),
MaritalStatus = MaritalStatus.Single,
Phones = new List <string> {
"477-7777", "155-555555"
},
Skills = new List <string> {
"Javascript", "jQuery", "HTML", "CSS", "PHP", "json"
},
AdvertisementIds = new List <string>()
{
advert1.Id
}
};
session.Store(applicant1);
session.SaveChanges();
}
}
private void SkillsInputAutocomplete()
{
using (var session = _documentStore.OpenSession())
{
//Este no aparece en los tags
var search2 = new WorkerSearch()
{
Date = new DateTime(2011, 10, 5),
Title = "Programador .NET",
Description = "Se necesita un programador .NET",
Skills = new List <string> {
"C#", "VisualBasic"
}
};
session.Store(search2);
//Me voy a traer la lista de skills ordenados por cantidad de busquedas realizadas y luego alfabeticamente para hacer un autocompleta
var qry = session.Query <SkillResult, Skills_All>()
.Customize(x => x.WaitForNonStaleResults())
.OrderByDescending(x => x.SearchCount)
.ThenBy(x => x.Name)
.Select(x => x.Name);
var allSkills = qry.Take(5).ToList();
Console.WriteLine("\n\nTodos los skills: ");
foreach (var skill in allSkills)
{
Console.WriteLine(skill);
}
//bug (o no soportado) en raven db:
//var skillsQueEmpiezanConJ = qry.Where(x => x.StartsWith("j")).Take(5).ToList();
//o
//var skillsQueEmpiezanConJ = session.Query<SkillResult, Skills_All>()
// .Customize(x => x.WaitForNonStaleResults())
// .OrderByDescending(x => x.SearchCount)
// .ThenBy(x => x.Name)
// .Select(x => x.Name)
// .Where(x => x.StartsWith("j"))
// .Take(5)
// .ToList();
var skillsQueEmpiezanConJ = session.Query <SkillResult, Skills_All>()
.Customize(x => x.WaitForNonStaleResults())
.Where(x => x.Name.StartsWith("j"))
.OrderByDescending(x => x.SearchCount)
.ThenBy(x => x.Name)
.Select(x => x.Name)
.Take(5)
.ToList();
Console.WriteLine("\n\nSkillsQueEmpiezanConJ: ");
foreach (var skill in skillsQueEmpiezanConJ)
{
Console.WriteLine(skill);
}
}
}
