/// <summary>
/// Initializes the mapping document.
/// </summary>
/// <param name="context">The context.</param>
protected override void InitializeMappingDocument(BusinessContext context)
{
InitializeMappingDocumentRequest request = ((InitializeMappingDocumentRequest)context.Request);
MetaClass metaClass = DataContext.Current.GetMetaClass(context.GetTargetMetaClassName());
List <PrimaryKeyId> primaryKeyIds = new List <PrimaryKeyId>();
// Create Default Mapping
MappingDocument retVal = new MappingDocument();
DataTable dataTable = request.Data.Tables[request.TableIndex];
MappingElement mapping = new MappingElement(dataTable.TableName, metaClass.Name);
retVal.Add(mapping);
MappingElementBuilder builder = new MappingElementBuilder(retVal);
//Call creation mapping document by saved patterns
DefaultMappingHelper.CreateMapingByPatternComparision(dataTable, metaClass, builder);
// Write Response
InitializeMappingDocumentResponse response = new InitializeMappingDocumentResponse();
response.MappingDocument = retVal;
context.SetResponse(response);
}
/// <summary>
/// Initializes the mapping document.
/// </summary>
/// <param name="context">The context.</param>
protected override void InitializeMappingDocument(BusinessContext context)
{
InitializeMappingDocumentRequest request = ((InitializeMappingDocumentRequest)context.Request);
MetaClass metaClass = DataContext.Current.GetMetaClass(context.GetTargetMetaClassName());
List<PrimaryKeyId> primaryKeyIds = new List<PrimaryKeyId>();
// Create Default Mapping
MappingDocument retVal = new MappingDocument();
DataTable dataTable = request.Data.Tables[request.TableIndex];
MappingElement mapping = new MappingElement(dataTable.TableName, metaClass.Name);
retVal.Add(mapping);
MappingElementBuilder builder = new MappingElementBuilder(retVal);
//Call creation mapping document by saved patterns
DefaultMappingHelper.CreateMapingByPatternComparision(dataTable, metaClass, builder);
// Write Response
InitializeMappingDocumentResponse response = new InitializeMappingDocumentResponse();
response.MappingDocument = retVal;
context.SetResponse(response);
}
/// <summary>
/// Creates the maping by friendly name comparison.
/// </summary>
/// <param name="column">The column.</param>
/// <param name="dstClass">The DST class.</param>
/// <param name="builder">The builder.</param>
public static void CreateMapingByFriendlyNameComparison(DataColumn column, MetaClass dstClass,
MappingElementBuilder builder)
{
if (column == null)
throw new ArgumentNullException("column");
if (dstClass == null)
throw new ArgumentNullException("dstClass");
if (builder == null)
throw new ArgumentNullException("builder");
FieldMathResult matchResult = CreateMapingByFriendlyNameComparison(column, dstClass, string.Empty, null, builder);
if (matchResult != null)
{
builder.AssignCopyValueRule(column.ColumnName, matchResult.Tag);
}
}
/// <summary>
/// Handles the SelectedIndexChanged event of the ddi control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param>
protected void ddi_SelectedIndexChanged(object sender, EventArgs e)
{
_ir = (ImportRequest)ViewState["_ir"];
if (_ir != null)
{
MappingElementBuilder meb = new MappingElementBuilder(_ir.MappingDocument);
DropDownList ddl = (DropDownList)sender;
DataGridItem dgi = (DataGridItem)ddl.NamingContainer;
DataGrid dg = (DataGrid)dgi.NamingContainer;
FillDefaultValues(dg, dgi);
_ir = (ImportRequest)ViewState["_ir"];
string mf = dgi.Cells[0].Text;
switch (ddl.SelectedValue)
{
case "-1":
meb.RemoveRuleByMetaField(mf);
break;
case "0":
MetaField field = FormController.GetMetaField(_className, mf);
MappingRule mr = meb.AssignDefaultValueRule(mf, field.DefaultValue);
if (field.IsEnum || field.IsReference)
{
DropDownList dd = (DropDownList)dgi.FindControl("ddColumn");
CHelper.SafeSelect(dd, mr.DefaultValue);
}
else
{
TextBox txt = (TextBox)dgi.FindControl("tbColumn");
if (txt != null)
{
txt.Text = mr.DefaultValue;
}
}
break;
default:
meb.AssignCopyValueRule(ddl.SelectedValue, mf);
break;
}
ViewState["_ir"] = _ir;
BindDG();
}
}
/// <summary>
/// Fills the default values for LIP.
/// </summary>
/// <param name="dg">The dg.</param>
/// <param name="excluded">The excluded.</param>
private void FillDefaultValues(DataGrid dg, DataGridItem excluded)
{
_ir = (ImportRequest)ViewState["_ir"];
MappingElementBuilder meb = new MappingElementBuilder(_ir.MappingDocument);
foreach (DataGridItem dgi in dg.Items)
{
if (excluded != null && excluded == dgi)
{
continue;
}
string mfName = dgi.Cells[0].Text;
MetaField field = FormController.GetMetaField(_className, mfName);
MappingRule mr = meb.GetRuleByMetaField(mfName);
if (mr != null && mr.RuleType == MappingRuleType.DefaultValue)
{
if (field.IsEnum || field.IsReference)
{
DropDownList dd = (DropDownList)dgi.FindControl("ddColumn");
if (dd != null && dd.SelectedValue != "-1")
{
meb.AssignDefaultValueRule(mfName, dd.SelectedValue);
}
}
else
{
TextBox txt = (TextBox)dgi.FindControl("tbColumn");
if (txt != null)
{
meb.AssignDefaultValueRule(mfName, txt.Text);
}
}
}
}
ViewState["_ir"] = _ir;
}
/// <summary>
/// Creates the maping by friendly name comparison.
/// </summary>
/// <param name="column">The column.</param>
/// <param name="dstClass">The DST class.</param>
/// <param name="builder">The builder.</param>
public static void CreateMapingByFriendlyNameComparison(DataColumn column, MetaClass dstClass,
MappingElementBuilder builder)
{
if (column == null)
{
throw new ArgumentNullException("column");
}
if (dstClass == null)
{
throw new ArgumentNullException("dstClass");
}
if (builder == null)
{
throw new ArgumentNullException("builder");
}
FieldMathResult matchResult = CreateMapingByFriendlyNameComparison(column, dstClass, string.Empty, null, builder);
if (matchResult != null)
{
builder.AssignCopyValueRule(column.ColumnName, matchResult.Tag);
}
}
/// <summary>
/// Gets the mapping source.
/// </summary>
/// <returns></returns>
private DataTable GetMappingSource()
{
if (ViewState["_ir"] == null)
return null;
_ir = (ImportRequest)ViewState["_ir"];
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("metaFieldName", typeof(string)));
dt.Columns.Add(new DataColumn("metaField", typeof(string)));
dt.Columns.Add(new DataColumn("column", typeof(string)));
DataRow dr;
MetaClass mc = MetaDataWrapper.GetMetaClassByName(_className);
MappingElementBuilder meb = new MappingElementBuilder(_ir.MappingDocument);
foreach (MetaField mf in mc.Fields)
{
if (mf.InPrimaryKey || mf.IsBackReference || mf.IsLink || mf.IsReferencedField ||
!SchemaAttribute.CheckIsUpdatable(mf))
continue;
if (mf.IsAggregation)
{
#region IsAggregation
string aggrClassName = mf.Attributes.GetValue<string>(McDataTypeAttribute.AggregationMetaClassName);
MetaClass aggrClass = MetaDataWrapper.GetMetaClassByName(aggrClassName);
foreach (MetaField aggrField in aggrClass.Fields)
{
if (aggrField.InPrimaryKey || aggrField.IsBackReference || aggrField.IsLink ||
aggrField.IsReferencedField ||
!SchemaAttribute.CheckIsUpdatable(mf) ||
aggrField.Attributes.ContainsKey(McDataTypeAttribute.AggregationMark))
continue;
dr = dt.NewRow();
string uniqName = String.Format("{0}.{1}", mf.Name, aggrField.Name);
dr["metaFieldName"] = uniqName;
dr["metaField"] = CHelper.GetResFileString(aggrField.FriendlyName) + " (" + ((aggrField.GetOriginalMetaType() == null) ? aggrField.TypeName : CHelper.GetResFileString(aggrField.GetMetaType().FriendlyName)) + ")";
MappingRule mr = meb.GetRuleByMetaField(uniqName);
if (mr != null)
dr["column"] = mr.ColumnName;
else
dr["column"] = String.Empty;
dt.Rows.Add(dr);
}
#endregion
continue;
}
#region NonAggregation
dr = dt.NewRow();
dr["metaFieldName"] = mf.Name;
dr["metaField"] = CHelper.GetResFileString(mf.FriendlyName) + " (" + ((mf.GetOriginalMetaType() == null) ? mf.TypeName : CHelper.GetResFileString(mf.GetMetaType().FriendlyName)) + ")";
MappingRule mr1 = meb.GetRuleByMetaField(mf.Name);
if (mr1 != null)
dr["column"] = mr1.ColumnName;
else
dr["column"] = String.Empty;
dt.Rows.Add(dr);
#endregion
}
return dt;
}
/// <summary>
/// Fills the default values for LIP.
/// </summary>
/// <param name="dg">The dg.</param>
/// <param name="excluded">The excluded.</param>
private void FillDefaultValues(DataGrid dg, DataGridItem excluded)
{
_ir = (ImportRequest)ViewState["_ir"];
MappingElementBuilder meb = new MappingElementBuilder(_ir.MappingDocument);
foreach (DataGridItem dgi in dg.Items)
{
if (excluded != null && excluded == dgi)
continue;
string mfName = dgi.Cells[0].Text;
MetaField field = FormController.GetMetaField(_className, mfName);
MappingRule mr = meb.GetRuleByMetaField(mfName);
if (mr != null && mr.RuleType == MappingRuleType.DefaultValue)
{
if (field.IsEnum || field.IsReference)
{
DropDownList dd = (DropDownList)dgi.FindControl("ddColumn");
if (dd != null && dd.SelectedValue != "-1")
meb.AssignDefaultValueRule(mfName, dd.SelectedValue);
}
else
{
TextBox txt = (TextBox)dgi.FindControl("tbColumn");
if (txt != null)
meb.AssignDefaultValueRule(mfName, txt.Text);
}
}
}
ViewState["_ir"] = _ir;
}
/// <summary>
/// Handles the ItemDataBound event of the dgMapping control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="System.Web.UI.WebControls.DataGridItemEventArgs"/> instance containing the event data.</param>
void dgMapping_ItemDataBound(object sender, DataGridItemEventArgs e)
{
DropDownList ddi = (DropDownList)e.Item.FindControl("ddColumns");
if (ddi != null)
{
string mfName = e.Item.Cells[0].Text;
#region Commented may be needed
//string ownFieldName = mfName;
//string aggrFieldName = String.Empty;
//string aggrClassName = String.Empty;
//MetaClass ownClass = MetaDataWrapper.GetMetaClassByName(_className);
//MetaClass aggrClass = null;
//MetaField ownField = null;
//MetaField aggrField = null;
//if (ownFieldName.Contains("."))
//{
// string[] mas = ownFieldName.Split(new string[] { "." }, StringSplitOptions.RemoveEmptyEntries);
// ownFieldName = mas[0];
// aggrFieldName = mas[1];
// ownField = MetaDataWrapper.GetMetaFieldByName(ownClass, ownFieldName);
// aggrClassName = ownField.Attributes.GetValue<string>(McDataTypeAttribute.AggregationMetaClassName);
// aggrField = MetaDataWrapper.GetMetaFieldByName(aggrClassName, aggrFieldName);
//}
//else
// ownField = MetaDataWrapper.GetMetaFieldByName(ownClass, ownFieldName);
#endregion
_ir = (ImportRequest)ViewState["_ir"];
MetaField field = FormController.GetMetaField(_className, mfName);
MappingElementBuilder meb = new MappingElementBuilder(_ir.MappingDocument);
MappingRule mr = meb.GetRuleByMetaField(mfName);
ddi.Items.Clear();
ddi.Items.Add(new ListItem(GetGlobalResourceObject("IbnFramework.Common", "tNotSetValue").ToString(), "-1"));
if (field.GetOriginalMetaType() != null)
ddi.Items.Add(new ListItem(GetGlobalResourceObject("IbnFramework.Common", "tDefaultValue").ToString(), "0"));
foreach (DataColumn dc in _ir.Data.Tables[0].Columns)
ddi.Items.Add(new ListItem(dc.ColumnName, dc.ColumnName));
string val = "-1";
if (mr != null)
{
if (mr.RuleType == MappingRuleType.DefaultValue)
val = "0";
else if (mr.RuleType == MappingRuleType.CopyValue)
val = mr.ColumnName;
}
CHelper.SafeSelect(ddi, val);
TextBox txt = (TextBox)e.Item.FindControl("tbColumn");
DropDownList dd = (DropDownList)e.Item.FindControl("ddColumn");
switch (val)
{
case "-1": //Not Set
txt.Visible = false;
dd.Visible = false;
break;
case "0": //Default Value
if (field.IsEnum)
{
dd.Visible = true;
txt.Visible = false;
dd.Items.Clear();
MetaFieldType mft = field.GetMetaType();
foreach (MetaEnumItem mei in mft.EnumItems)
dd.Items.Add(new ListItem(CHelper.GetResFileString(mei.Name), mei.Handle.ToString()));
if (!String.IsNullOrEmpty(mr.DefaultValue))
CHelper.SafeSelect(dd, mr.DefaultValue);
}
else if (field.IsReference)
{
dd.Visible = true;
txt.Visible = false;
dd.Items.Clear();
string refClassName = field.Attributes.GetValue<string>(McDataTypeAttribute.ReferenceMetaClassName);
MetaClass refClass = MetaDataWrapper.GetMetaClassByName(refClassName);
EntityObject[] list = BusinessManager.List(refClassName, (new FilterElementCollection()).ToArray());
dd.Items.Add(new ListItem(GetGlobalResourceObject("IbnFramework.Common", "tNotSetValue").ToString(), "-1"));
foreach (EntityObject eo in list)
dd.Items.Add(new ListItem(CHelper.GetResFileString(eo[refClass.TitleFieldName].ToString()), eo.PrimaryKeyId.Value.ToString()));
if (!String.IsNullOrEmpty(mr.DefaultValue))
CHelper.SafeSelect(dd, mr.DefaultValue);
}
else
{
dd.Visible = false;
txt.Visible = true;
txt.Text = mr.DefaultValue;
}
break;
default: //CopyValue
txt.Visible = false;
dd.Visible = false;
break;
}
//Update UpdatePanel with lbl & txt && dd (upValues)
foreach (Control c in e.Item.Cells[3].Controls)
{
if (c is UpdatePanel)
((UpdatePanel)c).Update();
}
}
}
/// <summary>
/// Handles the SelectedIndexChanged event of the ddi control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param>
protected void ddi_SelectedIndexChanged(object sender, EventArgs e)
{
_ir = (ImportRequest)ViewState["_ir"];
if (_ir != null)
{
MappingElementBuilder meb = new MappingElementBuilder(_ir.MappingDocument);
DropDownList ddl = (DropDownList)sender;
DataGridItem dgi = (DataGridItem)ddl.NamingContainer;
DataGrid dg = (DataGrid)dgi.NamingContainer;
FillDefaultValues(dg, dgi);
_ir = (ImportRequest)ViewState["_ir"];
string mf = dgi.Cells[0].Text;
switch (ddl.SelectedValue)
{
case "-1":
meb.RemoveRuleByMetaField(mf);
break;
case "0":
MetaField field = FormController.GetMetaField(_className, mf);
MappingRule mr = meb.AssignDefaultValueRule(mf, field.DefaultValue);
if (field.IsEnum || field.IsReference)
{
DropDownList dd = (DropDownList)dgi.FindControl("ddColumn");
CHelper.SafeSelect(dd, mr.DefaultValue);
}
else
{
TextBox txt = (TextBox)dgi.FindControl("tbColumn");
if (txt != null)
txt.Text = mr.DefaultValue;
}
break;
default:
meb.AssignCopyValueRule(ddl.SelectedValue, mf);
break;
}
ViewState["_ir"] = _ir;
BindDG();
}
}
/// <summary>
/// Creates the default by mapping element.
/// </summary>
public static void CreateMapingByPatternComparision(DataTable srcData, MetaClass dstMetaClass, MappingElementBuilder builder)
{
if (srcData == null)
throw new ArgumentNullException("srcData");
if (dstMetaClass == null)
throw new ArgumentNullException("dstMetaClass");
if (builder == null)
throw new ArgumentNullException("builder");
//MappingDocument enDefaultMappingDoc = MappingDocument.LoadFromXml(VCardType.LocRM.GetString("DefaultMapping",
// CultureInfo.GetCultureInfo("en-US")));
MappingDocument enDefaultMappingDoc = MappingDocument.LoadFromXml(GetWebResourceString("{IbnFramework.OutlookMappingPattern:Outlook2007}",
CultureInfo.GetCultureInfo("en-US")));
//MappingDocument ruDefaultMappingDoc = MappingDocument.LoadFromXml(VCardType.LocRM.GetString("DefaultMapping",
// CultureInfo.GetCultureInfo("ru-RU")));
MappingDocument ruDefaultMappingDoc = MappingDocument.LoadFromXml(GetWebResourceString("{IbnFramework.OutlookMappingPattern:Outlook2007}",
CultureInfo.GetCultureInfo("ru-RU")));
MappingElement srcEl = null;
MappingElement dstEl = null;
//Recognize source lang and type
DataColumnCollection dataColl = srcData.Columns;
//Recognize language pattern
if (enDefaultMappingDoc != null && enDefaultMappingDoc.Count != 0)
{
if (DataColumnSourceIsMatch(dataColl, enDefaultMappingDoc[0]))
{
srcEl = enDefaultMappingDoc[0];
if (FieldDestinationIsMatch(dstMetaClass.Fields, enDefaultMappingDoc[0]))
{
dstEl = enDefaultMappingDoc[0];
}
}
}
if (ruDefaultMappingDoc != null && ruDefaultMappingDoc.Count != 0)
{
if (DataColumnSourceIsMatch(dataColl, ruDefaultMappingDoc[0]))
{
srcEl = ruDefaultMappingDoc[0];
if (FieldDestinationIsMatch(dstMetaClass.Fields, ruDefaultMappingDoc[0]))
{
dstEl = ruDefaultMappingDoc[0];
}
}
}
//Pattern found, build mapping by pattern
if (srcEl != null && dstEl != null)
{
for (int i = 0; i < srcEl.Count; i++)
{
builder.AssignCopyValueRule(srcEl[i].ColumnName, dstEl[i].FieldName);
}
}
else
{
//Pattern not found, build mapping by field friendly names comparison
foreach (DataColumn dataCol in srcData.Columns)
{
CreateMapingByFriendlyNameComparison(dataCol, dstMetaClass, builder);
}
}
}
/// <summary>
/// Creates the default name of the mapping by.
/// </summary>
private static FieldMathResult CreateMapingByFriendlyNameComparison(DataColumn column, MetaClass dstClass,
string prefix, FieldMathResult prevMatchResult,
MappingElementBuilder builder)
{
FieldMathResult retVal = prevMatchResult;
foreach (MetaField metaField in dstClass.Fields)
{
string mappedFieldName = prefix + metaField.Name;
// Skip always maped metaField
if (builder.GetRuleByMetaField(mappedFieldName) != null)
continue;
// Skip Back Aggregation References
if (metaField.Attributes.ContainsKey(McDataTypeAttribute.AggregationMark))
continue;
//Skip referenses
if (metaField.IsReference)
continue;
// Process Aggregation
if (metaField.IsAggregation)
{
// Find Aggr meta class
MetaClass aggrMetaClass = DataContext.Current.GetMetaClass((string)metaField.Attributes[McDataTypeAttribute.AggregationMetaClassName]);
// Find rules
retVal = CreateMapingByFriendlyNameComparison(column, aggrMetaClass, metaField.Name + ".", retVal, builder);
continue;
}
//Получаем имя в русской локализации
string enName = GetWebResourceString(metaField.FriendlyName, CultureInfo.GetCultureInfo("en-US"));
//получаем имя в английской локализации
string ruName = GetWebResourceString(metaField.FriendlyName, CultureInfo.GetCultureInfo("ru-RU"));
//Find best match for pattern
foreach(string searchPattern in new string[] { enName, ruName })
{
if (column.ColumnName.Contains(searchPattern))
{
FieldMathResult newResult = new FieldMathResult(column.ColumnName, searchPattern, mappedFieldName);
if (retVal != null)
{
retVal = retVal.Weight < newResult.Weight ? retVal : newResult;
}
else
{
retVal = newResult;
}
break;
}
}
}
return retVal;
}
/// <summary>
/// Creates the default name of the mapping by.
/// </summary>
private static FieldMathResult CreateMapingByFriendlyNameComparison(DataColumn column, MetaClass dstClass,
string prefix, FieldMathResult prevMatchResult,
MappingElementBuilder builder)
{
FieldMathResult retVal = prevMatchResult;
foreach (MetaField metaField in dstClass.Fields)
{
string mappedFieldName = prefix + metaField.Name;
// Skip always maped metaField
if (builder.GetRuleByMetaField(mappedFieldName) != null)
{
continue;
}
// Skip Back Aggregation References
if (metaField.Attributes.ContainsKey(McDataTypeAttribute.AggregationMark))
{
continue;
}
//Skip referenses
if (metaField.IsReference)
{
continue;
}
// Process Aggregation
if (metaField.IsAggregation)
{
// Find Aggr meta class
MetaClass aggrMetaClass = DataContext.Current.GetMetaClass((string)metaField.Attributes[McDataTypeAttribute.AggregationMetaClassName]);
// Find rules
retVal = CreateMapingByFriendlyNameComparison(column, aggrMetaClass, metaField.Name + ".", retVal, builder);
continue;
}
//Получаем имя в русской локализации
string enName = GetWebResourceString(metaField.FriendlyName, CultureInfo.GetCultureInfo("en-US"));
//получаем имя в английской локализации
string ruName = GetWebResourceString(metaField.FriendlyName, CultureInfo.GetCultureInfo("ru-RU"));
//Find best match for pattern
foreach (string searchPattern in new string[] { enName, ruName })
{
if (column.ColumnName.Contains(searchPattern))
{
FieldMathResult newResult = new FieldMathResult(column.ColumnName, searchPattern, mappedFieldName);
if (retVal != null)
{
retVal = retVal.Weight < newResult.Weight ? retVal : newResult;
}
else
{
retVal = newResult;
}
break;
}
}
}
return(retVal);
}
/// <summary>
/// Creates the default by mapping element.
/// </summary>
public static void CreateMapingByPatternComparision(DataTable srcData, MetaClass dstMetaClass, MappingElementBuilder builder)
{
if (srcData == null)
{
throw new ArgumentNullException("srcData");
}
if (dstMetaClass == null)
{
throw new ArgumentNullException("dstMetaClass");
}
if (builder == null)
{
throw new ArgumentNullException("builder");
}
//MappingDocument enDefaultMappingDoc = MappingDocument.LoadFromXml(VCardType.LocRM.GetString("DefaultMapping",
// CultureInfo.GetCultureInfo("en-US")));
MappingDocument enDefaultMappingDoc = MappingDocument.LoadFromXml(GetWebResourceString("{IbnFramework.OutlookMappingPattern:Outlook2007}",
CultureInfo.GetCultureInfo("en-US")));
//MappingDocument ruDefaultMappingDoc = MappingDocument.LoadFromXml(VCardType.LocRM.GetString("DefaultMapping",
// CultureInfo.GetCultureInfo("ru-RU")));
MappingDocument ruDefaultMappingDoc = MappingDocument.LoadFromXml(GetWebResourceString("{IbnFramework.OutlookMappingPattern:Outlook2007}",
CultureInfo.GetCultureInfo("ru-RU")));
MappingElement srcEl = null;
MappingElement dstEl = null;
//Recognize source lang and type
DataColumnCollection dataColl = srcData.Columns;
//Recognize language pattern
if (enDefaultMappingDoc != null && enDefaultMappingDoc.Count != 0)
{
if (DataColumnSourceIsMatch(dataColl, enDefaultMappingDoc[0]))
{
srcEl = enDefaultMappingDoc[0];
if (FieldDestinationIsMatch(dstMetaClass.Fields, enDefaultMappingDoc[0]))
{
dstEl = enDefaultMappingDoc[0];
}
}
}
if (ruDefaultMappingDoc != null && ruDefaultMappingDoc.Count != 0)
{
if (DataColumnSourceIsMatch(dataColl, ruDefaultMappingDoc[0]))
{
srcEl = ruDefaultMappingDoc[0];
if (FieldDestinationIsMatch(dstMetaClass.Fields, ruDefaultMappingDoc[0]))
{
dstEl = ruDefaultMappingDoc[0];
}
}
}
//Pattern found, build mapping by pattern
if (srcEl != null && dstEl != null)
{
for (int i = 0; i < srcEl.Count; i++)
{
builder.AssignCopyValueRule(srcEl[i].ColumnName, dstEl[i].FieldName);
}
}
else
{
//Pattern not found, build mapping by field friendly names comparison
foreach (DataColumn dataCol in srcData.Columns)
{
CreateMapingByFriendlyNameComparison(dataCol, dstMetaClass, builder);
}
}
}
/// <summary>
/// Handles the ItemDataBound event of the dgMapping control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="System.Web.UI.WebControls.DataGridItemEventArgs"/> instance containing the event data.</param>
void dgMapping_ItemDataBound(object sender, DataGridItemEventArgs e)
{
DropDownList ddi = (DropDownList)e.Item.FindControl("ddColumns");
if (ddi != null)
{
string mfName = e.Item.Cells[0].Text;
#region Commented may be needed
//string ownFieldName = mfName;
//string aggrFieldName = String.Empty;
//string aggrClassName = String.Empty;
//MetaClass ownClass = MetaDataWrapper.GetMetaClassByName(_className);
//MetaClass aggrClass = null;
//MetaField ownField = null;
//MetaField aggrField = null;
//if (ownFieldName.Contains("."))
//{
// string[] mas = ownFieldName.Split(new string[] { "." }, StringSplitOptions.RemoveEmptyEntries);
// ownFieldName = mas[0];
// aggrFieldName = mas[1];
// ownField = MetaDataWrapper.GetMetaFieldByName(ownClass, ownFieldName);
// aggrClassName = ownField.Attributes.GetValue<string>(McDataTypeAttribute.AggregationMetaClassName);
// aggrField = MetaDataWrapper.GetMetaFieldByName(aggrClassName, aggrFieldName);
//}
//else
// ownField = MetaDataWrapper.GetMetaFieldByName(ownClass, ownFieldName);
#endregion
_ir = (ImportRequest)ViewState["_ir"];
MetaField field = FormController.GetMetaField(_className, mfName);
MappingElementBuilder meb = new MappingElementBuilder(_ir.MappingDocument);
MappingRule mr = meb.GetRuleByMetaField(mfName);
ddi.Items.Clear();
ddi.Items.Add(new ListItem(GetGlobalResourceObject("IbnFramework.Common", "tNotSetValue").ToString(), "-1"));
if (field.GetOriginalMetaType() != null)
{
ddi.Items.Add(new ListItem(GetGlobalResourceObject("IbnFramework.Common", "tDefaultValue").ToString(), "0"));
}
foreach (DataColumn dc in _ir.Data.Tables[0].Columns)
{
ddi.Items.Add(new ListItem(dc.ColumnName, dc.ColumnName));
}
string val = "-1";
if (mr != null)
{
if (mr.RuleType == MappingRuleType.DefaultValue)
{
val = "0";
}
else if (mr.RuleType == MappingRuleType.CopyValue)
{
val = mr.ColumnName;
}
}
CHelper.SafeSelect(ddi, val);
TextBox txt = (TextBox)e.Item.FindControl("tbColumn");
DropDownList dd = (DropDownList)e.Item.FindControl("ddColumn");
switch (val)
{
case "-1": //Not Set
txt.Visible = false;
dd.Visible = false;
break;
case "0": //Default Value
if (field.IsEnum)
{
dd.Visible = true;
txt.Visible = false;
dd.Items.Clear();
MetaFieldType mft = field.GetMetaType();
foreach (MetaEnumItem mei in mft.EnumItems)
{
dd.Items.Add(new ListItem(CHelper.GetResFileString(mei.Name), mei.Handle.ToString()));
}
if (!String.IsNullOrEmpty(mr.DefaultValue))
{
CHelper.SafeSelect(dd, mr.DefaultValue);
}
}
else if (field.IsReference)
{
dd.Visible = true;
txt.Visible = false;
dd.Items.Clear();
string refClassName = field.Attributes.GetValue <string>(McDataTypeAttribute.ReferenceMetaClassName);
MetaClass refClass = MetaDataWrapper.GetMetaClassByName(refClassName);
EntityObject[] list = BusinessManager.List(refClassName, (new FilterElementCollection()).ToArray());
dd.Items.Add(new ListItem(GetGlobalResourceObject("IbnFramework.Common", "tNotSetValue").ToString(), "-1"));
foreach (EntityObject eo in list)
{
dd.Items.Add(new ListItem(CHelper.GetResFileString(eo[refClass.TitleFieldName].ToString()), eo.PrimaryKeyId.Value.ToString()));
}
if (!String.IsNullOrEmpty(mr.DefaultValue))
{
CHelper.SafeSelect(dd, mr.DefaultValue);
}
}
else
{
dd.Visible = false;
txt.Visible = true;
txt.Text = mr.DefaultValue;
}
break;
default: //CopyValue
txt.Visible = false;
dd.Visible = false;
break;
}
//Update UpdatePanel with lbl & txt && dd (upValues)
foreach (Control c in e.Item.Cells[3].Controls)
{
if (c is UpdatePanel)
{
((UpdatePanel)c).Update();
}
}
}
}
/// <summary>
/// Gets the mapping source.
/// </summary>
/// <returns></returns>
private DataTable GetMappingSource()
{
if (ViewState["_ir"] == null)
{
return(null);
}
_ir = (ImportRequest)ViewState["_ir"];
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("metaFieldName", typeof(string)));
dt.Columns.Add(new DataColumn("metaField", typeof(string)));
dt.Columns.Add(new DataColumn("column", typeof(string)));
DataRow dr;
MetaClass mc = MetaDataWrapper.GetMetaClassByName(_className);
MappingElementBuilder meb = new MappingElementBuilder(_ir.MappingDocument);
foreach (MetaField mf in mc.Fields)
{
if (mf.InPrimaryKey || mf.IsBackReference || mf.IsLink || mf.IsReferencedField ||
!SchemaAttribute.CheckIsUpdatable(mf))
{
continue;
}
if (mf.IsAggregation)
{
#region IsAggregation
string aggrClassName = mf.Attributes.GetValue <string>(McDataTypeAttribute.AggregationMetaClassName);
MetaClass aggrClass = MetaDataWrapper.GetMetaClassByName(aggrClassName);
foreach (MetaField aggrField in aggrClass.Fields)
{
if (aggrField.InPrimaryKey || aggrField.IsBackReference || aggrField.IsLink ||
aggrField.IsReferencedField ||
!SchemaAttribute.CheckIsUpdatable(mf) ||
aggrField.Attributes.ContainsKey(McDataTypeAttribute.AggregationMark))
{
continue;
}
dr = dt.NewRow();
string uniqName = String.Format("{0}.{1}", mf.Name, aggrField.Name);
dr["metaFieldName"] = uniqName;
dr["metaField"] = CHelper.GetResFileString(aggrField.FriendlyName) + " (" + ((aggrField.GetOriginalMetaType() == null) ? aggrField.TypeName : CHelper.GetResFileString(aggrField.GetMetaType().FriendlyName)) + ")";
MappingRule mr = meb.GetRuleByMetaField(uniqName);
if (mr != null)
{
dr["column"] = mr.ColumnName;
}
else
{
dr["column"] = String.Empty;
}
dt.Rows.Add(dr);
}
#endregion
continue;
}
#region NonAggregation
dr = dt.NewRow();
dr["metaFieldName"] = mf.Name;
dr["metaField"] = CHelper.GetResFileString(mf.FriendlyName) + " (" + ((mf.GetOriginalMetaType() == null) ? mf.TypeName : CHelper.GetResFileString(mf.GetMetaType().FriendlyName)) + ")";
MappingRule mr1 = meb.GetRuleByMetaField(mf.Name);
if (mr1 != null)
{
dr["column"] = mr1.ColumnName;
}
else
{
dr["column"] = String.Empty;
}
dt.Rows.Add(dr);
#endregion
}
return(dt);
}
