public static string GenerateSQLinqField(Interfaces.IDatabaseField field, string tableName)
{
//linq_fields += this._field_list[i].Name + " = (string)(" + LinqAbbreviation(this._table_name) + "." + this._field_list[i].Name + " ?? \"\")";
string response = String.Empty;
switch (field.FieldType)
{
case DbType.String:
{
response = field.Name + " = (string)" + LinqAbbreviation(tableName) + "." + field.Name + @" ?? """"";
break;
}
case DbType.DateTime:
{
response = field.Name + " = (DateTime)" + LinqAbbreviation(tableName) + "." + field.Name;
break;
}
case DbType.Binary:
{
response = field.Name + " = (TimeSpan)" + LinqAbbreviation(tableName) + "." + field.Name;
break;
}
case DbType.Int32:
{
response = field.Name + " = (int)" + LinqAbbreviation(tableName) + "." + field.Name;
break;
}
case DbType.Int64:
{
response = field.Name + " = (long)" + LinqAbbreviation(tableName) + "." + field.Name;
break;
}
case DbType.Boolean:
{
response = field.Name + " = Convert.ToBoolean(" + LinqAbbreviation(tableName) + "." + field.Name + @")";
break;
}
case DbType.Decimal:
{
response = field.Name + " = (decimal)" + LinqAbbreviation(tableName) + "." + field.Name;
break;
}
case DbType.Double:
{
response = field.Name + " = (double)" + LinqAbbreviation(tableName) + "." + field.Name;
break;
}
}
return(response);
}
public static string GenerateInterfaceFieldProperty(Interfaces.IDatabaseField field)
{
string response = String.Empty;
switch (field.FieldType)
{
case DbType.String:
{
response = "string " + field.Name + "{get;set;}";
break;
}
case DbType.DateTime:
{
response = "DateTime? " + field.Name + "{get;set;}";
break;
}
case DbType.Binary:
{
response = "TimeSpan? " + field.Name + "{get;set;}";
break;
}
case DbType.Int32:
{
response = "int " + field.Name + "{get;set;}";
break;
}
case DbType.Int64:
{
response = "long " + field.Name + "{get;set;}";
break;
}
case DbType.Boolean:
{
response = "bool " + field.Name + "{get;set;}";
break;
}
case DbType.Decimal:
{
response = "decimal " + field.Name + "{get;set;}";
break;
}
case DbType.Double:
{
response = "double " + field.Name + "{get;set;}";
break;
}
}
return(response);
}
public static string GenerateReverseFieldAssignmentLeftSideNoCamelCase(Interfaces.IDatabaseField field, string recordName, string queryName)
{
string response = String.Empty;
switch (field.FieldType)
{
case DbType.String:
{
response = recordName + "." + field.Name + " = (string)" + queryName + "." + field.Name;
break;
}
case DbType.DateTime:
{
response = recordName + "." + field.Name + " = " + queryName + "." + field.Name;
break;
}
case DbType.Binary:
{
response = recordName + "." + field.Name + " = (TimeSpan)" + queryName + "." + field.Name;
break;
}
case DbType.Int32:
{
response = recordName + "." + field.Name + " = (int)" + queryName + "." + field.Name;
break;
}
case DbType.Int64:
{
response = recordName + "." + field.Name + " = (long)" + queryName + "." + field.Name;
break;
}
case DbType.Boolean:
{
response = recordName + "." + field.Name + " = Convert.ToBoolean(" + queryName + "." + field.Name;
break;
}
case DbType.Decimal:
{
response = recordName + "." + field.Name + " = (decimal)" + queryName + "." + field.Name;
break;
}
case DbType.Double:
{
response = recordName + "." + field.Name + " = (double)" + queryName + "." + field.Name;
break;
}
}
return(response);
}
public static string GenerateFieldAssignmentLeftSideNoCamelCase(Interfaces.IDatabaseField field, string recordName, string queryName)
{
string response = String.Empty;
switch (field.FieldType)
{
default:
{
response = recordName + "." + field.Name + " = " + queryName + "." + field.Name;
break;
}
}
return(response);
}