コード例 #1
0
ファイル: Query.Files.cs プロジェクト: hangmiao/DBLike
        /// <summary>
        /// If file already exists in the database
        /// </summary>
        /// <param name="userName"></param>
        /// <param name="filePath"></param>
        /// <returns>true/false</returns>
        public bool fileAlreadyExist(string userName,string filePath)
        {
            DataBaseConn dbconn = new DataBaseConn(1);
            try
            {
                SqlConnection conn = dbconn.DBConnect();
                string queryString = "SELECT * FROM dbo.FilesInfo WHERE UserName =@UserName AND FilePath = @FilePath";
                SqlCommand command = new SqlCommand(queryString, conn);
                command.Parameters.AddWithValue("@UserName", userName);
                command.Parameters.AddWithValue("@FilePath", filePath);
                SqlDataReader reader = command.ExecuteReader();

                if (reader.Read())
                {
                    return true;
                }
                else
                {
                    return false;
                }

            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                return false;
            }
            finally
            {
                dbconn.DBClose();

            }
        }
コード例 #2
0
ファイル: Query.Files.cs プロジェクト: hangmiao/DBLike
        /// <summary>
        /// insert new file data into database
        /// </summary>
        /// <param name="userName"></param>
        /// <param name="fileName"></param>
        /// <param name="filePath"></param>
        /// <param name="hashVaule"></param>
        /// <param name="timeStamp"></param>
        /// <returns></returns>
        public bool insertNewFileData(string userName, string fileName, string filePath, string hashVaule, DateTime timeStamp)
        {
            DataBaseConn dbconn = new DataBaseConn(1);
            try
            {
                SqlConnection conn = dbconn.DBConnect();
                string queryString = "INSERT INTO dbo.FilesInfo"+
                                     " (FileName, TimeStamp, HashValue, FilePath, UserName) VALUES"+
                                     " (@FileName, @TimeStamp, @HashValue, @FilePath, @UserName)";
                SqlCommand command = new SqlCommand(queryString, conn);
                command.Parameters.AddWithValue("@UserName", userName);
                command.Parameters.AddWithValue("@FilePath", filePath);
                command.Parameters.AddWithValue("@FileName", fileName);
                command.Parameters.AddWithValue("@TimeStamp", timeStamp);
                command.Parameters.AddWithValue("@HashValue", hashVaule);
                Int32 rowsAffected = command.ExecuteNonQuery();
                Console.WriteLine("RowsAffected: {0}", rowsAffected);
                if (rowsAffected == 0)
                {
                    return false;
                }

            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                return false;
            }
            finally
            {
                dbconn.DBClose();

            }
            return true;
        }
コード例 #3
0
ファイル: Query.Files.cs プロジェクト: hangmiao/DBLike
        /// <summary>
        /// update file data in the databse
        /// </summary>
        /// <param name="userName"></param>
        /// <param name="filePath"></param>
        /// <param name="hashVaule"></param>
        /// <param name="timeStamp"></param>
        /// <returns></returns>
        public bool updateFilesData(string userName, string filePath, string hashVaule, DateTime timeStamp)
        {
            DataBaseConn dbconn = new DataBaseConn(1);
            try
            {
                SqlConnection conn =  dbconn.DBConnect();
                string queryString = "UPDATE Users SET TimeStamp=@TimeStamp, HashValue=@HashValue WHERE UserName=@UserName AND FilePath=@FilePath ";
                SqlCommand command = new SqlCommand(queryString, conn);
                command.Parameters.AddWithValue("@TimeStamp", timeStamp);
                command.Parameters.AddWithValue("@HashValue", hashVaule);
                command.Parameters.AddWithValue("@UserName", userName);
                command.Parameters.AddWithValue("@FilePath", filePath);
                Int32 rowsAffected = command.ExecuteNonQuery();
                Console.WriteLine("RowsAffected: {0}", rowsAffected);
                if (rowsAffected == 0)
                {
                    return false;
                }

            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                return false;
            }
            finally
            {
                dbconn.DBClose();
            }
            return true;
        }