private bool importDocuments(FuncClasses.FastXML bdb)
{
var list = bdb.GetAllOrders(user);
foreach (var prevOrder in list)
{
// We just want to import invoices
if (prevOrder.OrderTyp != "1")
continue;
var invoice = bdb.GetOrder(prevOrder.OrderID, FuncClasses.Dokumentart.Rechnung, user);
var output = new OrderTypes_Biller.Invoice.Invoice();
// Customer
var task = Database.GetCustomer(prevOrder.CustomerID);
output.Customer = task.Result;
output.Date = invoice.Datum.ToDate();
output.DocumentID = invoice.OrderID.ToString();
output.OrderClosingText = invoice.OrderText;
output.OrderOpeningText = invoice.TextBefore;
// Rebate
//!## Fixed reduction not supported ##!\\
//!## Collect those orders and notify the user he has to adjust the rebate ##!\\
output.OrderRebate = new Utils.Percentage() { Amount = Convert.ToDouble(invoice.Rebate) };
//Payment methode
if(invoice.PaymentMethode != null)
{
var payment = new Utils.PaymentMethode() { Name = invoice.PaymentMethode.Name, Text = invoice.PaymentMethode.Text, Discount = new Utils.Percentage() { PercentageString = invoice.PaymentMethode.ReductionString } };
Database.SaveOrUpdatePaymentMethode(payment);
output.PaymentMethode = payment;
}
// Articles
foreach(var Article in invoice.OrderedArticles)
{
var taskArticle = Database.GetArticle(Article.ArticleID);
var basearticle = taskArticle.Result;
var orderedArticle = new Articles.OrderedArticle(basearticle);
orderedArticle.ArticleText = Article.OrderText;
orderedArticle.OrderedAmount = Convert.ToDouble(Article.OrderedAmount);
orderedArticle.OrderRebate.Amount = Convert.ToDouble(Article.OrderRebate);
orderedArticle.OrderPrice.Price1.AmountString = Article.OrderPrice.AmountString;
orderedArticle.OrderPosition = Article.OrderPosition;
output.OrderedArticles.Add(orderedArticle);
}
Database.SaveOrUpdateDocument(output);
// When the imported invoice has a fixed reduction (e.g. 20€ rebate) we add the document to a seperate list. The user needs to open these documents to adjust the correct end price.
if (invoice.Reduction.Amount > 0)
{
var listOfDocumentCompanyModels = DocumentsToModify.Where(x => x.Company.CompanyID == Database.CurrentCompany.CompanyID);
if (listOfDocumentCompanyModels.Count()>0)
{
var model = listOfDocumentCompanyModels.First();
model.Documents.Add(output);
}
else
{
var model = new CompanyDocumentListModel() { Company = Database.CurrentCompany };
model.Documents.Add(output);
DocumentsToModify.Add(model);
}
}
}
return true;
}
private bool importCustomers(FuncClasses.FastXML bdb)
{
var list = bdb.GetAllCustomers(user);
var savingList = new List<Customers.Customer>();
foreach (var cusprev in list)
{
var importedCustomer = new Core.Customers.Customer();
//Load full user
var customer = bdb.GetCustomer(cusprev.CustomerID, user);
// Payment methode
if(customer.PaymentMethode != null)
{
if (!String.IsNullOrEmpty(customer.PaymentMethode.Name))
{
var payment = new Utils.PaymentMethode() { Name = customer.PaymentMethode.Name, Text = customer.PaymentMethode.Text, Discount = new Utils.Percentage() { PercentageString = customer.PaymentMethode.ReductionString } };
Database.SaveOrUpdatePaymentMethode(payment);
importedCustomer.DefaultPaymentMethode = payment;
}
}
// Pricegroup
switch(customer.Preisgruppe)
{
case FuncClasses.Preisgruppe.Preisgruppe1:
importedCustomer.Pricegroup = 0;
break;
case FuncClasses.Preisgruppe.Preisgruppe2:
importedCustomer.Pricegroup = 1;
break;
case FuncClasses.Preisgruppe.Preisgruppe3:
importedCustomer.Pricegroup = 2;
break;
}
// ID
importedCustomer.CustomerID = customer.CustomerID;
// MainAddress
var MainAddress = new Utils.Address();
MainAddress.Addition = customer.Address.Addition;
MainAddress.City = customer.Address.City;
MainAddress.CompanyName = customer.Address.CompanyName;
MainAddress.Country = customer.Address.Country;
MainAddress.Forename = customer.Address.Forname;
MainAddress.Surname = customer.Address.Surname;
MainAddress.Title = customer.Address.Title;
MainAddress.Zip = customer.Address.ZipCode;
MainAddress.Street = customer.Address.Street;
MainAddress.HouseNumber = customer.Address.No;
MainAddress.Salutation = customer.Address.Salutation;
importedCustomer.MainAddress = MainAddress;
// Contact
var Contact = new Utils.Contact();
Contact.Facebook = customer.Contact.Facebook;
Contact.Fax1 = customer.Contact.Telefax1;
Contact.Fax2 = customer.Contact.Telefax2;
Contact.Mail1 = customer.Contact.Mail1;
Contact.Mail2 = customer.Contact.Mail2;
Contact.Mobile1 = customer.Contact.Mobil1;
Contact.Mobile2 = customer.Contact.Mobil2;
Contact.Phone1 = customer.Contact.Telefon1;
Contact.Phone2 = customer.Contact.Telefon2;
Contact.Twitter = customer.Contact.Twitter;
importedCustomer.Contact = Contact;
// Additional adresses
foreach(var address in customer.Addresses)
{
var eAddress = new Utils.EAddress();
eAddress.AddressDescription = address.AddressDescription;
eAddress.Addition = address.Addition;
eAddress.City = address.City;
eAddress.CompanyName = address.CompanyName;
eAddress.Country = address.Country;
eAddress.Forename = address.Forname;
eAddress.Surname = address.Surname;
eAddress.Title = address.Title;
eAddress.Zip = address.ZipCode;
eAddress.Street = address.Street;
eAddress.HouseNumber = address.No;
eAddress.Salutation = address.Salutation;
importedCustomer.ExtraAddresses.Add(eAddress);
}
savingList.Add(importedCustomer);
}
Database.SaveOrUpdateCustomer(savingList);
return true;
}
private IEnumerable<Utils.PaymentMethode> paymentMethodesList()
{
logger.Debug("Getting PaymentMethodes-list");
var templist = new ObservableCollection<Utils.PaymentMethode>();
if (!SettingsDB.Elements("PaymentMethodes").Any())
return templist;
var itemlist = SettingsDB.Element("PaymentMethodes").Elements("PaymentMethode");
foreach (XElement item in itemlist)
{
try
{
var tempitem = new Utils.PaymentMethode();
tempitem.ParseFromXElement(item);
templist.Add(tempitem);
}
catch (Exception e) { logger.Fatal("Error parsing the element", e); }
}
return templist;
}
