/// <summary>
/// Insert the data into database
/// </summary>
/// <param name="StoredProcedure"></param>
/// <param name="parms">List<SqlParameter></param>
/// <param name="ConnectionName"></param>
public static Int32 InsertData(String StoredProcedure, List <SqlParameter> parms, String ConnectionName)
{
SqlCommand myCommand = null;
Int32 result = 0;
try
{
myCommand = DbConnectionHelper.OpenCommand(StoredProcedure, parms, ConnectionName);
myCommand.ExecuteNonQuery();
result = (Int32)myCommand.Parameters["@RETURN_VALUE"].Value;
}
catch (Exception err)
{
// do something with the error
throw err;
}
finally
{
DbConnectionHelper.CloseCommand(myCommand);
}
return(result);
}
