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); }