private static void UpdatePersonOptionalField(Person person, OptionalFields optionalField, string value)
{
var personOptionalField = person.PersonOptionalFields.FirstOrDefault(c => c.OptionalFieldId == (int)optionalField);
if (personOptionalField == null)
{
personOptionalField = new PersonOptionalField
{
OptionalFieldId = (int) optionalField,
Created = DateTime.Now,
Changed = DateTime.Now
};
person.PersonOptionalFields.Add(personOptionalField);
}
if (personOptionalField.Value != (value ?? string.Empty))
personOptionalField.Changed = DateTime.Now;
personOptionalField.Value = value ?? string.Empty;
}
public static void SavePersonFacebookId(int personId, string facebookId)
{
using (oikonomosEntities context = new oikonomosEntities(ConfigurationManager.ConnectionStrings["oikonomosEntities"].ConnectionString))
{
PersonOptionalField facebookOptionalField = new PersonOptionalField();
facebookOptionalField.PersonId = personId;
facebookOptionalField.OptionalFieldId = (int)OptionalFields.Facebook;
facebookOptionalField.Value = facebookId;
facebookOptionalField.Created = DateTime.Now;
facebookOptionalField.Changed = DateTime.Now;
context.PersonOptionalFields.AddObject(facebookOptionalField);
context.SaveChanges();
}
}
private static void SaveWindowsLiveId(PersonViewModel person, Person personToSave, oikonomosEntities context)
{
if (string.IsNullOrEmpty(person.WindowsLiveId)) return;
var windowsLiveId = context.PersonOptionalFields.FirstOrDefault(p =>p.OptionalFieldId == (int) OptionalFields.WindowsLive && p.PersonId == personToSave.PersonId);
if(windowsLiveId==null)
{
windowsLiveId = new PersonOptionalField
{
Changed = DateTime.Now,
Created = DateTime.Now,
OptionalFieldId = (int) OptionalFields.WindowsLive,
PersonId = personToSave.PersonId,
Value = person.WindowsLiveId
};
context.AddToPersonOptionalFields(windowsLiveId);
context.SaveChanges();
}
else
{
if(windowsLiveId.Value!=person.WindowsLiveId)
{
windowsLiveId.Value = person.WindowsLiveId;
context.SaveChanges();
}
}
}
public static void SavePersonFacebookDetails(Person person, long facebookId, DateTime? birthday)
{
using (oikonomosEntities context = new oikonomosEntities(ConfigurationManager.ConnectionStrings["oikonomosEntities"].ConnectionString))
{
PersonOptionalField facebookOptionalField = new PersonOptionalField();
facebookOptionalField.PersonId = person.PersonId;
facebookOptionalField.OptionalFieldId = (int)OptionalFields.Facebook;
facebookOptionalField.Value = facebookId.ToString();
facebookOptionalField.Created = DateTime.Now;
facebookOptionalField.Changed = DateTime.Now;
context.PersonOptionalFields.AddObject(facebookOptionalField);
if (birthday != null)
{
var personToUpdate = (from p in context.People
where p.PersonId == person.PersonId
select p).FirstOrDefault();
if (personToUpdate.DateOfBirth == null || personToUpdate.DateOfBirth.Value.Year == 1900)
{
personToUpdate.DateOfBirth = birthday.Value;
}
}
context.SaveChanges();
}
}
