public MapPropertiesToDto(MyMeta.IColumn column, RequestContext context, string modelName, string dtoName) : this(column, context)
{
if (string.IsNullOrEmpty(modelName))
{
modelName = "model";
}
if (string.IsNullOrEmpty(dtoName))
{
dtoName = "dto";
}
this._dtoName = dtoName;
this._modelName = modelName;
}
public bool Equals(MyMeta.IColumn other)
{
throw new NotImplementedException();
}
public WcfPropertyRenderDto(MyMeta.IColumn column, RequestContext context)
: base(column, context)
{
}
public MapPropertiesToDto(MyMeta.IColumn column, RequestContext context)
: base(column, context)
{
}
public PropertyDecoratorBase(MyMeta.IColumn column, RequestContext context)
: base(column, context)
{
}
public RenderDataAnnotationsProperty(MyMeta.IColumn column, RequestContext context)
: base(column, context)
{
}
public string GetInputTypeByColumn(IColumn col)
{
if(col==null)
{
return "";
}
if (!col.IsInForeignKey)
{
return "";
}
foreach (IForeignKey obj in col.ForeignKeys)
{
foreach (IColumn frCol in obj.PrimaryColumns)
{
//System.Diagnostics.Debugger.Break();
if (col.Table.Name.Equals(frCol.Table.Name) && col.Name.Equals(frCol.Name))
{
//TODO: set input type
//return GetEditView(GetViewNameFromTable(frCol.Table)) + "Edit";
//or
continue;
}
return "Modal_" + GetEditView(GetViewNameFromTable(frCol.Table));
}
}
return "";
}
public bool ColumnDataTypeIsInt(IColumn col)
{
string dataType = GetColumnDataType(col);
return (dataType.Equals("INT") || dataType.Equals("INT UNSIGNED"));
}
public int GetColumnDataLengh(IColumn col)
{
string dataTypeNameComplete = col.DataTypeNameComplete;
string resultString = null;
try
{
resultString = Regex.Match(dataTypeNameComplete, @"\( *(\d+) *\)").Groups[1].Value;
return int.Parse(resultString);
}
catch (Exception ex)
{
if (ColumnDataTypeIsDateTime(col))
{
return 12;
}
else if (ColumnDataTypeIsText(col)||ColumnDataTypeIsMediumText(col))
{
return int.MaxValue;
}
else
{
return -1;
}
}
}
public string GetColumnDataType(IColumn column)
{
return column.DataTypeName;
}
public bool ColumnDataTypeIsVarchar(IColumn col)
{
return GetColumnDataType(col).Equals("VARCHAR");
}
public bool ColumnDataTypeIsText(IColumn col)
{
return GetColumnDataType(col).Equals("TEXT");
}
public bool ColumnDataTypeIsMediumText(IColumn col)
{
return GetColumnDataType(col).Equals("MEDIUMTEXT");
}
/// <summary>
/// This constructor takes the column and RequestContext.
/// </summary>
/// <param name="column"></param>
/// <param name="context"></param>
public BusinessObjectsPropertyRenderShortProperty(MyMeta.IColumn column, RequestContext context)
: base(column, context)
{
}
public TableJoinItem GetTableJoinItemByColumn(IColumn column)
{
if (column == null)
{
return null;
}
IList<string> columnforJoinList = DefaultColumnJointWithOtherTable;
if(columnforJoinList.Contains(column.Name.ToLower()))
{
return null;
}
TableJoinItem item = new TableJoinItem { TableAliasName = "", TableName = "", TitleName = "" , TableNameNoPrefix="", TitleAliasName=""};
if(column.IsInForeignKey)
{
foreach(IForeignKey foreColumn in column.ForeignKeys)
{
if(foreColumn.PrimaryColumns.Count>1)
{
continue;
}
foreach(IColumn frCol in foreColumn.PrimaryColumns)
{
if (column.Table.Name.Equals(frCol.Table.Name) && column.Name.Equals(frCol.Name))
{
continue;
}
string title = GetTitleFieldName(frCol.Table);
string tablealias = GetViewNameFromTable(frCol.Table)+"_al";
item.TitleAliasName = tablealias + "_" + title;
item.TitleName = title;
item.TableAliasName = tablealias;
item.TableName = frCol.Table.Name;
item.TableNameNoPrefix = "#__"+GetTableName(frCol.Table).ToLower();
item.PrimaryKey = frCol.Name;
//%>
//// Join over the <%=frCol.Table.Name%>
//$query->select('<%=tablealias%>.<%=titlealias%> AS <%=tablealias%>_<%=titlealias%>');
//$query->join('LEFT', '`#__<%=GetTableName(frCol.Table).ToLower()%>` AS <%=tablealias%> ON <%=tablealias%>.<%=frCol.Name%> = a.<%=column.Name%>');
//<%
return item;
}
}
}
return null;
}
/// <summary>
/// This constructor takes the column and RequestContext and a comma-delimited string of properties to omit.
/// </summary>
/// <param name="column">The IColumn variable</param>
/// <param name="context">The RequestContext</param>
/// <param name="omitList">The comma-delimited list of properties that will not be rendered.</param>
public BusinessObjectsPropertyRenderShortProperty(MyMeta.IColumn column, RequestContext context, string omitList)
: base(column, context)
{
this._omitList = omitList.ToLower().Split(',');
}
public bool ColumnDataTypeIsDateTime(IColumn col)
{
string dataType = GetColumnDataType(col);
return dataType.Equals("DATETIME") || dataType.Equals("TIMESTAMP");
}
