private DbUpdateStatement GetQuery_UpdateQuery(RecurringGeneralJournalLine _obj) { return(DbMgr.CreateUpdateClause("RecurringGeneralJournalLines", GetFields(_obj), "RecurringGeneralJournalLineID", _obj.RecurringGeneralJournalLineID)); }
private DbInsertStatement GetQuery_InsertQuery(CostCentreJournalRecord _obj) { Dictionary <string, DbFieldEntry> fields = GetFields(_obj); return(DbMgr.CreateInsertClause("CostCentreJournalRecords", fields)); }
private DbInsertStatement GetQuery_InsertQuery(ContributionType _obj) { Dictionary <string, DbFieldEntry> fields = GetFields(_obj); return(DbMgr.CreateInsertClause("ContributionTypes", fields)); }
private DbInsertStatement GetQuery_InsertQuery(TransferMoney _obj) { Dictionary <string, DbFieldEntry> fields = GetFields(_obj); return(DbMgr.CreateInsertClause("TransferMoney", fields)); }
private DbInsertStatement GetQuery_InsertQuery(CustomerPaymentLine _obj) { Dictionary <string, DbFieldEntry> fields = GetFields(_obj); return(DbMgr.CreateInsertClause("CustomerPaymentLines", fields)); }
private DbUpdateStatement GetQuery_UpdateQuery(Frequency _obj) { return(DbMgr.CreateUpdateClause("Frequencies", GetFields(_obj), "FrequencyID", _obj.FrequencyID)); }
private DbInsertStatement GetQuery_InsertQuery(Gender _obj) { Dictionary <string, DbFieldEntry> fields = GetFields(_obj); return(DbMgr.CreateInsertClause("Gender", fields)); }
private DbUpdateStatement GetQuery_UpdateQuery(Sale _obj) { return(DbMgr.CreateUpdateClause("Sales", GetFields(_obj), "SaleID", _obj.SaleID)); }
private DbSelectStatement GetQuery_SelectAll() { DbSelectStatement clause = DbMgr.CreateSelectClause(); return(clause.SelectAll().From("ProfessionalSaleLines")); }
private DbUpdateStatement GetQuery_UpdateQuery(SupplierFinanceCharge _obj) { return(DbMgr.CreateUpdateClause("SupplierFinanceCharges", GetFields(_obj), "SupplierFinanceChargeID", _obj.SupplierFinanceChargeID)); }
protected override void CreateTableCommands() //Sales() { Dictionary <string, DbManager.FIELDTYPE> fields = new Dictionary <string, DbManager.FIELDTYPE>(); Dictionary <string, string> foreignKeys = new Dictionary <string, string>(); fields["SaleID"] = DbManager.FIELDTYPE.INTEGER_INDEXED; fields["CardRecordID"] = DbManager.FIELDTYPE.INTEGER; fields["InvoiceNumber"] = DbManager.FIELDTYPE.VARCHAR_8; fields["CustomerPONumber"] = DbManager.FIELDTYPE.VARCHAR_20; fields["IsHistorical"] = DbManager.FIELDTYPE.VARCHAR_1; fields["BackorderSaleID"] = DbManager.FIELDTYPE.INTEGER; fields["Date"] = DbManager.FIELDTYPE.DATETIME; fields["InvoiceDate"] = DbManager.FIELDTYPE.DATETIME; fields["IsThirteenthPeriod"] = DbManager.FIELDTYPE.VARCHAR_1; fields["ShipToAddress"] = DbManager.FIELDTYPE.VARCHAR_255; fields["ShipToAddressLine1"] = DbManager.FIELDTYPE.VARCHAR_255; fields["ShipToAddressLine2"] = DbManager.FIELDTYPE.VARCHAR_255; fields["ShipToAddressLine3"] = DbManager.FIELDTYPE.VARCHAR_255; fields["ShipToAddressLine4"] = DbManager.FIELDTYPE.VARCHAR_255; fields["InvoiceTypeID"] = DbManager.FIELDTYPE.VARCHAR_1; fields["InvoiceStatusID"] = DbManager.FIELDTYPE.VARCHAR_2; fields["TermsID"] = DbManager.FIELDTYPE.INTEGER; fields["TotalLines"] = DbManager.FIELDTYPE.DOUBLE; fields["TaxExclusiveFreight"] = DbManager.FIELDTYPE.DOUBLE; fields["TaxInclusiveFreight"] = DbManager.FIELDTYPE.DOUBLE; fields["FreightTaxCodeID"] = DbManager.FIELDTYPE.INTEGER; fields["TotalTax"] = DbManager.FIELDTYPE.DOUBLE; fields["TotalPaid"] = DbManager.FIELDTYPE.DOUBLE; fields["TotalDeposits"] = DbManager.FIELDTYPE.DOUBLE; fields["TotalCredits"] = DbManager.FIELDTYPE.DOUBLE; fields["TotalDiscounts"] = DbManager.FIELDTYPE.DOUBLE; fields["OutstandingBalance"] = DbManager.FIELDTYPE.DOUBLE; fields["SalesPersonID"] = DbManager.FIELDTYPE.INTEGER; fields["Memo"] = DbManager.FIELDTYPE.VARCHAR_255; fields["Comment"] = DbManager.FIELDTYPE.VARCHAR_255; fields["ShippingMethodID"] = DbManager.FIELDTYPE.INTEGER; fields["PromisedDate"] = DbManager.FIELDTYPE.DATETIME; fields["ReferralSourceID"] = DbManager.FIELDTYPE.INTEGER; fields["IsAutoRecorded"] = DbManager.FIELDTYPE.VARCHAR_1; fields["IsPrinted"] = DbManager.FIELDTYPE.VARCHAR_1; fields["InvoiceDeliveryID"] = DbManager.FIELDTYPE.VARCHAR_1; fields["DaysTillPaid"] = DbManager.FIELDTYPE.INTEGER; fields["CurrencyID"] = DbManager.FIELDTYPE.INTEGER; fields["TransactionExchangeRate"] = DbManager.FIELDTYPE.DOUBLE; fields["CategoryID"] = DbManager.FIELDTYPE.INTEGER; fields["LinesPurged"] = DbManager.FIELDTYPE.VARCHAR_1; fields["PreAuditTrail"] = DbManager.FIELDTYPE.VARCHAR_1; fields["IsTaxInclusive"] = DbManager.FIELDTYPE.VARCHAR_1; fields["DestinationCountry"] = DbManager.FIELDTYPE.VARCHAR_256; /* * foreignKeys["CardRecordId"] = "Cards(CardRecordId)"; * foreignKeys["CardRecordId"] = "Customers(CardRecordId)"; * foreignKeys["InvoiceTypeID"] = "InvoiceType(InvoiceTypeID)"; * foreignKeys["InvoiceStatusID"] = "Status(InvoiceStatusID)"; * foreignKeys["TermsID"] = "Terms(TermsID)"; * foreignKeys["SalespersonID"] = "Cards(SalespersonID)"; * foreignKeys["SalespersonID"] = "Employees(SalespersonID)"; * foreignKeys["ReferralSourceID"] = "ReferralSources(ReferralSourceID)"; * foreignKeys["TaxCodeID"] = "TaxCodes(TaxCodeID)"; * foreignKeys["InvoiceDeliveryID"] = "InvoiceDelivery(InvoiceDeliveryID)"; * foreignKeys["CurrencyID"] = "Currency(CurrencyID)"; * foreignKeys["CategoryID"] = "Categories(CategoryID)"; * */ TableCommands["Sales"] = DbMgr.CreateTableCommand("Sales", fields, "SaleID", foreignKeys); }
private DbInsertStatement GetQuery_InsertQuery(SupplierFinanceCharge _obj) { Dictionary <string, DbFieldEntry> fields = GetFields(_obj); return(DbMgr.CreateInsertClause("SupplierFinanceCharges", fields)); }
private DbSelectStatement GetQuery_SelectAll() { DbSelectStatement clause = DbMgr.CreateSelectClause(); return(clause.SelectAll().From("BankingDetails")); }
private DbUpdateStatement GetQuery_UpdateQuery(Config _obj) { return(DbMgr.CreateUpdateClause("Configs", GetFields(_obj), "ConfigID", _obj.ConfigID)); }
private DbUpdateStatement GetQuery_UpdateQuery(MoneySpent _obj) { return(DbMgr.CreateUpdateClause("MoneySpent", GetFields(_obj), "MoneySpentID", _obj.MoneySpentID)); }
public override string ToString() { StringBuilder sb = new StringBuilder(); if (mSelectCount) { sb.Append("SELECT COUNT(*)"); } else { if (mColumns == null) { sb.Append("SELECT *"); } else { sb.Append("SELECT"); if (mSelectDistinct) { sb.Append(" DISTINCT"); } for (int i = 0; i != mColumns.Count; ++i) { if (i == 0) { sb.AppendFormat(" {0}", mColumns[i]); } else { sb.AppendFormat(", {0}", mColumns[i]); } } } } for (int i = 0; i != mTables.Count; ++i) { if (i == 0) { sb.AppendFormat(" FROM {0}", DbMgr.FieldAlias(mTables[i])); } else { sb.AppendFormat(", {0}", DbMgr.FieldAlias(mTables[i])); } } string where_text = WhereText; if (where_text != "") { sb.AppendFormat(" WHERE {0}", where_text); } for (int i = 0; i != mOrders.Count; ++i) { if (i == 0) { sb.AppendFormat(" ORDER BY {0}", mOrders[i]); } else { sb.AppendFormat(" AND {0}", mOrders[i]); } } //sb.Append(";"); return(sb.ToString()); }
private DbInsertStatement GetQuery_InsertQuery(Frequency _obj) { Dictionary <string, DbFieldEntry> fields = GetFields(_obj); return(DbMgr.CreateInsertClause("Frequencies", fields)); }
public DbSelectStatement SelectCurrencyColumn(params string[] values) { mColumns.Add(DbMgr.CreateCurrencyColumn(values)); return(this); }
private DbSelectStatement GetQuery_SelectAll() { DbSelectStatement clause = DbMgr.CreateSelectClause(); return(clause.SelectAll().From("ContributionTypes")); }
private DbUpdateStatement GetQuery_UpdateQuery(LinkedAccount _obj) { return(DbMgr.CreateUpdateClause("LinkedAccounts", GetFields(_obj), "LinkedAccountID", _obj.LinkedAccountID)); }
private DbUpdateStatement GetQuery_UpdateQuery(Gender _obj) { return(DbMgr.CreateUpdateClause("Gender", GetFields(_obj), "GenderID", _obj.GenderID)); }
private DbInsertStatement GetQuery_InsertQuery(AccountBudget _obj) { Dictionary <string, DbFieldEntry> fields = GetFields(_obj); return(DbMgr.CreateInsertClause("AccountBudgets", fields)); }
private DbUpdateStatement GetQuery_UpdateQuery(TransferMoney _obj) { return(DbMgr.CreateUpdateClause("TransferMoney", GetFields(_obj), "TransferMoneyID", _obj.TransferMoneyID)); }
private DbUpdateStatement GetQuery_UpdateQuery(AccountBudget _obj) { return(DbMgr.CreateUpdateClause("AccountBudgets", GetFields(_obj), "AccountBudgetID", _obj.AccountBudgetID)); }
private DbUpdateStatement GetQuery_UpdateQuery(CustomerPaymentLine _obj) { return(DbMgr.CreateUpdateClause("CustomerPaymentLines", GetFields(_obj), "CustomerPaymentLineID", _obj.CustomerPaymentLineID)); }
private DbInsertStatement GetQuery_InsertQuery(TaxInformation _obj) { Dictionary <string, DbFieldEntry> fields = GetFields(_obj); return(DbMgr.CreateInsertClause("TaxInformation", fields)); }
private DbUpdateStatement GetQuery_UpdateQuery(CostCentreJournalRecord _obj) { return(DbMgr.CreateUpdateClause("CostCentreJournalRecords", GetFields(_obj), "CostCentreJournalRecordID", _obj.CostCentreJournalRecordID)); }
private DbUpdateStatement GetQuery_UpdateQuery(TaxInformation _obj) { return(DbMgr.CreateUpdateClause("TaxInformation", GetFields(_obj), "TaxInformationID", _obj.TaxInformationID)); }
private DbUpdateStatement GetQuery_UpdateQuery(ContributionType _obj) { return(DbMgr.CreateUpdateClause("ContributionTypes", GetFields(_obj), "ContributionTypeID", _obj.ContributionTypeID)); }
private DbInsertStatement GetQuery_InsertQuery(RecurringGeneralJournalLine _obj) { Dictionary <string, DbFieldEntry> fields = GetFields(_obj); return(DbMgr.CreateInsertClause("RecurringGeneralJournalLines", fields)); }