Sending a DataTable to a Stored Procedure

#region Developer Notes
//Objective : To execute the procedure and return data to the business logic page
//Created By : Amit Kumar
//Created Date : 12/01/2012
//Company : KALS Information System Ltd, Bangalore
/************************************************************************************************
 * Modified date        Modified By         Version              Reasons for Modification       *             
 * **********************************************************************************************
 *                                                                                              *
 * **********************************************************************************************
//Considerations: Through this class we can maintain business logic of the Address Details Page
//
//Functions in this Class:
 // 1. fnConOpen            :   Opens the connection
 *  2. fnConClose           :   Closes the connection
 *  3. fnEXECStoredProc     :   Executes a procedures which returns a dataset
 *  4. fnStoredProc         :   Executes a procedures and gives datatable as its parameter
*/
#endregion

#region Namespaces
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
#endregion

/// <summary>
/// Objective : Data access layer class
/// </summary>
public class csDBMgr
{
    #region Connection String
    /// <summary>
    /// Objective : Specifies connection string
    /// </summary>
    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["EmpCon"].ConnectionString);
    #endregion

    #region Connection Open
    /// <summary>
    /// Type        : Function
    /// Objective   : Opens a connection
    /// </summary>
    public void fnConOpen() 
    {
        if (con.State != ConnectionState.Open) {
            con.Open();
        }
    }
    #endregion

    #region Connection Close
    /// <summary>
    /// Type        : Function
    /// Objective   : Closes a connection
    /// </summary>
    public void fnConClose() 
    {
        if (con.State != ConnectionState.Closed) 
        {
            con.Close();
        }
    }
    #endregion

    #region Execute Procedure Which Returns Dataset
    /// <summary>
    /// Type        : Function
    /// Objective   : Execute procedure which returns dataset
    /// Parameters  :
    ///         strProcName - Stored Procedure Name
    ///         dtParamDetails - Stored procedure parameters details
    /// </summary>
    /// <param name="strProcName"></param>
    /// <param name="dtParamDetails"></param>
    /// <returns></returns>
    public DataSet fnExecStoredProc()
    {
        DataSet dsRecords = new DataSet();
        try
        {
            fnConOpen();
            SqlCommand cmdProc = new SqlCommand("spEmpDetails", con);
            cmdProc.CommandType = CommandType.StoredProcedure;
            cmdProc.Parameters.AddWithValue("@Type", "FetchDetails");
            cmdProc.Parameters.AddWithValue("@Details", null);
            SqlDataAdapter sdaTablesColl = new SqlDataAdapter(cmdProc);
            sdaTablesColl.Fill(dsRecords);
            cmdProc.Dispose();
            sdaTablesColl.Dispose();
        }
        catch (Exception )
        {
            dsRecords = null;
        }
        finally {
            fnConClose();
        }
        return dsRecords;
    }
    #endregion

    #region Execute Procedure Which Returns string
    /// <summary>
    /// Type        : Function
    /// Objective   : Execute procedure and make changes in the database table and returns the string
    /// Parameters  :
    ///         dtDetails - DataTable with new and edited values
    /// </summary>
    /// <param name="strProcName"></param>
    /// <param name="dtParamDetails"></param>
    /// <returns></returns>
    public string fnStoredProc(DataTable dtDetails)
    {
        string strMsg = "";
        try
        {
            fnConOpen();
            SqlCommand cmdProc = new SqlCommand("spEmpDetails", con);
            cmdProc.CommandType = CommandType.StoredProcedure;
            cmdProc.Parameters.AddWithValue("@Type", "InsertDetails");
            cmdProc.Parameters.AddWithValue("@Details", dtDetails);
            cmdProc.ExecuteNonQuery();
            strMsg = "Saved successfully.";
        }
        catch (SqlException e) {
            //strMsg = "Data not saved successfully.";
            strMsg = e.Message.ToString();
        }
        finally 
        {
            fnConClose();
        }
        return strMsg;
    }
    #endregion

}