private Avatar GetOrAvatar(SqlDataManager sdm)
{
var avatarWhere = String.Format("AvatarId = '{0}'", this.PersonId);
var avatar = sdm.GetAllAvatars <Avatar>(avatarWhere).FirstOrDefault();
if (ReferenceEquals(avatar, null))
{
avatar = new Avatar();
avatar.AvatarId = this.PersonId;
avatar.Nickname = avatar.Handle = this.PreferredHandle;
sdm.Insert(avatar);
}
return(avatar);
}
internal void ParseSequence(SqlDataManager sdm, List <Signal> allSignals)
{
var signalDict = allSignals.ToDictionary(signal => signal.Symbol);
this.DeleteSequence(sdm);
foreach (var sequenceChar in this.SequenceCode)
{
var cs = new CharacterSquence()
{
Name = sequenceChar.ToString(),
Description = signalDict[sequenceChar.ToString()].Name,
CharacterId = this.CharacterId,
SignalId = signalDict[sequenceChar.ToString()].SignalId,
SignalIndex = this.CharacterSquences.Count() + 1
};
this.CharacterSquences.Add(cs);
sdm.Insert(cs);
}
}
public int Commit()
{
int affected = 0;
if (newModels != null)
{
affected += sqlDataManager.Insert(newModels);
}
if (deletedModels != null)
{
affected += sqlDataManager.Delete(deletedModels);
}
if (changedModel != null)
{
affected += sqlDataManager.Update(changedModel);
}
return(affected);
}
public static Person GetPerson(SqlDataManager sdm, Person person)
{
if (String.IsNullOrEmpty(person.EmailAddress))
{
throw new ArgumentException("Invalid Person request - Email Address is required to find a person");
}
else if (person.EmailAddress.IndexOf("@") <= 1)
{
throw new ArgumentException("Invalid person request - Email address is invalid.");
}
// Lookup the person by their email address
var personWhere = string.Format("EmailAddress LIKE '{0}'", person.EmailAddress.ToSqlSafeString());
var dbPerson = sdm.GetAllPersons <Person>(personWhere).FirstOrDefault();
if (ReferenceEquals(dbPerson, null))
{
dbPerson = new Person();
dbPerson.Name = person.EmailAddress;
dbPerson.EmailAddress = person.EmailAddress;
dbPerson.PreferredHandle = person.EmailAddress.Substring(0, person.EmailAddress.IndexOf("@"));
dbPerson.IsEmailVerified = false;
dbPerson.IsPhoneerified = false;
dbPerson.PhoneNumber = String.Empty;
dbPerson.SSN = String.Empty;
dbPerson.Avatar = dbPerson.GetOrAvatar(sdm);
sdm.Insert(dbPerson);
}
else
{
dbPerson.Avatar = dbPerson.GetOrAvatar(sdm);
}
return(dbPerson);
}
private void button1_Click(object sender, EventArgs e)
{
var sdm = new SqlDataManager();
var alphabet = this.listBox1.SelectedItem as Alphabet;
IEnumerable <Character> chars = this.listBox2.DataSource as IEnumerable <Character>;
var standardChars = "ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789-. ";
foreach (var standardChar in standardChars)
{
if (!chars.Any(anyChar => anyChar.Symbol == standardChar.ToString()))
{
var newChar = new Character()
{
AlphabetId = alphabet.AlphabetId,
Description = String.Format("{0} char {1}", alphabet.Name, standardChar),
Name = standardChar.ToString(),
Symbol = standardChar.ToString()
};
sdm.Insert(newChar);
}
}
}
