public pEditClientRevenues(Person currentPerson)
{
_currentPerson = currentPerson;
if (_currentPerson == null)
{
throw new Exception("Client cannot null");
}
InitializeComponent();
Init();
}
/// <summary>
/// Füllt Attribute
/// </summary>
/// <param name="person">Person</param>
public QuickBookingDataGridModel(Person person)
{
if (!(person.TableNo.HasValue))
return;
this.person = person;
this.tableNo = (int)person.TableNo;
this.lastName = person.LastName;
this.firstName = person.FirstName;
this.validityEnd = SafeStringParser.safeParseToStr(person.ValidityEnd);
this.dateOfBirth = SafeStringParser.safeParseToStr(person.DateOfBirth);
this.lastPurchase = SafeStringParser.safeParseToStr(person.LastPurchase);
this.group = person.Group;
}
/// <summary>
/// Legt neue Buchung an und aktualisiert Person
/// </summary>
/// <param name="person">Instanz von Person</param>
/// <param name="amount">Betrag</param>
/// <param name="srcAccountID">Quellkonto</param>
/// <param name="targetAccountID">Zielkonto</param>
/// <returns></returns>
private bool newQuickBooking(Person person, double amount, int srcAccountID, int targetAccountID)
{
try
{
// aktualisiere lastPurchase des Kunden
var personID = person.PersonID;
var firstName = person.FirstName;
var lastName = person.LastName;
var zipCode = person.ZipCode;
var city = person.City;
var street = person.Street;
var nationality = person.Nationality;
var tableNo = person.TableNo;
var phone = person.Phone;
var mobileNo = person.MobileNo;
var comment = person.Comment;
var countryOfBirth = person.CountryOfBirth;
var dateOfBirth = person.DateOfBirth;
var email = person.Email;
var group = person.Group;
var validityStart = person.ValidityStart;
var validityEnd = person.ValidityEnd;
var maritalBirthday = person.MaritalBirthday;
var maritalFirstName = person.MaritalFirstName;
var maritalLastName = person.MaritalLastName;
var maritalNationality = person.MaritalNationality;
var lastPurchase = DateTime.Now;
var maritalCountryOfBirth = person.MaritalCountryOfBirth;
var maritalPhone = person.MaritalPhone;
var maritalMobile = person.MaritalMobile;
var maritalEmail = person.MaritalEmail;
int familyStateID = person.FamilyState.FamilyStateID;
int titleID = person.Title.TitleID;
int? maritalTitleID;
if (person.MaritalTitle != null)
maritalTitleID = person.MaritalTitle.TitleID;
else
maritalTitleID = null;
int? userAccountID; // UserAccount ist manchmal null - wahrscheinlich ein Problem der Datenbank
if (person.UserAccount != null)
userAccountID = person.UserAccount.UserAccountID;
else
userAccountID = UserSession.userAccountID;
Person.Update(personID, titleID, familyStateID, userAccountID, firstName,
lastName, zipCode, city, street, nationality, tableNo, phone,
mobileNo, comment, countryOfBirth, dateOfBirth, email, group,
validityStart, validityEnd, maritalBirthday, maritalFirstName,
maritalLastName, maritalNationality, lastPurchase, maritalCountryOfBirth,
maritalPhone, maritalMobile, maritalEmail, maritalTitleID);
// Trage Buchung ein
int userAccountIDbooking = UserSession.userAccountID;
string description = IniParser.GetSetting("ACCOUNTING", "quickBookingDescription");
Booking.Add(srcAccountID, targetAccountID, amount, person.PersonID, userAccountIDbooking, description);
return true;
}
catch
{
// Bei Fehler gebe Kundendetails aus
string error = IniParser.GetSetting("ERRORMSG", "newQuickBookingError").Replace("{0}", person.FirstName + " " + person.LastName + " (" + person.TableNo + ")");
MessageBoxEnhanced.Error(error);
return false;
}
}
/// <summary>
/// Veraltete Methode zum Hinzufügen eines neuen Objekts zum EntitySet 'Persons'. Verwenden Sie stattdessen die Methode '.Add' der zugeordneten Eigenschaft 'ObjectSet<T>'.
/// </summary>
public void AddToPersons(Person person)
{
base.AddObject("Persons", person);
}
/// <summary>
/// Erstellt ein neues Person-Objekt.
/// </summary>
/// <param name="personID">Anfangswert der Eigenschaft PersonID.</param>
/// <param name="firstName">Anfangswert der Eigenschaft FirstName.</param>
/// <param name="lastName">Anfangswert der Eigenschaft LastName.</param>
/// <param name="street">Anfangswert der Eigenschaft Street.</param>
/// <param name="nationality">Anfangswert der Eigenschaft Nationality.</param>
/// <param name="dateOfBirth">Anfangswert der Eigenschaft DateOfBirth.</param>
/// <param name="isActive">Anfangswert der Eigenschaft IsActive.</param>
/// <param name="group">Anfangswert der Eigenschaft Group.</param>
/// <param name="zipCode">Anfangswert der Eigenschaft ZipCode.</param>
/// <param name="validityStart">Anfangswert der Eigenschaft ValidityStart.</param>
/// <param name="validityEnd">Anfangswert der Eigenschaft ValidityEnd.</param>
/// <param name="creationDate">Anfangswert der Eigenschaft CreationDate.</param>
/// <param name="city">Anfangswert der Eigenschaft City.</param>
public static Person CreatePerson(global::System.Int32 personID, global::System.String firstName, global::System.String lastName, global::System.String street, global::System.String nationality, global::System.DateTime dateOfBirth, global::System.Boolean isActive, global::System.Int32 group, global::System.Int32 zipCode, global::System.DateTime validityStart, global::System.DateTime validityEnd, global::System.DateTime creationDate, global::System.String city)
{
Person person = new Person();
person.PersonID = personID;
person.FirstName = firstName;
person.LastName = lastName;
person.Street = street;
person.Nationality = nationality;
person.DateOfBirth = dateOfBirth;
person.IsActive = isActive;
person.Group = group;
person.ZipCode = zipCode;
person.ValidityStart = validityStart;
person.ValidityEnd = validityEnd;
person.CreationDate = creationDate;
person.City = city;
return person;
}
/// <summary>
/// Fügt eine neue Person der Datenbank hinzu
/// </summary>
/// <param name="titleID">Die ID des Titels</param>
/// <param name="familyStateId">Die ID des Familienstatus</param>
/// <param name="firstName">Vorname</param>
/// <param name="lastName">Nachname</param>
/// <param name="street">Strasse</param>
/// <param name="nationality">Nationalität</param>
/// <param name="dateOfBirth">Geburtsdatum</param>
/// <param name="group">Die zugeordnete Gruppe</param>
/// <param name="zipCode">Die Postleitzahl</param>
/// <param name="city">Stadt</param>
/// <param name="validityStart">Gültigkeits Startdatum</param>
/// <param name="validityEnd">Gültigkeits Enddatum</param>
/// <param name="teamId">Die ID eines Teammitglieds, welcher die Person hinzugefügt werden soll</param>
/// <param name="countryOfBirth">Geburtsland</param>
/// <param name="email">Emailadresse</param>
/// <param name="mobileNo">Handynummer</param>
/// <param name="phone">Telefonnummer</param>
/// <param name="maritalFirstName">Verheiratete Person Vorname</param>
/// <param name="maritalLastName">Verheiratete Person Nachname</param>
/// <param name="maritalNationality">Verheiratete Person Nationalität</param>
/// <param name="maritalBirthday">Verheiratete Person Geburtsdatum</param>
/// <param name="maritalCountryOfBirth">Verheiratete Person Geburtsland</param>
/// <param name="maritalPhone">Verheiratete Person Telefonnummer</param>
/// <param name="maritalMobile">Verheiratete Person Handynummer</param>
/// <param name="maritalEmail">Verheiratete Person Emailadresse</param>
/// <param name="martialTitleID">Verheiratete Person Title ID</param>
/// <param name="comment">Kommentar</param>
/// <param name="tableNo">Tafel Nummer</param>
/// <returns>Die ID des Eintrags in der Datenbank</returns>
public static int Add(int titleID, int familyStateId, string firstName, string lastName, string street, string nationality,
DateTime dateOfBirth, int group, int zipCode, string city, DateTime validityStart, DateTime validityEnd,
int? userAccountID = null, string countryOfBirth = null, string email = null, string mobileNo = null, string phone = null,
string maritalFirstName = null, string maritalLastName = null, string maritalNationality = null,
DateTime? maritalBirthday = null, string maritalCountryOfBirth = null, string maritalPhone = null,
string maritalMobile = null, string maritalEmail = null, int? martialTitleID = null,
string comment = null, int? tableNo = null)
{
using (TafelModelContainer db = new TafelModelContainer())
{
var person = new Person()
{
City = city,
Comment = comment,
CountryOfBirth = countryOfBirth,
CreationDate = DateTime.Now,
DateOfBirth = dateOfBirth,
Email = email,
FamilyState = db.FamilyStates.Single(fs => fs.FamilyStateID == familyStateId),
FirstName = firstName,
Group = group,
IsActive = true,
LastModified = null,
LastName = lastName,
LastPurchase = null,
MaritalBirthday = maritalBirthday,
MaritalFirstName = maritalFirstName,
MaritalLastName = maritalLastName,
MaritalNationality = maritalNationality,
MaritalCountryOfBirth = maritalCountryOfBirth,
MaritalPhone = maritalPhone,
MaritalMobile = maritalMobile,
MaritalEmail = maritalEmail,
MaritalTitle = (martialTitleID.HasValue) ? db.Titles.Single(mt => mt.TitleID == martialTitleID.Value) : null,
MobileNo = mobileNo,
Nationality = nationality,
Phone = phone,
Street = street,
TableNo = tableNo,
Title = db.Titles.Single(t => t.TitleID == titleID),
ValidityEnd = validityEnd,
ValidityStart = validityStart,
ZipCode = zipCode,
UserAccount = (userAccountID.HasValue) ? db.UserAccounts.SingleOrDefault(u => u.UserAccountID == userAccountID.Value) : null,
};
db.Persons.AddObject(person);
db.SaveChanges();
return person.PersonID;
}
}
/// <summary>
/// Ermittelt die Anrede anhand des Geschlechts
/// </summary>
/// <param name="x">Person</param>
/// <returns>Anrede</returns>
private string getSaluation(Person 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;
}
