public void PerformSpNonQuery(String storedProcedureName, SqlParameterHandler handler, int commandTimeout)
{
ExecuteCommand(cmd =>
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = storedProcedureName;
if (commandTimeout != 0)
{
cmd.CommandTimeout = commandTimeout;
}
handler(cmd.Parameters);
cmd.ExecuteNonQuery();
});
}
public T PerformSpScalar <T>(String storeProcedure, SqlParameterHandler handler, int commandTimeout)
{
return(ExecuteCommand(cmd =>
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = storeProcedure;
if (commandTimeout != 0)
{
cmd.CommandTimeout = commandTimeout;
}
handler(cmd.Parameters);
var x = cmd.ExecuteScalar();
return (T)x;
}));
}
public void PerformSQLNonQuery(String commandText, SqlParameterHandler handler, int commandTimeout)
{
ExecuteCommand(cmd =>
{
cmd.CommandType = CommandType.Text;
cmd.CommandText = commandText;
if (commandTimeout != 0)
{
cmd.CommandTimeout = commandTimeout;
}
handler(cmd.Parameters);
cmd.ExecuteNonQuery();
}
);
}
public DataTable PerformSpDataTable(String storedProcedure, SqlParameterHandler handler, int commandTimeout)
{
return(ExecuteCommand(cmd =>
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = storedProcedure;
if (commandTimeout != 0)
{
cmd.CommandTimeout = commandTimeout;
}
handler(cmd.Parameters);
using (var reader = cmd.ExecuteReader())
{
DataTable table = new DataTable();
table.Load(reader);
return table;
}
}));
}
public void PerformSpNonQuery(String storedProcedure, SqlParameterHandler handler)
{
PerformSpNonQuery(storedProcedure, handler, 0);
}
public T PerformSpScalar <T>(String storedProcedure, SqlParameterHandler handler)
{
return(PerformSpScalar <T>(storedProcedure, handler, 0));
}
public DataTable PerformSpDataTable(String storedProcedure, SqlParameterHandler handler)
{
return(PerformSpDataTable(storedProcedure, handler, 0));
}
public void PerformSQLNonQuery(String commandText, SqlParameterHandler handler)
{
PerformSQLNonQuery(commandText, handler, 0);
}
