public void GivenNewGood_WhenDeriving_ThenNonSerialisedInventryItemIsCreatedForEveryFacility()
{
var settings = this.Session.GetSingleton().Settings;
var supplier = new OrganisationBuilder(this.Session).WithName("supplier").Build();
var internalOrganisation = this.InternalOrganisation;
var before = settings.DefaultFacility.InventoryItemsWhereFacility.Count;
var secondFacility = new FacilityBuilder(this.Session)
.WithFacilityType(new FacilityTypes(this.Session).Warehouse)
.WithOwner(this.InternalOrganisation)
.WithName("second facility")
.Build();
new SupplierRelationshipBuilder(this.Session)
.WithSupplier(supplier)
.WithFromDate(this.Session.Now())
.Build();
var good = new NonUnifiedGoodBuilder(this.Session)
.WithProductIdentification(new ProductNumberBuilder(this.Session)
.WithIdentification("1")
.WithProductIdentificationType(new ProductIdentificationTypes(this.Session).Good).Build())
.WithVatRate(new VatRateBuilder(this.Session).WithRate(21).Build())
.WithName("good1")
.WithUnitOfMeasure(new UnitsOfMeasure(this.Session).Piece)
.WithPart(new NonUnifiedPartBuilder(this.Session)
.WithProductIdentification(new PartNumberBuilder(this.Session)
.WithIdentification("1")
.WithProductIdentificationType(new ProductIdentificationTypes(this.Session).Part).Build())
.WithInventoryItemKind(new InventoryItemKinds(this.Session).NonSerialised).Build())
.Build();
new SupplierOfferingBuilder(this.Session)
.WithPart(good.Part)
.WithSupplier(supplier)
.WithFromDate(this.Session.Now())
.WithUnitOfMeasure(new UnitsOfMeasure(this.Session).Piece)
.WithPrice(1)
.WithCurrency(new Currencies(this.Session).FindBy(M.Currency.IsoCode, "EUR"))
.Build();
this.Session.Derive();
Assert.Equal(2, good.Part.InventoryItemsWherePart.Count);
Assert.Equal(before + 1, settings.DefaultFacility.InventoryItemsWhereFacility.Count);
Assert.Single(secondFacility.InventoryItemsWhereFacility);
}
public static FacilityBuilder WithDefaults(this FacilityBuilder @this, Organisation internalOrganisation)
{
var faker = @this.Session.Faker();
var customer = faker.Random.ListItem(internalOrganisation.ActiveCustomers);
var postalAddress = new PostalAddressBuilder(@this.Session).WithDefaults().Build();
@this.WithName(faker.Name.FullName());
@this.WithDescription(faker.Lorem.Sentence());
@this.WithLatitude(faker.Address.Latitude());
@this.WithLongitude(faker.Address.Longitude());
@this.WithOwner(internalOrganisation);
@this.WithSquareFootage(faker.Random.Decimal(100, 10000));
@this.WithFacilityType(faker.Random.ListItem(@this.Session.Extent <FacilityType>()));
@this.WithFacilityContactMechanism(customer.CurrentPartyContactMechanisms.Select(v => v.ContactMechanism).FirstOrDefault());
return(@this);
}
public static Organisation CreateInternalOrganisation(
ISession session,
string name,
string address,
string postalCode,
string locality,
Country country,
string phone1CountryCode,
string phone1,
ContactMechanismPurpose phone1Purpose,
string phone2CountryCode,
string phone2,
ContactMechanismPurpose phone2Purpose,
string emailAddress,
string websiteAddress,
string taxNumber,
string bankName,
string facilityName,
string bic,
string iban,
Currency currency,
string logo,
string storeName,
BillingProcess billingProcess,
string outgoingShipmentNumberPrefix,
string salesInvoiceNumberPrefix,
string salesOrderNumberPrefix,
string purchaseOrderNumberPrefix,
string purchaseInvoiceNumberPrefix,
string requestNumberPrefix,
string quoteNumberPrefix,
string productNumberPrefix,
string workEffortPrefix,
string creditNoteNumberPrefix,
bool isImmediatelyPicked,
bool autoGenerateShipmentPackage,
bool isImmediatelyPacked,
bool isAutomaticallyShipped,
bool autoGenerateCustomerShipment,
bool isAutomaticallyReceived,
bool autoGeneratePurchaseShipment,
bool useCreditNoteSequence,
int?requestCounterValue,
int?quoteCounterValue,
int?orderCounterValue,
int?purchaseOrderCounterValue,
int?invoiceCounterValue,
int?purchaseInvoiceCounterValue,
bool purchaseOrderNeedsApproval,
decimal?purchaseOrderApprovalThresholdLevel1,
decimal?purchaseOrderApprovalThresholdLevel2,
SerialisedItemSoldOn[] serialisedItemSoldOns,
bool collectiveWorkEffortInvoice,
InvoiceSequence invoiceSequence,
RequestSequence requestSequence,
QuoteSequence quoteSequence,
CustomerShipmentSequence customerShipmentSequence,
PurchaseShipmentSequence purchaseShipmentSequence,
WorkEffortSequence workEffortSequence)
{
var postalAddress1 = new PostalAddressBuilder(session)
.WithAddress1(address)
.WithPostalCode(postalCode)
.WithLocality(locality)
.WithCountry(country)
.Build();
var webSite = new WebAddressBuilder(session)
.WithElectronicAddressString(websiteAddress)
.Build();
BankAccount bankAccount = null;
if (!string.IsNullOrEmpty(bic) && !string.IsNullOrEmpty(iban))
{
var bank = new BankBuilder(session).WithName(bankName).WithBic(bic).WithCountry(country).Build();
bankAccount = new BankAccountBuilder(session)
.WithBank(bank)
.WithIban(iban)
.WithNameOnAccount(name)
.WithCurrency(currency)
.Build();
}
var internalOrganisation = new OrganisationBuilder(session)
.WithIsInternalOrganisation(true)
.WithTaxNumber(taxNumber)
.WithName(name)
.WithPreferredCurrency(new Currencies(session).FindBy(M.Currency.IsoCode, "EUR"))
.WithInvoiceSequence(invoiceSequence)
.WithRequestSequence(requestSequence)
.WithQuoteSequence(quoteSequence)
.WithCustomerShipmentSequence(customerShipmentSequence)
.WithPurchaseShipmentSequence(purchaseShipmentSequence)
.WithWorkEffortSequence(workEffortSequence)
.WithFiscalYearStartMonth(01)
.WithFiscalYearStartDay(01)
.WithDoAccounting(false)
.WithPurchaseOrderNeedsApproval(purchaseOrderNeedsApproval)
.WithPurchaseOrderApprovalThresholdLevel1(purchaseOrderApprovalThresholdLevel1)
.WithPurchaseOrderApprovalThresholdLevel2(purchaseOrderApprovalThresholdLevel2)
.WithAutoGeneratePurchaseShipment(autoGeneratePurchaseShipment)
.WithIsAutomaticallyReceived(isAutomaticallyReceived)
.WithCollectiveWorkEffortInvoice(collectiveWorkEffortInvoice)
.WithCountry(country)
.Build();
internalOrganisation.SerialisedItemSoldOns = serialisedItemSoldOns;
if (invoiceSequence == new InvoiceSequences(session).RestartOnFiscalYear)
{
var sequenceNumbers = internalOrganisation.FiscalYearsInternalOrganisationSequenceNumbers.FirstOrDefault(v => v.FiscalYear == session.Now().Year);
if (sequenceNumbers == null)
{
sequenceNumbers = new FiscalYearInternalOrganisationSequenceNumbersBuilder(session).WithFiscalYear(session.Now().Year).Build();
internalOrganisation.AddFiscalYearsInternalOrganisationSequenceNumber(sequenceNumbers);
}
sequenceNumbers.PurchaseOrderNumberPrefix = purchaseOrderNumberPrefix;
sequenceNumbers.PurchaseInvoiceNumberPrefix = purchaseInvoiceNumberPrefix;
if (purchaseOrderCounterValue != null)
{
sequenceNumbers.PurchaseOrderNumberCounter = new CounterBuilder(session).WithValue(purchaseOrderCounterValue).Build();
}
if (purchaseInvoiceCounterValue != null)
{
sequenceNumbers.PurchaseInvoiceNumberCounter = new CounterBuilder(session).WithValue(purchaseInvoiceCounterValue).Build();
}
}
else
{
internalOrganisation.PurchaseOrderNumberPrefix = purchaseOrderNumberPrefix;
internalOrganisation.PurchaseInvoiceNumberPrefix = purchaseInvoiceNumberPrefix;
if (purchaseOrderCounterValue != null)
{
internalOrganisation.PurchaseOrderNumberCounter = new CounterBuilder(session).WithValue(purchaseOrderCounterValue).Build();
}
if (purchaseInvoiceCounterValue != null)
{
internalOrganisation.PurchaseInvoiceNumberCounter = new CounterBuilder(session).WithValue(purchaseInvoiceCounterValue).Build();
}
}
if (requestSequence == new RequestSequences(session).RestartOnFiscalYear)
{
var sequenceNumbers = internalOrganisation.FiscalYearsInternalOrganisationSequenceNumbers.FirstOrDefault(v => v.FiscalYear == session.Now().Year);
if (sequenceNumbers == null)
{
sequenceNumbers = new FiscalYearInternalOrganisationSequenceNumbersBuilder(session).WithFiscalYear(session.Now().Year).Build();
internalOrganisation.AddFiscalYearsInternalOrganisationSequenceNumber(sequenceNumbers);
}
sequenceNumbers.RequestNumberPrefix = requestNumberPrefix;
if (requestCounterValue != null)
{
sequenceNumbers.RequestNumberCounter = new CounterBuilder(session).WithValue(requestCounterValue).Build();
}
}
else
{
internalOrganisation.RequestNumberPrefix = requestNumberPrefix;
if (requestCounterValue != null)
{
internalOrganisation.RequestNumberCounter = new CounterBuilder(session).WithValue(requestCounterValue).Build();
}
}
if (quoteSequence == new QuoteSequences(session).RestartOnFiscalYear)
{
var sequenceNumbers = internalOrganisation.FiscalYearsInternalOrganisationSequenceNumbers.FirstOrDefault(v => v.FiscalYear == session.Now().Year);
if (sequenceNumbers == null)
{
sequenceNumbers = new FiscalYearInternalOrganisationSequenceNumbersBuilder(session).WithFiscalYear(session.Now().Year).Build();
internalOrganisation.AddFiscalYearsInternalOrganisationSequenceNumber(sequenceNumbers);
}
sequenceNumbers.QuoteNumberPrefix = quoteNumberPrefix;
if (quoteCounterValue != null)
{
sequenceNumbers.QuoteNumberCounter = new CounterBuilder(session).WithValue(quoteCounterValue).Build();
}
}
else
{
internalOrganisation.QuoteNumberPrefix = quoteNumberPrefix;
if (quoteCounterValue != null)
{
internalOrganisation.QuoteNumberCounter = new CounterBuilder(session).WithValue(quoteCounterValue).Build();
}
}
if (workEffortSequence == new WorkEffortSequences(session).RestartOnFiscalYear)
{
var sequenceNumbers = internalOrganisation.FiscalYearsInternalOrganisationSequenceNumbers.FirstOrDefault(v => v.FiscalYear == session.Now().Year);
if (sequenceNumbers == null)
{
sequenceNumbers = new FiscalYearInternalOrganisationSequenceNumbersBuilder(session).WithFiscalYear(session.Now().Year).Build();
internalOrganisation.AddFiscalYearsInternalOrganisationSequenceNumber(sequenceNumbers);
}
sequenceNumbers.WorkEffortNumberPrefix = workEffortPrefix;
}
else
{
internalOrganisation.WorkEffortNumberPrefix = workEffortPrefix;
}
OwnBankAccount defaultCollectionMethod = null;
if (bankAccount != null)
{
internalOrganisation.AddBankAccount(bankAccount);
defaultCollectionMethod = new OwnBankAccountBuilder(session).WithBankAccount(bankAccount).WithDescription("Huisbank").Build();
internalOrganisation.DefaultCollectionMethod = defaultCollectionMethod;
}
if (!string.IsNullOrEmpty(emailAddress))
{
var email = new EmailAddressBuilder(session)
.WithElectronicAddressString(emailAddress)
.Build();
internalOrganisation.AddPartyContactMechanism(new PartyContactMechanismBuilder(session)
.WithUseAsDefault(true)
.WithContactMechanism(email)
.WithContactPurpose(new ContactMechanismPurposes(session).GeneralEmail)
.Build());
}
internalOrganisation.AddPartyContactMechanism(new PartyContactMechanismBuilder(session)
.WithUseAsDefault(true)
.WithContactMechanism(postalAddress1)
.WithContactPurpose(new ContactMechanismPurposes(session).RegisteredOffice)
.WithContactPurpose(new ContactMechanismPurposes(session).GeneralCorrespondence)
.WithContactPurpose(new ContactMechanismPurposes(session).BillingAddress)
.WithContactPurpose(new ContactMechanismPurposes(session).ShippingAddress)
.Build());
internalOrganisation.AddPartyContactMechanism(new PartyContactMechanismBuilder(session)
.WithUseAsDefault(true)
.WithContactMechanism(webSite)
.WithContactPurpose(new ContactMechanismPurposes(session).InternetAddress)
.Build());
TelecommunicationsNumber phoneNumber1 = null;
if (!string.IsNullOrEmpty(phone1))
{
phoneNumber1 = new TelecommunicationsNumberBuilder(session).WithContactNumber(phone1).Build();
if (!string.IsNullOrEmpty(phone1CountryCode))
{
phoneNumber1.CountryCode = phone1CountryCode;
}
}
if (phoneNumber1 != null)
{
internalOrganisation.AddPartyContactMechanism(new PartyContactMechanismBuilder(session)
.WithUseAsDefault(true)
.WithContactMechanism(phoneNumber1)
.WithContactPurpose(phone1Purpose)
.Build());
}
TelecommunicationsNumber phoneNumber2 = null;
if (!string.IsNullOrEmpty(phone2))
{
phoneNumber2 = new TelecommunicationsNumberBuilder(session).WithContactNumber(phone2).Build();
if (!string.IsNullOrEmpty(phone2CountryCode))
{
phoneNumber2.CountryCode = phone2CountryCode;
}
}
if (phoneNumber2 != null)
{
internalOrganisation.AddPartyContactMechanism(new PartyContactMechanismBuilder(session)
.WithUseAsDefault(true)
.WithContactMechanism(phoneNumber2)
.WithContactPurpose(phone2Purpose)
.Build());
}
if (!string.IsNullOrWhiteSpace(logo))
{
var singleton = session.GetSingleton();
internalOrganisation.LogoImage = new MediaBuilder(session).WithInFileName(logo).WithInData(singleton.GetResourceBytes(logo)).Build();
}
Facility facility = null;
if (facilityName != null)
{
facility = new FacilityBuilder(session)
.WithName(facilityName)
.WithFacilityType(new FacilityTypes(session).Warehouse)
.WithOwner(internalOrganisation)
.Build();
}
var store = new StoreBuilder(session)
.WithName(storeName)
.WithDefaultCollectionMethod(defaultCollectionMethod)
.WithDefaultShipmentMethod(new ShipmentMethods(session).Ground)
.WithDefaultCarrier(new Carriers(session).Fedex)
.WithBillingProcess(billingProcess)
.WithIsImmediatelyPicked(isImmediatelyPicked)
.WithAutoGenerateShipmentPackage(autoGenerateShipmentPackage)
.WithIsImmediatelyPacked(isImmediatelyPacked)
.WithIsAutomaticallyShipped(isAutomaticallyShipped)
.WithAutoGenerateCustomerShipment(autoGenerateCustomerShipment)
.WithUseCreditNoteSequence(useCreditNoteSequence)
.WithInternalOrganisation(internalOrganisation)
.Build();
if (defaultCollectionMethod == null)
{
store.DefaultCollectionMethod = new CashBuilder(session).Build();
}
else
{
store.DefaultCollectionMethod = defaultCollectionMethod;
}
if (facility != null)
{
store.DefaultFacility = facility;
}
if (invoiceSequence == new InvoiceSequences(session).RestartOnFiscalYear)
{
var sequenceNumbers = new FiscalYearStoreSequenceNumbersBuilder(session).WithFiscalYear(session.Now().Year).Build();
sequenceNumbers.CreditNoteNumberPrefix = creditNoteNumberPrefix;
sequenceNumbers.OutgoingShipmentNumberPrefix = outgoingShipmentNumberPrefix;
sequenceNumbers.SalesInvoiceNumberPrefix = salesInvoiceNumberPrefix;
sequenceNumbers.SalesOrderNumberPrefix = salesOrderNumberPrefix;
if (orderCounterValue != null)
{
sequenceNumbers.SalesOrderNumberCounter = new CounterBuilder(session).WithValue(orderCounterValue).Build();
}
if (invoiceCounterValue != null)
{
sequenceNumbers.SalesInvoiceNumberCounter = new CounterBuilder(session).WithValue(invoiceCounterValue).Build();
}
store.AddFiscalYearsStoreSequenceNumber(sequenceNumbers);
}
else
{
store.CreditNoteNumberPrefix = creditNoteNumberPrefix;
store.OutgoingShipmentNumberPrefix = outgoingShipmentNumberPrefix;
store.SalesInvoiceNumberPrefix = salesInvoiceNumberPrefix;
store.SalesOrderNumberPrefix = salesOrderNumberPrefix;
if (orderCounterValue != null)
{
store.SalesOrderNumberCounter = new CounterBuilder(session).WithValue(orderCounterValue).Build();
}
if (invoiceCounterValue != null)
{
store.SalesInvoiceNumberCounter = new CounterBuilder(session).WithValue(invoiceCounterValue).Build();
}
}
return(internalOrganisation);
}
public static void Setup(IDatabase database)
{
CultureInfo.CurrentCulture = new CultureInfo("en-GB");
CultureInfo.CurrentUICulture = new CultureInfo("en-GB");
using (var session = database.CreateSession())
{
new Setup(session, null).Apply();
var administrator = new Users(session).GetUser("administrator");
session.SetUser(administrator);
var singleton = session.GetSingleton();
new UserGroups(session).Administrators.AddMember(administrator);
singleton.Guest = new PersonBuilder(session).WithUserName("guest").WithLastName("guest").Build();
session.Derive();
session.Commit();
var belgium = new Countries(session).CountryByIsoCode["BE"];
var euro = belgium.Currency;
var bank = new BankBuilder(session).WithCountry(belgium).WithName("ING België").WithBic("BBRUBEBB").Build();
var ownBankAccount = new OwnBankAccountBuilder(session)
.WithBankAccount(new BankAccountBuilder(session).WithBank(bank)
.WithCurrency(euro)
.WithIban("BE68539007547034")
.WithNameOnAccount("Koen")
.Build())
.WithDescription("Main bank account")
.Build();
var postalBoundary = new PostalBoundaryBuilder(session).WithLocality("Mechelen").WithCountry(belgium).Build();
var postalAddress = new PostalAddressBuilder(session).WithAddress1("Kleine Nieuwedijkstraat 2").WithPostalBoundary(postalBoundary).Build();
var internalOrganisation = new OrganisationBuilder(session)
.WithIsInternalOrganisation(true)
.WithDoAccounting(false)
.WithName("internalOrganisation")
.WithPreferredCurrency(new Currencies(session).CurrencyByCode["EUR"])
.WithIncomingShipmentNumberPrefix("incoming shipmentno: ")
.WithPurchaseInvoiceNumberPrefix("incoming invoiceno: ")
.WithPurchaseOrderNumberPrefix("purchase orderno: ")
.WithDefaultCollectionMethod(ownBankAccount)
.WithSubAccountCounter(new CounterBuilder(session).WithUniqueId(Guid.NewGuid()).WithValue(0).Build())
.Build();
internalOrganisation.AddPartyContactMechanism(new PartyContactMechanismBuilder(session)
.WithUseAsDefault(true)
.WithContactMechanism(postalAddress)
.WithContactPurpose(new ContactMechanismPurposes(session).GeneralCorrespondence)
.WithContactPurpose(new ContactMechanismPurposes(session).BillingAddress)
.Build());
var facility = new FacilityBuilder(session)
.WithFacilityType(new FacilityTypes(session).Warehouse)
.WithName("facility")
.WithOwner(internalOrganisation)
.Build();
singleton.Settings.DefaultFacility = facility;
var collectionMethod = new PaymentMethods(session).Extent().First;
new StoreBuilder(session)
.WithName("store")
.WithBillingProcess(new BillingProcesses(session).BillingForShipmentItems)
.WithInternalOrganisation(internalOrganisation)
.WithOutgoingShipmentNumberPrefix("shipmentno: ")
.WithSalesInvoiceNumberPrefix("invoiceno: ")
.WithSalesOrderNumberPrefix("orderno: ")
.WithDefaultShipmentMethod(new ShipmentMethods(session).Ground)
.WithDefaultCarrier(new Carriers(session).Fedex)
.WithCreditLimit(500)
.WithPaymentGracePeriod(10)
.WithDefaultCollectionMethod(collectionMethod)
.WithIsImmediatelyPicked(false)
.Build();
new ProductCategoryBuilder(session).WithName("Primary Category").Build();
var customer = new OrganisationBuilder(session).WithName("customer").WithLocale(singleton.DefaultLocale).Build();
var supplier = new OrganisationBuilder(session).WithName("supplier").WithLocale(singleton.DefaultLocale).Build();
var purchaser = new PersonBuilder(session).WithLastName("purchaser").WithUserName("purchaser").Build();
var salesrep = new PersonBuilder(session).WithLastName("salesRep").WithUserName("salesRep").Build();
var orderProcessor = new PersonBuilder(session).WithLastName("orderProcessor").WithUserName("orderProcessor").Build();
new CustomerRelationshipBuilder(session).WithCustomer(customer).WithInternalOrganisation(internalOrganisation).WithFromDate(DateTime.UtcNow).Build();
new SupplierRelationshipBuilder(session).WithSupplier(supplier).WithInternalOrganisation(internalOrganisation).WithFromDate(DateTime.UtcNow).Build();
new EmploymentBuilder(session).WithFromDate(DateTime.UtcNow).WithEmployee(purchaser).WithEmployer(internalOrganisation).Build();
new EmploymentBuilder(session).WithFromDate(DateTime.UtcNow).WithEmployee(salesrep).WithEmployer(internalOrganisation).Build();
new EmploymentBuilder(session).WithFromDate(DateTime.UtcNow).WithEmployee(orderProcessor).WithEmployer(internalOrganisation).Build();
new SalesRepRelationshipBuilder(session).WithFromDate(DateTime.UtcNow).WithCustomer(customer).WithSalesRepresentative(salesrep).Build();
var vatRate21 = new VatRateBuilder(session).WithRate(21).Build();
var good1 = new NonUnifiedGoodBuilder(session)
.WithProductIdentification(new ProductNumberBuilder(session)
.WithIdentification("1")
.WithProductIdentificationType(new ProductIdentificationTypes(session).Good).Build())
.WithVatRate(vatRate21)
.WithName("good1")
.WithUnitOfMeasure(new UnitsOfMeasure(session).Piece)
.WithPart(new NonUnifiedPartBuilder(session)
.WithProductIdentification(new PartNumberBuilder(session)
.WithIdentification("1")
.WithProductIdentificationType(new ProductIdentificationTypes(session).Part).Build())
.WithInventoryItemKind(new InventoryItemKinds(session).NonSerialised).Build())
.Build();
var good2 = new NonUnifiedGoodBuilder(session)
.WithProductIdentification(new ProductNumberBuilder(session)
.WithIdentification("2")
.WithProductIdentificationType(new ProductIdentificationTypes(session).Good).Build())
.WithVatRate(vatRate21)
.WithName("good2")
.WithUnitOfMeasure(new UnitsOfMeasure(session).Piece)
.WithPart(new NonUnifiedPartBuilder(session)
.WithProductIdentification(new PartNumberBuilder(session)
.WithIdentification("2")
.WithProductIdentificationType(new ProductIdentificationTypes(session).Part).Build())
.WithInventoryItemKind(new InventoryItemKinds(session).NonSerialised).Build())
.Build();
var good3 = new NonUnifiedGoodBuilder(session)
.WithProductIdentification(new ProductNumberBuilder(session)
.WithIdentification("3")
.WithProductIdentificationType(new ProductIdentificationTypes(session).Good).Build())
.WithVatRate(vatRate21)
.WithName("good3")
.WithUnitOfMeasure(new UnitsOfMeasure(session).Piece)
.WithPart(new NonUnifiedPartBuilder(session)
.WithProductIdentification(new PartNumberBuilder(session)
.WithIdentification("3")
.WithProductIdentificationType(new ProductIdentificationTypes(session).Part).Build())
.WithInventoryItemKind(new InventoryItemKinds(session).NonSerialised).Build())
.Build();
var catMain = new ProductCategoryBuilder(session).WithName("main cat").Build();
var cat1 = new ProductCategoryBuilder(session)
.WithName("cat for good1")
.WithParent(catMain)
.WithProduct(good1)
.Build();
var cat2 = new ProductCategoryBuilder(session)
.WithName("cat for good2")
.WithParent(catMain)
.WithProduct(good2)
.WithProduct(good3)
.Build();
session.Derive();
session.Commit();
}
}
public void Execute()
{
var singleton = this.Session.GetSingleton();
var dutchLocale = new Locales(this.Session).DutchNetherlands;
singleton.AddAdditionalLocale(dutchLocale);
var euro = new Currencies(this.Session).FindBy(M.Currency.IsoCode, "EUR");
var be = new Countries(this.Session).FindBy(M.Country.IsoCode, "BE");
var us = new Countries(this.Session).FindBy(M.Country.IsoCode, "US");
var email2 = new EmailAddressBuilder(this.Session)
.WithElectronicAddressString("*****@*****.**")
.Build();
var allorsLogo = this.DataPath + @"\www\admin\images\logo.png";
var serialisedItemSoldOns = new SerialisedItemSoldOn[] { new SerialisedItemSoldOns(this.Session).SalesInvoiceSend, new SerialisedItemSoldOns(this.Session).PurchaseInvoiceConfirm };
var allors = Organisations.CreateInternalOrganisation(
session: this.Session,
name: "Allors BVBA",
address: "Kleine Nieuwedijkstraat 4",
postalCode: "2800",
locality: "Mechelen",
country: be,
phone1CountryCode: "+32",
phone1: "2 335 2335",
phone1Purpose: new ContactMechanismPurposes(this.Session).GeneralPhoneNumber,
phone2CountryCode: string.Empty,
phone2: string.Empty,
phone2Purpose: null,
emailAddress: "*****@*****.**",
websiteAddress: "www.allors.com",
taxNumber: "BE 0476967014",
bankName: "ING",
facilityName: "Allors warehouse 1",
bic: "BBRUBEBB",
iban: "BE89 3200 1467 7685",
currency: euro,
logo: allorsLogo,
storeName: "Allors Store",
billingProcess: new BillingProcesses(this.Session).BillingForOrderItems,
outgoingShipmentNumberPrefix: "a-CS",
salesInvoiceNumberPrefix: "a-SI",
salesOrderNumberPrefix: "a-SO",
purchaseOrderNumberPrefix: "a-PO",
purchaseInvoiceNumberPrefix: "a-PI",
requestNumberPrefix: "a-RFQ",
quoteNumberPrefix: "a-Q",
productNumberPrefix: "A-",
workEffortPrefix: "a-WO-",
creditNoteNumberPrefix: "a-CN-",
isImmediatelyPicked: true,
autoGenerateShipmentPackage: true,
isImmediatelyPacked: true,
isAutomaticallyShipped: true,
autoGenerateCustomerShipment: true,
isAutomaticallyReceived: false,
autoGeneratePurchaseShipment: false,
useCreditNoteSequence: true,
requestCounterValue: 1,
quoteCounterValue: 1,
orderCounterValue: 1,
purchaseOrderCounterValue: 1,
purchaseInvoiceCounterValue: 1,
invoiceCounterValue: 1,
purchaseOrderNeedsApproval: true,
purchaseOrderApprovalThresholdLevel1: 1000M,
purchaseOrderApprovalThresholdLevel2: 5000M,
serialisedItemSoldOns: serialisedItemSoldOns,
collectiveWorkEffortInvoice: true);
var dipu = Organisations.CreateInternalOrganisation(
session: this.Session,
name: "Dipu BVBA",
address: "Kleine Nieuwedijkstraat 2",
postalCode: "2800",
locality: "Mechelen",
country: be,
phone1CountryCode: "+32",
phone1: "2 15 49 49 49",
phone1Purpose: new ContactMechanismPurposes(this.Session).GeneralPhoneNumber,
phone2CountryCode: string.Empty,
phone2: string.Empty,
phone2Purpose: null,
emailAddress: "*****@*****.**",
websiteAddress: "www.dipu.com",
taxNumber: "BE 0445366489",
bankName: "ING",
facilityName: "Dipu Facility",
bic: "BBRUBEBB",
iban: "BE23 3300 6167 6391",
currency: euro,
logo: allorsLogo,
storeName: "Dipu Store",
billingProcess: new BillingProcesses(this.Session).BillingForOrderItems,
outgoingShipmentNumberPrefix: "d-CS",
salesInvoiceNumberPrefix: "d-SI",
salesOrderNumberPrefix: "d-SO",
purchaseOrderNumberPrefix: "d-PO",
purchaseInvoiceNumberPrefix: "d-PI",
requestNumberPrefix: "d-RFQ",
quoteNumberPrefix: "d-Q",
productNumberPrefix: "D-",
workEffortPrefix: "d-WO-",
creditNoteNumberPrefix: "d-CN-",
isImmediatelyPicked: true,
autoGenerateShipmentPackage: true,
isImmediatelyPacked: true,
isAutomaticallyShipped: true,
autoGenerateCustomerShipment: true,
isAutomaticallyReceived: false,
autoGeneratePurchaseShipment: false,
useCreditNoteSequence: true,
requestCounterValue: 1,
quoteCounterValue: 1,
orderCounterValue: 1,
purchaseOrderCounterValue: 1,
purchaseInvoiceCounterValue: 1,
invoiceCounterValue: 1,
purchaseOrderNeedsApproval: false,
purchaseOrderApprovalThresholdLevel1: null,
purchaseOrderApprovalThresholdLevel2: null,
serialisedItemSoldOns: serialisedItemSoldOns,
collectiveWorkEffortInvoice: true);
singleton.Settings.DefaultFacility = allors.FacilitiesWhereOwner.First;
var faker = this.Session.Faker();
allors.CreateEmployee("letmein", faker);
allors.CreateAdministrator("letmein", faker);
var allorsB2BCustomer = allors.CreateB2BCustomer(this.Session.Faker());
var allorsB2CCustomer = allors.CreateB2CCustomer(this.Session.Faker());
allors.CreateSupplier(this.Session.Faker());
allors.CreateSubContractor(this.Session.Faker());
new CustomerRelationshipBuilder(this.Session)
.WithCustomer(allorsB2BCustomer)
.WithInternalOrganisation(dipu)
.WithFromDate(this.Session.Now())
.Build();
new CustomerRelationshipBuilder(this.Session)
.WithCustomer(allorsB2CCustomer)
.WithInternalOrganisation(dipu)
.WithFromDate(this.Session.Now())
.Build();
new CustomerRelationshipBuilder(this.Session)
.WithCustomer(dipu)
.WithInternalOrganisation(allors)
.WithFromDate(this.Session.Now())
.Build();
dipu.CreateEmployee("letmein", faker);
dipu.CreateAdministrator("letmein", faker);
var dipuB2BCustomer = dipu.CreateB2BCustomer(this.Session.Faker());
var dipuB2CCustomer = dipu.CreateB2CCustomer(this.Session.Faker());
dipu.CreateSupplier(this.Session.Faker());
dipu.CreateSubContractor(this.Session.Faker());
new CustomerRelationshipBuilder(this.Session)
.WithCustomer(dipuB2BCustomer)
.WithInternalOrganisation(allors)
.WithFromDate(this.Session.Now())
.Build();
new CustomerRelationshipBuilder(this.Session)
.WithCustomer(dipuB2CCustomer)
.WithInternalOrganisation(allors)
.WithFromDate(this.Session.Now())
.Build();
new CustomerRelationshipBuilder(this.Session)
.WithCustomer(allors)
.WithInternalOrganisation(dipu)
.WithFromDate(this.Session.Now())
.Build();
this.Session.Derive();
var facility = new FacilityBuilder(this.Session)
.WithName("Allors warehouse 2")
.WithFacilityType(new FacilityTypes(this.Session).Warehouse)
.WithOwner(allors)
.Build();
var store = new StoreBuilder(this.Session).WithName("store")
.WithInternalOrganisation(allors)
.WithDefaultFacility(facility)
.WithDefaultShipmentMethod(new ShipmentMethods(this.Session).Ground)
.WithDefaultCarrier(new Carriers(this.Session).Fedex)
.Build();
var productType = new ProductTypeBuilder(this.Session)
.WithName($"Gizmo Serialised")
.WithSerialisedItemCharacteristicType(new SerialisedItemCharacteristicTypeBuilder(this.Session)
.WithName("Size")
.WithLocalisedName(new LocalisedTextBuilder(this.Session).WithText("Afmeting").WithLocale(dutchLocale).Build())
.Build())
.WithSerialisedItemCharacteristicType(new SerialisedItemCharacteristicTypeBuilder(this.Session)
.WithName("Weight")
.WithLocalisedName(new LocalisedTextBuilder(this.Session).WithText("Gewicht").WithLocale(dutchLocale).Build())
.WithUnitOfMeasure(new UnitsOfMeasure(this.Session).Kilogram)
.Build())
.Build();
var vatRate = new VatRateBuilder(this.Session).WithRate(21).Build();
var brand = new BrandBuilder(this.Session).WithDefaults().Build();
var good_1 = new UnifiedGoodBuilder(this.Session).WithNonSerialisedDefaults(allors).Build();
this.Session.Derive();
new InventoryItemTransactionBuilder(this.Session)
.WithPart(good_1)
.WithQuantity(100)
.WithReason(new InventoryTransactionReasons(this.Session).Unknown)
.Build();
var good_2 = new NonUnifiedGoodBuilder(this.Session)
.WithSerialisedPartDefaults(allors)
.Build();
var serialisedItem1 = new SerialisedItemBuilder(this.Session).WithDefaults(allors).Build();
good_2.Part.AddSerialisedItem(serialisedItem1);
this.Session.Derive();
new SerialisedInventoryItemBuilder(this.Session)
.WithPart(good_2.Part)
.WithSerialisedItem(serialisedItem1)
.WithFacility(allors.StoresWhereInternalOrganisation.First.DefaultFacility)
.Build();
var good_3 = new NonUnifiedGoodBuilder(this.Session)
.WithNonSerialisedPartDefaults(allors)
.Build();
var good_4 = new UnifiedGoodBuilder(this.Session).WithSerialisedDefaults(allors).Build();
var productCategory_1 = new ProductCategoryBuilder(this.Session)
.WithInternalOrganisation(allors)
.WithName("Best selling gizmo's")
.WithLocalisedName(new LocalisedTextBuilder(this.Session).WithText("Meest verkochte gizmo's").WithLocale(dutchLocale).Build())
.Build();
var productCategory_2 = new ProductCategoryBuilder(this.Session)
.WithInternalOrganisation(allors)
.WithName("Big Gizmo's")
.WithLocalisedName(new LocalisedTextBuilder(this.Session).WithText("Grote Gizmo's").WithLocale(dutchLocale).Build())
.Build();
var productCategory_3 = new ProductCategoryBuilder(this.Session)
.WithInternalOrganisation(allors)
.WithName("Small gizmo's")
.WithLocalisedName(new LocalisedTextBuilder(this.Session).WithText("Kleine gizmo's").WithLocale(dutchLocale).Build())
.WithProduct(good_1)
.WithProduct(good_2)
.WithProduct(good_3)
.WithProduct(good_4)
.Build();
new CatalogueBuilder(this.Session)
.WithInternalOrganisation(allors)
.WithName("New gizmo's")
.WithLocalisedName(new LocalisedTextBuilder(this.Session).WithText("Nieuwe gizmo's").WithLocale(dutchLocale).Build())
.WithDescription("Latest in the world of Gizmo's")
.WithLocalisedDescription(new LocalisedTextBuilder(this.Session).WithText("Laatste in de wereld van Gizmo's").WithLocale(dutchLocale).Build())
.WithProductCategory(productCategory_1)
.Build();
this.Session.Derive();
var administrator = (Person) new UserGroups(this.Session).Administrators.Members.First;
new FaceToFaceCommunicationBuilder(this.Session)
.WithDescription($"Meeting")
.WithSubject($"meeting")
.WithEventPurpose(new CommunicationEventPurposes(this.Session).Meeting)
.WithFromParty(allors.ActiveEmployees.First)
.WithToParty(allors.ActiveCustomers.First)
.WithOwner(administrator)
.WithActualStart(DateTime.UtcNow)
.Build();
new EmailCommunicationBuilder(this.Session)
.WithDescription($"Email")
.WithSubject($"email")
.WithFromParty(allors.ActiveEmployees.First)
.WithToParty(allors.ActiveCustomers.First)
.WithFromEmail(allors.ActiveEmployees.First.GeneralEmail)
.WithToEmail(allors.ActiveCustomers.First.GeneralEmail)
.WithEventPurpose(new CommunicationEventPurposes(this.Session).Meeting)
.WithOwner(administrator)
.WithActualStart(DateTime.UtcNow)
.Build();
new LetterCorrespondenceBuilder(this.Session)
.WithDescription($"Letter")
.WithSubject($"letter")
.WithFromParty(administrator)
.WithToParty(allors.ActiveCustomers.First)
.WithEventPurpose(new CommunicationEventPurposes(this.Session).Meeting)
.WithOwner(administrator)
.WithActualStart(DateTime.UtcNow)
.Build();
new PhoneCommunicationBuilder(this.Session)
.WithDescription($"Phone")
.WithSubject($"phone")
.WithFromParty(administrator)
.WithToParty(allors.ActiveCustomers.First)
.WithEventPurpose(new CommunicationEventPurposes(this.Session).Meeting)
.WithOwner(administrator)
.WithActualStart(DateTime.UtcNow)
.Build();
new SalesOrderBuilder(this.Session).WithOrganisationInternalDefaults(allors).Build();
new SalesOrderBuilder(this.Session).WithOrganisationExternalDefaults(allors).Build();
new SalesOrderBuilder(this.Session).WithPersonInternalDefaults(allors).Build();
new SalesOrderBuilder(this.Session).WithPersonExternalDefaults(allors).Build();
new SalesInvoiceBuilder(this.Session).WithSalesExternalB2BInvoiceDefaults(allors).Build();
new SupplierOfferingBuilder(this.Session)
.WithPart(good_1)
.WithSupplier(allors.ActiveSuppliers.First)
.WithFromDate(this.Session.Now().AddMinutes(-1))
.WithUnitOfMeasure(new UnitsOfMeasure(this.Session).Piece)
.WithPrice(7)
.WithCurrency(euro)
.Build();
var purchaseInvoiceItem_1 = new PurchaseInvoiceItemBuilder(this.Session)
.WithDescription("first item")
.WithPart(good_1)
.WithAssignedUnitPrice(3000)
.WithQuantity(1)
.WithMessage(@"line1
line2")
.WithInvoiceItemType(new InvoiceItemTypes(this.Session).ProductItem)
.Build();
var purchaseInvoiceItem_2 = new PurchaseInvoiceItemBuilder(this.Session)
.WithDescription("second item")
.WithAssignedUnitPrice(2000)
.WithQuantity(2)
.WithInvoiceItemType(new InvoiceItemTypes(this.Session).ProductItem)
.Build();
var purchaseInvoiceItem_3 = new PurchaseInvoiceItemBuilder(this.Session)
.WithDescription("Service")
.WithAssignedUnitPrice(100)
.WithQuantity(1)
.WithInvoiceItemType(new InvoiceItemTypes(this.Session).Service)
.Build();
var purchaseInvoice = new PurchaseInvoiceBuilder(this.Session)
.WithBilledTo(allors)
.WithInvoiceNumber("1")
.WithBilledFrom(allors.ActiveSuppliers.First)
.WithPurchaseInvoiceItem(purchaseInvoiceItem_1)
.WithPurchaseInvoiceItem(purchaseInvoiceItem_2)
.WithPurchaseInvoiceItem(purchaseInvoiceItem_3)
.WithCustomerReference("a reference number")
.WithDescription("Purchase of 1 used Aircraft Towbar")
.WithPurchaseInvoiceType(new PurchaseInvoiceTypes(this.Session).PurchaseInvoice)
.WithVatRegime(new VatRegimes(this.Session).Assessable21)
.Build();
var purchaseOrderItem_1 = new PurchaseOrderItemBuilder(this.Session)
.WithDescription("first purchase order item")
.WithPart(good_1)
.WithQuantityOrdered(1)
.Build();
var purchaseOrder = new PurchaseOrderBuilder(this.Session)
.WithOrderedBy(allors)
.WithTakenViaSupplier(allors.ActiveSuppliers.First)
.WithPurchaseOrderItem(purchaseOrderItem_1)
.WithCustomerReference("reference 123")
.WithStoredInFacility(facility)
.Build();
var workTask = new WorkTaskBuilder(this.Session)
.WithTakenBy(allors)
.WithCustomer(allors.ActiveCustomers.First)
.WithName("maintenance")
.Build();
new PositionTypeBuilder(this.Session)
.WithTitle("Mechanic")
.WithUniqueId(new Guid("E62A8F4B-8045-472E-AB18-E39C51A02696"))
.Build();
new PositionTypeRateBuilder(this.Session)
.WithRate(100)
.WithRateType(new RateTypes(this.Session).StandardRate)
.WithFrequency(new TimeFrequencies(this.Session).Hour)
.Build();
this.Session.Derive();
// Serialized RFQ with Serialized Unified-Good
var serializedRFQ = new RequestForQuoteBuilder(this.Session).WithSerializedDefaults(allors).Build();
// NonSerialized RFQ with NonSerialized Unified-Good
var nonSerializedRFQ = new RequestForQuoteBuilder(this.Session).WithNonSerializedDefaults(allors).Build();
var quote = new ProductQuoteBuilder(this.Session)
.WithIssuer(allors)
.WithDescription("quote")
.WithReceiver(allors.ActiveCustomers.First)
.WithFullfillContactMechanism(allors.ActiveCustomers.First.GeneralCorrespondence)
.Build();
this.Session.Derive();
var quoteItem = new QuoteItemBuilder(this.Session)
.WithProduct(new Goods(this.Session).Extent().First)
.WithQuantity(1)
.WithAssignedUnitPrice(10)
.Build();
quote.AddQuoteItem(quoteItem);
this.Session.Derive();
var salesOrder = new SalesOrderBuilder(this.Session)
.WithTakenBy(allors)
.WithShipToCustomer(allors.ActiveCustomers.First)
.Build();
this.Session.Derive();
var salesOrderItem = new SalesOrderItemBuilder(this.Session)
.WithProduct(good_1)
.WithQuantityOrdered(1)
.WithAssignedUnitPrice(10)
.Build();
salesOrder.AddSalesOrderItem(salesOrderItem);
this.Session.Derive();
new CustomerShipmentBuilder(this.Session).WithDefaults(allors).Build();
this.Session.Derive();
new PurchaseShipmentBuilder(this.Session).WithDefaults(allors).Build();
this.Session.Derive();
}
public void GivenNonSerialisedNonUnifiedPart_WhenPurchased_ThenAverageCostIsCalculated()
{
this.InternalOrganisation.IsAutomaticallyReceived = true;
var secondFacility = new FacilityBuilder(this.Session)
.WithFacilityType(new FacilityTypes(this.Session).Warehouse)
.WithName("second facility")
.WithOwner(this.InternalOrganisation)
.Build();
var supplier = this.InternalOrganisation.ActiveSuppliers.First;
var customer = this.InternalOrganisation.ActiveCustomers.First;
var part = new NonUnifiedPartBuilder(this.Session).WithNonSerialisedDefaults(this.InternalOrganisation).Build();
var good = new NonUnifiedGoodBuilder(this.Session)
.WithName(part.Name)
.WithPart(part)
.WithVatRate(new VatRates(this.Session).Zero)
.Build();
this.Session.Derive();
var purchaseOrder1 = new PurchaseOrderBuilder(this.Session)
.WithTakenViaSupplier(supplier)
.WithDeliveryDate(this.Session.Now())
.Build();
this.Session.Derive();
// Beginning inventory: 150 items at 8 euro received in 2 facilities
var purchaseItem = new PurchaseOrderItemBuilder(this.Session).WithPart(part).WithQuantityOrdered(100).WithAssignedUnitPrice(8M).Build();
purchaseOrder1.AddPurchaseOrderItem(purchaseItem);
this.Session.Derive();
purchaseOrder1.SetReadyForProcessing();
this.Session.Derive();
purchaseOrder1.Send();
this.Session.Derive();
purchaseItem.QuickReceive();
this.Session.Derive();
var purchaseOrder2 = new PurchaseOrderBuilder(this.Session)
.WithTakenViaSupplier(supplier)
.WithFacility(secondFacility)
.WithDeliveryDate(this.Session.Now())
.Build();
this.Session.Derive();
// Beginning inventory: 150 items at 8 euro
purchaseItem = new PurchaseOrderItemBuilder(this.Session).WithPart(part).WithQuantityOrdered(50).WithAssignedUnitPrice(8M).Build();
purchaseOrder2.AddPurchaseOrderItem(purchaseItem);
this.Session.Derive();
purchaseOrder2.SetReadyForProcessing();
this.Session.Derive();
purchaseOrder2.Send();
this.Session.Derive();
purchaseItem.QuickReceive();
this.Session.Derive();
Assert.Equal(150, part.QuantityOnHand);
Assert.Equal(8, part.PartWeightedAverage.AverageCost);
purchaseOrder1.Revise();
this.Session.Derive();
// Purchase: 75 items at 8.1 euro
purchaseItem = new PurchaseOrderItemBuilder(this.Session).WithPart(part).WithQuantityOrdered(75).WithAssignedUnitPrice(8.1M).Build();
purchaseOrder1.AddPurchaseOrderItem(purchaseItem);
this.Session.Derive();
purchaseOrder1.SetReadyForProcessing();
this.Session.Derive();
purchaseOrder1.Send();
this.Session.Derive();
purchaseItem.QuickReceive();
this.Session.Derive();
Assert.Equal(225, part.QuantityOnHand);
Assert.Equal(8.03M, part.PartWeightedAverage.AverageCost);
var salesOrder = new SalesOrderBuilder(this.Session)
.WithTakenBy(this.InternalOrganisation)
.WithShipToCustomer(customer)
.Build();
this.Session.Derive();
// Sell 50 items for 20 euro
var salesItem1 = new SalesOrderItemBuilder(this.Session).WithProduct(good).WithQuantityOrdered(50).WithAssignedUnitPrice(20M).Build();
salesOrder.AddSalesOrderItem(salesItem1);
this.Session.Derive();
salesOrder.SetReadyForPosting();
this.Session.Derive();
salesOrder.Post();
this.Session.Derive();
salesOrder.Accept();
this.Session.Derive();
salesOrder.Ship();
this.Session.Derive();
var customerShipment = salesItem1.OrderShipmentsWhereOrderItem.First.ShipmentItem.ShipmentWhereShipmentItem as CustomerShipment;
customerShipment.Pick();
this.Session.Derive();
customer.PickListsWhereShipToParty.First(v => v.PickListState.Equals(new PickListStates(this.Session).Created)).SetPicked();
var package = new ShipmentPackageBuilder(this.Session).Build();
customerShipment.AddShipmentPackage(package);
foreach (ShipmentItem shipmentItem in customerShipment.ShipmentItems)
{
package.AddPackagingContent(new PackagingContentBuilder(this.Session).WithShipmentItem(shipmentItem).WithQuantity(shipmentItem.Quantity).Build());
}
this.Session.Derive();
customerShipment.Ship();
this.Session.Derive();
Assert.Equal(175, part.QuantityOnHand);
Assert.Equal(8.03M, part.PartWeightedAverage.AverageCost);
Assert.Equal(401.5M, salesItem1.CostOfGoodsSold);
// Again Sell 50 items for 20 euro
salesOrder.Revise();
this.Session.Derive();
var salesItem2 = new SalesOrderItemBuilder(this.Session).WithProduct(good).WithQuantityOrdered(50).WithAssignedUnitPrice(20M).Build();
salesOrder.AddSalesOrderItem(salesItem2);
this.Session.Derive();
salesOrder.SetReadyForPosting();
this.Session.Derive();
salesOrder.Post();
this.Session.Derive();
salesOrder.Accept();
this.Session.Derive();
salesOrder.Ship();
this.Session.Derive();
var customerShipment2 = salesItem2.OrderShipmentsWhereOrderItem.First.ShipmentItem.ShipmentWhereShipmentItem as CustomerShipment;
customerShipment2.Pick();
this.Session.Derive();
customer.PickListsWhereShipToParty.First(v => v.PickListState.Equals(new PickListStates(this.Session).Created)).SetPicked();
var package2 = new ShipmentPackageBuilder(this.Session).Build();
customerShipment2.AddShipmentPackage(package2);
foreach (ShipmentItem shipmentItem in customerShipment2.ShipmentItems)
{
package.AddPackagingContent(new PackagingContentBuilder(this.Session).WithShipmentItem(shipmentItem).WithQuantity(shipmentItem.Quantity).Build());
}
this.Session.Derive();
customerShipment2.Ship();
this.Session.Derive();
Assert.Equal(125, part.QuantityOnHand);
Assert.Equal(8.03M, part.PartWeightedAverage.AverageCost);
Assert.Equal(401.5M, salesItem1.CostOfGoodsSold);
// Purchase: 50 items at 8.25 euro
purchaseOrder1.Revise();
this.Session.Derive();
purchaseItem = new PurchaseOrderItemBuilder(this.Session).WithPart(part).WithQuantityOrdered(50).WithAssignedUnitPrice(8.25M).Build();
purchaseOrder1.AddPurchaseOrderItem(purchaseItem);
this.Session.Derive();
purchaseOrder1.SetReadyForProcessing();
this.Session.Derive();
purchaseOrder1.Send();
this.Session.Derive();
purchaseItem.QuickReceive();
this.Session.Derive();
Assert.Equal(175, part.QuantityOnHand);
Assert.Equal(8.09M, part.PartWeightedAverage.AverageCost);
// Use 65 items in a workorder
var workEffort = new WorkTaskBuilder(this.Session).WithName("Activity").WithCustomer(customer).WithTakenBy(this.InternalOrganisation).Build();
this.Session.Derive(true);
var inventoryAssignment = new WorkEffortInventoryAssignmentBuilder(this.Session)
.WithAssignment(workEffort)
.WithInventoryItem(part.InventoryItemsWherePart.First)
.WithQuantity(65)
.Build();
this.Session.Derive(true);
Assert.Equal(110, part.QuantityOnHand);
Assert.Equal(8.09M, part.PartWeightedAverage.AverageCost);
Assert.Equal(525.85M, inventoryAssignment.CostOfGoodsSold);
// Cancel workeffort inventory assignment
inventoryAssignment.Delete();
this.Session.Derive(true);
Assert.Equal(175, part.QuantityOnHand);
Assert.Equal(8.09M, part.PartWeightedAverage.AverageCost);
// Use 35 items in a workorder
inventoryAssignment = new WorkEffortInventoryAssignmentBuilder(this.Session)
.WithAssignment(workEffort)
.WithInventoryItem(part.InventoryItemsWherePart.First)
.WithQuantity(35)
.Build();
this.Session.Derive(true);
this.Session.Derive(true);
Assert.Equal(140, part.QuantityOnHand);
Assert.Equal(8.09M, part.PartWeightedAverage.AverageCost);
Assert.Equal(283.15M, inventoryAssignment.CostOfGoodsSold);
// Use 30 items in a workorder form second facility
inventoryAssignment = new WorkEffortInventoryAssignmentBuilder(this.Session)
.WithAssignment(workEffort)
.WithInventoryItem(part.InventoryItemsWherePart.First(v => v.Facility.Equals(secondFacility)))
.WithQuantity(30)
.Build();
this.Session.Derive(true);
Assert.Equal(110, part.QuantityOnHand);
Assert.Equal(8.09M, part.PartWeightedAverage.AverageCost);
Assert.Equal(242.7M, inventoryAssignment.CostOfGoodsSold);
// Purchase: 90 items at 8.35 euro
var purchaseOrder3 = new PurchaseOrderBuilder(this.Session)
.WithTakenViaSupplier(supplier)
.WithDeliveryDate(this.Session.Now())
.Build();
this.Session.Derive();
purchaseItem = new PurchaseOrderItemBuilder(this.Session).WithPart(part).WithQuantityOrdered(90).WithAssignedUnitPrice(8.35M).Build();
purchaseOrder3.AddPurchaseOrderItem(purchaseItem);
this.Session.Derive();
purchaseOrder3.SetReadyForProcessing();
this.Session.Derive();
purchaseOrder3.Send();
this.Session.Derive();
purchaseOrder3.QuickReceive();
this.Session.Derive();
// Purchase: 50 items at 8.45 euro
var purchaseOrder4 = new PurchaseOrderBuilder(this.Session)
.WithTakenViaSupplier(supplier)
.WithDeliveryDate(this.Session.Now())
.Build();
this.Session.Derive();
purchaseItem = new PurchaseOrderItemBuilder(this.Session).WithPart(part).WithQuantityOrdered(50).WithAssignedUnitPrice(8.45M).Build();
purchaseOrder4.AddPurchaseOrderItem(purchaseItem);
this.Session.Derive();
purchaseOrder4.SetReadyForProcessing();
this.Session.Derive();
purchaseOrder4.Send();
this.Session.Derive();
purchaseOrder4.QuickReceive();
this.Session.Derive();
Assert.Equal(250, part.QuantityOnHand);
Assert.Equal(8.26M, part.PartWeightedAverage.AverageCost);
// Ship 10 items to customer (without sales order)
var outgoingShipment = new CustomerShipmentBuilder(this.Session)
.WithShipToParty(customer)
.WithShipToAddress(customer.ShippingAddress)
.WithShipmentMethod(new ShipmentMethods(this.Session).Ground)
.Build();
this.Session.Derive(true);
var outgoingItem = new ShipmentItemBuilder(this.Session).WithGood(good).WithQuantity(10).Build();
outgoingShipment.AddShipmentItem(outgoingItem);
this.Session.Derive(true);
outgoingShipment.Pick();
this.Session.Derive();
customer.PickListsWhereShipToParty.First(v => v.PickListState.Equals(new PickListStates(this.Session).Created)).SetPicked();
package = new ShipmentPackageBuilder(this.Session).Build();
customerShipment2.AddShipmentPackage(package);
foreach (ShipmentItem shipmentItem in outgoingShipment.ShipmentItems)
{
package.AddPackagingContent(new PackagingContentBuilder(this.Session).WithShipmentItem(shipmentItem).WithQuantity(shipmentItem.Quantity).Build());
}
this.Session.Derive();
outgoingShipment.Ship();
this.Session.Derive();
Assert.Equal(240, part.QuantityOnHand);
Assert.Equal(8.26M, part.PartWeightedAverage.AverageCost);
// Receive 10 items at 8.55 from supplier (without purchase order)
var incomingShipment = new PurchaseShipmentBuilder(this.Session)
.WithShipmentMethod(new ShipmentMethods(this.Session).Ground)
.WithShipFromParty(supplier)
.Build();
this.Session.Derive();
var incomingItem = new ShipmentItemBuilder(this.Session).WithPart(part).WithQuantity(10).WithUnitPurchasePrice(8.55M).Build();
incomingShipment.AddShipmentItem(incomingItem);
this.Session.Derive();
incomingShipment.Receive();
this.Session.Derive();
Assert.Equal(250, part.QuantityOnHand);
Assert.Equal(8.27M, part.PartWeightedAverage.AverageCost);
// Receive 100 items at 7.9 from supplier (without purchase order)
incomingShipment = new PurchaseShipmentBuilder(this.Session)
.WithShipmentMethod(new ShipmentMethods(this.Session).Ground)
.WithShipFromParty(supplier)
.Build();
this.Session.Derive();
incomingItem = new ShipmentItemBuilder(this.Session).WithPart(part).WithQuantity(100).WithUnitPurchasePrice(7.9M).Build();
incomingShipment.AddShipmentItem(incomingItem);
this.Session.Derive();
incomingShipment.Receive();
this.Session.Derive();
Assert.Equal(350, part.QuantityOnHand);
Assert.Equal(8.17M, part.PartWeightedAverage.AverageCost);
// Ship all items to customer (without sales order)
outgoingShipment = new CustomerShipmentBuilder(this.Session)
.WithShipToParty(customer)
.WithShipFromFacility(part.DefaultFacility)
.WithShipToAddress(customer.ShippingAddress)
.WithShipmentMethod(new ShipmentMethods(this.Session).Ground)
.Build();
this.Session.Derive(true);
outgoingItem = new ShipmentItemBuilder(this.Session).WithGood(good).WithQuantity(330).Build();
outgoingShipment.AddShipmentItem(outgoingItem);
this.Session.Derive(true);
outgoingShipment.Pick();
this.Session.Derive();
customer.PickListsWhereShipToParty.First(v => v.PickListState.Equals(new PickListStates(this.Session).Created)).SetPicked();
package = new ShipmentPackageBuilder(this.Session).Build();
customerShipment2.AddShipmentPackage(package);
foreach (ShipmentItem shipmentItem in outgoingShipment.ShipmentItems)
{
package.AddPackagingContent(new PackagingContentBuilder(this.Session).WithShipmentItem(shipmentItem).WithQuantity(shipmentItem.Quantity).Build());
}
this.Session.Derive();
outgoingShipment.Ship();
this.Session.Derive();
// Ship all items to customer (without sales order)
outgoingShipment = new CustomerShipmentBuilder(this.Session)
.WithShipToParty(customer)
.WithShipFromFacility(secondFacility)
.WithShipToAddress(customer.ShippingAddress)
.WithShipmentMethod(new ShipmentMethods(this.Session).Ground)
.Build();
this.Session.Derive(true);
outgoingItem = new ShipmentItemBuilder(this.Session).WithGood(good).WithQuantity(20).Build();
outgoingShipment.AddShipmentItem(outgoingItem);
this.Session.Derive(true);
outgoingShipment.Pick();
this.Session.Derive();
customer.PickListsWhereShipToParty.First(v => v.PickListState.Equals(new PickListStates(this.Session).Created)).SetPicked();
package = new ShipmentPackageBuilder(this.Session).Build();
customerShipment2.AddShipmentPackage(package);
foreach (ShipmentItem shipmentItem in outgoingShipment.ShipmentItems)
{
package.AddPackagingContent(new PackagingContentBuilder(this.Session).WithShipmentItem(shipmentItem).WithQuantity(shipmentItem.Quantity).Build());
}
this.Session.Derive();
outgoingShipment.Ship();
this.Session.Derive();
Assert.Equal(0, part.QuantityOnHand);
Assert.Equal(8.17M, part.PartWeightedAverage.AverageCost);
purchaseOrder1.Revise();
this.Session.Derive();
// Purchase 150 items at 8 euro
purchaseItem = new PurchaseOrderItemBuilder(this.Session).WithPart(part).WithQuantityOrdered(150).WithAssignedUnitPrice(8M).Build();
purchaseOrder1.AddPurchaseOrderItem(purchaseItem);
this.Session.Derive();
purchaseOrder1.SetReadyForProcessing();
this.Session.Derive();
purchaseOrder1.Send();
this.Session.Derive();
purchaseItem.QuickReceive();
this.Session.Derive();
Assert.Equal(150, part.QuantityOnHand);
Assert.Equal(8, part.PartWeightedAverage.AverageCost);
}
public static Organisation CreateInternalOrganisation(
ISession session,
string name,
string address,
string postalCode,
string locality,
Country country,
string phone1CountryCode,
string phone1,
ContactMechanismPurpose phone1Purpose,
string phone2CountryCode,
string phone2,
ContactMechanismPurpose phone2Purpose,
string emailAddress,
string websiteAddress,
string taxNumber,
string bankName,
string facilityName,
string bic,
string iban,
Currency currency,
string logo,
string storeName,
BillingProcess billingProcess,
string outgoingShipmentNumberPrefix,
string salesInvoiceNumberPrefix,
string salesOrderNumberPrefix,
string requestNumberPrefix,
string quoteNumberPrefix,
string productNumberPrefix,
int?requestCounterValue,
int?quoteCounterValue,
int?orderCounterValue,
int?invoiceCounterValue)
{
var postalAddress1 = new PostalAddressBuilder(session)
.WithAddress1(address)
.WithPostalBoundary(new PostalBoundaryBuilder(session).WithPostalCode(postalCode).WithLocality(locality).WithCountry(country).Build())
.Build();
var email = new EmailAddressBuilder(session)
.WithElectronicAddressString(emailAddress)
.Build();
var webSite = new WebAddressBuilder(session)
.WithElectronicAddressString(websiteAddress)
.Build();
var bank = new BankBuilder(session).WithName(bankName).WithBic(bic).WithCountry(country).Build();
var bankaccount = new BankAccountBuilder(session)
.WithBank(bank)
.WithIban(iban)
.WithNameOnAccount(name)
.WithCurrency(currency)
.Build();
var organisation = new OrganisationBuilder(session)
.WithIsInternalOrganisation(true)
.WithTaxNumber(taxNumber)
.WithName(name)
.WithBankAccount(bankaccount)
.WithDefaultCollectionMethod(new OwnBankAccountBuilder(session).WithBankAccount(bankaccount).WithDescription("Huisbank").Build())
.WithPreferredCurrency(new Currencies(session).FindBy(M.Currency.IsoCode, "EUR"))
.WithInvoiceSequence(new InvoiceSequences(session).EnforcedSequence)
.WithFiscalYearStartMonth(01)
.WithFiscalYearStartDay(01)
.WithDoAccounting(false)
.WithRequestNumberPrefix(requestNumberPrefix)
.WithQuoteNumberPrefix(quoteNumberPrefix)
.Build();
if (requestCounterValue != null)
{
organisation.RequestCounter = new CounterBuilder(session).WithValue(requestCounterValue).Build();
}
if (quoteCounterValue != null)
{
organisation.QuoteCounter = new CounterBuilder(session).WithValue(quoteCounterValue).Build();
}
organisation.AddPartyContactMechanism(new PartyContactMechanismBuilder(session)
.WithUseAsDefault(true)
.WithContactMechanism(email)
.WithContactPurpose(new ContactMechanismPurposes(session).GeneralEmail)
.Build());
organisation.AddPartyContactMechanism(new PartyContactMechanismBuilder(session)
.WithUseAsDefault(true)
.WithContactMechanism(postalAddress1)
.WithContactPurpose(new ContactMechanismPurposes(session).GeneralCorrespondence)
.Build());
organisation.AddPartyContactMechanism(new PartyContactMechanismBuilder(session)
.WithUseAsDefault(true)
.WithContactMechanism(webSite)
.WithContactPurpose(new ContactMechanismPurposes(session).InternetAddress)
.Build());
TelecommunicationsNumber phoneNumber1 = null;
if (!string.IsNullOrEmpty(phone1))
{
phoneNumber1 = new TelecommunicationsNumberBuilder(session).WithContactNumber(phone1).Build();
if (!string.IsNullOrEmpty(phone1CountryCode))
{
phoneNumber1.CountryCode = phone1CountryCode;
}
}
if (phoneNumber1 != null)
{
organisation.AddPartyContactMechanism(new PartyContactMechanismBuilder(session)
.WithUseAsDefault(true)
.WithContactMechanism(phoneNumber1)
.WithContactPurpose(phone1Purpose)
.Build());
}
TelecommunicationsNumber phoneNumber2 = null;
if (!string.IsNullOrEmpty(phone2))
{
phoneNumber2 = new TelecommunicationsNumberBuilder(session).WithContactNumber(phone2).Build();
if (!string.IsNullOrEmpty(phone2CountryCode))
{
phoneNumber2.CountryCode = phone2CountryCode;
}
}
if (phoneNumber2 != null)
{
organisation.AddPartyContactMechanism(new PartyContactMechanismBuilder(session)
.WithUseAsDefault(true)
.WithContactMechanism(phoneNumber2)
.WithContactPurpose(phone2Purpose)
.Build());
}
if (File.Exists(logo))
{
var fileInfo = new FileInfo(logo);
var fileName = System.IO.Path.GetFileNameWithoutExtension(fileInfo.FullName).ToLowerInvariant();
var content = File.ReadAllBytes(fileInfo.FullName);
var image = new MediaBuilder(session).WithFileName(fileName).WithInData(content).Build();
organisation.LogoImage = image;
}
Facility facility = null;
if (facilityName != null)
{
facility = new FacilityBuilder(session)
.WithName(facilityName)
.WithFacilityType(new FacilityTypes(session).Warehouse)
.WithOwner(organisation)
.Build();
}
var paymentMethod = new OwnBankAccountBuilder(session).WithBankAccount(bankaccount).WithDescription("Hoofdbank").Build();
var store = new StoreBuilder(session)
.WithName(storeName)
.WithOutgoingShipmentNumberPrefix(outgoingShipmentNumberPrefix)
.WithSalesInvoiceNumberPrefix(salesInvoiceNumberPrefix)
.WithSalesOrderNumberPrefix(salesOrderNumberPrefix)
.WithDefaultCollectionMethod(paymentMethod)
.WithDefaultShipmentMethod(new ShipmentMethods(session).Ground)
.WithDefaultCarrier(new Carriers(session).Fedex)
.WithBillingProcess(billingProcess)
.WithSalesInvoiceCounter(new CounterBuilder(session).WithUniqueId(Guid.NewGuid()).WithValue(0).Build())
.WithIsImmediatelyPicked(true)
.WithIsAutomaticallyShipped(true)
.WithInternalOrganisation(organisation)
.Build();
if (facility != null)
{
store.DefaultFacility = facility;
}
if (orderCounterValue != null)
{
store.SalesOrderCounter = new CounterBuilder(session).WithValue(orderCounterValue).Build();
}
if (invoiceCounterValue != null)
{
store.SalesInvoiceCounter = new CounterBuilder(session).WithValue(invoiceCounterValue).Build();
}
return(organisation);
}
