private void saveFile(string sourceFilePath, string id)
        {
            string fileName             = System.IO.Path.GetFileName(sourceFilePath);
            string dectinationDirectory = GlobalFunctions.CVfolderPath + id + "\\";

            if (!Directory.Exists(dectinationDirectory))
            {
                Directory.CreateDirectory(dectinationDirectory);
            }
            if (File.Exists(dectinationDirectory + fileName))
            {
                if ((MessageBox.Show("File you are trying to copy already exists in this folder. Would you like to remove old one?", "", MessageBoxButton.YesNo)) == MessageBoxResult.Yes)
                {
                }
                else
                {
                    return;
                }
            }

            try
            {
                File.Copy(sourceFilePath, dectinationDirectory + fileName);
                ((Candidate)MainView.SelectedItem).IsCvUploaded = true;
                GlobalFunctions.ExecProcedureWithArgs("UPDATE_CV", "@ID" + "-" + ((Candidate)MainView.SelectedItem).ID, "@CV_UPLOADED" + "-" + true);
                MessageBox.Show("File attached succesfully ", "", MessageBoxButton.OK, MessageBoxImage.Information);
            }
            catch (Exception ex)
            {
                MessageBox.Show("File was not deleted! " + ex.Message, "", MessageBoxButton.OK, MessageBoxImage.Error);
            }
        }
        private void removeFile(string filePath, string dectinationDirectory)
        {
            if (!GlobalFunctions.IsFileLocked(filePath))
            {
                try
                {
                    string[] files = Directory.GetFiles(dectinationDirectory);
                    File.Delete(filePath);
                    if (files.Length == 1)
                    {
                        ((Candidate)MainView.SelectedItem).IsCvUploaded = false;

                        GlobalFunctions.ExecProcedureWithArgs("UPDATE_CV", "@ID" + "-" + ((Candidate)MainView.SelectedItem).ID, "@CV_UPLOADED" + "-" + false);
                    }
                    MessageBox.Show("File deleted succesfully ", "", MessageBoxButton.OK, MessageBoxImage.Information);
                }
                catch (Exception ex)
                {
                    MessageBox.Show("File was not deleted! " + ex.Message, "", MessageBoxButton.OK, MessageBoxImage.Error);
                }
            }
            else
            {
                MessageBox.Show("File is currently locked, cannot be deleted", "", MessageBoxButton.OK, MessageBoxImage.Error);
            }
        }