/* Agregar un Profesional Afín */
public long Post(M.OtherPerson otraPersona)
{
O.OtherPerson BDOtherPerson = new O.OtherPerson
{
Name = otraPersona.Name,
Profesion = otraPersona.Profesion,
ProfesionDescription = otraPersona.ProfesionDescription,
Email = otraPersona.Email,
Phone = otraPersona.Phone,
City = otraPersona.City,
Latitude = otraPersona.Latitude,
Longitude = otraPersona.Longitude,
Ciprin = otraPersona.Ciprin,
Active = false,
CreationDate = System.DateTime.Now.ToString("g"),
CreationHourZone = System.TimeZoneInfo.Local.ToString(),
Avatar = "",
NameAvatar = "",
Views = 0,
IdUser = otraPersona.IdUser
};
BD.OtherPersons.Add(BDOtherPerson);
BD.SaveChanges();
O.User BDUser = BD.Users.FirstOrDefault(x => x.Id == otraPersona.IdUser);
BDUser.CountProfiles = BDUser.CountProfiles + 1;
BD.SaveChanges();
return(BDOtherPerson.Id);
}
public M.OtherPerson[] Get(string criterio)
{
var SOP = BD.OtherPersons;
var query = from OP in SOP
where ((OP.City.Contains(criterio)) && OP.Active)
select new { OP.Id, OP.Name, OP.Profesion, OP.ProfesionDescription, OP.Email, OP.Phone, OP.Latitude, OP.Longitude, OP.Ciprin, OP.CreationDate, OP.CreationHourZone, OP.Avatar, OP.Views, OP.User.Username };
M.OtherPerson[] arrayOtherPerson = new M.OtherPerson[query.Count()];
M.OtherPerson temp;
long i = 0;
foreach (var item in query)
{
temp = new M.OtherPerson
{
Id = item.Id,
Name = item.Name,
Profesion = item.Profesion,
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
};
arrayOtherPerson[i] = temp;
i++;
}
return(arrayOtherPerson);
}
