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