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));
}
