예제 #1
0
        public void Insert(FileInfo fileInfo, AudioFileInfo audioFileInfo)
        {
            Database database = (new DbFactory()).CreateDatabase();

            string spName = ((new Resources()).CreateInsertSPList())[TableList.Track].ToString();

            ExecuteStoredProcWithParam executeStoredProcWithParam = 
                    new ExecuteStoredProcWithParam(database, spName);

            executeStoredProcWithParam.AddInParameter(database,
                InsertValueByTableName(fileInfo.DirectoryName, TableList.Path),
                @"PathID");

            executeStoredProcWithParam.AddInParameter(database,
                InsertValueByTableName(audioFileInfo.Artist, TableList.Artist),
                @"ArtistID");

            executeStoredProcWithParam.AddInParameter(database,
                InsertValueByTableName(audioFileInfo.Album, TableList.Album),
                @"AlbumID");

            executeStoredProcWithParam.AddInParameter(database,
                InsertValueByTableName(audioFileInfo.Genre, TableList.Genre),
                @"GenreID");

            executeStoredProcWithParam.AddInParameter(database,
                InsertValueByTableName(audioFileInfo.Bitrate, TableList.Bitrate),
                @"BitrateID");

            executeStoredProcWithParam.AddInParameter(database,
              audioFileInfo.Title,
              @"TrackTitle");

            executeStoredProcWithParam.AddInParameter(database,
              fileInfo.Name,
              @"FileName");

            executeStoredProcWithParam.AddInParameter(database,
              fileInfo.Length,
              @"FileSize");

            string newName = string.Empty;

            if (string.IsNullOrEmpty(audioFileInfo.Artist) && string.IsNullOrEmpty(audioFileInfo.Title))
            {
                newName = fileInfo.Name;
            }
            else
            {
                newName = audioFileInfo.Artist + "_" + audioFileInfo.Title;
            }

            executeStoredProcWithParam.AddInParameter(database,
              newName,
              @"NewFileName");

            executeStoredProcWithParam.AddOutParameter(database, @"return_value");
            executeStoredProcWithParam.ExecuteSpSetResultValue(database, @"return_value");

        }
예제 #2
0
        private int InsertValueByTableName(string value, TableList tableName)
        {
            Database database = (new DbFactory()).CreateDatabase();

            string spName = ((new Resources()).CreateInsertSPList())[tableName].ToString();

            ExecuteStoredProcWithParam executeStoredProcWithParam = new ExecuteStoredProcWithParam(database, spName);

            executeStoredProcWithParam.AddInParameter(database, value, @"ValueToInsert");
            executeStoredProcWithParam.AddOutParameter(database, @"return_value");

            return executeStoredProcWithParam.ExecuteSpSetResultValue(database, @"return_value");
        }
예제 #3
0
        public void ClearDataBase()
        {
            Database database = (new DbFactory()).CreateDatabase();

            ExecuteStoredProcWithParam executeStoredProcWithParam =
                new ExecuteStoredProcWithParam(
                    database, 
                    (new Resources().CreateSelectSPList())[TableList.ClearDataBase].ToString());

            executeStoredProcWithParam.AddOutParameter(database, @"return_value");
            executeStoredProcWithParam.ExecuteSpSetResultValue(database, @"return_value");
        }