public bool UpdateNumberVisitor(int count)
{
bool check = true;
NumberVisitor number = new NumberVisitor();
try
{
using (SqlConnection sqlConnection = new SqlConnection(connectionString))
{
SqlCommand sqlCommand = new SqlCommand("Proc_UpdateNumberVisitor", sqlConnection);
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@NumberVisitsId", "55bca65d-5aba-4570-813d-633ea319c8fb");
sqlCommand.Parameters.AddWithValue("@NumberVisitAmount", count);
sqlConnection.Open();
sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
check = true;
}
}
catch (Exception ex)
{
Console.WriteLine("Có lỗi xảy ra: " + ex.Message);
check = false;
}
return(check);
}
public exercise111()
{
NumberVisitor numberVistor = new NumberVisitor();
numberVistor.onMyFloat(new MyFloat());
numberVistor.onMyInt(new MyInt());
Console.Read();
}
public int GetNumberVisitor()
{
var count = 0;
NumberVisitor number = new NumberVisitor();
try
{
using (SqlConnection sqlConnection = new SqlConnection(connectionString))
{
SqlCommand sqlCommand = new SqlCommand("Proc_GetNumberVisitor", sqlConnection);
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlConnection.Open();
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
while (sqlDataReader.Read())
{
count = int.Parse(sqlDataReader["NumberVisitAmount"].ToString());
}
sqlConnection.Close();
}
}
catch (Exception ex)
{
Console.WriteLine("Có lỗi xảy ra: " + ex.Message);
}
return(count);
}
