private Dictionary <string, DbFieldEntry> GetQueryMap_StoreItemInventoryAdjustmentLines(InventoryAdjustment _sale, InventoryAdjustmentLine _line) { Dictionary <string, DbFieldEntry> query_map = new Dictionary <string, DbFieldEntry>(); bool multi_currency_support = _sale.RepositoryMgr.CurrencyMgr.SupportMultiCurrency; query_map.Add("JournalNumber", DbMgr.CreateStringFieldEntry(_sale.InventoryJournalNumber)); query_map.Add("AdjustmentDate", _sale.Date != null ? (DbFieldEntry)DbMgr.CreateDateTimeFieldEntry(_sale.Date) : (DbFieldEntry)DbMgr.CreateStringFieldEntry("")); query_map.Add("Memo", DbMgr.CreateStringFieldEntry(_sale.Memo)); query_map.Add("ItemNumber", DbMgr.CreateStringFieldEntry(_line.ItemNumber)); query_map.Add("Location", DbMgr.CreateStringFieldEntry(_line.Location != null ? _line.Location.ToString() : "")); query_map.Add("Quantity", DbMgr.CreateDoubleFieldEntry(_line.Quantity)); query_map.Add("UnitCost", DbMgr.CreateDoubleFieldEntry(_line.UnitCost)); query_map.Add("Amount", DbMgr.CreateDoubleFieldEntry(_line.Amount)); if (_line.Account != null) { int account_number = 0; if (AccountNumber2Int(_line.AccountNumber, out account_number)) { query_map.Add("Account", DbMgr.CreateIntFieldEntry(account_number)); } } if (_line.Job != null) { query_map.Add("JobNumber", DbMgr.CreateStringFieldEntry(_line.JobNumber)); } query_map.Add("AllocationMemo", DbMgr.CreateStringFieldEntry(_line.Memo)); //query_map.Add("Category", DbMgr.CreateStringFieldEntry("")); return(query_map); }
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(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(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(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(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(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(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(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(MoveItem _obj) { Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>(); fields["Description"] = DbMgr.CreateStringFieldEntry(_obj.Description); //GetString(reader, ""); fields["ItemID"] = DbMgr.CreateIntFieldEntry(_obj.ItemID); //GetInt32(reader, ""); fields["MoveDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.MoveDate); //GetDateTime(reader, ""); fields["UserID"] = DbMgr.CreateIntFieldEntry(_obj.UserID); //GetInt32(reader, ""); fields["MoveItemID"] = DbMgr.CreateAutoIntFieldEntry(_obj.MoveItemID); //GetInt32(reader, ""); return(fields); }
public override Dictionary <string, DbFieldEntry> GetFields(Sale _obj) { Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>(); fields["SaleID"] = DbMgr.CreateAutoIntFieldEntry(_obj.SaleID); fields["InvoiceNumber"] = DbMgr.CreateStringFieldEntry(_obj.InvoiceNumber); fields["CardRecordID"] = DbMgr.CreateIntFieldEntry(_obj.CardRecordID); fields["CustomerPONumber"] = DbMgr.CreateStringFieldEntry(_obj.CustomerPONumber); fields["IsHistorical"] = DbMgr.CreateStringFieldEntry(_obj.IsHistorical); fields["BackorderSaleID"] = DbMgr.CreateIntFieldEntry(_obj.BackorderSaleID); fields["Date"] = DbMgr.CreateDateTimeFieldEntry(_obj.Date); fields["InvoiceDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.InvoiceDate); fields["IsThirteenthPeriod"] = DbMgr.CreateStringFieldEntry(_obj.IsThirteenthPeriod); 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["InvoiceTypeID"] = DbMgr.CreateStringFieldEntry(_obj.InvoiceTypeID); fields["InvoiceStatusID"] = DbMgr.CreateStringFieldEntry(_obj.InvoiceStatusID); fields["TermsID"] = DbMgr.CreateIntFieldEntry(_obj.TermsID); fields["TotalLines"] = DbMgr.CreateDoubleFieldEntry(_obj.TotalLines); fields["TaxExclusiveFreight"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxExclusiveFreight); fields["TaxInclusiveFreight"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxInclusiveFreight); fields["FreightTaxCodeID"] = DbMgr.CreateIntFieldEntry(_obj.FreightTaxCodeID); fields["TotalTax"] = DbMgr.CreateDoubleFieldEntry(_obj.TotalTax); fields["TotalPaid"] = DbMgr.CreateDoubleFieldEntry(_obj.TotalPaid); fields["TotalCredits"] = DbMgr.CreateDoubleFieldEntry(_obj.TotalCredits); fields["TotalDeposits"] = DbMgr.CreateDoubleFieldEntry(_obj.TotalDeposits); fields["TotalDiscounts"] = DbMgr.CreateDoubleFieldEntry(_obj.TotalDiscounts); fields["OutstandingBalance"] = DbMgr.CreateDoubleFieldEntry(_obj.OutstandingBalance); fields["SalesPersonID"] = DbMgr.CreateIntFieldEntry(_obj.SalesPersonID); fields["Memo"] = DbMgr.CreateStringFieldEntry(_obj.Memo); fields["Comment"] = DbMgr.CreateStringFieldEntry(_obj.Comment); fields["ShippingMethodID"] = DbMgr.CreateIntFieldEntry(_obj.ShippingMethodID); fields["Date"] = DbMgr.CreateDateTimeFieldEntry(_obj.InvoiceDate); fields["PromisedDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.PromisedDate); fields["ReferralSourceID"] = DbMgr.CreateIntFieldEntry(_obj.ReferralSourceID); fields["IsTaxInclusive"] = DbMgr.CreateStringFieldEntry(_obj.IsTaxInclusive); fields["IsAutoRecorded"] = DbMgr.CreateStringFieldEntry(_obj.IsAutoRecorded); fields["IsPrinted"] = DbMgr.CreateStringFieldEntry(_obj.IsPrinted); fields["InvoiceDeliveryID"] = DbMgr.CreateStringFieldEntry(_obj.InvoiceDeliveryID); fields["DaysTillPaid"] = DbMgr.CreateIntFieldEntry(_obj.DaysTillPaid); fields["CurrencyID"] = DbMgr.CreateIntFieldEntry(_obj.CurrencyID); fields["TransactionExchangeRate"] = DbMgr.CreateDoubleFieldEntry(_obj.TransactionExchangeRate); //fields["CostCentreID"]= Convert.ToString(_obj.CostCentreID); fields["LinesPurged"] = DbMgr.CreateStringFieldEntry(_obj.LinesPurged); fields["PreAuditTrail"] = DbMgr.CreateStringFieldEntry(_obj.PreAuditTrail); fields["DestinationCountry"] = DbMgr.CreateStringFieldEntry(_obj.DestinationCountry); return(fields); }
public override Dictionary <string, DbFieldEntry> GetFields(ContactLog _obj) { Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>(); fields["ContactLogID"] = DbMgr.CreateAutoIntFieldEntry(_obj.ContactLogID); fields["CardRecordID"] = DbMgr.CreateIntFieldEntry(_obj.CardRecordID); fields["Contact"] = DbMgr.CreateStringFieldEntry(_obj.Contact); fields["Date"] = DbMgr.CreateDateTimeFieldEntry(_obj.Date); fields["ElapsedTime"] = DbMgr.CreateStringFieldEntry(_obj.ElapsedTime); fields["LogDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.LogDate); fields["Notes"] = DbMgr.CreateStringFieldEntry(_obj.Notes); fields["RecontactDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.RecontactDate); return(fields); }
public override Dictionary <string, DbFieldEntry> GetFields(ItemAddOn _obj) { Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>(); fields["ItemAddOnID"] = DbMgr.CreateAutoIntFieldEntry(_obj.ItemAddOnID); fields["Color"] = DbMgr.CreateStringFieldEntry(_obj.Color); fields["Brand"] = DbMgr.CreateStringFieldEntry(_obj.Brand); fields["ItemSizeID"] = DbMgr.CreateStringFieldEntry(_obj.ItemSizeID); fields["BatchNumber"] = DbMgr.CreateStringFieldEntry(_obj.BatchNumber); fields["SerialNumber"] = DbMgr.CreateStringFieldEntry(_obj.SerialNumber); fields["GenderID"] = DbMgr.CreateStringFieldEntry(_obj.GenderID); fields["ExpiryDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.ExpiryDate); fields["ItemNumber"] = DbMgr.CreateStringFieldEntry(_obj.ItemNumber); return(fields); }
public override Dictionary <string, DbFieldEntry> GetFields(AuditTrail _obj) { Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>(); fields["AuditTrailID"] = DbMgr.CreateIntFieldEntry(_obj.AuditTrailID); //GetInt32(reader, ""); fields["AuditTypeID"] = DbMgr.CreateStringFieldEntry(_obj.AuditTypeID); //GetString(reader, ""); fields["ChangeDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.ChangeDate); //GetDateTime(reader, ""); fields["Description"] = DbMgr.CreateStringFieldEntry(_obj.Description); //GetString(reader, ""); fields["IsReconciled"] = DbMgr.CreateStringFieldEntry(_obj.IsReconciled); //GetString(reader, ""); fields["OriginalDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.OriginalDate); //GetDateTime(reader, ""); fields["TransactionNumber"] = DbMgr.CreateStringFieldEntry(_obj.TransactionNumber); //GetString(reader, ""); fields["UserID"] = DbMgr.CreateIntFieldEntry(_obj.UserID); //GetInt32(reader, ""); fields["WasThirteenthPeriod"] = DbMgr.CreateStringFieldEntry(_obj.WasThirteenthPeriod); //GetString(reader, ""); return(fields); }
public override Dictionary <string, DbFieldEntry> GetFields(InventoryTransfer _obj) { Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>(); fields["CostCentreID"] = DbMgr.CreateIntFieldEntry(_obj.CostCentreID); fields["CurrencyID"] = DbMgr.CreateIntFieldEntry(_obj.CurrencyID); fields["TransactionDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.TransactionDate); fields["Date"] = DbMgr.CreateDateTimeFieldEntry(_obj.Date); fields["InventoryJournalNumber"] = DbMgr.CreateStringFieldEntry(_obj.InventoryJournalNumber); fields["InventoryTransferID"] = DbMgr.CreateAutoIntFieldEntry(_obj.InventoryTransferID); fields["IsTaxInclusive"] = DbMgr.CreateStringFieldEntry(_obj.IsTaxInclusive); fields["IsThirteenthPeriod"] = DbMgr.CreateStringFieldEntry(_obj.IsThirteenthPeriod); fields["Memo"] = DbMgr.CreateStringFieldEntry(_obj.Memo); fields["TransactionExchangeRate"] = DbMgr.CreateDoubleFieldEntry(_obj.TransactionExchangeRate); return(fields); }
public override Dictionary <string, DbFieldEntry> GetFields(CostCentreJournalRecord _obj) { Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>(); fields["CostCentreJournalRecordID"] = DbMgr.CreateIntFieldEntry(_obj.CostCentreJournalRecordID); //GetInt32(reader, "CostCentreJournalRecordID"); fields["TransactionNumber"] = DbMgr.CreateStringFieldEntry(_obj.TransactionNumber); //GetString(reader, "TransactionNumber"); fields["TransactionDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.TransactionDate); //GetDateTime(reader, "TransactionDate"); fields["Date"] = DbMgr.CreateDateTimeFieldEntry(_obj.Date); //fields[""]=DbMgr.CreateIntFieldEntry(_obj.TransactionDate; fields["IsThirteenthPeriod"] = DbMgr.CreateStringFieldEntry(_obj.IsThirteenthPeriod); //GetString(reader, "IsThirteenthPeriod"); fields["CostCentreID"] = DbMgr.CreateIntFieldEntry(_obj.CostCentreID); //GetInt32(reader, "CostCentreID"); fields["AccountID"] = DbMgr.CreateIntFieldEntry(_obj.AccountID); //GetInt32(reader, "AccountID"); fields["TaxExclusiveAmount"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxExclusiveAmount); //GetDouble(reader, "TaxExclusiveAmount"); fields["JournalRecordID"] = DbMgr.CreateIntFieldEntry(_obj.JournalRecordID); //GetInt32(reader, "JournalRecordID"); fields["JournalTypeID"] = DbMgr.CreateStringFieldEntry(_obj.JournalTypeID); //GetString(reader, "JournalTypeID"); return(fields); }
public override Dictionary <string, DbFieldEntry> GetFields(Account _obj) { Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>(); fields["AccountID"] = DbMgr.CreateAutoIntFieldEntry(_obj.AccountID); fields["AccountName"] = DbMgr.CreateStringFieldEntry(_obj.AccountName); fields["AccountNumber"] = DbMgr.CreateStringFieldEntry(_obj.AccountNumber); fields["IsInactive"] = DbMgr.CreateStringFieldEntry(_obj.IsInactive); fields["ParentAccountID"] = DbMgr.CreateIntFieldEntry(_obj.ParentAccountID); fields["AccountClassificationID"] = DbMgr.CreateStringFieldEntry(_obj.AccountClassificationID); fields["AccountLevel"] = DbMgr.CreateIntFieldEntry(_obj.AccountLevel); fields["SubAccountClassificationID"] = DbMgr.CreateStringFieldEntry(_obj.SubAccountClassificationID); fields["TaxCodeID"] = DbMgr.CreateIntFieldEntry(_obj.TaxCodeID); fields["CurrencyID"] = DbMgr.CreateIntFieldEntry(_obj.CurrencyID); fields["AccountTypeID"] = DbMgr.CreateStringFieldEntry(_obj.AccountTypeID); fields["CurrentAccountBalance"] = DbMgr.CreateDoubleFieldEntry(_obj.CurrentAccountBalance); fields["CashFlowClassificationID"] = DbMgr.CreateStringFieldEntry(_obj.CashFlowClassificationID); fields["AccountDescription"] = DbMgr.CreateStringFieldEntry(_obj.AccountDescription); fields["LastChequeNumber"] = DbMgr.CreateStringFieldEntry(_obj.LastChequeNumber); fields["CurrencyExchangeAccountID"] = DbMgr.CreateIntFieldEntry(_obj.CurrencyExchangeAccountID); fields["IsReconciled"] = DbMgr.CreateStringFieldEntry(_obj.IsReconciled); fields["LastReconciledDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.LastReconciledDate); fields["StatementBalance"] = DbMgr.CreateDoubleFieldEntry(_obj.StatementBalance); fields["IsCreditBalance"] = DbMgr.CreateStringFieldEntry(_obj.IsCreditBalance); fields["OpeningAccountBalance"] = DbMgr.CreateDoubleFieldEntry(_obj.OpeningAccountBalance); fields["PreLastYearActivity"] = DbMgr.CreateDoubleFieldEntry(_obj.PreLastYearActivity); fields["LastYearOpeningBalance"] = DbMgr.CreateDoubleFieldEntry(_obj.LastYearOpeningBalance); fields["ThisYearOpeningBalance"] = DbMgr.CreateDoubleFieldEntry(_obj.ThisYearOpeningBalance); fields["PostThisYearActivity"] = DbMgr.CreateDoubleFieldEntry(_obj.PostThisYearActivity); fields["IsTotal"] = DbMgr.CreateStringFieldEntry(_obj.IsTotal); fields["BSBCode"] = DbMgr.CreateStringFieldEntry(_obj.BSBCode); fields["BankAccountNumber"] = DbMgr.CreateStringFieldEntry(_obj.BankAccountNumber); fields["BankAccountName"] = DbMgr.CreateStringFieldEntry(_obj.BankAccountName); fields["CompanyTradingName"] = DbMgr.CreateStringFieldEntry(_obj.CompanyTradingName); fields["CreateBankFiles"] = DbMgr.CreateStringFieldEntry(_obj.CreateBankFiles); fields["BankCode"] = DbMgr.CreateStringFieldEntry(_obj.BankCode); fields["DirectEntryUserID"] = DbMgr.CreateStringFieldEntry(_obj.DirectEntryUserID); fields["IsSelfBalancing"] = DbMgr.CreateStringFieldEntry(_obj.IsSelfBalancing); //fields["StatementParticulars"] = new StringFieldEntry(_obj.StatementParticulars); //fields["StatementCode"] = new StringFieldEntry(_obj.StatementCode); //fields["StatementReference"] = new StringFieldEntry(_obj.StatementReference); //fields["AccountantLinkCode"] = DbMgr.CreateStringFieldEntry(_obj.AccountantLinkCode); return(fields); }
public override Dictionary <string, DbFieldEntry> GetFields(BankDeposit _obj) { Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>(); fields["AmountDeposited"] = DbMgr.CreateDoubleFieldEntry(_obj.AmountDeposited); //GetDouble(reader, "AmountDeposited"); fields["BankDepositID"] = DbMgr.CreateAutoIntFieldEntry(_obj.BankDepositID); //GetInt32(reader, "BankDepositID"); fields["BankDepositNumber"] = DbMgr.CreateStringFieldEntry(_obj.BankDepositNumber); //GetString(reader, "BankDepositNumber"); 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["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["RecipientAccountID"] = DbMgr.CreateIntFieldEntry(_obj.RecipientAccountID); //GetInt32(reader, "RecipientAccountID"); fields["TransactionExchangeRate"] = DbMgr.CreateDoubleFieldEntry(_obj.TransactionExchangeRate); //GetDouble(reader, "TransactionExchangeRate"); return(fields); }
public override Dictionary <string, DbFieldEntry> GetFields(JobJournalRecord _obj) { Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>(); fields["JobJournalRecordID"] = DbMgr.CreateAutoIntFieldEntry(_obj.JobJournalRecordID); fields["JobID"] = DbMgr.CreateIntFieldEntry(_obj.JobID); fields["AccountID"] = DbMgr.CreateIntFieldEntry(_obj.AccountID); fields["JournalTypeID"] = DbMgr.CreateStringFieldEntry(_obj.JournalTypeID); fields["JournalRecordID"] = DbMgr.CreateIntFieldEntry(_obj.JournalRecordID); fields["SalePurchaseLineID"] = DbMgr.CreateIntFieldEntry(_obj.SalePurchaseLineID); fields["TaxExclusiveAmount"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxExclusiveAmount); fields["TransactionNumber"] = DbMgr.CreateStringFieldEntry(_obj.TransactionNumber); fields["IsThirteenthPeriod"] = DbMgr.CreateStringFieldEntry(_obj.IsThirteenthPeriod); fields["IsReimbursed"] = DbMgr.CreateStringFieldEntry(_obj.IsReimbursed); fields["TransactionDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.TransactionDate); fields["Date"] = DbMgr.CreateDateTimeFieldEntry(_obj.TransactionDate); return(fields); }
public override Dictionary <string, DbFieldEntry> GetFields(ElectronicPayment _obj) { Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>(); fields["CurrencyID"] = DbMgr.CreateIntFieldEntry(_obj.CurrencyID); //GetInt32(reader, ""); fields["TransactionDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.TransactionDate); //GetDateTime(reader, ""); fields["Date"] = DbMgr.CreateDateTimeFieldEntry(_obj.Date); //fields[""]=DbMgr.CreateIntFieldEntry(_obj.TransactionDate; fields["ElectronicPaymentID"] = DbMgr.CreateAutoIntFieldEntry(_obj.ElectronicPaymentID); //GetInt32(reader, ""); fields["IssuingAccountID"] = DbMgr.CreateIntFieldEntry(_obj.IssuingAccountID); //GetInt32(reader, ""); fields["IsTaxInclusive"] = DbMgr.CreateStringFieldEntry(_obj.IsTaxInclusive); //GetString(reader, ""); fields["IsThirteenthPeriod"] = DbMgr.CreateStringFieldEntry(_obj.IsThirteenthPeriod); //GetString(reader, ""); fields["Memo"] = DbMgr.CreateStringFieldEntry(_obj.Memo); //GetString(reader, ""); fields["PaymentNumber"] = DbMgr.CreateStringFieldEntry(_obj.PaymentNumber); //GetString(reader, ""); fields["StatementText"] = DbMgr.CreateStringFieldEntry(_obj.StatementText); //GetString(reader, ""); fields["TotalPaymentAmount"] = DbMgr.CreateDoubleFieldEntry(_obj.TotalPaymentAmount); //GetDouble(reader, ""); fields["TransactionExchangeRate"] = DbMgr.CreateDoubleFieldEntry(_obj.TransactionExchangeRate); //GetDouble(reader, ""); return(fields); }
public override Dictionary <string, DbFieldEntry> GetFields(PayrollInformation _obj) { Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>(); fields["BaseHourlyWageID"] = DbMgr.CreateIntFieldEntry(_obj.BaseHourlyWageID); //GetInt32(reader, "BaseHourlyWageID"); fields["BaseSalaryWageID"] = DbMgr.CreateIntFieldEntry(_obj.BaseSalaryWageID); //GetInt32(reader, "BaseSalaryWageID"); fields["CurrentPayrollYear"] = DbMgr.CreateIntFieldEntry(_obj.CurrentPayrollYear); //GetInt32(reader, "CurrentPayrollYear"); fields["DefaultSuperannuationFundID"] = DbMgr.CreateIntFieldEntry(_obj.DefaultSuperannuationFundID); //GetInt32(reader, "DefaultSuperannuationFundID"); fields["HoursInWorkWeek"] = DbMgr.CreateDoubleFieldEntry(_obj.HoursInWorkWeek); //GetDouble(reader, "HoursInWorkWeek"); fields["IncludeTimeBillingInTimesheets"] = DbMgr.CreateStringFieldEntry(_obj.IncludeTimeBillingInTimesheets); //GetString(reader, "IncludeTimeBillingInTimesheets"); fields["PayrollInformationID"] = DbMgr.CreateAutoIntFieldEntry(_obj.PayrollInformationID); //GetInt32(reader, "PayrollInformationID"); fields["RoundNetPayTo"] = DbMgr.CreateIntFieldEntry(_obj.RoundNetPayTo); //GetInt32(reader, "RoundNetPayTo"); fields["TaxTableRevisionDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.TaxTableRevisionDate); //GetDateTime(reader, "TaxTableRevisionDate"); fields["TimesheetWeekStartID"] = DbMgr.CreateStringFieldEntry(_obj.TimesheetWeekStartID); //GetString(reader, "TimesheetWeekStartID"); fields["UseTimesheets"] = DbMgr.CreateStringFieldEntry(_obj.UseTimesheets); //GetString(reader, "UseTimesheets"); fields["WithholderPayerNumber"] = DbMgr.CreateStringFieldEntry(_obj.WithholderPayerNumber); //GetString(reader, "WithholderPayerNumber"); return(fields); }
public override Dictionary <string, DbFieldEntry> GetFields(RecurringSale _obj) { Dictionary <string, DbFieldEntry> fields = GetRecurringEntityFields(_obj); fields["RecurringSaleID"] = DbMgr.CreateAutoIntFieldEntry(_obj.RecurringSaleID); fields["InvoiceNumber"] = DbMgr.CreateStringFieldEntry(_obj.InvoiceNumber); fields["CardRecordID"] = DbMgr.CreateIntFieldEntry(_obj.CardRecordID); fields["CustomerPONumber"] = DbMgr.CreateStringFieldEntry(_obj.CustomerPONumber); fields["IsHistorical"] = DbMgr.CreateStringFieldEntry(_obj.IsHistorical); fields["Date"] = DbMgr.CreateDateTimeFieldEntry(_obj.Date); fields["InvoiceDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.InvoiceDate); fields["IsThirteenthPeriod"] = DbMgr.CreateStringFieldEntry(_obj.IsThirteenthPeriod); 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["InvoiceTypeID"] = DbMgr.CreateStringFieldEntry(_obj.InvoiceTypeID); fields["InvoiceStatusID"] = DbMgr.CreateStringFieldEntry(_obj.InvoiceStatusID); fields["TermsID"] = DbMgr.CreateIntFieldEntry(_obj.TermsID); fields["TotalLines"] = DbMgr.CreateDoubleFieldEntry(_obj.TotalLines); fields["TaxExclusiveFreight"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxExclusiveFreight); fields["TaxInclusiveFreight"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxInclusiveFreight); fields["FreightTaxCodeID"] = DbMgr.CreateIntFieldEntry(_obj.FreightTaxCodeID); fields["TotalTax"] = DbMgr.CreateDoubleFieldEntry(_obj.TotalTax); fields["TotalPaid"] = DbMgr.CreateDoubleFieldEntry(_obj.TotalPaid); fields["TotalCredits"] = DbMgr.CreateDoubleFieldEntry(_obj.TotalCredits); fields["TotalDeposits"] = DbMgr.CreateDoubleFieldEntry(_obj.TotalDeposits); fields["TotalDiscounts"] = DbMgr.CreateDoubleFieldEntry(_obj.TotalDiscounts); fields["OutstandingBalance"] = DbMgr.CreateDoubleFieldEntry(_obj.OutstandingBalance); fields["SalesPersonID"] = DbMgr.CreateIntFieldEntry(_obj.SalesPersonID); fields["Memo"] = DbMgr.CreateStringFieldEntry(_obj.Memo); fields["Comment"] = DbMgr.CreateStringFieldEntry(_obj.Comment); fields["ShippingMethodID"] = DbMgr.CreateIntFieldEntry(_obj.ShippingMethodID); fields["Date"] = DbMgr.CreateDateTimeFieldEntry(_obj.InvoiceDate); fields["ReferralSourceID"] = DbMgr.CreateIntFieldEntry(_obj.ReferralSourceID); fields["IsTaxInclusive"] = DbMgr.CreateStringFieldEntry(_obj.IsTaxInclusive); fields["InvoiceDeliveryID"] = DbMgr.CreateStringFieldEntry(_obj.InvoiceDeliveryID); fields["CurrencyID"] = DbMgr.CreateIntFieldEntry(_obj.CurrencyID); fields["CostCentreID"] = DbMgr.CreateIntFieldEntry(_obj.CostCentreID); return(fields); }
public override Dictionary <string, DbFieldEntry> GetFields(SupplierFinanceCharge _obj) { Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>(); fields["CardRecordID"] = DbMgr.CreateIntFieldEntry(_obj.CardRecordID); fields["CurrencyID"] = DbMgr.CreateIntFieldEntry(_obj.CurrencyID); fields["SupplierFinanceChargeID"] = DbMgr.CreateAutoIntFieldEntry(_obj.SupplierFinanceChargeID); fields["SupplierFinanceChargeNumber"] = DbMgr.CreateStringFieldEntry(_obj.SupplierFinanceChargeNumber); 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["LateChargesAccountID"] = DbMgr.CreateIntFieldEntry(_obj.LateChargesAccountID); fields["FinanceCharge"] = DbMgr.CreateDoubleFieldEntry(_obj.FinanceCharge); fields["TransactionExchangeRate"] = DbMgr.CreateDoubleFieldEntry(_obj.TransactionExchangeRate); return(fields); }
public override Dictionary <string, DbFieldEntry> GetFields(RecurringProfessionalSaleLine _obj) { Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>(); fields["RecurringProfessionalSaleLineID"] = DbMgr.CreateAutoIntFieldEntry(_obj.RecurringProfessionalSaleLineID); 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["AccountID"] = DbMgr.CreateIntFieldEntry(_obj.AccountID); fields["Description"] = 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); return(fields); }
public override Dictionary <string, DbFieldEntry> GetFields(CustomerDeposit _obj) { Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>(); fields["CardRecordID"] = DbMgr.CreateIntFieldEntry(_obj.CardRecordID); fields["CurrencyID"] = DbMgr.CreateIntFieldEntry(_obj.CurrencyID); fields["CustomerDepositID"] = DbMgr.CreateAutoIntFieldEntry(_obj.CustomerDepositID); fields["CustomerDepositNumber"] = DbMgr.CreateStringFieldEntry(_obj.CustomerDepositNumber); fields["CustomerDepositsAccountID"] = DbMgr.CreateIntFieldEntry(_obj.CustomerDepositsAccountID); fields["TransactionDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.TransactionDate); fields["Date"] = DbMgr.CreateDateTimeFieldEntry(_obj.Date); fields["DepositApplied"] = DbMgr.CreateDoubleFieldEntry(_obj.DepositApplied); 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["SaleID"] = DbMgr.CreateIntFieldEntry(_obj.SaleID); fields["TransactionExchangeRate"] = DbMgr.CreateDoubleFieldEntry(_obj.TransactionExchangeRate); return(fields); }
public override Dictionary <string, DbFieldEntry> GetFields(TransferMoney _obj) { Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>(); fields["TransferMoneyID"] = DbMgr.CreateAutoIntFieldEntry(_obj.TransferMoneyID); fields["FromAccountID"] = DbMgr.CreateIntFieldEntry(_obj.FromAccountID); fields["ToAccountID"] = DbMgr.CreateIntFieldEntry(_obj.ToAccountID); fields["TransferNumber"] = DbMgr.CreateStringFieldEntry(_obj.TransferNumber); fields["TransactionDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.TransactionDate); fields["Amount"] = DbMgr.CreateDoubleFieldEntry(_obj.Amount); fields["Memo"] = DbMgr.CreateStringFieldEntry(_obj.Memo); //fields["IsTransferredElectronically"]=new StringFieldEntry(_obj.IsTransferredElectronically); //fields["StatementText"]=new StringFieldEntry(_obj.StatementText); fields["IsTaxInclusive"] = DbMgr.CreateStringFieldEntry(_obj.IsTaxInclusive); fields["IsAutoRecorded"] = DbMgr.CreateStringFieldEntry(_obj.IsAutoRecorded); fields["CurrencyID"] = DbMgr.CreateIntFieldEntry(_obj.CurrencyID); fields["TransactionExchangeRate"] = DbMgr.CreateDoubleFieldEntry(_obj.TransactionExchangeRate); fields["CategoryID"] = DbMgr.CreateIntFieldEntry(_obj.CategoryID); //fields["CostCentreID"]=new IntFieldEntry(_obj.CostCentreID); return(fields); }
public override Dictionary <string, DbFieldEntry> GetFields(Job _obj) { Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>(); fields["JobID"] = DbMgr.CreateAutoIntFieldEntry(_obj.JobID); fields["ParentJobID"] = DbMgr.CreateIntFieldEntry(_obj.ParentJobID); fields["IsInactive"] = DbMgr.CreateStringFieldEntry(_obj.IsInactive); fields["JobName"] = DbMgr.CreateStringFieldEntry(_obj.JobName); fields["JobNumber"] = DbMgr.CreateStringFieldEntry(_obj.JobNumber); fields["IsHeader"] = DbMgr.CreateStringFieldEntry(_obj._IsHeader); fields["JobLevel"] = DbMgr.CreateIntFieldEntry(_obj.JobLevel); fields["IsTrackingReimburseable"] = DbMgr.CreateStringFieldEntry(_obj.IsTrackingReimburseable); fields["JobDescription"] = DbMgr.CreateStringFieldEntry(_obj.JobDescription); fields["ContactName"] = DbMgr.CreateStringFieldEntry(_obj.ContactName); fields["Manager"] = DbMgr.CreateStringFieldEntry(_obj.Manager); fields["PercentCompleted"] = DbMgr.CreateDoubleFieldEntry(_obj.PercentCompleted); fields["StartDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.StartDate); fields["FinishDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.FinishDate); fields["CustomerID"] = DbMgr.CreateIntFieldEntry(_obj.CustomerID); return(fields); }
public virtual Dictionary <string, DbFieldEntry> GetFields(RecurringEntity _obj) { Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>(); fields["AlertID"] = DbMgr.CreateStringFieldEntry(_obj.AlertID); //DbMgr.GetString(_reader, "AlertID"); fields["AlertTypeID"] = DbMgr.CreateStringFieldEntry(_obj.AlertTypeID); //DbMgr.GetString(_reader, "AlertTypeID"); fields["AlertUserID"] = DbMgr.CreateIntFieldEntry(_obj.AlertUserID); //DbMgr.GetInt32(_reader, "AlertUserID"); fields["AppliedNumber"] = DbMgr.CreateStringFieldEntry(_obj.AppliedNumber); //DbMgr.GetString(_reader, "AppliedNumber"); fields["ContinueUntil"] = DbMgr.CreateDateTimeFieldEntry(_obj.ContinueUntil); //DbMgr.GetDateTime(_reader, "ContinueUntil"); fields["DaysInAdvance"] = DbMgr.CreateIntFieldEntry(_obj.DaysInAdvance); //DbMgr.GetInt32(_reader, "DaysInAdvance"); fields["FrequencyID"] = DbMgr.CreateStringFieldEntry(_obj.FrequencyID); //DbMgr.GetString(_reader, "FrequencyID"); fields["LastPosted"] = DbMgr.CreateDateTimeFieldEntry(_obj.LastPosted); //DbMgr.GetDateTime(_reader, "LastPosted"); fields["NextDue"] = DbMgr.CreateDateTimeFieldEntry(_obj.NextDue); //DbMgr.GetDateTime(_reader, "NextDue"); fields["PerformTimes"] = DbMgr.CreateIntFieldEntry(_obj.PerformTimes); //DbMgr.GetInt32(_reader, "PerformTimes"); fields["RecurringName"] = DbMgr.CreateStringFieldEntry(_obj.RecurringName); //DbMgr.GetString(_reader, "RecurringName"); fields["RemainingTime"] = DbMgr.CreateIntFieldEntry(_obj.RemainingTime); //DbMgr.GetInt32(_reader, "RemainingTime"); fields["RepeatedOn"] = DbMgr.CreateDateTimeFieldEntry(_obj.RepeatedOn); //DbMgr.GetDateTime(_reader, "RepeatedOn"); fields["RetainChanges"] = DbMgr.CreateStringFieldEntry(_obj.RetainChanges); //DbMgr.GetString(_reader, "RetainChanges"); fields["ScheduleID"] = DbMgr.CreateStringFieldEntry(_obj.ScheduleID); //DbMgr.GetString(_reader, "ScheduleID"); fields["StartingOn"] = DbMgr.CreateDateTimeFieldEntry(_obj.StartingOn); //DbMgr.GetDateTime(_reader, "StartingOn"); return(fields); }
public override Dictionary <string, DbFieldEntry> GetFields(JournalRecord _obj) { Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>(); fields["JournalRecordID"] = DbMgr.CreateAutoIntFieldEntry(_obj.JournalRecordID); fields["RecordSessionDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.RecordSessionDate); fields["TransactionDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.TransactionDate); fields["DateReconciled"] = DbMgr.CreateDateTimeFieldEntry(_obj.DateReconciled); fields["JobID"] = DbMgr.CreateIntFieldEntry(_obj.JobID); fields["RecordSessionTime"] = DbMgr.CreateStringFieldEntry(_obj.RecordSessionTime); fields["UserID"] = DbMgr.CreateIntFieldEntry(_obj.UserID); fields["ReconciliationStatusID"] = DbMgr.CreateStringFieldEntry(_obj.ReconciliationStatusID); fields["IsExchangeConversion"] = DbMgr.CreateStringFieldEntry(_obj.IsExchangeConversion); fields["IsForeignTransaction"] = DbMgr.CreateStringFieldEntry(_obj.IsForeignTransaction); fields["EntryIsPurged"] = DbMgr.CreateStringFieldEntry(_obj.EntryIsPurged); fields["IsMultipleJob"] = DbMgr.CreateStringFieldEntry(_obj.IsMultipleJob); fields["TaxExclusiveAmount"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxExclusiveAmount); fields["AccountID"] = DbMgr.CreateIntFieldEntry(_obj.AccountID); fields["IsThirteenthPeriod"] = DbMgr.CreateStringFieldEntry(_obj.IsThirteenthPeriod); fields["SetID"] = DbMgr.CreateIntFieldEntry(_obj.SetID); fields["LineNumber"] = DbMgr.CreateIntFieldEntry(_obj.LineNumber); return(fields); }
public override Dictionary <string, DbFieldEntry> GetFields(CreditRefund _obj) { Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>(); fields["AmountRefunded"] = DbMgr.CreateDoubleFieldEntry(_obj.AmountRefunded); // = GetDouble(reader, ""); fields["CardRecordID"] = DbMgr.CreateIntFieldEntry(_obj.CardRecordID); // = GetInt32(reader, ""); fields["ChequeNumber"] = DbMgr.CreateStringFieldEntry(_obj.ChequeNumber); // = GetString(reader, ""); fields["CreditNoteID"] = DbMgr.CreateIntFieldEntry(_obj.CreditNoteID); // = GetInt32(reader, ""); fields["CreditRefundID"] = DbMgr.CreateAutoIntFieldEntry(_obj.CreditRefundID); // = GetInt32(reader, ""); fields["CurrencyID"] = DbMgr.CreateIntFieldEntry(_obj.CurrencyID); // = GetInt32(reader, ""); fields["TransactionDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.TransactionDate); // = GetDateTime(reader, ""); fields["Date"] = DbMgr.CreateDateTimeFieldEntry(_obj.Date); // = fields[""]=DbMgr.CreateStringFieldEntry(_obj.TransactionDate; fields["ExchangeGainLoss"] = DbMgr.CreateDoubleFieldEntry(_obj.ExchangeGainLoss); // = GetDouble(reader, ""); fields["IsPrinted"] = DbMgr.CreateStringFieldEntry(_obj.IsPrinted); // = GetString(reader, ""); fields["IssuingAccountID"] = DbMgr.CreateIntFieldEntry(_obj.IssuingAccountID); // = GetInt32(reader, ""); fields["IsTaxInclusive"] = DbMgr.CreateStringFieldEntry(_obj.IsTaxInclusive); // = GetString(reader, ""); fields["IsThirteenthPeriod"] = DbMgr.CreateStringFieldEntry(_obj.IsThirteenthPeriod); // = GetString(reader, ""); fields["Memo"] = DbMgr.CreateStringFieldEntry(_obj.Memo); // = GetString(reader, ""); fields["Payee"] = DbMgr.CreateStringFieldEntry(_obj.Payee); // = GetString(reader, ""); fields["PaymentDeliveryID"] = DbMgr.CreateStringFieldEntry(_obj.PaymentDeliveryID); // = GetString(reader, ""); fields["TransactionExchangeRate"] = DbMgr.CreateDoubleFieldEntry(_obj.TransactionExchangeRate); // = GetDouble(reader, ""); return(fields); }