internal static DataTable AdapterFill(string sprocName)
{
DataTable dataTable = new DataTable();
try
{
using (SqlConnection con = new SqlConnection(_Connection))
{
SqlCommand cmd = new SqlCommand(sprocName, con);
cmd.CommandType = CommandType.StoredProcedure;
for (int index = 0; index < _ParamName.Count; index++)
{
cmd.Parameters.AddWithValue(_ParamName[index], _ParamValue[index]);
}
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
sda.Fill(dataTable);
}
}
}
catch (Exception ex)
{
DBCommands.RecordError(ex);
}
finally
{
EmptyParams();
}
return(dataTable);
}
internal static bool ExecuteNonQuery(string sprocName)
{
try
{
using (SqlConnection con = new SqlConnection(_Connection))
{
SqlCommand cmd = new SqlCommand(sprocName, con);
cmd.CommandType = CommandType.StoredProcedure;
for (int index = 0; index < _ParamName.Count; index++)
{
cmd.Parameters.AddWithValue(_ParamName[index], _ParamValue[index]);
}
con.Open();
cmd.ExecuteNonQuery();
return(true);
}
}
catch (Exception ex)
{
DBCommands.RecordError(ex);
return(false);
}
finally
{
EmptyParams();
}
}
internal static string ExecuteScalar(string sprocName)
{
try
{
using (SqlConnection con = new SqlConnection(_Connection))
{
SqlCommand cmd = new SqlCommand(sprocName, con);
cmd.CommandType = CommandType.StoredProcedure;
for (int index = 0; index < _ParamName.Count; index++)
{
cmd.Parameters.AddWithValue(_ParamName[index], _ParamValue[index]);
}
con.Open();
var result = cmd.ExecuteScalar();
if (result != null)
{
return(result.ToString());
}
else
{
return(null);
}
}
}
catch (Exception ex)
{
DBCommands.RecordError(ex);
return(null);
}
finally
{
EmptyParams();
}
}