Esempio n. 1
0
        public Worker Create(Worker worker)
        {
            using (IDbConnection connection = DatabaseService.CreateOpenConnection())
            {
                Worker userExist = new Worker();
                worker.Id = Guid.NewGuid();
                if (!(userExist = Get(worker.Login)).isEmpty())
                {
                    return(userExist);
                }

                FolderTreeService folderTreeService = new FolderTreeService(_databaseService);
                folderTreeService.Create(new Folder()
                {
                    Name     = PrivateFolders,
                    ParentId = Guid.Empty,
                    Type     = 0,
                    OwnerId  = worker.Id,
                    Data     = string.Empty
                }
                                         );
                using (IDbCommand command = DatabaseService.CreateStoredProcCommand(SpCreateWorker, connection))
                {
                    DatabaseService.AddParameterWithValue(IdColumn, worker.Id, command);
                    DatabaseService.AddParameterWithValue(NameColumn, worker.Name, command);
                    DatabaseService.AddParameterWithValue(LoginColumn, worker.Login, command);
                    DatabaseService.AddParameterWithValue(PasswordColumn, worker.Password, command);

                    command.ExecuteNonQuery();
                    return(worker);
                }
            }
        }
Esempio n. 2
0
 private void SaveButton_Click(object sender, EventArgs e)
 {
     if (pathTextBox.Text != "")
     {
         var directoryInfo = new DirectoryInfo(pathTextBox.Text);
         if (directoryInfo.Exists)
         {
             var saveFileDialog = new SaveFileDialog();
             saveFileDialog.Filter     = "JSON Files | *.json";
             saveFileDialog.DefaultExt = "json";
             if (saveFileDialog.ShowDialog() == DialogResult.OK)
             {
                 using (StreamWriter file = File.CreateText(saveFileDialog.FileName))
                 {
                     var folder     = FolderTreeService.GenerateTree(pathTextBox.Text);
                     var serializer = new JsonSerializer();
                     file.Write(JsonConvert.SerializeObject(folder, Formatting.Indented));
                 }
             }
         }
         else
         {
             warning.Text = "Folder path is invalid";
         }
     }
     else
     {
         warning.Text = "Folder path can't be empty";
     }
 }
Esempio n. 3
0
        private IFolderTreeService getFolderTreeService(string databaseName)
        {
            if (string.IsNullOrEmpty(databaseName))
            {
                throw new ArgumentNullException(nameof(databaseName));
            }

            IFolderTreeService folderTreeService;

            if (!_existFolderTreeService.TryGetValue(databaseName, out folderTreeService))
            {
                DatabaseService _databaseService = ((IDatabasesService)_serviceFolderContainer.GetService(typeof(IDatabasesService))).GetDatabasesService()[databaseName];
                folderTreeService = new FolderTreeService(_databaseService);
                _existFolderTreeService.Add(databaseName, folderTreeService);
            }

            return(folderTreeService);
        }