public void OnTimedEvent() { httpWWWadress httpWWWadress = new httpWWWadress(); ConnectionBD connection = new ConnectionBD(); int timeMinute10 = 0; int timeHour = 0; timeHour = DateTime.Now.Hour; timeMinute10 = DateTime.Now.Minute; if (timeMinute10 == 00 || timeMinute10 == 20 || timeMinute10 == 30 || timeMinute10 == 40 || timeMinute10 == 50) { connection.SendInfoBD5minCron(); } if ((timeHour == 22 && timeMinute10 == 10) || (timeHour == 02 && timeMinute10 == 10) || (timeHour == 06 && timeMinute10 == 10) || (timeHour == 10 && timeMinute10 == 10) || (timeHour == 14 && timeMinute10 == 10) || (timeHour == 19 && timeMinute10 == 10)) { connection.SendInfoBDFullCron(); } }
public void SendInfoBDFullCron() { httpWWWadress httpWWWadress = new httpWWWadress(); ConnectionTheBase(sqlConnection); SqlCommand command = new SqlCommand("INSERT INTO[croneFull](ButyKupAjaksHTTP, ButyKupAllHTTP, CzasNaButyAjaksHTTP, CzasNaButyAllHTTP, ModaPtakFullHTTP, DataTimeCrone)" + "VALUES (@ButyKupAjaksHTTP, @ButyKupAllHTTP, @CzasNaButyAjaksHTTP, @CzasNaButyAllHTTP, @ModaPtakFullHTTP, @DataTimeCrone)", sqlConnection); command.Parameters.AddWithValue("ButyKupAjaksHTTP", httpWWWadress.ButyKupAjaksHTTP().ToString()); command.Parameters.AddWithValue("ButyKupAllHTTP", httpWWWadress.ButyKupAllHTTP()); command.Parameters.AddWithValue("CzasNaButyAjaksHTTP", httpWWWadress.CzasNaButyAjaksHTTP()); command.Parameters.AddWithValue("CzasNaButyAllHTTP", httpWWWadress.CzasNaButyAllHTTP()); command.Parameters.AddWithValue("ModaPtakFullHTTP", httpWWWadress.ModaPtakFullHTTP()); command.Parameters.AddWithValue("DataTimeCrone", DateTime.Now); command.ExecuteNonQuery(); }
public void SendInfoBD5minCron() { httpWWWadress httpWWWadress = new httpWWWadress(); ConnectionTheBase(sqlConnection); SqlCommand command = new SqlCommand("INSERT INTO[crone5min](ButyKupFst5MinHTTP, CzasNaButyFst5MinHTTP, ModaPtakUpdate5MinHTTP, AllegroStartCronPtak, AllegroStartCronButy, DataTimeCrone)" + "VALUES (@ButyKupFst5MinHTTP, @CzasNaButyFst5MinHTTP, @ModaPtakUpdate5MinHTTP, @AllegroStartCronPtak, @AllegroStartCronButy, @DataTimeCrone)", sqlConnection); command.Parameters.AddWithValue("ButyKupFst5MinHTTP", httpWWWadress.ButyKupFst5MinHTTP().ToString()); command.Parameters.AddWithValue("CzasNaButyFst5MinHTTP", httpWWWadress.CzasNaButyFst5MinHTTP()); command.Parameters.AddWithValue("ModaPtakUpdate5MinHTTP", httpWWWadress.ModaPtakUpdate5MinHTTP()); command.Parameters.AddWithValue("AllegroStartCronPtak", httpWWWadress.AllegroStartCronPtak()); command.Parameters.AddWithValue("AllegroStartCronButy", httpWWWadress.AllegroStartCronButy()); command.Parameters.AddWithValue("DataTimeCrone", DateTime.Now); command.ExecuteNonQuery(); }