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 RefreshMapSetting()
{
dataGrid_mapping.DataSource = null;
dataGrid_mapping.SelectAll();
dataGrid_mapping.ClearSelection();
comboBox_ExcelTemplate.Items.Clear();
IAccountSettings result = userExcelAccounts.SingleOrDefault(x => x.Name == cmbAccounts.SelectedItem.ToString());
if (SettingsManager.GetDetailsForAccount(loggedUser, result.ID) != null)
{
userExcelFullAccount = (ExcelAccountSettings)SettingsManager.GetDetailsForAccount(loggedUser, result.ID);
}
if (userExcelFullAccount.Template.Count > 0)
{
comboBox_ExcelTemplate.Items.Add(userExcelFullAccount.Template.First().TemplateName);
}
}
private void comboBox_shared_SelectedIndexChanged(object sender, EventArgs e)
{
if (comboBox_shared.SelectedItem != null)
{
IAccountSettings selectedAccount = sharedUserExcelAccounts.FirstOrDefault(x => x.Name == comboBox_shared.SelectedItem.ToString());
userExcelFullAccount = (ExcelAccountSettings)loggedUser.GetDetailsForAccount(selectedAccount.ID, selectedAccount.Owner);
cmbTokens.Text = String.Empty;
if (userExcelFullAccount != null)
{
cmbTokens.Items.Clear();
foreach (var item in userExcelFullAccount.Tokens)
{
cmbTokens.Items.Add(item.TokenName);
}
btn_delete_account.Enabled = true;
groupBoxTokens.Show();
MakeFormReadOnly();
comboBox_ExcelTemplate.Items.Clear();
if (userExcelFullAccount.Template.Count > 0)
{
comboBox_ExcelTemplate.Items.Add(userExcelFullAccount.Template.First().TemplateName);
}
}
}
}
private void GetSelectedAccountAndFillTokensToControl()
{
if (cmbAccounts.SelectedItem != null)
{
IAccountSettings selectedAccount = userExcelAccounts.FirstOrDefault(x => x.Name == cmbAccounts.SelectedItem.ToString());
userExcelFullAccount = (ExcelAccountSettings)loggedUser.GetDetailsForAccount(selectedAccount.ID, selectedAccount.Owner);
cmbTokens.Items.Clear();
cmbTokens.Text = String.Empty;
panelSelectFolderForFiles.Show();
pathToFolder = userExcelFullAccount.GetPathToCurrentFolderForUserFromConfigFile(new AuthorizationResult(true, loggedUser));
if (!String.IsNullOrEmpty(pathToFolder))
{
txtCurrentFolder.Text = pathToFolder;
panelSelectFolderForFiles.Show();
}
foreach (var item in userExcelFullAccount.Tokens)
{
cmbTokens.Items.Add(item.TokenName);
}
}
else if (cmbAccounts.SelectedItem != null && dataGrid_mapping.Rows.Count > 1)
{
FillDataGridWithExistingMapping();
}
}
private void btnNewAccountForExcel_Click(object sender, EventArgs e)
{
panelNewAccount.Visible = true;
textBox_NameNewAccountExcel.Text = String.Empty;
newAccountSetting = new ExcelAccountSettings();
}
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 ExcelAdapter(Byte[] bytes, Int32 tokID)
{
excelPackegInBytes = bytes;
currentAccount = (ExcelAccountSettings)SettingsManager.GetAccountByTokenID(tokID);
tokenID = tokID;
}
public ExcelAdapter(IAccountSettings account, Byte[] bytes)
{
currentAccount = (ExcelAccountSettings)account;
excelPackegInBytes = bytes;
}
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;
}
}
