/// <summary>
/// Erstellt eine neue Adresse.
/// </summary>
/// <param name="street">Straße.</param>
/// <param name="streetNumber">Hausnummer.</param>
/// <param name="zipcode">Postleitzahl.</param>
/// <param name="city">Ort.</param>
/// <param name="country">Land.</param>
/// <param name="dbContext">Datenbankkontext für die Transaktion.</param>
/// <returns>Die neue Adresse.</returns>
public static Adress CreateAdress(string street, string streetNumber, string zipcode, string city, string country, DataClasses1DataContext dbContext)
{
Adress adress = new Adress()
{
Street = street,
StreetNumber = streetNumber,
Zipcode = zipcode,
City = city,
Country = country
};
dbContext.Adress.InsertOnSubmit(adress);
dbContext.SubmitChanges();
dbContext.WriteLogItem("Adresse angelegt.", LogTypes.INSERT, adress.Id, "Adress");
return adress;
}
/// <summary>
/// Erstelle eine Kopie der Adress
/// </summary>
/// <param name="adress">Zu kopierende Adress</param>
/// <param name="dbContext">Datenbank Kontext</param>
/// <returns>Adress</returns>
public static Adress CreateCopy(Adress adress, DataClasses1DataContext dbContext)
{
Adress copy = new Adress()
{
Street = adress.Street,
StreetNumber = adress.StreetNumber,
Zipcode = adress.Zipcode,
City = adress.City,
Country = adress.Country
};
dbContext.Adress.InsertOnSubmit(copy);
dbContext.SubmitChanges();
dbContext.WriteLogItem("Adresse kopiert.", LogTypes.INSERT, copy.Id, "Adress", adress.Id);
return copy;
}
/// <summary>
/// Erstellt einen neuen Laufzetteldatensatz.
/// </summary>
/// <param name="recipient">Empfänger des Laufzettels.</param>
/// <param name="recipientAdressId">Id der Adresse für den Laufzettel.</param>
/// <param name="dbContext">Datenbankkontext für die Transaktion.</param>
/// <returns>Den neuen Lieferscheindatensatz.</returns>
public static DocketList CreateDocketList(string recipient, Adress recipientAdress, DataClasses1DataContext dbContext)
{
if (recipient == null)
{
throw new Exception("Der Empfänger des Lieferscheins darf nicht leer sein.");
}
DocketList docketList = new DocketList()
{
Adress = recipientAdress,
Recipient = recipient
};
dbContext.DocketList.InsertOnSubmit(docketList);
dbContext.SubmitChanges();
dbContext.WriteLogItem("Laufzettel erstellt.", LogTypes.INSERT, docketList.DocketListNumber, "DocketList");
return docketList;
}
/// <summary>
/// Erstellt einen neuen Lieferscheindatensatz.
/// </summary>
/// <param name="recipient">Empfänger des Lieferscheins.</param>
/// <param name="recipientAdressId">Id der Adresse für den Lieferschein.</param>
/// <param name="dbContext">Datenbankkontext für die Transaktion.</param>
/// <returns>Den neuen Lieferscheindatensatz.</returns>
public static PackingList CreatePackingList(string recipient, Adress recipientAdress, DataClasses1DataContext dbContext)
{
if (recipient == null)
{
throw new Exception("Der Empfänger des Lieferscheins darf nicht leer sein.");
}
PackingList packingList = new PackingList()
{
Adress = recipientAdress,
Recipient = recipient
};
dbContext.PackingList.InsertOnSubmit(packingList);
dbContext.SubmitChanges();
dbContext.WriteLogItem("Lieferschein erstellt.", LogTypes.INSERT, packingList.PackingListNumber, "PackingList");
return packingList;
}
/// <summary>
/// Erstelle einen neuen Fahrzeughalter
/// </summary>
/// <param name="name">Nachname</param>
/// <param name="firstName">Vorname</param>
/// <param name="bankAccountId">ID der Bankverbindung</param>
/// <param name="contactId">ID des Kontaktdatensatzes</param>
/// <param name="adressId">ID der Adresse</param>
/// <param name="dbContext">DB Kontext</param>
/// <returns>CarOwner</returns>
public static CarOwner CreateCarOwner(string name, string firstName, BankAccount bankAccount, Contact contact, Adress adress, DataClasses1DataContext dbContext)
{
if (string.IsNullOrEmpty(name))
{
////throw new Exception("Der Name des Halters darf nicht leer sein.");
}
CarOwner owner = new CarOwner()
{
Name = name,
FirstName = firstName,
BankAccount = bankAccount,
Contact = contact,
Adress = adress
};
dbContext.CarOwner.InsertOnSubmit(owner);
dbContext.SubmitChanges();
dbContext.WriteLogItem("Halter " + name + " wurde angelegt.", LogTypes.INSERT, owner.Id, "CarOwner");
return owner;
}
/// <summary>
/// Erstellt einen neuen Kunden.
/// </summary>
/// <param name="name">Name des Kunden.</param>
/// <param name="street">Straße.</param>
/// <param name="streetnumber">Hausnummer.</param>
/// <param name="zipcode">Postleitzahl.</param>
/// <param name="city">Ort.</param>
/// <param name="country">Land.</param>
/// <param name="phone">Telefonnummer.</param>
/// <param name="fax">Faxnummer.</param>
/// <param name="mobilephone">Mobiltelefonnummer.</param>
/// <param name="email">E-Mailadresse.</param>
/// <param name="vat">Mehrwersteuersatz.</param>
/// <param name="termOfCredit">Zahlungsziel (in Tagen).</param>
/// <param name="customerNumber">Kundennummer.</param>
/// <returns>Den Kunden.</returns>
/// <remarks>Methode soll nur für interne Zwecke benutzt werden. Die public Create-Methoden befinden sich in den spezialisierten Kundenklassen.</remarks>
internal static Customer CreateCustomer(string name, string street, string streetnumber, string zipcode, string city, string country, string phone, string fax, string mobilephone, string email, decimal vat, int? termOfCredit, string customerNumber, string Matchcode="", string Debitornumber="", string eVB_Number="")
{
if (string.IsNullOrEmpty(customerNumber))
{
throw new ArgumentNullException("Die Kundennummer darf nicht leer sein.");
}
if (string.IsNullOrEmpty(name))
{
throw new ArgumentNullException("Der Kundenname darf nicht leer sein.");
}
var adress = new Adress()
{
Street = street,
StreetNumber = streetnumber,
City = city,
Country = country,
Zipcode = zipcode
};
var contact = new Contact()
{
Phone = phone,
Fax = fax,
MobilePhone = mobilephone,
Email = email
};
var customer = new Customer()
{
Name = name,
Adress = adress,
Contact = contact,
VAT = vat,
InvoiceAdress = adress,
InvoiceDispatchAdress = adress,
TermOfCredit = termOfCredit,
CustomerNumber = customerNumber,
MatchCode = Matchcode,
Debitornumber = Debitornumber,
eVB_Number = eVB_Number
};
return customer;
}
/// <summary>
/// Vergleiche zwei Adressen zu einander
/// </summary>
/// <param name="toCompare">Zu vergleichende Adresse</param>
/// <returns>bool</returns>
public bool ContentEquals(Adress toCompare)
{
return this.Street == toCompare.Street
&& this.StreetNumber == toCompare.StreetNumber
&& this.Zipcode == toCompare.Zipcode
&& this.City == toCompare.City
&& this.Country == toCompare.Country;
}
partial void DeleteAdress(Adress instance);
partial void UpdateAdress(Adress instance);
partial void InsertAdress(Adress instance);
/// <summary>
/// Erstellt eine neue Rechnung.
/// </summary>
/// <param name="dbContext">Datenbankkontext für die Transaktion.</param>
/// <param name="userId">Id des Benutzers.</param>
/// <param name="invoiceRecipient">Rechnungsempfänger.</param>
/// <param name="invoiceRecipientAdressId">Adresse des Rechnungsempfängers.</param>
/// <param name="customerId">Id des Kunden.</param>
/// <returns>Die neue Rechnung.</returns>
public static Invoice CreateInvoice(DataClasses1DataContext dbContext, int userId, string invoiceRecipient, Adress invoiceRecipientAdress, int customerId, double? discount, string invTypeId)
{
//if (string.IsNullOrEmpty(invoiceRecipient))
//{
// throw new ArgumentNullException("Der Rechnungsempfänger darf nicht leer sein.");
//}
decimal? helper = null;
Invoice invoice = new Invoice()
{
CreateDate = DateTime.Now,
IsPrinted = false,
UserId = userId,
InvoiceRecipient = invoiceRecipient,
Adress = invoiceRecipientAdress,
CustomerId = customerId,
discount = ((discount.HasValue) ? decimal.Parse(discount.Value.ToString()) : helper),
InvoiceType = GetInvoiceTypeId(dbContext, invTypeId)
};
dbContext.Invoice.InsertOnSubmit(invoice);
dbContext.SubmitChanges();
dbContext.WriteLogItem("Rechnung wurde angelegt.", LogTypes.INSERT, invoice.Id, "Invoice");
return invoice;
}
