Saving Files Into Database Using .NET Web Services

using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.IO;
using System.Configuration;
using Microsoft.Practices.EnterpriseLibrary.Data.Sql;

namespace FileTransferWebService
{
    [WebService(Namespace = "http://tempuri.org/")]
    [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
    [System.ComponentModel.ToolboxItem(false)]
    public class FileTransfer : System.Web.Services.WebService
    {
        [WebMethod]
        public string GetTempFilename()
        {
            try
            {
                Guid g = Guid.NewGuid();
                //We have to create temporary file on server with unique name. 
                //In this case it will be new Guid.
                FileStream fs = new FileStream(Server.MapPath(g.ToString()), FileMode.Create);
                fs.Close();
                return g.ToString();
            }
            catch (Exception err)
            {
                throw new Exception("GetTempFilename: " + err.Message);
            }
        }

        [WebMethod]
        public void AppendToTempFile(string tempFilename, byte[] data)
        {
            try
            {
                //This method appends block of data to the end of the temporary file.
                FileStream fs = new FileStream(Server.MapPath(tempFilename), FileMode.Append);
                BinaryWriter bw = new BinaryWriter(fs);
                bw.Write(data);
                bw.Close();
                fs.Close();
            }
            catch (Exception err)
            {
                throw new Exception("AppendToTempFile: " + err.Message);
            }
        }

        [WebMethod]
        public void SaveFileIntoDatabase(string filename, string tempFilename)
        {
            SqlDatabase sqlDatabase = new SqlDatabase(ConfigurationManager.ConnectionStrings["ftConnString"].ConnectionString);
            //Now we must get all bytes from file and put them into fileData byte array.
            //This byte array we later save on database into File table.

            byte[] fileData = GetBytes(tempFilename);

            string sql = "spFile_Add";

            SqlCommand sqlCommand = sqlDatabase.GetStoredProcCommand(sql) as SqlCommand;
            try
            {
                sqlDatabase.AddInParameter(sqlCommand, "@Filename", SqlDbType.VarChar, filename);
                sqlDatabase.AddInParameter(sqlCommand, "@Content", SqlDbType.VarBinary, fileData);
                sqlDatabase.ExecuteNonQuery(sqlCommand);
            }
            catch (Exception err)
            {
                throw new Exception("SaveFileIntoDatabase: " + err.Message);
            }
        }

        public byte[] GetBytes(string path)
        {
            FileStream fs=null;
            BinaryReader br=null;
            try
            {
                byte[] buffer = null;
                fs = new FileStream(Server.MapPath(path), FileMode.Open, FileAccess.Read);
                br = new BinaryReader(fs);
                long numBytes = new FileInfo(Server.MapPath(path)).Length;
                buffer = br.ReadBytes((int)numBytes);
                br.Close();
                fs.Close();
                return buffer;
            }
            catch (Exception err)
            {
                throw new Exception("SaveFileIntoDatabase: " + err.Message);
            }
        }
    }
}