Notification in certain time

[Johnmcenroy]

I have SQL database , there I have a column Remind with row Time.
So also there is a service that reads SQL database's time and show notification.
How is the best way to show this notification in certain time ? How I understand service must check time every 1-5 minutes and if this time same as in DB - show notification. Is this correct ?

Thanks

 

[Erel]

You should use StartServiceAt to schedule a notification at a specific time.

 

[Johnmcenroy]

You should use StartServiceAt to schedule a notification at a specific time.

Thank you very much

 

[Johnmcenroy]

Also Erel one question . If i have 10 different times , can I use StartServiceAt to start the same service in 10 different times ?

 

[barx]

You start the service on the first (earliest) time, Then when the service starts check for next time and schedule again.

 

[Johnmcenroy]

Thanks. Didn't thought about this. Time to rest

You start the service on the first (earliest) time, Then when the service starts check for next time and schedule again.

 

[Johnmcenroy]

I made in my Service_Start :

StartServiceAt("",DateTime.TimeParse("21" & "-" & "45" & "-" & "00"),True)

It works , but I see continious loop in logs. Service Starts again and again.And cpu is nearly 50%. What is wrong ? Thanks

 

[Johnmcenroy]

Sorry really can't understand how to start service in certain time cause of ticks.
If I want to start every 3 minute ok - it is DateTime.Now + 3 *DateTime.TicksPerMinute . But how to start every day in 20:00 for example ?

Thanks

 

[Erel]

First, you should use DateUtils.SetDateAndTime to get the ticks value.

You will need to call StartServiceAt in Service_Start and schedule for the next day.

 

[Johnmcenroy]

Thanks. But when I write so:

StartServiceAt("",DateUtils.SetDateAndTime(2013,06,24,16,02,00),True)

Service starts continiously in loop and cpu is nearly 50% . Why ?

I have started it when device's time was 16,00

 

[Erel]

Because you are scheduling for a time in the past causing the service to be started again and again.
You should use this code to calculate the next schedule:

Dim four As Long
Dim now As Long = DateTime.Now
four = DateUtils.SetDateAndTime(DateTime.GetYear(now), DateTime.GetMonth(now), _
   DateTime.GetDayOfMonth(now),16, 0, 0)
If four < now Then
   'skip to tomorrow
   Dim p As Period
   p.Days = 1
   four = DateUtils.AddPeriod(four, p)
End If
Log(DateUtils.TicksToString(four))

 

[Johnmcenroy]

Thank you very much Erel. Amazing support. B4A the best ! :icon_clap:

 

[Mashiane]

Hi Erel. How can I have the same code running inside a class module. On compilation its saying it needs an activity context? Any advice? Thanks

 

[Erel]

Please start a new thread for this question.

 

[Mashiane]

Am sorted Erel, thanks

 

[Johan Schoeman]

Please help. I have used a combination of Simple_Alarm and WheelView to create an alarm clock. It works perfectly but once I have scheduled the alarm and "closed" the app I want the app to come "alive" when alarm starts sounding so that I can shut the alarm or select for eg "snooze" that will silent the alam for 5 or 10 or 15 minutes (user selecteable). How do I make the app come "alive" again so that I can interface with it?

 

[Erel]

As discussed in the other thread you should use StartServiceAt to schedule a service to start.

 

[bsnqt]

Hi Erel, sorry for this simple question, but I cannot figure it out how to do.
I am ok with StartServiceAt, now my Service is started and running. Now I want to stop it at a given time (at that time I will schedule it to start again and so on). How can I stop a Service at a given time (I don't want to use a timer, I want to use the same solution as StartServiceAt)

Thank you.

 

[Erel]

Please start a new thread for this question and also explain what is this service doing.