public override Dictionary <string, DbFieldEntry> GetFields(Address _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["AddressID"] = DbMgr.CreateAutoIntFieldEntry(_obj.AddressID);
fields["StreetLine1"] = DbMgr.CreateStringFieldEntry(_obj.StreetLine1);
fields["StreetLine2"] = DbMgr.CreateStringFieldEntry(_obj.StreetLine2);
fields["StreetLine3"] = DbMgr.CreateStringFieldEntry(_obj.StreetLine3);
fields["StreetLine4"] = DbMgr.CreateStringFieldEntry(_obj.StreetLine4);
fields["Street"] = DbMgr.CreateStringFieldEntry(_obj.Street);
fields["City"] = DbMgr.CreateStringFieldEntry(_obj.City);
fields["Country"] = DbMgr.CreateStringFieldEntry(_obj.Country);
fields["Phone1"] = DbMgr.CreateStringFieldEntry(_obj.Phone1);
fields["Phone2"] = DbMgr.CreateStringFieldEntry(_obj.Phone2);
fields["Phone3"] = DbMgr.CreateStringFieldEntry(_obj.Phone3);
fields["Email"] = DbMgr.CreateStringFieldEntry(_obj.Email);
fields["Fax"] = DbMgr.CreateStringFieldEntry(_obj.Fax);
fields["ContactName"] = DbMgr.CreateStringFieldEntry(_obj.ContactName);
fields["WWW"] = DbMgr.CreateStringFieldEntry(_obj.Website);
fields["Location"] = DbMgr.CreateIntFieldEntry(_obj.Location);
fields["CardRecordID"] = DbMgr.CreateIntFieldEntry(_obj.CardRecordID);
fields["Postcode"] = DbMgr.CreateStringFieldEntry(_obj.Postcode);
fields["State"] = DbMgr.CreateStringFieldEntry(_obj.State);
fields["Solutation"] = DbMgr.CreateStringFieldEntry(_obj.Solutation);
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(MoneySpent _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["MoneySpentID"] = DbMgr.CreateAutoIntFieldEntry(_obj.MoneySpentID);
fields["CardRecordID"] = DbMgr.CreateIntFieldEntry(_obj.CardRecordID);
fields["ChequeNumber"] = DbMgr.CreateStringFieldEntry(_obj.ChequeNumber);
fields["CostCentreID"] = DbMgr.CreateIntFieldEntry(_obj.CostCentreID);
fields["CurrencyID"] = DbMgr.CreateIntFieldEntry(_obj.CurrencyID);
fields["Date"] = DbMgr.CreateDateTimeFieldEntry(_obj.Date);
fields["IsAutoRecorded"] = DbMgr.CreateStringFieldEntry(_obj.IsAutoRecorded);
fields["IsPrinted"] = DbMgr.CreateStringFieldEntry(_obj.IsPrinted);
fields["IssuingAccountID"] = DbMgr.CreateIntFieldEntry(_obj.IssuingAccountID);
fields["IsTaxInclusive"] = DbMgr.CreateStringFieldEntry(_obj.IsTaxInclusive);
fields["IsThirteenthPeriod"] = DbMgr.CreateStringFieldEntry(_obj.IsThirteenthPeriod);
fields["Memo"] = DbMgr.CreateStringFieldEntry(_obj.Memo);
fields["Payee"] = DbMgr.CreateStringFieldEntry(_obj.Payee);
fields["PayeeLine1"] = DbMgr.CreateStringFieldEntry(_obj.PayeeLine1);
fields["PayeeLine2"] = DbMgr.CreateStringFieldEntry(_obj.PayeeLine2);
fields["PayeeLine3"] = DbMgr.CreateStringFieldEntry(_obj.PayeeLine3);
fields["PayeeLine4"] = DbMgr.CreateStringFieldEntry(_obj.PayeeLine4);
fields["PaymentDeliveryID"] = DbMgr.CreateStringFieldEntry(_obj.PaymentDeliveryID);
fields["PaymentStatusID"] = DbMgr.CreateStringFieldEntry(_obj.PaymentStatusID);
fields["StatementCode"] = DbMgr.CreateStringFieldEntry(_obj.StatementCode);
fields["StatementParticulars"] = DbMgr.CreateStringFieldEntry(_obj.StatementParticulars);
fields["StatementReference"] = DbMgr.CreateStringFieldEntry(_obj.StatementReference);
fields["StatementText"] = DbMgr.CreateStringFieldEntry(_obj.StatementText);
fields["TotalSpentAmount"] = DbMgr.CreateDoubleFieldEntry(_obj.TotalSpentAmount);
fields["TransactionDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.TransactionDate);
fields["TransactionExchangeRate"] = DbMgr.CreateDoubleFieldEntry(_obj.TransactionExchangeRate);
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(BankingDetail _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["Bank1CalculatedAmount"] = DbMgr.CreateDoubleFieldEntry(_obj.Bank1CalculatedAmount); //GetDouble(reader, "Bank1CalculatedAmount");
fields["Bank1Value"] = DbMgr.CreateDoubleFieldEntry(_obj.Bank1Value); //GetDouble(reader, "Bank1Value");
fields["Bank1ValueTypeID"] = DbMgr.CreateStringFieldEntry(_obj.Bank1ValueTypeID); //GetString(reader, "Bank1ValueTypeID");
fields["BankAccountName1"] = DbMgr.CreateStringFieldEntry(_obj.BankAccountName1); //GetString(reader, "BankAccountName1");
fields["BankAccountNumber1"] = DbMgr.CreateStringFieldEntry(_obj.BankAccountNumber1); //GetString(reader, "BankAccountNumber1");
fields["BSBCode1"] = DbMgr.CreateStringFieldEntry(_obj.BSBCode1); //GetString(reader, "BSBCode1");
fields["Bank2CalculatedAmount"] = DbMgr.CreateDoubleFieldEntry(_obj.Bank2CalculatedAmount); //GetDouble(reader, "Bank2CalculatedAmount");
fields["Bank2Value"] = DbMgr.CreateDoubleFieldEntry(_obj.Bank2Value); //GetDouble(reader, "Bank2Value");
fields["Bank2ValueTypeID"] = DbMgr.CreateStringFieldEntry(_obj.Bank2ValueTypeID); //GetString(reader, "Bank2ValueTypeID");
fields["BankAccountName2"] = DbMgr.CreateStringFieldEntry(_obj.BankAccountName2); //GetString(reader, "BankAccountName2");
fields["BankAccountNumber2"] = DbMgr.CreateStringFieldEntry(_obj.BankAccountNumber2); //GetString(reader, "BankAccountNumber2");
fields["BSBCode2"] = DbMgr.CreateStringFieldEntry(_obj.BSBCode2); //GetString(reader, "BSBCode2");
fields["Bank3CalculatedAmount"] = DbMgr.CreateDoubleFieldEntry(_obj.Bank3CalculatedAmount); //GetDouble(reader, "Bank3CalculatedAmount");
fields["Bank3Value"] = DbMgr.CreateDoubleFieldEntry(_obj.Bank3Value); //GetDouble(reader, "Bank3Value");
fields["Bank3ValueTypeID"] = DbMgr.CreateStringFieldEntry(_obj.Bank3ValueTypeID); //GetString(reader, "Bank3ValueTypeID");
fields["BankAccountName3"] = DbMgr.CreateStringFieldEntry(_obj.BankAccountName3); //GetString(reader, "BankAccountName3");
fields["BankAccountNumber3"] = DbMgr.CreateStringFieldEntry(_obj.BankAccountNumber3); //GetString(reader, "BankAccountNumber3");
fields["BSBCode3"] = DbMgr.CreateStringFieldEntry(_obj.BSBCode3); //GetString(reader, "BSBCode3");
fields["BankingDetailsID"] = DbMgr.CreateAutoIntFieldEntry(_obj.BankingDetailID); //GetInt32(reader, "BankingDetailID");
fields["CardRecordID"] = DbMgr.CreateIntFieldEntry(_obj.CardRecordID); //GetInt32(reader, "CardRecordID");
fields["WritePaychequeID"] = DbMgr.CreateIntFieldEntry(_obj.WritePaychequeID); //GetInt32(reader, "WritePaychequeID");
fields["JournalRecordID"] = DbMgr.CreateIntFieldEntry(_obj.JournalRecordID); //GetInt32(reader, "JournalRecordID");
fields["NumberBankAccounts"] = DbMgr.CreateIntFieldEntry(_obj.NumberBankAccounts); //GetInt32(reader, "NumberBankAccounts");
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(RecurringPurchase _obj)
{
Dictionary <string, DbFieldEntry> fields = GetRecurringEntityFields(_obj);
fields["RecurringPurchaseID"] = DbMgr.CreateAutoIntFieldEntry(_obj.RecurringPurchaseID);
fields["CardRecordID"] = DbMgr.CreateIntFieldEntry(_obj.CardRecordID);
fields["Memo"] = DbMgr.CreateStringFieldEntry(_obj.Memo);
fields["Comment"] = DbMgr.CreateStringFieldEntry(_obj.Comment);
fields["ShipToAddress"] = DbMgr.CreateStringFieldEntry(_obj.ShipToAddress);
fields["ShipToAddressLine1"] = DbMgr.CreateStringFieldEntry(_obj.ShipToAddressLine1);
fields["ShipToAddressLine2"] = DbMgr.CreateStringFieldEntry(_obj.ShipToAddressLine2);
fields["ShipToAddressLine3"] = DbMgr.CreateStringFieldEntry(_obj.ShipToAddressLine3);
fields["ShipToAddressLine4"] = DbMgr.CreateStringFieldEntry(_obj.ShipToAddressLine4);
fields["PurchaseStatusID"] = DbMgr.CreateStringFieldEntry(_obj.PurchaseStatusID);
fields["TermsID"] = DbMgr.CreateIntFieldEntry(_obj.TermsID);
fields["InvoiceDeliveryID"] = DbMgr.CreateStringFieldEntry(_obj.InvoiceDeliveryID);
fields["ShippingMethodID"] = DbMgr.CreateIntFieldEntry(_obj.ShippingMethodID);
fields["TaxExclusiveFreight"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxExclusiveFreight);
fields["TaxInclusiveFreight"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxInclusiveFreight);
fields["FreightTaxCodeID"] = DbMgr.CreateIntFieldEntry(_obj.FreightTaxCodeID);
fields["CurrencyID"] = DbMgr.CreateIntFieldEntry(_obj.CurrencyID);
//fields["CostCentreID"] = new IntFieldEntry(_obj.CostCentreID);
fields["IsTaxInclusive"] = DbMgr.CreateStringFieldEntry(_obj.IsTaxInclusive);
fields["PurchaseTypeID"] = DbMgr.CreateStringFieldEntry(_obj.PurchaseTypeID);
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(CustomerDiscount _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["CardRecordID"] = DbMgr.CreateIntFieldEntry(_obj.CardRecordID);
fields["CurrencyID"] = DbMgr.CreateIntFieldEntry(_obj.CurrencyID);
fields["CustomerDiscountID"] = DbMgr.CreateAutoIntFieldEntry(_obj.CustomerDiscountID);
fields["CustomerDiscountNumber"] = DbMgr.CreateStringFieldEntry(_obj.CustomerDiscountNumber);
fields["TransactionDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.TransactionDate);
fields["Date"] = DbMgr.CreateDateTimeFieldEntry(_obj.Date);
fields["ExchangeGainLoss"] = DbMgr.CreateDoubleFieldEntry(_obj.ExchangeGainLoss);
fields["IsTaxInclusive"] = DbMgr.CreateStringFieldEntry(_obj.IsTaxInclusive);
fields["IsThirteenthPeriod"] = DbMgr.CreateStringFieldEntry(_obj.IsThirteenthPeriod);
fields["Memo"] = DbMgr.CreateStringFieldEntry(_obj.Memo);
fields["MethodOfPaymentID"] = DbMgr.CreateIntFieldEntry(_obj.MethodOfPaymentID);
fields["PaymentAuthorisationNumber"] = DbMgr.CreateStringFieldEntry(_obj.PaymentAuthorisationNumber);
fields["PaymentBankAccountName"] = DbMgr.CreateStringFieldEntry(_obj.PaymentBankAccountName);
fields["PaymentBankAccountNumber"] = DbMgr.CreateStringFieldEntry(_obj.PaymentBankAccountNumber);
fields["PaymentBankBranch"] = DbMgr.CreateStringFieldEntry(_obj.PaymentBankBranch);
fields["PaymentBSB"] = DbMgr.CreateStringFieldEntry(_obj.PaymentBSB);
fields["PaymentCardNumber"] = DbMgr.CreateStringFieldEntry(_obj.PaymentCardNumber);
fields["PaymentChequeNumber"] = DbMgr.CreateStringFieldEntry(_obj.PaymentChequeNumber);
fields["PaymentExpirationDate"] = DbMgr.CreateStringFieldEntry(_obj.PaymentExpirationDate);
fields["PaymentNameOnCard"] = DbMgr.CreateStringFieldEntry(_obj.PaymentNameOnCard);
fields["PaymentNotes"] = DbMgr.CreateStringFieldEntry(_obj.PaymentNotes);
fields["DiscountAccountID"] = DbMgr.CreateIntFieldEntry(_obj.DiscountAccountID);
fields["TotalDiscount"] = DbMgr.CreateDoubleFieldEntry(_obj.TotalDiscount);
fields["TransactionExchangeRate"] = DbMgr.CreateDoubleFieldEntry(_obj.TransactionExchangeRate);
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(LinkedAccount _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["LinkedAccountID"] = DbMgr.CreateAutoIntFieldEntry(_obj.LinkedAccountID);
fields["ChangeControl"] = DbMgr.CreateStringFieldEntry(_obj.ChangeControl);
fields["CurrencyGainLossID"] = DbMgr.CreateIntFieldEntry(_obj.CurrencyGainLossID);
fields["CurrentEarningsID"] = DbMgr.CreateIntFieldEntry(_obj.CurrentEarningsID);
fields["ElectronicPaymentsID"] = DbMgr.CreateIntFieldEntry(_obj.ElectronicPaymentsID);
fields["EmployerExpenseID"] = DbMgr.CreateIntFieldEntry(_obj.EmployerExpenseID);
fields["HistoricalBalancingID"] = DbMgr.CreateIntFieldEntry(_obj.HistoricalBalancingID);
fields["PayablesAccountID"] = DbMgr.CreateIntFieldEntry(_obj.PayablesAccountID);
fields["PayablesChequeID"] = DbMgr.CreateIntFieldEntry(_obj.PayablesChequeID);
fields["PayablesDepositsID"] = DbMgr.CreateIntFieldEntry(_obj.PayablesDepositsID);
fields["PayablesDiscountsID"] = DbMgr.CreateIntFieldEntry(_obj.PayablesDiscountsID);
fields["PayablesFreightID"] = DbMgr.CreateIntFieldEntry(_obj.PayablesFreightID);
fields["PayablesInventoryID"] = DbMgr.CreateIntFieldEntry(_obj.PayablesInventoryID);
fields["PayablesLateFeesID"] = DbMgr.CreateIntFieldEntry(_obj.PayablesLateFeesID);
fields["PayrollCashID"] = DbMgr.CreateIntFieldEntry(_obj.PayrollCashID);
fields["PayrollChequeID"] = DbMgr.CreateIntFieldEntry(_obj.PayrollChequeID);
fields["ReceivablesAccountID"] = DbMgr.CreateIntFieldEntry(_obj.ReceivablesAccountID);
fields["ReceivablesDepositsID"] = DbMgr.CreateIntFieldEntry(_obj.ReceivablesDepositsID);
fields["ReceivablesDiscountsID"] = DbMgr.CreateIntFieldEntry(_obj.ReceivablesDiscountsID);
fields["ReceivablesFreightID"] = DbMgr.CreateIntFieldEntry(_obj.ReceivablesFreightID);
fields["ReceivablesLateFeesID"] = DbMgr.CreateIntFieldEntry(_obj.ReceivablesLateFeesID);
fields["RetainedEarningsID"] = DbMgr.CreateIntFieldEntry(_obj.RetainedEarningsID);
fields["UndepositedFundsID"] = DbMgr.CreateIntFieldEntry(_obj.UndepositedFundsID);
fields["WagesExpenseID"] = DbMgr.CreateIntFieldEntry(_obj.WagesExpenseID);
fields["WithholdingPayableID"] = DbMgr.CreateIntFieldEntry(_obj.WithholdingPayableID);
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(BASInformation _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["BASInformationID"] = DbMgr.CreateAutoIntFieldEntry(_obj.BASInformationID); //GetInt32(reader, "BASInformationID");
fields["CalculationMethodID"] = DbMgr.CreateStringFieldEntry(_obj.CalculationMethodID); //GetString(reader, "CalculationMethodID");
fields["ClaimFuelTaxCredits"] = DbMgr.CreateStringFieldEntry(_obj.ClaimFuelTaxCredits); //GetString(reader, "ClaimFuelTaxCredits");
fields["FBTInstalmentAmount"] = DbMgr.CreateIntFieldEntry(_obj.FBTInstalmentAmount); //GetInt32(reader, "FBTInstalmentAmount");
fields["GSTBasisID"] = DbMgr.CreateStringFieldEntry(_obj.GSTBasisID); //GetString(reader, "GSTBasisID");
fields["GSTFreePurchases"] = DbMgr.CreateDoubleFieldEntry(_obj.GSTFreePurchases); //GetDouble(reader, "GSTFreePurchases");
fields["GSTFreeSales"] = DbMgr.CreateDoubleFieldEntry(_obj.GSTFreeSales); //GetDouble(reader, "GSTFreeSales");
fields["GSTFrequencyID"] = DbMgr.CreateStringFieldEntry(_obj.GSTFrequencyID); //GetString(reader, "GSTFrequencyID");
fields["GSTInstalmentAmount"] = DbMgr.CreateIntFieldEntry(_obj.GSTInstalmentAmount); //GetInt32(reader, "GSTInstalmentAmount");
fields["GSTOption"] = DbMgr.CreateStringFieldEntry(_obj.GSTOption); //GetString(reader, "GSTOption");
fields["HaveFBTObligations"] = DbMgr.CreateStringFieldEntry(_obj.HaveFBTObligations); //GetString(reader, "HaveFBTObligations");
fields["Include13Period"] = DbMgr.CreateStringFieldEntry(_obj.Include13Period); //GetString(reader, "Include13Period");
fields["InstalmentBasisID"] = DbMgr.CreateStringFieldEntry(_obj.InstalmentBasisID); //GetString(reader, "InstalmentBasisID");
fields["InstalmentFrequencyID"] = DbMgr.CreateStringFieldEntry(_obj.InstalmentFrequencyID); //GetString(reader, "InstalmentFrequencyID");
fields["InstalmentOption"] = DbMgr.CreateStringFieldEntry(_obj.InstalmentOption); //GetString(reader, "InstalmentOption");
fields["PAYGInstalmentAmount"] = DbMgr.CreateIntFieldEntry(_obj.PAYGInstalmentAmount); //GetInt32(reader, "PAYGInstalmentAmount");
fields["PAYGInstalmentRate"] = DbMgr.CreateDoubleFieldEntry(_obj.PAYGInstalmentRate); //GetDouble(reader, "PAYGInstalmentRate");
fields["UseSimplifiedAccounting"] = DbMgr.CreateStringFieldEntry(_obj.UseSimplifiedAccounting); //GetString(reader, "UseSimplifiedAccounting");
fields["WithholdingFrequencyID"] = DbMgr.CreateStringFieldEntry(_obj.WithholdingFrequencyID); //GetString(reader, "WithholdingFrequencyID");
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(RecurringItemSaleLine _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["RecurringItemSaleLineID"] = DbMgr.CreateAutoIntFieldEntry(_obj.RecurringItemSaleLineID);
fields["RecurringSaleLineID"] = DbMgr.CreateIntFieldEntry(_obj.RecurringSaleLineID);
fields["RecurringSaleID"] = DbMgr.CreateIntFieldEntry(_obj.RecurringSaleID);
fields["LineNumber"] = DbMgr.CreateIntFieldEntry(_obj.LineNumber);
fields["LineTypeID"] = DbMgr.CreateStringFieldEntry(_obj.LineTypeID);
fields["ItemID"] = DbMgr.CreateIntFieldEntry(_obj.ItemID);
fields["Description"] = DbMgr.CreateStringFieldEntry(_obj.Description);
fields["Quantity"] = DbMgr.CreateDoubleFieldEntry(_obj.Quantity);
fields["TaxExclusiveUnitPrice"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxExclusiveUnitPrice);
fields["TaxInclusiveUnitPrice"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxInclusiveUnitPrice);
fields["TaxExclusiveTotal"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxExclusiveTotal);
fields["TaxInclusiveTotal"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxInclusiveTotal);
fields["Discount"] = DbMgr.CreateDoubleFieldEntry(_obj.Discount);
fields["JobID"] = DbMgr.CreateIntFieldEntry(_obj.JobID);
fields["TaxBasisAmount"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxBasisAmount);
fields["TaxBasisAmountIsInclusive"] = DbMgr.CreateStringFieldEntry(_obj.TaxBasisAmountIsInclusive);
fields["TaxCodeID"] = DbMgr.CreateIntFieldEntry(_obj.TaxCodeID);
fields["CostOfGoodsSoldAmount"] = DbMgr.CreateDoubleFieldEntry(_obj.CostOfGoodsSoldAmount);
fields["LocationID"] = DbMgr.CreateIntFieldEntry(_obj.LocationID);
fields["SalesTaxCalBasisID"] = DbMgr.CreateStringFieldEntry(_obj.SalesTaxCalBasisID);
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(Supplier _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["SupplierID"] = DbMgr.CreateAutoIntFieldEntry(_obj.SupplierID);
fields["CardRecordID"] = DbMgr.CreateIntFieldEntry(_obj.CardRecordID);
fields["Name"] = DbMgr.CreateStringFieldEntry(_obj.Name);
fields["TermsID"] = DbMgr.CreateIntFieldEntry(_obj.TermsID);
fields["CurrentBalance"] = DbMgr.CreateDoubleFieldEntry(_obj.CurrentBalance);
fields["CardIdentification"] = DbMgr.CreateStringFieldEntry(_obj.CardIdentification);
fields["PurchaseCommentID"] = DbMgr.CreateIntFieldEntry(_obj.PurchaseCommentID);
fields["CardRecordID"] = DbMgr.CreateIntFieldEntry(_obj.CardRecordID);
fields["TaxCodeID"] = DbMgr.CreateIntFieldEntry(_obj.TaxCodeID);
fields["PurchaseLayoutID"] = DbMgr.CreateStringFieldEntry(_obj.PurchaseLayoutID);
fields["PaymentDeliveryID"] = DbMgr.CreateStringFieldEntry(_obj.PaymentDeliveryID);
fields["InvoiceDeliveryID"] = DbMgr.CreateStringFieldEntry(_obj.InvoiceDeliveryID);
fields["IsInactive"] = DbMgr.CreateStringFieldEntry(_obj.IsInactive);
fields["CurrencyID"] = DbMgr.CreateIntFieldEntry(_obj.CurrencyID);
fields["FreightTaxCodeID"] = DbMgr.CreateIntFieldEntry(_obj.FreightTaxCodeID);
fields["ShippingMethodID"] = DbMgr.CreateIntFieldEntry(_obj.ShippingMethodID);
fields["IsIndividual"] = DbMgr.CreateStringFieldEntry(_obj.IsIndividual);
fields["ExpenseAccountID"] = DbMgr.CreateIntFieldEntry(_obj.ExpenseAccountID);
fields["PaymentNotes"] = DbMgr.CreateStringFieldEntry(_obj.PaymentNotes);
fields["HourlyBillingRate"] = DbMgr.CreateDoubleFieldEntry(_obj.HourlyBillingRate);
fields["CreditLimit"] = DbMgr.CreateDoubleFieldEntry(_obj.CreditLimit);
fields["ABN"] = DbMgr.CreateStringFieldEntry(_obj.ABN);
fields["ABNBranch"] = DbMgr.CreateStringFieldEntry(_obj.ABNBranch);
fields["TaxIDNumber"] = DbMgr.CreateStringFieldEntry(_obj.TaxIDNumber);
fields["UseSupplierTaxCode"] = DbMgr.CreateStringFieldEntry(_obj.UseSupplierTaxCode);
fields["VolumeDiscount"] = DbMgr.CreateDoubleFieldEntry(_obj.VolumeDiscount);
fields["Picture"] = DbMgr.CreateStringFieldEntry(_obj.Picture);
fields["Notes"] = DbMgr.CreateStringFieldEntry(_obj.Notes);
fields["MethodOfPaymentID"] = DbMgr.CreateIntFieldEntry(_obj.PaymentMethodID);
fields["PaymentMemo"] = DbMgr.CreateStringFieldEntry(_obj.PaymentMemo);
fields["PaymentCardNumber"] = DbMgr.CreateStringFieldEntry(_obj.PaymentCardNumber);
fields["PaymentNameOnCard"] = DbMgr.CreateStringFieldEntry(_obj.PaymentNameOnCard);
fields["PaymentExpiryDate"] = DbMgr.CreateStringFieldEntry(_obj.PaymentExpirationDate);
fields["SupplierSince"] = DbMgr.CreateDateTimeFieldEntry(_obj.SupplierSince);
fields["LastPurchaseDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.LastPurchaseDate);
fields["LastPaymentDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.LastPaymentDate);
fields["HighestPurchaseAmount"] = DbMgr.CreateDoubleFieldEntry(_obj.HighestPurchaseAmount);
fields["HighestPayableAmount"] = DbMgr.CreateDoubleFieldEntry(_obj.HighestPayableAmount);
fields["EstimatedCostPerHour"] = DbMgr.CreateDoubleFieldEntry(_obj.EstimatedCostPerHour);
fields["BSBCode"] = DbMgr.CreateStringFieldEntry(_obj.BSBCode);
fields["BankAccountNumber"] = DbMgr.CreateStringFieldEntry(_obj.BankAccountNumber);
fields["BankAccountName"] = DbMgr.CreateStringFieldEntry(_obj.BankAccountName);
fields["LastName"] = DbMgr.CreateStringFieldEntry(_obj.LastName);
fields["FirstName"] = DbMgr.CreateStringFieldEntry(_obj.FirstName);
fields["CustomField1"] = DbMgr.CreateStringFieldEntry(_obj.CustomField1);
fields["CustomList1ID"] = DbMgr.CreateIntFieldEntry(_obj.CustomList1ID);
fields["CustomField2"] = DbMgr.CreateStringFieldEntry(_obj.CustomField2);
fields["CustomList2ID"] = DbMgr.CreateIntFieldEntry(_obj.CustomList2ID);
fields["CustomField3"] = DbMgr.CreateStringFieldEntry(_obj.CustomField3);
fields["CustomList3ID"] = DbMgr.CreateIntFieldEntry(_obj.CustomList3ID);
fields["Identifiers"] = DbMgr.CreateStringFieldEntry(_obj.Identifiers);
fields["PaymentBSB"] = DbMgr.CreateStringFieldEntry(_obj.PaymentBSB);
fields["PaymentBankAccountNumber"] = DbMgr.CreateStringFieldEntry(_obj.PaymentBankAccountNumber);
fields["PaymentBankAccountName"] = DbMgr.CreateStringFieldEntry(_obj.PaymentBankAccountName);
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(RecurringTimeBillingSaleLine _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["RecurringTimeBillingSaleLineID"] = DbMgr.CreateAutoIntFieldEntry(_obj.RecurringTimeBillingSaleLineID);
fields["RecurringSaleLineID"] = DbMgr.CreateIntFieldEntry(_obj.RecurringSaleLineID);
fields["RecurringSaleID"] = DbMgr.CreateIntFieldEntry(_obj.RecurringSaleID);
fields["LineNumber"] = DbMgr.CreateIntFieldEntry(_obj.LineNumber);
fields["LineTypeID"] = DbMgr.CreateStringFieldEntry(_obj.LineTypeID);
fields["Notes"] = DbMgr.CreateStringFieldEntry(_obj.Description);
fields["TaxExclusiveAmount"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxExclusiveAmount);
fields["TaxInclusiveAmount"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxInclusiveAmount);
fields["JobID"] = DbMgr.CreateIntFieldEntry(_obj.JobID);
fields["TaxBasisAmount"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxBasisAmount);
fields["TaxBasisAmountIsInclusive"] = DbMgr.CreateStringFieldEntry(_obj.TaxBasisAmountIsInclusive);
fields["TaxCodeID"] = DbMgr.CreateIntFieldEntry(_obj.TaxCodeID);
fields["LineDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.LineDate);
fields["HoursUnits"] = DbMgr.CreateDoubleFieldEntry(_obj.HoursUnits);
fields["ActivityID"] = DbMgr.CreateIntFieldEntry(_obj.ActivityID);
fields["LocationID"] = DbMgr.CreateIntFieldEntry(_obj.LocationID);
fields["EstimatedCost"] = DbMgr.CreateDoubleFieldEntry(_obj.EstimatedCost);
fields["TaxExclusiveRate"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxExclusiveRate);
fields["TaxInclusiveRate"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxInclusiveRate);
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(PayLiability _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["CardRecordID"] = DbMgr.CreateIntFieldEntry(_obj.CardRecordID); //GetInt32(reader, "CardRecordID");
fields["ChequeNumber"] = DbMgr.CreateStringFieldEntry(_obj.ChequeNumber); //GetString(reader, "ChequeNumber");
fields["CurrencyID"] = DbMgr.CreateIntFieldEntry(_obj.CurrencyID); //GetInt32(reader, "CurrencyID");
fields["FromDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.FromDate); //GetDateTime(reader, "FromDate");
fields["IsPrinted"] = DbMgr.CreateStringFieldEntry(_obj.IsPrinted); //GetString(reader, "IsPrinted");
fields["IssuingAccountID"] = DbMgr.CreateIntFieldEntry(_obj.IssuingAccountID); //GetInt32(reader, "IssuingAccountID");
fields["IsTaxInclusive"] = DbMgr.CreateStringFieldEntry(_obj.IsTaxInclusive); //GetString(reader, "IsTaxInclusive");
fields["IsThirteenthPeriod"] = DbMgr.CreateStringFieldEntry(_obj.IsThirteenthPeriod); //GetString(reader, "IsThirteenthPeriod");
fields["Memo"] = DbMgr.CreateStringFieldEntry(_obj.Memo); //GetString(reader, "Memo");
fields["Payee"] = DbMgr.CreateStringFieldEntry(_obj.Payee); //GetString(reader, "Payee");
fields["PayeeLine1"] = DbMgr.CreateStringFieldEntry(_obj.PayeeLine1); //GetString(reader, "PayeeLine1");
fields["PayeeLine2"] = DbMgr.CreateStringFieldEntry(_obj.PayeeLine2); //GetString(reader, "PayeeLine2");
fields["PayeeLine3"] = DbMgr.CreateStringFieldEntry(_obj.PayeeLine3); //GetString(reader, "PayeeLine3");
fields["PayeeLine4"] = DbMgr.CreateStringFieldEntry(_obj.PayeeLine4); //GetString(reader, "PayeeLine4");
fields["PayLiabilitiesID"] = DbMgr.CreateAutoIntFieldEntry(_obj.PayLiabilityID); //GetInt32(reader, "PayLiabilitiesID");
fields["PaymentDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.PaymentDate); //GetDateTime(reader, "PaymentDate");
fields["PaymentStatusID"] = DbMgr.CreateStringFieldEntry(_obj.PaymentStatusID); //GetString(reader, "PaymentStatusID");
fields["StatementText"] = DbMgr.CreateStringFieldEntry(_obj.StatementText); //GetString(reader, "StatementText");
fields["ToDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.ToDate); //GetDateTime(reader, "ToDate");
fields["TotalPayment"] = DbMgr.CreateDoubleFieldEntry(_obj.TotalPayment); //GetDouble(reader, "TotalPayment");
fields["TransactionExchangeRate"] = DbMgr.CreateDoubleFieldEntry(_obj.TransactionExchangeRate); //GetDouble(reader, "TransactionExchangeRate");
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(DebitRefund _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["AmountRefunded"] = DbMgr.CreateDoubleFieldEntry(_obj.AmountRefunded);
fields["CardRecordID"] = DbMgr.CreateIntFieldEntry(_obj.CardRecordID);
fields["DebitNoteID"] = DbMgr.CreateIntFieldEntry(_obj.DebitNoteID);
fields["DebitRefundID"] = DbMgr.CreateAutoIntFieldEntry(_obj.DebitRefundID);
fields["CurrencyID"] = DbMgr.CreateIntFieldEntry(_obj.CurrencyID);
fields["TransactionDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.TransactionDate);
fields["Date"] = DbMgr.CreateDateTimeFieldEntry(_obj.Date);
fields["ExchangeGainLoss"] = DbMgr.CreateDoubleFieldEntry(_obj.ExchangeGainLoss);
fields["MethodOfPaymentID"] = DbMgr.CreateIntFieldEntry(_obj.MethodOfPaymentID);
fields["RecipientAccountID"] = DbMgr.CreateIntFieldEntry(_obj.RecipientAccountID);
fields["IsTaxInclusive"] = DbMgr.CreateStringFieldEntry(_obj.IsTaxInclusive);
fields["IsThirteenthPeriod"] = DbMgr.CreateStringFieldEntry(_obj.IsThirteenthPeriod);
fields["Memo"] = DbMgr.CreateStringFieldEntry(_obj.Memo);
fields["DepositStatusID"] = DbMgr.CreateStringFieldEntry(_obj.DepositStatusID);
fields["TransactionExchangeRate"] = DbMgr.CreateDoubleFieldEntry(_obj.TransactionExchangeRate);
fields["PaymentAuthorisationNumber"] = DbMgr.CreateStringFieldEntry(_obj.PaymentAuthorisationNumber);
fields["PaymentBankAccountName"] = DbMgr.CreateStringFieldEntry(_obj.PaymentBankAccountName);
fields["PaymentBankAccountNumber"] = DbMgr.CreateStringFieldEntry(_obj.PaymentBankAccountNumber);
fields["PaymentBSB"] = DbMgr.CreateStringFieldEntry(_obj.PaymentBSB);
fields["PaymentCardNumber"] = DbMgr.CreateStringFieldEntry(_obj.PaymentCardNumber);
fields["PaymentChequeNumber"] = DbMgr.CreateStringFieldEntry(_obj.PaymentChequeNumber);
fields["PaymentExpirationDate"] = DbMgr.CreateStringFieldEntry(_obj.PaymentExpirationDate);
fields["PaymentNameOnCard"] = DbMgr.CreateStringFieldEntry(_obj.PaymentNameOnCard);
fields["PaymentNotes"] = DbMgr.CreateStringFieldEntry(_obj.PaymentNotes);
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(ItemPurchaseLine _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["ItemPurchaseLineID"] = DbMgr.CreateAutoIntFieldEntry(_obj.ItemPurchaseLineID);
fields["PurchaseLineID"] = DbMgr.CreateIntFieldEntry(_obj.PurchaseLineID);
fields["PurchaseID"] = DbMgr.CreateIntFieldEntry(_obj.PurchaseID);
fields["LineNumber"] = DbMgr.CreateIntFieldEntry(_obj.LineNumber);
fields["LineTypeID"] = DbMgr.CreateStringFieldEntry(_obj.LineTypeID);
fields["ItemID"] = DbMgr.CreateIntFieldEntry(_obj.ItemID);
fields["Description"] = DbMgr.CreateStringFieldEntry(_obj.Description);
fields["Quantity"] = DbMgr.CreateDoubleFieldEntry(_obj.Quantity);
fields["TaxExclusiveUnitPrice"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxExclusiveUnitPrice);
fields["TaxInclusiveUnitPrice"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxInclusiveUnitPrice);
fields["TaxExclusiveTotal"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxExclusiveTotal);
fields["TaxInclusiveTotal"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxInclusiveTotal);
fields["Discount"] = DbMgr.CreateDoubleFieldEntry(_obj.Discount);
fields["IsMultipleJob"] = DbMgr.CreateStringFieldEntry(_obj.IsMultipleJob);
fields["JobID"] = DbMgr.CreateIntFieldEntry(_obj.JobID);
fields["TaxBasisAmount"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxBasisAmount);
fields["TaxBasisAmountIsInclusive"] = DbMgr.CreateStringFieldEntry(_obj.TaxBasisAmountIsInclusive);
fields["TaxCodeID"] = DbMgr.CreateIntFieldEntry(_obj.TaxCodeID);
fields["Received"] = DbMgr.CreateDoubleFieldEntry(_obj.Received);
fields["LocationID"] = DbMgr.CreateIntFieldEntry(_obj.LocationID);
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(ActivitySlip _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["ActivityDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.ActivityDate); //GetDateTime(reader, "");
fields["ActivityID"] = DbMgr.CreateIntFieldEntry(_obj.ActivityID); //GetInt32(reader, "");
fields["ActivitySlipID"] = DbMgr.CreateAutoIntFieldEntry(_obj.ActivitySlipID); //GetInt32(reader, "");
fields["ActivitySlipNumber"] = DbMgr.CreateStringFieldEntry(_obj.ActivitySlipNumber); //GetString(reader, "");
fields["AdjustmentAmount"] = DbMgr.CreateDoubleFieldEntry(_obj.AdjustmentAmount); //GetDouble(reader, "");
fields["AdjustmentUnits"] = DbMgr.CreateDoubleFieldEntry(_obj.AdjustmentUnits); //GetDouble(reader, "");
fields["AlreadyBilledAmount"] = DbMgr.CreateDoubleFieldEntry(_obj.AlreadyBilledAmount); //GetDouble(reader, "");
fields["AlreadyBilledUnits"] = DbMgr.CreateDoubleFieldEntry(_obj.AlreadyBilledUnits); //GetDouble(reader, "");
fields["CardTypeID"] = DbMgr.CreateStringFieldEntry(_obj.CardTypeID); //GetString(reader, "");
fields["CustomerID"] = DbMgr.CreateIntFieldEntry(_obj.CustomerID); //GetInt32(reader, "");
fields["Date"] = DbMgr.CreateDateTimeFieldEntry(_obj.Date); //fields[""]=DbMgr.CreateIntFieldEntry(_obj.ActivityDate;
fields["ElapsedTime"] = DbMgr.CreateIntFieldEntry(_obj.ElapsedTime); //GetInt32(reader, "");
fields["EmployeeSupplierID"] = DbMgr.CreateIntFieldEntry(_obj.EmployeeSupplierID); //GetInt32(reader, "");
fields["IncludeInPayroll"] = DbMgr.CreateStringFieldEntry(_obj.IncludeInPayroll); //GetString(reader, "");
fields["JobID"] = DbMgr.CreateIntFieldEntry(_obj.JobID); //GetInt32(reader, "");
fields["JournalRecordID"] = DbMgr.CreateIntFieldEntry(_obj.JournalRecordID); //GetInt32(reader, "");
fields["Notes"] = DbMgr.CreateStringFieldEntry(_obj.Notes); //GetString(reader, "");
fields["PayrollStatusID"] = DbMgr.CreateStringFieldEntry(_obj.PayrollStatusID); //GetString(reader, "");
fields["Rate"] = DbMgr.CreateDoubleFieldEntry(_obj.Rate); //GetDouble(reader, "");
fields["SetID"] = DbMgr.CreateIntFieldEntry(_obj.SetID); //GetInt32(reader, "");
fields["SlipStatusID"] = DbMgr.CreateStringFieldEntry(_obj.SlipStatusID); //GetString(reader, "");
fields["StartTime"] = DbMgr.CreateStringFieldEntry(_obj.StartTime); //GetString(reader, "");
fields["StopTime"] = DbMgr.CreateStringFieldEntry(_obj.StopTime); //GetString(reader, "");
fields["Units"] = DbMgr.CreateDoubleFieldEntry(_obj.Units); //GetDouble(reader, "");
fields["WagesID"] = DbMgr.CreateIntFieldEntry(_obj.WagesID); //GetInt32(reader, "");
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(WritePaycheque _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["BankingDetailsID"] = DbMgr.CreateIntFieldEntry(_obj.BankingDetailsID); //GetInt32(reader, "BankingDetailsID");
fields["CardRecordID"] = DbMgr.CreateIntFieldEntry(_obj.CardRecordID); //GetInt32(reader, "CardRecordID");
fields["ChequeNumber"] = DbMgr.CreateStringFieldEntry(_obj.ChequeNumber); //GetString(reader, "ChequeNumber");
fields["CostCentreID"] = DbMgr.CreateIntFieldEntry(_obj.CostCentreID); //GetInt32(reader, "CostCentreID");
fields["CurrencyID"] = DbMgr.CreateIntFieldEntry(_obj.CurrencyID); //GetInt32(reader, "CurrencyID");
fields["TransactionDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.TransactionDate); //GetDateTime(reader, "TransactionDate");
fields["Date"] = DbMgr.CreateDateTimeFieldEntry(_obj.Date); //fields[""]=DbMgr.CreateIntFieldEntry(_obj.TransactionDate;
fields["IsPrinted"] = DbMgr.CreateStringFieldEntry(_obj.IsPrinted); //GetString(reader, "IsPrinted");
fields["IssuingAccountID"] = DbMgr.CreateIntFieldEntry(_obj.IssuingAccountID); //GetInt32(reader, "IssuingAccountID");
fields["IsTaxInclusive"] = DbMgr.CreateStringFieldEntry(_obj.IsTaxInclusive); //GetString(reader, "IsTaxInclusive");
fields["IsThirteenthPeriod"] = DbMgr.CreateStringFieldEntry(_obj.IsThirteenthPeriod); //GetString(reader, "");
fields["Memo"] = DbMgr.CreateStringFieldEntry(_obj.Memo); //GetString(reader, "Memo");
fields["NetPay"] = DbMgr.CreateDoubleFieldEntry(_obj.NetPay); //GetDouble(reader, "NetPay");
fields["NumberOfPayPeriods"] = DbMgr.CreateDoubleFieldEntry(_obj.NumberOfPayPeriods); //GetDouble(reader, "NumberOfPayPeriods");
fields["Payee"] = DbMgr.CreateStringFieldEntry(_obj.Payee); //GetString(reader, "Payee");
fields["PayeeLine1"] = DbMgr.CreateStringFieldEntry(_obj.PayeeLine1); //GetString(reader, "PayeeLine1");
fields["PayeeLine2"] = DbMgr.CreateStringFieldEntry(_obj.PayeeLine2); //GetString(reader, "PayeeLine2");
fields["PayeeLine3"] = DbMgr.CreateStringFieldEntry(_obj.PayeeLine3); //GetString(reader, "PayeeLine3");
fields["PayeeLine4"] = DbMgr.CreateStringFieldEntry(_obj.PayeeLine4); //GetString(reader, "PayeeLine4");
fields["PaymentTypeID"] = DbMgr.CreateStringFieldEntry(_obj.PaymentTypeID); //GetString(reader, "PaymentTypeID");
fields["PaymentStatusID"] = DbMgr.CreateStringFieldEntry(_obj.PaymentStatusID); //GetString(reader, "PaymentStatusID");
fields["PayPeriodEndingDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.PayPeriodEndingDate); //GetDateTime(reader, "PayPeriodEndingDate");
fields["PayPeriodStartDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.PayPeriodStartDate); //GetDateTime(reader, "PayPeriodStartDate");
fields["StatementText"] = DbMgr.CreateStringFieldEntry(_obj.StatementText); //GetString(reader, "StatementText");
fields["TransactionExchangeRate"] = DbMgr.CreateDoubleFieldEntry(_obj.TransactionExchangeRate); //GetDouble(reader, "TransactionExchangeRate");
fields["WritePaychequeID"] = DbMgr.CreateAutoIntFieldEntry(_obj.WritePaychequeID); //GetInt32(reader, "WritePaychequeID");
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(ShippingMethod _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["ShippingMethodID"] = DbMgr.CreateAutoIntFieldEntry(_obj.ShippingMethodID);
fields["ShippingMethod"] = DbMgr.CreateStringFieldEntry(_obj.Method);
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(PaymentMethod _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["PaymentMethodID"] = DbMgr.CreateAutoIntFieldEntry(_obj.PaymentMethodID);
fields["PaymentMethod"] = DbMgr.CreateStringFieldEntry(_obj.Description);
fields["MethodType"] = DbMgr.CreateStringFieldEntry(_obj.MethodType);
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(EmploymentClassification _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["EmploymentClassificationID"] = DbMgr.CreateAutoIntFieldEntry(_obj.EmploymentClassificationID);
fields["EmploymentClassificationName"] = DbMgr.CreateStringFieldEntry(_obj.EmploymentClassificationName);
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(ReferralSource _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["ReferralSourceID"] = DbMgr.CreateAutoIntFieldEntry(_obj.ReferralSourceID);
fields["ReferralSource"] = DbMgr.CreateStringFieldEntry(_obj.Description);
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(TaxScale _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["TaxScaleID"] = DbMgr.CreateAutoIntFieldEntry(_obj.TaxScaleID);
fields["Description"] = DbMgr.CreateStringFieldEntry(_obj.Description);
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(Comment _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["CommentID"] = DbMgr.CreateAutoIntFieldEntry(_obj.CommentID);
fields["Comment"] = DbMgr.CreateStringFieldEntry(_obj.Text);
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(Item _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["ItemID"] = DbMgr.CreateAutoIntFieldEntry(_obj.ItemID);
fields["PriceIsInclusive"] = DbMgr.CreateStringFieldEntry(_obj.PriceIsInclusive);
fields["BaseSellingPrice"] = DbMgr.CreateDoubleFieldEntry(_obj.BaseSellingPrice);
fields["BuyTaxCodeID"] = DbMgr.CreateIntFieldEntry(_obj.BuyTaxCodeID);
fields["BuyUnitMeasure"] = DbMgr.CreateStringFieldEntry(_obj.BuyUnitMeasure);
fields["BuyUnitQuantity"] = DbMgr.CreateIntFieldEntry(_obj.BuyUnitQuantity);
fields["ChangeControl"] = DbMgr.CreateStringFieldEntry(_obj.ChangeControl);
fields["DefaultReceiveLocationID"] = DbMgr.CreateIntFieldEntry(_obj.DefaultReceiveLocationID);
fields["DefaultReorderQuantity"] = DbMgr.CreateDoubleFieldEntry(_obj.DefaultReorderQuantity);
fields["DefaultSellLocationID"] = DbMgr.CreateIntFieldEntry(_obj.DefaultSellLocationID);
fields["ExpenseAccountID"] = DbMgr.CreateIntFieldEntry(_obj.ExpenseAccountID);
fields["IncomeAccountID"] = DbMgr.CreateIntFieldEntry(_obj.IncomeAccountID);
fields["InventoryAccountID"] = DbMgr.CreateIntFieldEntry(_obj.InventoryAccountID);
fields["ItemDescription"] = DbMgr.CreateStringFieldEntry(_obj.ItemDescription);
fields["ItemIsBought"] = DbMgr.CreateStringFieldEntry(_obj.ItemIsBought);
fields["ItemIsInventoried"] = DbMgr.CreateStringFieldEntry(_obj.ItemIsInventoried);
fields["ItemIsSold"] = DbMgr.CreateStringFieldEntry(_obj.ItemIsSold);
fields["ItemName"] = DbMgr.CreateStringFieldEntry(_obj.ItemName);
fields["ItemNumber"] = DbMgr.CreateStringFieldEntry(_obj.ItemNumber);
fields["LastUnitPrice"] = DbMgr.CreateDoubleFieldEntry(_obj.LastUnitPrice);
fields["MinLevelBeforeReorder"] = DbMgr.CreateDoubleFieldEntry(_obj.MinLevelBeforeReorder);
fields["NegativeAverageCost"] = DbMgr.CreateDoubleFieldEntry(_obj.NegativeAverageCost);
fields["NegativeQuantityOnHand"] = DbMgr.CreateDoubleFieldEntry(_obj.NegativeQuantityOnHand);
fields["Picture"] = DbMgr.CreateStringFieldEntry(_obj.Picture);
fields["PositiveAverageCost"] = DbMgr.CreateDoubleFieldEntry(_obj.PositiveAverageCost);
fields["PrimarySupplierID"] = DbMgr.CreateIntFieldEntry(_obj.PrimarySupplierID);
fields["PurchaseOnOrder"] = DbMgr.CreateDoubleFieldEntry(_obj.PurchaseOnOrder);
fields["QuantityAvailable"] = DbMgr.CreateDoubleFieldEntry(_obj.QuantityAvailable);
fields["QuantityOnHand"] = DbMgr.CreateDoubleFieldEntry(_obj.QuantityOnHand);
fields["ReceivedOnOrder"] = DbMgr.CreateDoubleFieldEntry(_obj.ReceivedOnOrder);
fields["SalesTaxCalcBasisID"] = DbMgr.CreateStringFieldEntry(_obj.SalesTaxCalcBasisID);
fields["SellOnOrder"] = DbMgr.CreateDoubleFieldEntry(_obj.SellOnOrder);
fields["SellTaxCodeID"] = DbMgr.CreateIntFieldEntry(_obj.SellTaxCodeID);
fields["SellUnitMeasure"] = DbMgr.CreateStringFieldEntry(_obj.SellUnitMeasure);
fields["SellUnitQuantity"] = DbMgr.CreateIntFieldEntry(_obj.SellUnitQuantity);
fields["SupplierItemNumber"] = DbMgr.CreateStringFieldEntry(_obj.SupplierItemNumber);
fields["TaxExclusiveLastPurchasePrice"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxExclusiveLastPurchasePrice);
fields["TaxExclusiveStandardCost"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxExclusiveStandardCost);
fields["TaxInclusiveLastPurchasePrice"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxInclusiveLastPurchasePrice);
fields["TaxInclusiveStandardCost"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxInclusiveStandardCost);
fields["UseDescription"] = DbMgr.CreateStringFieldEntry(_obj.UseDescription);
fields["ValueOnHand"] = DbMgr.CreateDoubleFieldEntry(_obj.ValueOnHand);
fields["IsInactive"] = DbMgr.CreateStringFieldEntry(_obj.IsInactive);
fields["CustomField1"] = DbMgr.CreateStringFieldEntry(_obj.CustomField1);
fields["CustomList1ID"] = DbMgr.CreateIntFieldEntry(_obj.CustomList1ID);
fields["CustomField2"] = DbMgr.CreateStringFieldEntry(_obj.CustomField2);
fields["CustomList2ID"] = DbMgr.CreateIntFieldEntry(_obj.CustomList2ID);
fields["CustomField3"] = DbMgr.CreateStringFieldEntry(_obj.CustomField3);
fields["CustomList3ID"] = DbMgr.CreateIntFieldEntry(_obj.CustomList3ID);
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(MiscNumber _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["ID"] = DbMgr.CreateAutoIntFieldEntry(_obj.ID);
fields["type"] = DbMgr.CreateIntFieldEntry((int)_obj.type);
fields["signature"] = DbMgr.CreateStringFieldEntry(_obj.signature);
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(AuthRole _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["RoleID"] = DbMgr.CreateAutoIntFieldEntry(_obj.RoleID);
fields["RoleName"] = DbMgr.CreateStringFieldEntry(_obj.RoleName);
fields["Description"] = DbMgr.CreateStringFieldEntry(_obj.Description);
fields["FullControl"] = DbMgr.CreateStringFieldEntry(_obj.FullControl);
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(TaxCodeConsolidation _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["TaxCodeConsolidationID"] = DbMgr.CreateAutoIntFieldEntry(_obj.TaxCodeConsolidationID);
fields["ConsolidatedTaxCodeID"] = DbMgr.CreateIntFieldEntry(_obj.ConsolidatedTaxCodeID);
fields["ElementTaxCodeID"] = DbMgr.CreateIntFieldEntry(_obj.ElementTaxCodeID);
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(DataField _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["DataFieldID"] = DbMgr.CreateAutoIntFieldEntry(_obj.DataFieldID);
fields["DataFieldType"] = DbMgr.CreateStringFieldEntry(_obj.DataFieldType);
fields["DataFieldName"] = DbMgr.CreateStringFieldEntry(_obj.DataFieldName);
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(BuiltItem _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["BuiltItemID"] = DbMgr.CreateAutoIntFieldEntry(_obj.BuiltItemID);
fields["ItemID"] = DbMgr.CreateIntFieldEntry(_obj.ItemID);
fields["QuantityBuilt"] = DbMgr.CreateDoubleFieldEntry(_obj.QuantityBuilt);
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(Config _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["ConfigID"] = DbMgr.CreateAutoIntFieldEntry(_obj.ConfigID);
fields["ConfigName"] = DbMgr.CreateStringFieldEntry(_obj.ConfigName);
fields["ConfigValue"] = DbMgr.CreateStringFieldEntry(_obj.ConfigValue);
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(JobBudget _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["JobBudgetID"] = DbMgr.CreateAutoIntFieldEntry(_obj.JobBudgetID);
fields["AccountID"] = DbMgr.CreateIntFieldEntry(_obj.AccountID);
fields["JobID"] = DbMgr.CreateIntFieldEntry(_obj.JobID);
fields["Amount"] = DbMgr.CreateDoubleFieldEntry(_obj.Amount);
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(ItemDataFieldEntry _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["ItemDataFieldEntryID"] = DbMgr.CreateAutoIntFieldEntry(_obj.ItemDataFieldEntryID);
fields["DataFieldID"] = DbMgr.CreateIntFieldEntry(_obj.DataFieldID);
fields["ItemNumber"] = DbMgr.CreateStringFieldEntry(_obj.ItemNumber);
fields["Content"] = DbMgr.CreateStringFieldEntry(_obj.Content);
return(fields);
}