Пример #1
0
        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);
        }
Пример #2
0
        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);
        }
Пример #3
0
        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);
        }
Пример #6
0
        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);
        }
Пример #7
0
        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);
        }
Пример #9
0
        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);
        }
Пример #10
0
        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);
        }
Пример #12
0
        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);
        }
Пример #13
0
        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);
        }
Пример #16
0
        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);
        }
Пример #19
0
        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);
        }
Пример #20
0
        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);
        }
Пример #23
0
        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);
        }
Пример #24
0
        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);
        }
Пример #26
0
        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);
        }
Пример #27
0
        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);
        }
Пример #28
0
        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);
        }
Пример #30
0
        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);
        }