public int getIntByQueryParameter(string query, string Column, int Count, ParameterBack p)
{
int name = 0; string Variable = "@Parameter";
using (SqlConnection con = new SqlConnection(connectionString))
{
using (SqlCommand cmd = new SqlCommand(query, con))
{
for (int i = 1; i <= Count; i++)
{
cmd.Parameters.AddWithValue(Variable + i, p.getParameter(i));
}
using (SqlDataAdapter sda = new SqlDataAdapter())
{
cmd.Connection = con;
sda.SelectCommand = cmd;
using (dt = new DataTable())
{
sda.Fill(dt);
}
}
}
}
foreach (DataRow row in dt.Rows)
{
name = Convert.ToInt32(row[Column]);
}
return(name);
}
public Boolean CheckByQueryParameter(string query, int Count, ParameterBack p)
{
string Variable = "@Parameter";
Boolean name = false;
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
using (SqlCommand command = new SqlCommand(query, connection))
{
for (int i = 1; i <= Count; i++)
{
command.Parameters.AddWithValue(Variable + i, p.getParameter(i));
}
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
if (reader["ID"] != DBNull.Value)
{
name = true;
}
}
}
}
return(name);
}
public void ChangeByQueryParameter(string query, int Count, ParameterBack p)
{
string Variable = "@Parameter";
using (SqlConnection con = new SqlConnection(connectionString))
{
using (SqlCommand cmd = new SqlCommand(query, con))
{
con.Open();
for (int i = 1; i <= Count; i++)
{
cmd.Parameters.AddWithValue(Variable + i, p.getParameter(i));
}
cmd.ExecuteNonQuery();
con.Close();
}
}
}