/// <summary>
/// Excecute Sps
/// </summary>
/// <param name="spCollection"></param>
/// <param name="Connection"></param>
/// <returns></returns>
public static bool ExecuteSps(StoredProcedureCollection spCollection, SqlConnection Connection)
{
try
{
foreach (StoredProcedure spData in spCollection)
{
SqlCommand cmd = new SqlCommand();
int i = 0;
if (Connection.State != ConnectionState.Open)
{
Connection.Open();
}
cmd.Connection = Connection;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = spData.ProcName;
IEnumerator myEnumerator = spData.GetParams().GetEnumerator();
while (myEnumerator.MoveNext())
{
ParamData pData = (ParamData)myEnumerator.Current;
cmd.Parameters.Add(pData.pName, pData.pDataType);
cmd.Parameters[i].Value = pData.pValue;
i = i + 1;
}
cmd.ExecuteNonQuery();
}
return(true);
}
catch (Exception exc)
{
return(false);
}
}
/// <summary>
/// set the parameters
/// </summary>
/// <param name="pName"></param>
/// <param name="pDataType"></param>
/// <param name="pValue"></param>
/// <returns></returns>
///
public void SetParam(string pName, SqlDbType pDataType, string pValue)
{
ParamData pData = new ParamData(pName, pDataType, pValue);
sParams.Add(pData);
}
