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); } } }