/* Obtiene todos los perfiles creados por un Usuario */
/* Agregar un Investigador Privado */
public long Post(M.Person persona)
{
O.Person BDPerson = new O.Person
{
Name = persona.Name,
ProfesionDescription = persona.ProfesionDescription,
Email = persona.Email,
Phone = persona.Phone,
City = persona.City,
Latitude = persona.Latitude,
Longitude = persona.Longitude,
Ciprin = persona.Ciprin,
Active = false,
CreationDate = System.DateTime.Now.ToString(),
CreationHourZone = System.TimeZoneInfo.Local.ToString(),
Avatar = "",
NameAvatar = "",
Views = 0,
IdUser = persona.IdUser
};
BD.People.Add(BDPerson);
BD.SaveChanges();
O.User BDUser = BD.Users.FirstOrDefault(x => x.Id == persona.IdUser);
BDUser.CountProfiles = BDUser.CountProfiles + 1;
BD.SaveChanges();
return(BDPerson.Id);
}
/* Buscar Investigadores Privados */
public M.Person[] Get(string criterio)
{
var SP = BD.People;
var query = from P in SP
where ((P.City.Contains(criterio)) && P.Active)
select new { P.Id, P.Name, P.ProfesionDescription, P.Email, P.Phone, P.Latitude, P.Longitude, P.Ciprin, P.CreationDate, P.CreationHourZone, P.Avatar, P.Views, P.User.Username };
M.Person[] arrayPeople = new M.Person[query.Count()];
M.Person temp;
long i = 0;
foreach (var item in query)
{
temp = new M.Person
{
Id = item.Id,
Name = item.Name,
ProfesionDescription = item.ProfesionDescription,
Email = item.Email,
Phone = item.Phone,
Latitude = item.Latitude,
Longitude = item.Longitude,
Ciprin = item.Ciprin,
CreationDate = item.CreationDate,
CreationHourZone = item.CreationHourZone,
Avatar = item.Avatar,
Views = item.Views,
Username = item.Username
};
arrayPeople[i] = temp;
i++;
}
return(arrayPeople);
}
/* Buscar Investigadores Privados */
/* Obtiene todos los perfiles creados por un Usuario */
public M.Person[] Get(long idUser)
{
var SP = BD.People;
var SOP = BD.OtherPersons;
var query = from P in SP
where (P.IdUser.Equals(idUser))
select new { P.Id, P.Name, P.ProfesionDescription, P.Email, P.Phone, P.Ciprin, P.Active, P.CreationDate, P.CreationHourZone, P.Avatar, P.Views };
var query2 = from OP in SOP
where (OP.IdUser.Equals(idUser))
select new { OP.Id, OP.Name, OP.Profesion, OP.Email, OP.Phone, OP.Ciprin, OP.Active, OP.CreationDate, OP.CreationHourZone, OP.Avatar, OP.Views };
M.Person[] arrayPeople = new M.Person[query.Count() + query2.Count()];
M.Person PT;
int i = 0;
foreach (var item in query)
{
PT = new M.Person
{
Id = item.Id,
Name = item.Name,
ProfesionDescription = item.ProfesionDescription,
Email = item.Email,
Phone = item.Phone,
Ciprin = item.Ciprin,
Active = item.Active,
CreationDate = item.CreationDate,
CreationHourZone = item.CreationHourZone,
Avatar = item.Avatar,
Views = item.Views,
Type = false
};
arrayPeople[i] = PT;
i++;
}
foreach (var item in query2)
{
PT = new M.Person
{
Id = item.Id,
Name = item.Name,
ProfesionDescription = item.Profesion,
Email = item.Email,
Phone = item.Phone,
Ciprin = item.Ciprin,
Active = item.Active,
CreationDate = item.CreationDate,
CreationHourZone = item.CreationHourZone,
Avatar = item.Avatar,
Views = item.Views,
Type = true
};
arrayPeople[i] = PT;
i++;
}
return(arrayPeople);
}