{
int rowsAffected=0;
string sql = "insert into publishers(pub_id,pub_name,city,state,country) values
(@pub_id,@pub_name,@city,@state,@country)";
SqlParameter [] pars;
if((pars=SqlHelperParameterCache.GetCachedParameterSet(connectionArg, sql))== null)
{
pars = new SqlParameter[5];
pars[0] = new SqlParameter("@pub_id", SqlDbType.VarChar);
pars[1] = new SqlParameter("@pub_name", SqlDbType.VarChar);
pars[2] = new SqlParameter("@city", SqlDbType.VarChar);
pars[3] = new SqlParameter("@state", SqlDbType.VarChar);
pars[4] = new SqlParameter("@country", SqlDbType.VarChar);
SqHelperParameterCache.CacheParameterSet(connectionArg , sql, pars);
}
pars[0].Value = pub_idArg;
pars[1].Value = pub_nameArg;
pars[2].Value = cityArg;
pars[3].Value = stateArg;
pars[4].Value = countryArg;
try
{
if (transactionArg ==
null)
rowAffected = SqlHelper.ExecuteNonQuery(connectionArg, CommandType.Text, sql, pars);
else
rowAffected = SqlHelper.ExecuteNonQuery(transactionArg, CommandType.Text, sql, pars);
}
catch(System.Exception ex)
{
throw new System.ApplicationException(ex.Message);
}
return rowsAffected;
}