public ServiceAccountDTO ConvertToDAO(IAccountSettings serviceAccount)
{
ServiceAccountDTO target = new ServiceAccountDTO();
ExcelAccountSettings currentAccount = (ExcelAccountSettings)serviceAccount;
target.ServiceAccountId = currentAccount.ID;
target.ServiceAccountName = currentAccount.Name;
target.Source = Sources.Excel;
target.MinUpdateTime = serviceAccount.MinUpdateTime;
target.AccountVersion = serviceAccount.AccountVersion;
List <TokenDTO> tok = new List <TokenDTO>();
List <TemplateDTO> templ = new List <TemplateDTO>();
if (currentAccount.Tokens.Count > 0)
{
foreach (ExcelAccountToken token in currentAccount.Tokens)
{
TokenDTO localtok = token.ConvertToDAO(token);
tok.Add(localtok);
}
target.Tokens = tok.ToArray();
}
if (currentAccount.Template.Count > 0)
{
foreach (ExcelAccountTemplate template in currentAccount.Template)
{
TemplateDTO localtemp = template.ConvertToDAO(template);
templ.Add(localtemp);
}
target.MappingTemplates = templ.ToArray();
}
return(target);
}
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);
}
}
}
}
public IAccountSettings ConvertFromDAO(ServiceAccountDTO serviceAccount)
{
ExcelAccountSettings target = new ExcelAccountSettings();
target.ID = serviceAccount.ServiceAccountId;
target.Name = serviceAccount.ServiceAccountName;
target.Source = serviceAccount.Source;
target.AccountVersion = serviceAccount.AccountVersion;
target.MinUpdateTime = serviceAccount.MinUpdateTime;
target.Tokens = new List <ExcelAccountToken>();
target.Template = new List <ExcelAccountTemplate>();
if (serviceAccount.Tokens.Length > 0)
{
foreach (TokenDTO token in serviceAccount.Tokens)
{
ExcelAccountToken targetToken = new ExcelAccountToken();
targetToken = (ExcelAccountToken)targetToken.ConvertFromDAO(token);
target.Tokens.Add(targetToken);
}
}
if (serviceAccount.MappingTemplates.Length > 0)
{
foreach (TemplateDTO template in serviceAccount.MappingTemplates)
{
ExcelAccountTemplate targetTemplate = new ExcelAccountTemplate();
targetTemplate = (ExcelAccountTemplate)targetTemplate.ConvertFromDAO(template);
target.Template.Add(targetTemplate);
}
}
return(target);
}
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 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 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 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;
}
}
private void btnNewAccountForExcel_Click(object sender, EventArgs e)
{
panelNewAccount.Visible = true;
textBox_NameNewAccountExcel.Text = String.Empty;
newAccountSetting = new ExcelAccountSettings();
}
