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(); }