private void ConvertFieldTableToMappings() { columnMapping = new List <ColumnConversionInfo>(); foreach (DataRow row in dataDictionary.Rows) { if ((bool)row[0] == true) { ColumnConversionInfo cci = new ColumnConversionInfo(); cci.SourceColumnName = row["SourceColumnName"].ToString(); cci.DestinationColumnName = row["DestinationColumnName"].ToString(); cci.Prompt = row["Prompt"].ToString(); cci.SourceColumnType = (DbType)row["SourceColumnType"]; switch (row["FieldType"].ToString()) { case "Text": cci.FieldType = MetaFieldType.Text; break; case "Multiline": cci.FieldType = MetaFieldType.Multiline; break; case "Number": cci.FieldType = MetaFieldType.Number; break; case "Checkbox": cci.FieldType = MetaFieldType.Checkbox; break; case "YesNo": cci.FieldType = MetaFieldType.YesNo; break; case "LegalValues": cci.FieldType = MetaFieldType.LegalValues; break; case "Date": cci.FieldType = MetaFieldType.Date; break; case "DateTime": cci.FieldType = MetaFieldType.DateTime; break; case "Time": cci.FieldType = MetaFieldType.Time; break; default: throw new ApplicationException("Invalid field type"); } cci.PageNumber = (int)row["PageNumber"]; cci.TabIndex = (int)row["TabIndex"]; cci.IsTabStop = (bool)row["IsTabStop"]; cci.IsReadOnly = (bool)row["IsReadOnly"]; cci.IsRequired = (bool)row["IsRequired"]; cci.IsRepeatLast = (bool)row["IsRepeatLast"]; cci.HasRange = (bool)row["HasRange"]; cci.LowerBound = row["LowerBound"].ToString(); cci.UpperBound = row["UpperBound"].ToString(); cci.ListSourceTableName = row["ListSourceTableName"].ToString(); cci.ListSourceTextColumnName = row["ListSourceTextColumnName"].ToString(); if (row["ListSourceTable"] != null && row["ListSourceTable"] != DBNull.Value) { cci.ListSourceTable = (DataTable)row["ListSourceTable"]; } if (row["ControlFont"] != null && row["ControlFont"] != DBNull.Value) { cci.ControlFont = (Font)row["ControlFont"]; } if (row["PromptFont"] != null && row["PromptFont"] != DBNull.Value) { cci.PromptFont = (Font)row["PromptFont"]; } cci.ControlLeftPosition = (double)row["ControlLeftPosition"]; cci.ControlTopPosition = (double)row["ControlTopPosition"]; cci.PromptLeftPosition = (double)row["PromptLeftPosition"]; cci.PromptTopPosition = (double)row["PromptTopPosition"]; columnMapping.Add(cci); } } }
private void ConvertFieldTableToMappings() { columnMapping = new List<ColumnConversionInfo>(); foreach (DataRow row in dataDictionary.Rows) { if ((bool)row[0] == true) { ColumnConversionInfo cci = new ColumnConversionInfo(); cci.SourceColumnName = row["SourceColumnName"].ToString(); cci.DestinationColumnName = row["DestinationColumnName"].ToString(); cci.Prompt = row["Prompt"].ToString(); cci.SourceColumnType = (DbType)row["SourceColumnType"]; switch (row["FieldType"].ToString()) { case "Text": cci.FieldType = MetaFieldType.Text; break; case "Multiline": cci.FieldType = MetaFieldType.Multiline; break; case "Number": cci.FieldType = MetaFieldType.Number; break; case "Checkbox": cci.FieldType = MetaFieldType.Checkbox; break; case "YesNo": cci.FieldType = MetaFieldType.YesNo; break; case "LegalValues": cci.FieldType = MetaFieldType.LegalValues; break; case "Date": cci.FieldType = MetaFieldType.Date; break; case "DateTime": cci.FieldType = MetaFieldType.DateTime; break; case "Time": cci.FieldType = MetaFieldType.Time; break; default: throw new ApplicationException("Invalid field type"); } cci.PageNumber = (int)row["PageNumber"]; cci.TabIndex = (int)row["TabIndex"]; cci.IsTabStop = (bool)row["IsTabStop"]; cci.IsReadOnly = (bool)row["IsReadOnly"]; cci.IsRequired = (bool)row["IsRequired"]; cci.IsRepeatLast = (bool)row["IsRepeatLast"]; cci.HasRange = (bool)row["HasRange"]; cci.LowerBound = row["LowerBound"].ToString(); cci.UpperBound = row["UpperBound"].ToString(); cci.ListSourceTableName = row["ListSourceTableName"].ToString(); cci.ListSourceTextColumnName = row["ListSourceTextColumnName"].ToString(); if (row["ListSourceTable"] != null && row["ListSourceTable"] != DBNull.Value) { cci.ListSourceTable = (DataTable)row["ListSourceTable"]; } if (row["ControlFont"] != null && row["ControlFont"] != DBNull.Value) { cci.ControlFont = (Font)row["ControlFont"]; } if (row["PromptFont"] != null && row["PromptFont"] != DBNull.Value) { cci.PromptFont = (Font)row["PromptFont"]; } cci.ControlLeftPosition = (double)row["ControlLeftPosition"]; cci.ControlTopPosition = (double)row["ControlTopPosition"]; cci.PromptLeftPosition = (double)row["PromptLeftPosition"]; cci.PromptTopPosition = (double)row["PromptTopPosition"]; columnMapping.Add(cci); } } }