public DataSet GetAllTransactionDataSources(String StockTransID)
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
Boolean blnTranStarted = false;
String spName = String.Empty;
try
{
DataSet dsLoad = new DataSet();
DataSet dsReturn = new DataSet();
conManager.BeginTransaction();
blnTranStarted = true;
spName = String.Format("Exec sprptStorckTransactionAll @StockTransID = '{0}'", StockTransID);
conManager.OpenDataSetThroughAdapter(spName, ref dsLoad, true);
dsLoad.Tables[0].TableName = "sprptStorckTransactionAll";
dsReturn.Tables.Add(dsLoad.Tables[0].Copy());
conManager.CommitTransaction();
blnTranStarted = false;
return dsReturn;
}
catch (Exception ex)
{
if (blnTranStarted)
{
conManager.RollBack();
}
throw (ex);
}
}