private List<String> Import(string file, out ExcelAccountSettings result)
{
IAccountSettings setingForTest;
ExcelAccountSettings testAcc = new ExcelAccountSettings();
Byte[] fileInByteArray = testAcc.OpenExcelFileAndReturnByteArray(new AuthorizationResult(true, loggedUser), file);
if (fileInByteArray == null)
{
result = null;
return null;
}
SettingsManager.AccountSettingsTest(testAcc, fileInByteArray, out setingForTest);
if (setingForTest != null)
{
ExcelAccountSettings resultFromServices = (ExcelAccountSettings)setingForTest;
ExcelAccountTemplate template = new ExcelAccountTemplate();
template = resultFromServices.Template.FirstOrDefault();
result = (ExcelAccountSettings)setingForTest;
return template.AllFieldsInFile;
}
result = null; ;
return null;
}
private void FillDataGridWithExistingMapping()
{
Dictionary<String, String> templateMapping = new Dictionary<String, String>();
ExcelAccountTemplate template = userExcelFullAccount.Template.FirstOrDefault();
if (template == null)
{
template = new ExcelAccountTemplate();
FillDataGridWithEmptyMapping(template.AllFieldsInTeemplate);
return;
}
templateMapping = userExcelFullAccount.Template.FirstOrDefault().Mapping;
List<string> field = templateMapping.Values.Select(value => value).Where(str => !String.IsNullOrEmpty(str)).ToList();
for (int i = 0; i < templateMapping.Count; i++)
{
if (dataGrid_mapping.Rows.Count < templateMapping.Count)
{
dataGrid_mapping.Rows.Add();
}
DataGridViewTextBoxCell Cell_Template =
(DataGridViewTextBoxCell)dataGrid_mapping.Rows[i].Cells[1];
Cell_Template.Value = templateMapping.ElementAt(i).Key;
if (templateMapping.Count > 0)
{
DataGridViewComboBoxCell comboCell_ITask = (DataGridViewComboBoxCell)dataGrid_mapping.Rows[i].Cells[0];
comboCell_ITask.DataSource = field;
comboCell_ITask.Value = templateMapping.ElementAt(i).Value;
}
else
{
DataGridViewComboBoxCell comboCell_ITask = (DataGridViewComboBoxCell)dataGrid_mapping.Rows[i].Cells[0];
comboCell_ITask.DataSource = field;
comboCell_ITask.Value = "";
}
}
}
private ExcelAccountTemplate Acc_ExcelMapping()
{
ExcelAccountTemplate accEx_template;
if (userExcelFullAccount.Template.Count > 0)
{
accEx_template = userExcelFullAccount.Template.FirstOrDefault();
}
else
{
accEx_template = new ExcelAccountTemplate();
}
for (int i = 0; i < dataGrid_mapping.Rows.Count - 1; i++)
{
DataGridViewComboBoxCell comboCell_file =
(DataGridViewComboBoxCell)dataGrid_mapping.Rows[i].Cells[0];
DataGridViewTextBoxCell combotxtCell =
(DataGridViewTextBoxCell)dataGrid_mapping.Rows[i].Cells[1];
String cellValue = comboCell_file.Value.ToString();
String fieldValue = combotxtCell.Value.ToString();
cellValue = cellValue ?? "";
if (fieldValue == "TaskID")
{
accEx_template.TaskID = cellValue;
continue;
}
if (fieldValue == "SubtaskType")
{
accEx_template.SubtaskType = cellValue;
continue;
}
if (fieldValue == "Summary")
{
accEx_template.Summary = cellValue;
continue;
}
if (fieldValue == "Description")
{
accEx_template.Description = cellValue;
continue;
}
if (fieldValue == "Status")
{
accEx_template.Status = cellValue;
continue;
}
if (fieldValue == "Priority")
{
accEx_template.Priority = cellValue;
continue;
}
if (fieldValue == "Project")
{
accEx_template.Project = cellValue;
continue;
}
if (fieldValue == "CreatedDate")
{
accEx_template.CreatedDate = cellValue;
continue;
}
if (fieldValue == "CreatedBy")
{
accEx_template.CreatedBy = cellValue;
continue;
}
if (fieldValue == "LinkToTracker")
{
accEx_template.LinkToTracker = cellValue;
continue;
}
if (fieldValue == "Source")
{
accEx_template.Source = Sources.Excel;
continue;
}
if (fieldValue == "Estimation")
{
accEx_template.Estimation = cellValue;
continue;
}
if (fieldValue == "TargetVersion")
{
accEx_template.TargetVersion = cellValue;
continue;
}
if (fieldValue == "Comments")
{
accEx_template.Comments = cellValue;
continue;
}
if (fieldValue == "TaskParent")
{
accEx_template.TaskParent = cellValue;
continue;
}
if (fieldValue == "Assigned")
{
accEx_template.Assigned = cellValue;
continue;
}
}
return accEx_template;
}
private void btnSaveSettings_Click(object sender, EventArgs e)
{
if (txtNewTemplateName.Text.Trim() != String.Empty && rtxtMapping.Text.Trim() != String.Empty)
{
ExcelAccountTemplate accEx_template = new ExcelAccountTemplate();
accEx_template = Acc_ExcelMapping();
accEx_template.TemplateName = txtNewTemplateName.Text.Trim();
userExcelFullAccount.Template.Add(accEx_template);
if (SettingsManager.SaveOrUpdateAccount(userExcelFullAccount))
{
ExcelSynchronizer.UpdateWatchibleFiles();
ExcelTab.SelectTab(Settings);
RefreshMapSetting();
btn_AddNewExcelTemplate.Enabled = false;
btn_delete_template.Enabled = true;
dataGrid_mapping.RowCount = 1;
dataGrid_mapping.Rows[0].Visible = true; //не обязательно (если в datagridview не скрывается срока)
for (int i = 0; i < dataGrid_mapping.ColumnCount; i++)
{
dataGrid_mapping[i, 0].Value = null;
}
}
}
else
{
label5.Show();
label5.Text = "Please enter token name and mapping!";
label5.ForeColor = Color.Red;
}
}
private void btnChekMapping_Click(object sender, EventArgs e)
{
IAccountSettings testAccRessult;
ExcelAccountSettings testAcc = new ExcelAccountSettings();
ExcelAccountTemplate accEx_template = new ExcelAccountTemplate();
accEx_template = Acc_ExcelMapping();
accEx_template.TemplateName = txtNewTemplateName.Text.Trim();
testAcc.Template.Add(accEx_template);
if (SettingsManager.AccountSettingsTest(testAcc, testAcc.OpenExcelFileAndReturnByteArray(new AuthorizationResult(true, loggedUser),
cmbTokens.SelectedItem.ToString()), out testAccRessult))
{
btnSaveSettings.Enabled = true;
label5.Hide();
}
else
{
btnSaveSettings.Enabled = false;
label5.Show();
label5.Text = "Cant read from file!";
label5.ForeColor = Color.Red;
}
}
public IAccountSettings TestAccount(IAccountSettings testAccount)
{
currentAccount = (ExcelAccountSettings)testAccount;
if (currentAccount.Template.Count > 0)
{
currentAccount.TestResult = TryReadTasksFromFile();
return currentAccount;
}
else
{
ExcelAccountTemplate newTemplate = new ExcelAccountTemplate();
newTemplate.AllFieldsInFile = GetAllColumnsName(OpenExcelFromByteArray());
if (newTemplate.AllFieldsInFile.Count > 0)
{
currentAccount.TestResult = true;
currentAccount.Template.Add(newTemplate);
}
else
{
currentAccount.TestResult = false;
}
return currentAccount;
}
}
