public partial class MyPluginControl : PluginControlBase, IGitHubPlugin, IHelpPlugin

{

// CREATE EXCEL OBJECTS.

Excel.Application xlApp = new Excel.Application();

Excel.Workbook xlWorkBook;

Excel.Worksheet xlWorkSheet;

Excel.Range xlRange;

EntityMetadata resultsaved;

EntityMetadata lkpresultsaved;

RichTextBox richTextBoxErrors = new RichTextBox();

RichTextBox richTextBoxImported = new RichTextBox();

RichTextBox richTextBoxAll = new RichTextBox();

RichTextBox richTextBoxWarning = new RichTextBox();

//DataGridViewComboBoxCell dcc; //??

string sFileName;

bool strIsKey;

bool IsReadyToImport = false;

string qestr;

int iRow, iCol = 1;

bool flaglookup;

int lookupscount;

StringBuilder boxall = new StringBuilder();

StringBuilder boxwarning = new StringBuilder();

StringBuilder boxerror = new StringBuilder();

StringBuilder boxsuccess = new StringBuilder();

int successnumber = 0;

int errornumber = 0;

int creatednumber = 0;

int updatednumber = 0;

int deletednumber = 0;

int importRunNumber = 0; // Number of times the Excel Import process has been run

// The Settings for the import

private Settings settings = Settings.Instance;

// To store the table logs

DataTable tableLogEntries = new DataTable();

// To store the Excel Mapping once ready for import

DataTable tableMapping = new DataTable();

#region Initialising Plugin

public MyPluginControl()

{

InitializeComponent();

}

public void MyPluginControl_Load(object sender, System.EventArgs e)

{

mainTableLayout.RowStyles[1] = new RowStyle(SizeType.Absolute, 0); // Hides the logs

dataGridViewMapping.Enabled = false; // Locks all the mapping until Excel is loaded.

settingsLookupFoundMultipleRecords.SelectedIndex = 0;

settingsCrmAction.SelectedIndex = 0;

textView.SelectedIndex = 0;

settingsOptionSetValuesOrLabel.SelectedIndex = 0;

settingsKeyFoundMultipleRecords.SelectedIndex = 0;

completeRecords.Checked = false;

ExecuteMethod(InitEntities);

// Initialise the table logs

tableLogEntries.Columns.Add("Import", typeof(int));

tableLogEntries.Columns.Add("Line", typeof(int));

tableLogEntries.Columns.Add("Result", typeof(string));

tableLogEntries.Columns.Add("Updates", typeof(int));

tableLogEntries.Columns.Add("GUID", typeof(string));

tableLogEntries.Columns.Add("Logs", typeof(string));

dataGridViewLogs.DataSource = tableLogEntries;

tableMapping.TableName = "TableMapping";

// Initialise the table mapping

tableMapping.Columns.Add("ExcelColumn");

tableMapping.Columns.Add("isKey", typeof(bool));

tableMapping.Columns.Add("CRMField");

tableMapping.Columns.Add("IsLookup");

tableMapping.Columns.Add("lkpTargetEntity");

tableMapping.Columns.Add("lkpTargetfield");

tableMapping.Columns.Add("Truevalue");

tableMapping.Columns.Add("Falsevalue");

tableMapping.Columns.Add("DefaultValue");

tableMapping.Columns.Add("BlankBehaviour");

tableMapping.Columns.Add("DataType");

this.dataGridViewMapping.CellValueChanged += new System.Windows.Forms.DataGridViewCellEventHandler(this.dataGridViewMapping_CellValueChanged);

}

#endregion Initialising Plugin

#region XRMToolbox Commands

// If the connection is updated and another environment is chosen.

public override void UpdateConnection(IOrganizationService newService, ConnectionDetail detail, string actionName, object parameter)

{

base.UpdateConnection(newService, detail, actionName, parameter);

InitEntities();

}

private void TsbClose_Click(object sender, EventArgs e)

{

CloseTool();

}

#region IGitHubPlugin implementation

public string RepositoryName => "XTBPlugins.DataImport";

public string UserName => "YesWeCandrew";

#endregion IGitHubPlugin implementation

#region IHelpPlugin implementation

public string HelpUrl => "https://github.com/YesWeCandrew/XTBPlugins.DataImport/blob/master/README.md";

#endregion IHelpPlugin implementation

#endregion XRMToolbox Commands

#region Retrieving Data From Dynamics

public void InitEntities()

{

WorkAsync(new WorkAsyncInfo

{

Message = "Getting entities",

Work = (worker, args) =>

{

RetrieveAllEntitiesResponse metaDataResponse = new RetrieveAllEntitiesResponse();

RetrieveAllEntitiesRequest retrieveAllEntitiesRequest = new RetrieveAllEntitiesRequest

{

RetrieveAsIfPublished = true,

EntityFilters = EntityFilters.Attributes

};

retrieveAllEntitiesRequest.EntityFilters = EntityFilters.Entity;

// Execute the request.

args.Result = (RetrieveAllEntitiesResponse)Service.Execute(retrieveAllEntitiesRequest);

},

PostWorkCallBack = (args) =>

{

if (args.Error != null)

{

MessageBox.Show(args.Error.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);

}

settingsEntity.Items.Clear();

lkpTargetEntity.Items.Clear();

var result = args.Result as RetrieveAllEntitiesResponse;

if (result != null)

{

var entities = result.EntityMetadata;

foreach (EntityMetadata Entity in entities)

{

settingsEntity.Items.Add(Entity.LogicalName);

lkpTargetEntity.Items.Add(Entity.LogicalName);

}

}

}

});

}

private void InitEntityFields()

{

if (settingsEntity.SelectedItem == null)

{

//MessageBox.Show("Please load entities first and pick your entity then press this button.");

//ExecuteMethod(InitEntities);

return;

}

CRMField.Items.Clear();

WorkAsync(new WorkAsyncInfo

{

Message = "Getting entity fields",

Work = (worker, args) =>

{

Dictionary<string, string> attributesData = new Dictionary<string, string>();

RetrieveEntityRequest retrieveEntityRequest = new RetrieveEntityRequest

{

EntityFilters = EntityFilters.All,

LogicalName = settings.Entity

};

// Execute the request

args.Result = (RetrieveEntityResponse)Service.Execute(retrieveEntityRequest);

},

PostWorkCallBack = (args) =>

{

if (args.Error != null)

{

MessageBox.Show(args.Error.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);

}

var result = args.Result as RetrieveEntityResponse;

resultsaved = result.EntityMetadata;

if (result != null)

{

CRMField.Items.Add("");

foreach (object attribute in resultsaved.Attributes)

{

AttributeMetadata a = (AttributeMetadata)attribute;

if (a.AttributeType.ToString() == "DateTime" || a.AttributeType.ToString() == "State" || a.AttributeType.ToString() == "Status" || a.AttributeType.ToString() == "Memo" || a.AttributeType.ToString() == "String" || (a.AttributeType.ToString() == "Virtual" && a.SourceType == 0) || a.AttributeType.ToString() == "Picklist" || a.AttributeType.ToString() == "Boolean" || a.AttributeType.ToString() == "Integer" || a.AttributeType.ToString() == "Decimal" || a.AttributeType.ToString() == "Money" || a.AttributeType.ToString() == "Lookup" || a.AttributeType.ToString() == "Customer" || a.AttributeType.ToString() == "PartyList" || a.AttributeType.ToString() == "Uniqueidentifier" || a.AttributeType.ToString() == "Owner")

CRMField.Items.Add(a.LogicalName.ToString());

}

}

ProcessFields();

setInstructionVisibility(false);

dataGridViewMapping.Enabled = true;

}

});

}

private void InitLookupFields(string myentity, int thatRow)

{

if (myentity == null || myentity == "")

{

return;

}

//lkpTargetfield.Items.Clear();

DataGridViewComboBoxCell datalkpfield = dataGridViewMapping.Rows[thatRow].Cells[5] as DataGridViewComboBoxCell;

datalkpfield.Items.Clear();

WorkAsync(new WorkAsyncInfo

{

Message = "Getting entity fields",

Work = (worker, args) =>

{

Dictionary<string, string> attributesData = new Dictionary<string, string>();

RetrieveEntityRequest retrieveEntityRequest = new RetrieveEntityRequest

{

EntityFilters = EntityFilters.All,

LogicalName = myentity

};

// Execute the request

args.Result = (RetrieveEntityResponse)Service.Execute(retrieveEntityRequest);

},

PostWorkCallBack = (args) =>

{

if (args.Error != null)

{

MessageBox.Show(args.Error.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);

}

var result = args.Result as RetrieveEntityResponse;

lkpresultsaved = result.EntityMetadata;

if (result != null)

{

DataGridViewComboBoxCell stateCell = (DataGridViewComboBoxCell)(dataGridViewMapping.Rows[thatRow].Cells[5]);

foreach (object attribute in lkpresultsaved.Attributes)

{

AttributeMetadata a = (AttributeMetadata)attribute;

if (a.AttributeType.ToString() == "Uniqueidentifier" || a.AttributeType.ToString() == "String" || a.AttributeType.ToString() == "State" /*|| a.AttributeType.ToString() == "DateTime" || a.AttributeType.ToString() == "Integer" || a.AttributeType.ToString() == "Decimal" || a.AttributeType.ToString() == "Money"*/)

{

stateCell.Items.Add(a.LogicalName.ToString());

}

}

}

}

});

}

#endregion Retrieving Data From Dynamics

#region Get Excel

private void BrowseFileButton_Click(object sender, EventArgs e)

{

GetFile();

}

private void GetFile()

{

openFileDialog.FileName = "";

openFileDialog.Title = "Excel File to Import";

openFileDialog.Filter = "Excel File|*.xlsx;*.xls";

DialogResult result = openFileDialog.ShowDialog(); // Show the dialog.

if (result == DialogResult.OK) // Test result.

{

EmptyDataGrid();

string file = openFileDialog.FileName;

try

{

sFileName = openFileDialog.FileName;

if (sFileName.Trim() != "")

{

ReadExcel(sFileName);

settingsPanel.Enabled = true; // Enable all controls now that Excel is loaded

loadSettingsButton.Enabled = true;

saveSettingsButton.Enabled = true;

}

}

catch (IOException ex)

{

MessageBox.Show("Failed to load Excel file correctly:" + ex.Message.ToString());

}

}

}

// GET DATA FROM EXCEL AND POPULATE COMB0 BOX.

private void ReadExcel(string sFile)

{

WorkAsync(new WorkAsyncInfo

{

Message = "Reading Excel File..",

Work = (worker, args) =>

{

xlApp = new Excel.Application();

xlWorkBook = xlApp.Workbooks.Open(sFile); // WORKBOOK TO OPEN THE EXCEL FILE.

xlWorkSheet = xlWorkBook.Worksheets[1]; // NAME OF THE SHEET.

xlRange = xlWorkSheet.UsedRange;

},

PostWorkCallBack = (args) =>

{

for (iCol = 1; iCol <= xlRange.Columns.Count; iCol++) // START FROM THE SECOND ROW.

{

if (xlRange.Cells[1, iCol].value == null)

{

break; // BREAK LOOP.

}

else

{

dataGridViewMapping.Rows.Add(xlRange.Cells[1, iCol].value);

// Set default for load to CRM to Keeps CRM Value

dataGridViewMapping.Rows[iCol-1].Cells[9].Value = "Keeps CRM value";

}

}

// Set the labels and row values to the correct values.

toolStripStatusRowsNum.Text = ((xlRange.Rows.Count) - 1).ToString();

rowEndNum.Maximum = xlRange.Rows.Count;

rowEndNum.Minimum = 2;

rowEndNum.Value = xlRange.Rows.Count;

rowStartNum.Maximum = xlRange.Rows.Count;

rowStartNum.Value = 2;

xlWorkBook.Close();

xlApp.Quit();

processFieldsButton.Enabled = true;

}

});

}

#endregion Get Excel

#region Logging

#region OriginalLogging

private void SetTextBox1()

{

if (textView.SelectedItem.ToString() == "📙 ALL")

{

logTextBox.Text = richTextBoxAll.Text;

}

else if (textView.SelectedItem.ToString() == "✓ SUCCESS")

{

logTextBox.Text = richTextBoxImported.Text;

}

else if (textView.SelectedItem.ToString() == "❌ ERRORS")

{

logTextBox.Text = richTextBoxErrors.Text;

}

else if (textView.SelectedItem.ToString() == "⚠ WARNINGS")

{

logTextBox.Text = richTextBoxWarning.Text;

}

toolStripStatusSuccessNum.Text = successnumber.ToString();

toolStripStatusErrorNum.Text = errornumber.ToString();

toolStripStatusCreatedNum.Text = creatednumber.ToString();

toolStripStatusUpdatedNum.Text = updatednumber.ToString();

toolStripStatusDeletedNum.Text = deletednumber.ToString();

}

private void TextView_DropDownClosed(object sender, EventArgs e)

{

//SetTextBox1();

if (textView.SelectedItem.ToString() == "📙 ALL")

{

logTextBox.Text = richTextBoxAll.Text;

}

else if (textView.SelectedItem.ToString() == "✓ SUCCESS")

{

logTextBox.Text = richTextBoxImported.Text;

}

else if (textView.SelectedItem.ToString() == "❌ ERRORS")

{

logTextBox.Text = richTextBoxErrors.Text;

}

else if (textView.SelectedItem.ToString() == "⚠ WARNINGS")

{

logTextBox.Text = richTextBoxWarning.Text;

}

toolStripStatusSuccessNum.Text = successnumber.ToString();

toolStripStatusErrorNum.Text = errornumber.ToString();

toolStripStatusCreatedNum.Text = creatednumber.ToString();

toolStripStatusUpdatedNum.Text = updatednumber.ToString();

toolStripStatusDeletedNum.Text = deletednumber.ToString();

}

private void CopyText_Click(object sender, EventArgs e)

{

StringBuilder sb = new StringBuilder();

foreach (string line in logTextBox.Lines)

sb.AppendLine(line);

if (sb.Length != 0)

Clipboard.SetText(sb.ToString());

else

MessageBox.Show("Logs are empty");

}

#endregion Original Logging

#region New Logging

private void LogToggle_Click(object sender, EventArgs e)

{

if (mainTableLayout.RowStyles[1].Height == 0) // Log sections are hidden

{

LogTableShow();

}

else

{

LogTableHide();

}

}

private void LogTableHide()

{

mainTableLayout.RowStyles[1] = new RowStyle(SizeType.Percent, 0);

LogToggle.Text = "Show Logs";

}

private void LogTableShow()

{

mainTableLayout.RowStyles[1] = new RowStyle(SizeType.Percent, 45);

LogToggle.Text = "Hide Logs";

}

private void RefreshLogs_Click_2(object sender, EventArgs e)

{

SetTextBox1();

dataGridViewLogs.Refresh();

}

private void AddToLogRow(string[] row, string log = null, string GUID = null, string result = null)

{

// 0 = #

// 1 = Line

// 2 = Result

// 3 = Updates

// 4 = GUID

// 5 = Logs

// add the GUID to the cell if GUID is not null

if (GUID != null)

{

if (row[4] == null)

{

row[3] = "1";

row[4] = GUID;

}

else

{

row[3] = (int.Parse(row[3]) + 1).ToString();

row[4] += " " + GUID;

}

}

// Add the logs to the log cell

if (log != null)

{

if (row[5] == null)

{

row[5] = log;

}

else

{

row[5] += " | " + log;

}

}

// If a result is provided, add it to the result cell

if (result == null)

{ return; }

else

{

row[2] = result;

}

}

#endregion New Logging

#endregion Logging

#region Clearing

private void resetButton_Click(object sender, EventArgs e)

{

///CLEAR ALL

xlWorkBook = null;

xlWorkSheet = null;

xlRange = null;

xlApp = null;

settingsEntity.SelectedItem = null;

settingsLookupFoundMultipleRecords.Visible = false;

settingsCrmAction.SelectedIndex = 0;

settingsLookupFoundMultipleRecords.SelectedIndex = 0;

settingsOptionSetValuesOrLabel.SelectedIndex = 0;

settingsKeyFoundMultipleRecords.SelectedIndex = 0;

completeRecords.Checked = false;

settings.Reset();

labelOptionSetValuesOrLabel.Visible = false;

settingsOptionSetValuesOrLabel.Visible = false;

labelLookupFoundMultipleRecords.Visible = false;

mainTableLayout.RowStyles[1] = new RowStyle(SizeType.Percent, 0);

saveSettingsButton.Enabled = false;

loadSettingsButton.Enabled = false;

setInstructionVisibility(true);

settingsPanel.Enabled = false;

dataGridViewMapping.Enabled = false;

EmptyDataGrid();

CRMField.Items.Clear();

}

private void EmptyDataGrid()

{

dataGridViewMapping.Rows.Clear();

dataGridViewMapping.Columns["lkpTargetEntity"].Visible = false;

dataGridViewMapping.Columns["lkpTargetfield"].Visible = false;

dataGridViewMapping.Columns["Truevalue"].Visible = false;

dataGridViewMapping.Columns["Falsevalue"].Visible = false;

dataGridViewMapping.Columns["DefaultValue"].Visible = false;

}

#endregion Clearing

#region Sidebar Options

private void rowStartNum_ValueChanged(object sender, EventArgs e)

{

// Set row end equal to start if start is after end

if (rowEndNum.Value <= rowStartNum.Value) {

rowEndNum.Value = rowStartNum.Value;

}

// Make the minimum equal to the new start

rowEndNum.Minimum = new decimal(new int[] {

(int) rowStartNum.Value,

0,

0,

0

});

}

private void settingsEntity_DropDownClosed(object sender, EventArgs e)

{

if (settingsEntity.SelectedItem != null)

{

settings.Entity = settingsEntity.SelectedItem.ToString();

for (int o = 0; o < dataGridViewMapping.RowCount; o++)

{

DataGridViewComboBoxCell data = dataGridViewMapping.Rows[o].Cells[2] as DataGridViewComboBoxCell;

data.Value = null;

}

ExecuteMethod(InitEntityFields);

}

else if (settingsEntity.Items.Count == 0)

{

ExecuteMethod(InitEntities);

}

}

private void settingsCrmAction_SelectedIndexChanged(object sender, EventArgs e)

{

settings.CrmAction = settingsCrmAction.SelectedItem.ToString();

if (settings.CrmAction == "Create")

{

settingsKeyFoundMultipleRecords.Visible = false;

labelKeyFoundMultipleRecords.Visible = false;

dataGridViewMapping.Columns[1].Visible = false;

if(settings.Entity == "activity" || settings.Entity == "letter" || settings.Entity == "task")

{

completeRecords.Visible = true;

}

else

{

completeRecords.Visible = false;

}

}

else

{

settingsKeyFoundMultipleRecords.Visible = true;

labelKeyFoundMultipleRecords.Visible = true;

dataGridViewMapping.Columns[1].Visible = true;

completeRecords.Visible = false;

}

}

private void settingsKeyFoundMultipleRecords_SelectedIndexChanged(object sender, EventArgs e)

{

settings.KeyFoundMultipleRecords = settingsKeyFoundMultipleRecords.SelectedItem.ToString();

}

private void settingsOptionSetValuesOrLabel_SelectedIndexChanged(object sender, EventArgs e)

{

settings.OptionSetValuesOrLabel = settingsOptionSetValuesOrLabel.SelectedItem.ToString();

}

private void settingsLookupFoundMultipleRecords_SelectedIndexChanged(object sender, EventArgs e)

{

settings.LookupFoundMultipleRecords = settingsLookupFoundMultipleRecords.SelectedItem.ToString();

}

private void settingscompleteRecords_SelectionChanged(object sender, EventArgs e)

{

settings.CompleteRecordsPostAction = completeRecords.Checked;

}

#endregion Sidebar Options

#region Data Grid

private void dataGridViewMapping_CellValueChanged(object sender, DataGridViewCellEventArgs e)

{

switch (e.ColumnIndex)

{

// If the user changes the CRM Field, check if it is a lookup and process it

case 2:

foreach (object attribute in resultsaved.Attributes)

{

AttributeMetadata a = (AttributeMetadata)attribute;

if (a.LogicalName.ToString() == dataGridViewMapping.Rows[e.RowIndex].Cells[e.ColumnIndex].FormattedValue.ToString()) //Find the CRM field between the metadata

{

if (a.AttributeType.ToString() == "Lookup" || a.AttributeType.ToString() == "Customer" || a.AttributeType.ToString() == "PartyList" || a.AttributeType.ToString() == "Owner") // check if the CRM field is of type Lookup

{

processLookupEntity(e.RowIndex, a.AttributeType.ToString());

}

else

{

processNonLookupEntity(e.RowIndex, a.AttributeType.ToString());

}

if (a.AttributeType.ToString() == "Boolean")

{

processBoolean(e.RowIndex, a.AttributeType.ToString());

}

if (a.AttributeType.ToString() == "Picklist" || a.AttributeType.ToString() == "State" || a.AttributeType.ToString() == "Status")

{

processChoice(e.RowIndex, a.AttributeType.ToString());

}

}

}

break;

case 4:

dataGridViewMapping.Rows[e.RowIndex].Cells["lkpTargetfield"].Value = null;

processLookupField(e.RowIndex);

break;

}

}

private void processLookupEntity(int row, string dataType)

{

// make the lookup columns visible

dataGridViewMapping.Columns["lkpTargetEntity"].Visible = true;

dataGridViewMapping.Columns["lkpTargetfield"].Visible = true;

labelLookupFoundMultipleRecords.Visible = true;

settingsLookupFoundMultipleRecords.Visible = true;

//Flag row as lookup

lookupscount++;

dataGridViewMapping.Rows[row].Cells["IsLookup"].Value = true;

// Unlock the lookup fields

DataGridViewComboBoxCell data1 = dataGridViewMapping.Rows[row].Cells[4] as DataGridViewComboBoxCell;

data1.ReadOnly = false;

data1.DisplayStyle = DataGridViewComboBoxDisplayStyle.DropDownButton;

DataGridViewComboBoxCell data2 = dataGridViewMapping.Rows[row].Cells[5] as DataGridViewComboBoxCell;

data2.ReadOnly = false;

data2.DisplayStyle = DataGridViewComboBoxDisplayStyle.DropDownButton;

//Set Data Type

DataGridViewCell data3 = dataGridViewMapping.Rows[row].Cells["DataType"] as DataGridViewCell;

data3.ReadOnly = true;

data3.Style.BackColor = Color.LightGray;

data3.Value = dataType;

}

private void processLookupField(int row)

{

string lkpentityname = Convert.ToString((dataGridViewMapping.Rows[row].Cells[4] as DataGridViewComboBoxCell).FormattedValue.ToString());

InitLookupFields(lkpentityname, row);

}

private void processNonLookupEntity(int row, string dataType)

{

// set is Lookup to false

dataGridViewMapping.Rows[row].Cells["IsLookup"].Value = false;

// Lock the lookup fields

DataGridViewComboBoxCell data1 = dataGridViewMapping.Rows[row].Cells[4] as DataGridViewComboBoxCell;

data1.ReadOnly = true;

data1.Value = null;

data1.DisplayStyle = DataGridViewComboBoxDisplayStyle.Nothing;

DataGridViewComboBoxCell data2 = dataGridViewMapping.Rows[row].Cells[5] as DataGridViewComboBoxCell;

data2.ReadOnly = true;

data2.DisplayStyle = DataGridViewComboBoxDisplayStyle.Nothing;

data2.Value = null;

//Set Data Type

DataGridViewCell data3 = dataGridViewMapping.Rows[row].Cells["DataType"] as DataGridViewCell;

data3.ReadOnly = true;

data3.Style.BackColor = Color.LightGray;

data3.Value = dataType;

}

private void processBoolean(int row, string dataType)

{

dataGridViewMapping.Columns["Truevalue"].Visible = true;

dataGridViewMapping.Columns["Falsevalue"].Visible = true;

dataGridViewMapping.Columns["DefaultValue"].Visible = true;

DataGridViewCell databooltrue = dataGridViewMapping.Rows[row].Cells["Truevalue"] as DataGridViewCell;

databooltrue.ReadOnly = false;

databooltrue.Style.BackColor = Color.LightGray;

DataGridViewCell databoolfalse = dataGridViewMapping.Rows[row].Cells["Falsevalue"] as DataGridViewCell;

databoolfalse.ReadOnly = false;

databoolfalse.Style.BackColor = Color.LightGray;

DataGridViewCell databooldefault = dataGridViewMapping.Rows[row].Cells["DefaultValue"] as DataGridViewCell;

databooldefault.ReadOnly = false;

databooldefault.Style.BackColor = Color.LightGray;

//Set Data Type

DataGridViewCell data3 = dataGridViewMapping.Rows[row].Cells["DataType"] as DataGridViewCell;

data3.ReadOnly = true;

data3.Style.BackColor = Color.LightGray;

data3.Value = dataType;

//fetch for true and false boolean values

RetrieveAttributeRequest retrieveAttributeRequest = new RetrieveAttributeRequest

{

EntityLogicalName = settingsEntity.SelectedItem.ToString(),

LogicalName = Convert.ToString((dataGridViewMapping.Rows[row].Cells[2] as DataGridViewComboBoxCell).FormattedValue.ToString()),

RetrieveAsIfPublished = true

};

RetrieveAttributeResponse retrieveAttributeResponse = (RetrieveAttributeResponse)Service.Execute(retrieveAttributeRequest);

BooleanAttributeMetadata retrievedBooleanAttributeMetadata = (BooleanAttributeMetadata)retrieveAttributeResponse.AttributeMetadata;

string boolTextTrue = retrievedBooleanAttributeMetadata.OptionSet.TrueOption.Label.UserLocalizedLabel.Label;

string boolTextFalse = retrievedBooleanAttributeMetadata.OptionSet.FalseOption.Label.UserLocalizedLabel.Label;

bool boolDefault = retrievedBooleanAttributeMetadata.DefaultValue.Value;

string boolTextDefault;

if (boolDefault)

boolTextDefault = boolTextTrue;

else

boolTextDefault = boolTextFalse;

dataGridViewMapping.Rows[row].Cells["Truevalue"].Value = boolTextTrue;

dataGridViewMapping.Rows[row].Cells["Falsevalue"].Value = boolTextFalse;

dataGridViewMapping.Rows[row].Cells["DefaultValue"].Value = boolTextDefault;

}

private void processChoice(int row, string dataType)

{