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