public DataTable GetProviderInfoBySubProcessID(Int64 AtulInstanceProcessSubProcessID)
{
SqlCommand cmd = new SqlCommand("exec dbo.Atul_GetProviderInfoBySubProcessID_sp @AtulInstanceProcessSubProcessID", this._connection);
cmd.Parameters.Add(new SqlParameter("@AtulInstanceProcessSubProcessID", AtulInstanceProcessSubProcessID));
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataTable returnTable = new DataTable(); returnTable.TableName = "atulinstanceSubProcessProviderInfo";
da.Fill(returnTable);
return returnTable;
}