private void ImportFile(object obj) { DocumentToAction.Action = ActionType.Import; MessengerCandidate.Default.Send <Document>(DocumentToAction); dialogService.ShowDetailDialog(); if (DocumentToAction.DocumentNames.Length == 0) { return; } try { DataTable dt = GlobalFunctions.ImportDataToDataTable(DocumentToAction.DocumentNames[0]); if (dt.Select("Candidate is null or Status is null").Count() > 0) { MessageBox.Show("Import failed,. Please complete Candidate Name and Status details!"); return; } string fileName = Path.GetFileNameWithoutExtension(DocumentToAction.DocumentNames[0]); dt.Columns.Add("fileName"); foreach (DataRow row in dt.Rows) { row["fileName"] = fileName; } string TempTableName = "##importTable"; string SqlToCreateTable = @" CREATE TABLE ##importTable ( Company NVARCHAR(MAX), Candidate NVARCHAR(MAX), Position NVARCHAR(MAX), [Contact phone] NVARCHAR(MAX), [Contact e-mail] NVARCHAR(MAX), [Status] NVARCHAR(MAX), [Comments] NVARCHAR(MAX), [History of contact] NVARCHAR(MAX), fileName NVARCHAR(MAX) ) "; DBObjects.UploadFileIntoDB(dt, TempTableName, SqlToCreateTable); LoadData(); addConfigsToCandidates(); LoadViews(); //MessengerConfigProject.Default.Send<ConfigProject>(ConfigProjectCollection.FirstOrDefault()); string newProjectName = fileName.Substring(fileName.IndexOf("-") + 1, fileName.Length - (fileName.IndexOf("-") + 1)).Substring(0, fileName.Substring(fileName.IndexOf("-") + 1, fileName.Length - (fileName.IndexOf("-") + 1)).IndexOf('_', fileName.Substring(fileName.IndexOf("-") + 1, fileName.Length - (fileName.IndexOf("-") + 1)).IndexOf('_') + 1)).Trim(); configProjectMessenger.RaiseConfigProjectChanged(ConfigProjectCollection.Where(e => e.ProjectName == newProjectName).FirstOrDefault()); MessageBox.Show("import success"); } catch (Exception ex) { } }
private void OnConfigProjectChanged(object sender, ConfigProjectValueChangedEventArgs e) { var receivedConfigProject = e.ConfigProject; if (!ConfigProjectCollection.Any(cp => cp.Id == receivedConfigProject.ConfigProjectLibID)) { ConfigProjectCollection.Add(receivedConfigProject); } }