// кнопка "Обновить общую статистику (быстро)" private void button7_Click(object sender, EventArgs e) { BookDBConnect currentBookDBConnect = new BookDBConnect(); currentBookDBConnect.SetSQLConnectionToAzureDBLitClassicBooks(); currentBookDBConnect.UpdateTotalStatisticsShort(); }
private void backgroundWorker2_DeleteParticles(object sender, DoWorkEventArgs e) { if (listBox3.Items.Count != 0) { SetProgressMaximumValue(listBox3.Items.Count); System.Timers.Timer currentTimer = new System.Timers.Timer(1000); //currentTimer.Elapsed += async (sender, e) => await HandleTimer(); currentTimer.Elapsed += OnTimedEvent; //progressBar2.Maximum = listBox3.Items.Count; currentTimer.Start(); //foreach (int ID in listBox3.Items) for (int iListBox3 = 0; iListBox3 < listBox3.Items.Count; iListBox3++) { var currentConnect = new BookDBConnect(); currentConnect.SetSQLConnectionToAzureDBLitClassicBooks(); currentConnect.DeleteParticles(Convert.ToInt32(listBox3.Items[iListBox3])); currentProgress++; } currentTimer.Stop(); //if (textBox1.Text.IndexOf(",") != -1) //{ // string[] idsString = textBox1.Text.Split(','); // List<int> listIDs = new List<int>(); // progressBar2.Maximum = idsString.Length; // foreach (string ID in idsString) // { // //listIDs.Add(Convert.ToInt32(ID)); // var currentConnect = new BookDBConnect(); // currentConnect.DeleteParticals(Convert.ToInt32(ID)); // progressBar2.Value++; // } //} //else //{ // var currentConnect = new BookDBConnect(); // currentConnect.DeleteParticals(Convert.ToInt32(textBox1.Text)); // progressBar2.Value++; //} } backgroundWorker2.CancelAsync(); }