public bool IsString(DataJuggler.Net5.DataTable table, string fieldName)
{
// initial value
bool isString = false;
// Create Generic row
DataJuggler.Net5.DataRow row = new DataRow();
// Get the Index Of Fieldname
int Index = SQLDatabaseConnector.FindFieldIndex(table.ActiveFields, fieldName);
// If Index Was Found
if (Index >= 0)
{
// if this field is a string
if (table.ActiveFields[Index].DataType == DataManager.DataTypeEnum.String)
{
// Use Quotes For Strings
isString = true;
}
}
// return value
return(isString);
}
/// <summary>
/// Returns a valid sql statement to load an object from a table based upon the primary key.
/// This is for a single field primary key.
/// </summary>
/// <param name="table">DataJuggler.Net5.DataTable</param>
/// <param name="primaryKeyValue">A double value in where clause</param>
/// <returns>A valid sql statement if the table has a primary key</returns>
public string CreateSelectSQL(DataJuggler.Net5.DataTable table, double primaryKeyValue)
{
// Verify table Has A Primary Key
if (table.PrimaryKey != null)
{
return("void");
}
// Verify table Has A Primary Key
if (table.PrimaryKey.FieldName != null)
{
return("void");
}
// Create StringBuilder
StringBuilder sb = new StringBuilder("Select * From [");
// Append tableName
sb.Append(table.Name);
// Append Where
sb.Append("] Where ");
// Append PrimaryKey.fieldName
sb.Append(table.PrimaryKey.FieldName);
// Append =
sb.Append(" = ");
// Append Value
sb.Append(primaryKeyValue.ToString());
// return SelectSQL
return(sb.ToString());
}
/// <summary>
/// Creates A Valid sql Statement To Select All Records From A Given table
/// </summary>
/// <param name="table">table To Create sql Statement For</param>
/// <returns>sql Statement To Select All Records From A Given table</returns>
public string CreateSelectAllSQL(DataJuggler.Net5.DataTable dataTable)
{
// If tableName Is Null
if ((dataTable == null) || (dataTable.Name == null))
{
return("void");
}
StringBuilder sb = new StringBuilder();
// Create StringBuilder
string selectAllSQL = dataTable.SQLGenerator.CreateFieldList(dataTable, true);
// append
sb.Append(selectAllSQL);
// Append Open Brack
sb.Append(" From [");
// Append tableName
sb.Append(dataTable.Name);
// Append Where
sb.Append("]");
// return SelectSQL
return(sb.ToString());
}
public DataRow(DataJuggler.Net5.DataTable ParentDataTable)
{
// Set Parent table
this.ParentTable = ParentDataTable;
// Create Fields Collection
fields = new List <DataField>();
}
/// <summary>
/// Returns a valid sql statement to load an object from a table based upon a fieldName &
/// field value passed in. This method is for a single field >> value pair.
/// </summary>
/// <param name="fieldName">field name that where clause will include</param>
/// <param name="fieldValue">value in where clause</param>
/// <returns>A valid sql statement to select a row with a certain field, value</returns>
public string CreateSelectSQL(DataJuggler.Net5.DataTable table, string fieldName, string fieldValue)
{
// bool UseQuotes
bool UseQuotes = IsString(table, fieldName);
// If tableName Is Null
if (table.Name == null)
{
return("void");
}
// fieldValue Exists
if (fieldValue == null)
{
return("void");
}
// Verify fieldName Is Not Null
if (fieldName == null)
{
return("void");
}
// Create StringBuilder
StringBuilder sb = new StringBuilder("Select * From [");
// Append tableName
sb.Append(table.Name);
// Append Where
sb.Append("] Where ");
// Append field.fieldName
sb.Append(fieldName);
// Append =
sb.Append(" = ");
// If This Is A String
if (UseQuotes)
{
// Append Single Quote
sb.Append("'");
}
// Append Value
sb.Append(fieldValue);
// If This Is A String
if (UseQuotes)
{
// Append Single Quote
sb.Append("'");
}
// return SelectSQL
return(sb.ToString());
}
