private void Statistics_Load(object sender, EventArgs e)
{
DataBaseCommunication dbTool = new DataBaseCommunication();
string querry1 = "SELECT COUNT(UserID) FROM USERS";
string querry2 = "SELECT COUNT(UserID) FROM DELETEDUSERS";
string querry3 = "SELECT COUNT(MessageID) FROM MESSAGES";
string querry4 = "SELECT COUNT(DISTINCT MessageID) FROM USERSMESSAGES";
richTextBox1.Text += "MESSAGES AND USERS STATISTICS\r\n\r\n\r\n\r\n\r\n*EXISTNG USERS: " + dbTool.HowManyExistsInDatabase(querry1) + "\r\n\r\n";
richTextBox1.Text += "*DELETED USERS : " + dbTool.HowManyExistsInDatabase(querry2) + "\r\n\r\n";
richTextBox1.Text += "*TOTAL NUMBER OF SENDED MESSAGES : " + dbTool.HowManyExistsInDatabase(querry3) + "\r\n\r\n";
richTextBox1.Text += "*ACTIVE MESSAGES : " + dbTool.HowManyExistsInDatabase(querry4) + "\r\n\r\n*message deactivated when deleted\r\n from sender and from receiver" + "\r\n\r\n";
}
