/// <summary>
/// Fetches the data table.
/// </summary>
/// <param name="storedProcedure">The stored procedure.</param>
/// <returns>DataSet</returns>
public static DataTable FetchDataTable(string storedProcedure)
{
return(SAL.FetchDataTable(storedProcedure));
}
/// <summary>
/// Fetches the data table.
/// </summary>
/// <param name="storedProcedure">The stored procedure.</param>
/// <param name="paramAndValue">The param and value.</param>
/// <returns>DataSet</returns>
public static DataTable FetchDataTable(string storedProcedure, IDictionary paramAndValue)
{
return(SAL.FetchDataTable(storedProcedure, paramAndValue));
}
/// <summary>
/// Fetches the SP output (returntype - object).
/// </summary>
/// <param name="storedProcedure">The stored procedure.</param>
/// <param name="paramAndValue">The param and value.</param>
/// <returns>the object</returns>
public static object FetchSpObject(string storedProcedure, IDictionary paramAndValue)
{
return(SAL.FetchSpObject(storedProcedure, paramAndValue));
}
/// <summary>
/// Fetches the data set.
/// </summary>
/// <param name="storedProcedure">The stored procedure.</param>
/// <returns>DataSet</returns>
public static DataSet FetchDataSet(string storedProcedure)
{
return(SAL.FetchDataSet(storedProcedure));
}
/// <summary>
/// Executes the SP.
/// </summary>
/// <param name="storedProcedure">The stored procedure.</param>
/// <param name="paramAndValue">The param and value.</param>
/// <returns>Number of Row Affected</returns>
public static int ExecuteSP(string storedProcedure, IDictionary paramAndValue)
{
return(SAL.LoadProcedureItem(storedProcedure, paramAndValue));
}