public pEditTeamMember(Team currentTeamMember, int? pagingStartValue = null)
{
_CurrentTeamMember = currentTeamMember;
if (_CurrentTeamMember == null)
{
throw new Exception("Team member cannot null");
}
InitializeComponent();
if (pagingStartValue.HasValue)
this.pagingStartValue = pagingStartValue.Value;
Init();
}
/// <summary>
/// Fügt ein neues Teammitglied der Datenbank hinzu
/// </summary>
/// <param name="firstname">Vorname</param>
/// <param name="lastname">Nachnamen</param>
/// <param name="street">Strasse</param>
/// <param name="zipcode">Postleitzahl</param>
/// <param name="city">Stadt</param>
/// <param name="mobileNo">Handynummer</param>
/// <param name="phoneNo">Telefonnummer</param>
/// <param name="commercialPhoneNo">Telefonnummer Arbeit</param>
/// <returns>Die ID des Eintrags in der Datenbank</returns>
public static int Add(int titleID, int teamFunctionID, string firstname, string lastname, string street, int zipcode, string city, DateTime dateOfBirth, string mobileNo = null, string phoneNo = null, string email = null, bool isFormLetterAllowed = false)
{
using (TafelModelContainer db = new TafelModelContainer())
{
var title = db.Titles.Single(t => t.TitleID == titleID);
var teamFunction = db.TeamFunctions.Single(t => t.TeamFunctionID == teamFunctionID);
Team team = new Team()
{
FirstName = firstname,
LastName = lastname,
IsActive = true,
Street = street,
ZipCode = zipcode,
City = city,
MobileNo = mobileNo,
DateOfBirth = dateOfBirth,
IsFormLetterAllowed = isFormLetterAllowed,
PhoneNo = phoneNo,
Title = title,
TeamFunction = teamFunction,
Email = email,
};
db.Teams.AddObject(team);
db.SaveChanges();
return team.TeamID;
}
}
/// <summary>
/// Veraltete Methode zum Hinzufügen eines neuen Objekts zum EntitySet 'Teams'. Verwenden Sie stattdessen die Methode '.Add' der zugeordneten Eigenschaft 'ObjectSet<T>'.
/// </summary>
public void AddToTeams(Team team)
{
base.AddObject("Teams", team);
}
/// <summary>
/// Erstellt ein neues Team-Objekt.
/// </summary>
/// <param name="teamID">Anfangswert der Eigenschaft TeamID.</param>
/// <param name="firstName">Anfangswert der Eigenschaft FirstName.</param>
/// <param name="lastName">Anfangswert der Eigenschaft LastName.</param>
/// <param name="isActive">Anfangswert der Eigenschaft IsActive.</param>
/// <param name="street">Anfangswert der Eigenschaft Street.</param>
/// <param name="zipCode">Anfangswert der Eigenschaft ZipCode.</param>
/// <param name="city">Anfangswert der Eigenschaft City.</param>
/// <param name="isFormLetterAllowed">Anfangswert der Eigenschaft IsFormLetterAllowed.</param>
/// <param name="dateOfBirth">Anfangswert der Eigenschaft DateOfBirth.</param>
public static Team CreateTeam(global::System.Int32 teamID, global::System.String firstName, global::System.String lastName, global::System.Boolean isActive, global::System.String street, global::System.Int32 zipCode, global::System.String city, global::System.Boolean isFormLetterAllowed, global::System.DateTime dateOfBirth)
{
Team team = new Team();
team.TeamID = teamID;
team.FirstName = firstName;
team.LastName = lastName;
team.IsActive = isActive;
team.Street = street;
team.ZipCode = zipCode;
team.City = city;
team.IsFormLetterAllowed = isFormLetterAllowed;
team.DateOfBirth = dateOfBirth;
return team;
}
/// <summary>
/// Ermittelt die Anrede anhand des Geschlechts
/// </summary>
/// <param name="x">Teammitglied</param>
/// <returns>Anrede</returns>
private string getSaluation(Team x)
{
string defaultMaleTitle = IniParser.GetSetting("FORMLETTER", "defaultMaleTitle");
string defaultFemaleTitle = IniParser.GetSetting("FORMLETTER", "defaultFemaleTitle");
if (string.IsNullOrEmpty(x.LastName))
return this.formletterPatternModel.saluation_n;
else if (x != null && x.Title.Name.Equals(defaultMaleTitle))
return this.formletterPatternModel.saluation_m;
else if (x != null && x.Title.Name.Equals(defaultFemaleTitle))
return this.formletterPatternModel.saluation_f;
else
return this.formletterPatternModel.saluation_n;
}
