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