//public string ToString(string format)
//{
// Dictionary<string, string> replacements = new Dictionary<string, string>
// {
// { "Tt", Title?.CapitalizeAll() },
// { "TT", Title?.ToUpper() },
// { "tt", Title?.ToLower() },
// { "Ff", Forename?.CapitalizeAll() },
// { "FF", Forename?.ToUpper() },
// { "ff", Forename?.ToLower() },
// { "F", Forename?.FirstOrDefault().ToString().ToUpper() },
// { "f", Forename?.FirstOrDefault().ToString().ToLower() },
// { "Mm", string.Join(' ', MiddleNames.Select(m => m?.CapitalizeAll())) },
// { "MM", string.Join(' ', MiddleNames.Select(m => m?.ToUpper())) },
// { "mm", string.Join(' ', MiddleNames.Select(m => m?.ToLower())) },
// { "M.", string.Join(' ', MiddleNames.Select(m => $"{m?.FirstOrDefault().ToString().ToUpper()}.")) },
// { "m.", string.Join(' ', MiddleNames.Select(m => $"{m?.FirstOrDefault().ToString().ToLower()}.")) },
// { "M", string.Join(' ', MiddleNames.Select(m => m?.FirstOrDefault().ToString().ToUpper())) },
// { "m", string.Join(' ', MiddleNames.Select(m => m?.FirstOrDefault().ToString().ToLower())) },
// { "Ll", Surname?.CapitalizeAll() },
// { "LL", Surname?.ToUpper() },
// { "ll", Surname?.ToLower() },
// { "L", Surname?.FirstOrDefault().ToString().ToUpper() },
// { "l", Surname?.FirstOrDefault().ToString().ToLower() },
// { "Ss", (Suffix ?? "").IsRomanNumeral() ? Suffix?.ToUpper() : Suffix?.CapitalizeAll() },
// { "SS", Suffix?.ToUpper() },
// { "ss", Suffix?.ToLower() }
// };
// return format.ReplaceAll(replacements);
//}
public string ToString(NameFormat format)
{
string titleFormatted = Title?.ToString(format.TitleDisplayType) ?? string.Empty;
string givenNamesFormatted = $"{Forename?.ToString(format.ForenameDisplayType)} {string.Join(' ', MiddleNames.Select(n => n?.ToString(format.MiddleNameDisplayType)))}".Trim();
string surnameFormatted = Surname?.ToString(format.SurnameDisplayType) ?? string.Empty;
string suffixFormatted = Suffix?.ToString(format.SuffixDisplayType) ?? string.Empty;
StringBuilder fullName = new StringBuilder(titleFormatted);
switch (format.NameOrder)
{
case NameOrder.Eastern:
if (fullName.Length > 0 && !string.IsNullOrWhiteSpace(surnameFormatted))
{
fullName.Append(' ');
}
fullName.Append(surnameFormatted);
if (fullName.Length > 0 && !string.IsNullOrWhiteSpace(givenNamesFormatted))
{
fullName.Append(' ');
}
fullName.Append(givenNamesFormatted);
break;
case NameOrder.WesternReversed:
if (fullName.Length > 0 && !string.IsNullOrWhiteSpace(surnameFormatted))
{
fullName.Append(' ');
}
fullName.Append(surnameFormatted);
if (fullName.Length > 0 && !string.IsNullOrWhiteSpace(givenNamesFormatted))
{
fullName.Append(", ");
}
fullName.Append(givenNamesFormatted);
break;
case NameOrder.Western:
default:
if (fullName.Length > 0 && !string.IsNullOrWhiteSpace(givenNamesFormatted))
{
fullName.Append(' ');
}
fullName.Append(givenNamesFormatted);
if (fullName.Length > 0 && !string.IsNullOrWhiteSpace(surnameFormatted))
{
fullName.Append(' ');
}
fullName.Append(surnameFormatted);
break;
}
if (fullName.Length > 0 && !string.IsNullOrWhiteSpace(suffixFormatted))
{
fullName.Append(' ');
}
fullName.Append(suffixFormatted);
return(fullName.ToString());
}
//Implementation of IFiltrable
public bool FilterClause(string filter)
{
return(City.ToLower().Contains(filter) ||
CountryName.ToLower().Contains(filter) ||
Forename.ToLower().Contains(filter) ||
PersonTypeName.ToLower().Contains(filter) ||
Postcode.ToLower().Contains(filter) ||
Surname.ToLower().Contains(filter));
}
public int CompareTo(Person other)
{
int comp = Forename.CompareTo(other.Forename);
if (comp != 0)
{
return(comp);
}
return(Surname.CompareTo(other.Surname));
}
public override int GetHashCode()
{
unchecked
{
var hashCode = UserId.GetHashCode();
hashCode = (hashCode * 397) ^ (Title != null ? Title.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ (Forename != null ? Forename.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ (Surname != null ? Surname.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ (Email != null ? Email.GetHashCode() : 0);
return(hashCode);
}
}
public override int GetHashCode()
{
int hash = 1;
if (Surname.Length != 0)
{
hash ^= Surname.GetHashCode();
}
if (Forename.Length != 0)
{
hash ^= Forename.GetHashCode();
}
hash ^= otherNames_.GetHashCode();
if (Salutation.Length != 0)
{
hash ^= Salutation.GetHashCode();
}
if (Suffix.Length != 0)
{
hash ^= Suffix.GetHashCode();
}
if (DisplayName.Length != 0)
{
hash ^= DisplayName.GetHashCode();
}
if (Gender != global::PKIo.Gender.NotKnown)
{
hash ^= Gender.GetHashCode();
}
if (dateOfBirth_ != null)
{
hash ^= DateOfBirth.GetHashCode();
}
if (EmailAddress.Length != 0)
{
hash ^= EmailAddress.GetHashCode();
}
if (MobileNumber.Length != 0)
{
hash ^= MobileNumber.GetHashCode();
}
if (ExternalId.Length != 0)
{
hash ^= ExternalId.GetHashCode();
}
if (_unknownFields != null)
{
hash ^= _unknownFields.GetHashCode();
}
return(hash);
}
public override int GetHashCode()
{
int hash = 1;
if (Forename.Length != 0)
{
hash ^= Forename.GetHashCode();
}
if (Surename.Length != 0)
{
hash ^= Surename.GetHashCode();
}
if (Age != 0)
{
hash ^= Age.GetHashCode();
}
return(hash);
}
private void SetAccessLevel()
{
_connection = DB_Connect.connect();
_command = new SqlCommand(@"SELECT * FROM[Users] WHERE [Username] = '" + UserName + "'", _connection);
try
{
_connection.Open();
var myReader = _command.ExecuteReader();
while (myReader.Read())
{
AccessLevel = myReader.GetInt32(4);
Forename = myReader.GetString(0);
Forename = Forename.Substring(0, Forename.IndexOf(' ') + 1);
}
_connection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void InsertTeachers()
{
using (var db = new SMSContext())
{
int id = this.GetNextRowID();
if (Type == 'P')
{
var teachers = new Teacher {
teacherID = id, surname = Surname.Trim(), forename = Forename.Trim(), dob = DOB.Date, phone = Phone.Trim(), type = Type.ToString(), salary = Convert.ToDecimal(SalaryPartTime.Trim()), subjects = Subject.Trim()
};
db.Teachers.Add(teachers);
}
else
{
var teachers = new Teacher {
teacherID = id, surname = Surname.Trim(), forename = Forename.Trim(), dob = DOB.Date, phone = Phone.Trim(), type = Type.ToString(), salary = Convert.ToDecimal(SalaryFullTime.Trim()), subjects = Subject.Trim()
};
db.Teachers.Add(teachers);
}
db.SaveChanges();
}
}
private bool IsInputValid()
{
this.ErrorsList.Clear();
bool ForenameValid = false, SurnameValid = false, EmailAddressValid = false, PasswordValid = false, PasswordsMatch = false;
if (!String.IsNullOrEmpty(Forename) && Forename.All(Char.IsLetter))
{
ForenameValid = true;
}
else
{
this.ErrorsList.Add("The forename you entered was illegal.");
}
if (!String.IsNullOrEmpty(Surname) && Surname.All(Char.IsLetter))
{
SurnameValid = true;
}
else
{
this.ErrorsList.Add("The surname you entered was illegal.");
}
if (!String.IsNullOrEmpty(EmailAddress) && (EmailAddress.Length > 5 && EmailAddress.Length < 70))
{
EmailAddressValid = true;
}
else
{
this.ErrorsList.Add("The email address you entered was invalid.");
}
if (Password != null && ReEnterPassword != null)
{
if (Password.Length >= 6)
{
PasswordValid = true;
}
else
{
this.ErrorsList.Add("The password you entered was too short. Make sure it's longer than 6 characters.");
}
if (Core.IsEqualTo(Password, ReEnterPassword))
{
PasswordsMatch = true;
}
else
{
this.ErrorsList.Add("The passwords you entered don't match.");
}
}
else
{
this.ErrorsList.Add("You need to enter a password in both fields.");
}
bool valid = ForenameValid && SurnameValid && EmailAddressValid && PasswordValid && PasswordsMatch;
this.Errors = !valid;
return(valid);
}
private string GetFullName()
{
return(string.Format("{0} {1}", Forename.Polish(), Surname.Polish()));
}
