public string GetDataType(string DSname, EntityField fld)
{
string retval = null;
IDataSource ds;
try
{
if (DSname != null)
{
ds = DMEEditor.GetDataSource(DSname);
if (DMEEditor.ConfigEditor.DataTypesMap == null)
{
DMEEditor.ConfigEditor.ReadDataTypeFile();
}
if (!fld.fieldtype.Contains("System."))
{
retval = GetFieldTypeWoConversion(DSname, fld);
}
else
{
AssemblyClassDefinition classhandler = DMEEditor.GetDataSourceClass(DSname);
if (classhandler != null)
{
DatatypeMapping dt = null;
if (fld.fieldtype.Equals("System.String", StringComparison.OrdinalIgnoreCase)) //-- Fist Check all Data field that Contain Length
{
if (fld.Size1 > 0) //-- String Type first
{
dt = DMEEditor.ConfigEditor.DataTypesMap.Where(x => x.DataSourceName.Equals(classhandler.className, StringComparison.OrdinalIgnoreCase) && x.NetDataType.Equals(fld.fieldtype, StringComparison.OrdinalIgnoreCase) && x.DataType.Contains("N")).FirstOrDefault();
if (dt != null)
{
retval = dt.DataType.Replace("(N)", "(" + fld.Size1.ToString() + ")");
}
}
else
{
dt = DMEEditor.ConfigEditor.DataTypesMap.Where(x => x.DataSourceName.Equals(classhandler.className, StringComparison.OrdinalIgnoreCase) && x.NetDataType.Equals(fld.fieldtype, StringComparison.OrdinalIgnoreCase)).FirstOrDefault();
retval = dt.DataType;
}
}
else
if (!fld.fieldtype.Equals("System.DateTime", StringComparison.OrdinalIgnoreCase))
{
if (fld.fieldtype.Equals("System.Decimal", StringComparison.OrdinalIgnoreCase))
{
if (fld.NumericPrecision == 0)
{
fld.NumericPrecision = 28;
}
if (fld.NumericScale == 0)
{
fld.NumericScale = 8;
}
}
if (fld.NumericPrecision > 0)
{
if (fld.NumericScale > 0)
{
dt = DMEEditor.ConfigEditor.DataTypesMap.Where(x => x.DataSourceName.Equals(classhandler.className, StringComparison.OrdinalIgnoreCase) && x.NetDataType.Equals(fld.fieldtype, StringComparison.OrdinalIgnoreCase) && x.DataType.Contains("P,S")).FirstOrDefault();
if (dt != null)
{
retval = dt.DataType.Replace("(P,S)", "(" + fld.NumericPrecision.ToString() + "," + fld.NumericScale.ToString() + ")");
}
}
else
{
dt = DMEEditor.ConfigEditor.DataTypesMap.Where(x => x.DataSourceName.Equals(classhandler.className, StringComparison.OrdinalIgnoreCase) && x.NetDataType.Equals(fld.fieldtype, StringComparison.OrdinalIgnoreCase) && x.DataType.Contains("(N)")).FirstOrDefault();
if (dt != null)
{
retval = dt.DataType.Replace("(N)", "(" + fld.NumericPrecision.ToString() + ")");
}
else
{
dt = DMEEditor.ConfigEditor.DataTypesMap.Where(x => x.DataSourceName.Equals(classhandler.className, StringComparison.OrdinalIgnoreCase) && x.NetDataType.Equals(fld.fieldtype, StringComparison.OrdinalIgnoreCase) && x.DataType.Contains("(P,S)")).FirstOrDefault();
}
if (dt != null)
{
retval = dt.DataType.Replace("(P,S)", "(" + fld.NumericPrecision.ToString() + "," + fld.NumericScale.ToString() + ")");
}
}
}
}
if (retval == null)
{
dt = DMEEditor.ConfigEditor.DataTypesMap.Where(x => x.DataSourceName.Equals(classhandler.className, StringComparison.OrdinalIgnoreCase) && x.NetDataType.Equals(fld.fieldtype, StringComparison.OrdinalIgnoreCase)).FirstOrDefault();
retval = dt.DataType;
}
}
else
{
DMEEditor.AddLogMessage("Fail", "Could not Find Class Handler " + fld.EntityName + "_" + fld.fieldname, DateTime.Now, -1, null, Errors.Failed);
}
}
}
else
{
DMEEditor.AddLogMessage("Fail", "Could not Convert Field Type to Provider Type " + fld.EntityName + "_" + fld.fieldname, DateTime.Now, -1, null, Errors.Failed);
}
}
catch (Exception ex)
{
string mes = "";
retval = null;
DMEEditor.AddLogMessage(ex.Message, "Could not Convert Field Type to Provider Type " + mes, DateTime.Now, -1, mes, Errors.Failed);
};
return(retval);
}
public string GetFieldTypeWoConversion(string DSname, EntityField fld)
{
string retval = null;
try
{
if (DSname != null)
{
if (DMEEditor.ConfigEditor.DataTypesMap == null)
{
DMEEditor.ConfigEditor.ReadDataTypeFile();
}
AssemblyClassDefinition classhandler = DMEEditor.GetDataSourceClass(DSname);
if (classhandler != null)
{
DatatypeMapping dt = null;
dt = DMEEditor.ConfigEditor.DataTypesMap.Where(x => x.DataSourceName == classhandler.className && x.DataType == fld.fieldtype && x.DataType.Contains("N")).FirstOrDefault();
if (dt != null)
{
retval = dt.DataType.Replace("(N)", "(" + fld.Size1.ToString() + ")");
}
if (fld.NumericPrecision > 0)
{
if (fld.NumericScale > 0)
{
dt = DMEEditor.ConfigEditor.DataTypesMap.Where(x => x.DataSourceName == classhandler.className && x.DataType == fld.fieldtype && x.DataType.Contains("N,S")).FirstOrDefault();
if (dt != null)
{
retval = dt.DataType.Replace("(N,S)", "(" + fld.NumericPrecision.ToString() + "," + fld.NumericScale.ToString() + ")");
}
}
else
{
dt = DMEEditor.ConfigEditor.DataTypesMap.Where(x => x.DataSourceName == classhandler.className && x.DataType == fld.fieldtype && x.DataType.Contains("(N)")).FirstOrDefault();
if (dt != null)
{
retval = dt.DataType.Replace("(N)", "(" + fld.NumericPrecision.ToString() + ")");
}
else
{
dt = DMEEditor.ConfigEditor.DataTypesMap.Where(x => x.DataSourceName == classhandler.className && x.DataType == fld.fieldtype && x.DataType.Contains("(N,S)")).FirstOrDefault();
}
if (dt != null)
{
retval = dt.DataType.Replace("(N,S)", "(" + fld.NumericPrecision.ToString() + ",0)");
}
}
}
if (retval == null)
{
dt = DMEEditor.ConfigEditor.DataTypesMap.Where(x => x.DataSourceName == classhandler.className && x.DataType == fld.fieldtype).FirstOrDefault();
retval = dt.DataType;
}
}
else
{
DMEEditor.AddLogMessage("Fail", "Could not Find Class Handler " + fld.EntityName + "_" + fld.fieldname, DateTime.Now, -1, null, Errors.Failed);
}
}
else
{
DMEEditor.AddLogMessage("Fail", "Could not Convert Field Type to Provider Type " + fld.EntityName + "_" + fld.fieldname, DateTime.Now, -1, null, Errors.Failed);
}
}
catch (Exception ex)
{
string mes = "";
retval = null;
DMEEditor.AddLogMessage(ex.Message, "Could not Convert Field Type to Provider Type " + mes, DateTime.Now, -1, mes, Errors.Failed);
};
return(retval);
}