Find nearest time from list of time to TimeNow

Question

I have 5 textbox with time :

Textbox1 = 05:04
Textbox2 = 06:26
Textbox3 = 11:42
Textbox4 = 14:38
Textbox5 = 16:57
Textbox6 = 16:57
Textbox6 = 18:15

and need to check the nearest textbox value to time now

Vulpes · Answer

Try this LINQ code: string Fajr = node["Fajr"].InnerText; string Sunrise = node["Sunrise"].InnerText; string Dhuhr = node["Dhuhr"].InnerText; string Asr = node["Asr"].InnerText; string Sunset = node["Sunset"].InnerText; string Maghrib = node["Maghrib"].InnerText; string Isha = node["Isha"].InnerText; string[] names = {"Fajr", "Sunrise", "Dhuhr", "Asr", "Sunset", "Maghrib", "Isha"}; string[] times = {Fajr, Sunrise, Dhuhr, Asr, Sunset, Maghrib, Isha}; DateTime now = DateTime.Now; string nearest = times.Select((t, n) => new {Duration = (DateTime.Parse(t) - now).Duration(), Name = names[n]}).OrderBy(dn => dn.Duration).First().Name; this.PrayerLabel.Text = nearest;

ikrami sami · Answer

Thanks all, i think the best solution for me Vuples answer it is good thanks al

Dhirendra Misra · Answer

Hello Ikrami, You can create a function to get close time. public TimeSpan getClosestTime(TimeSpan time, List arr) { TimeSpan closest, closestDiff, currentDiff; closest = new TimeSpan(0,0,0); if (arr.Count > 0) { closest = arr[0]; foreach(TimeSpan ts in arr) { closestDiff = time.Subtract(closest); currentDiff = time.Subtract(ts); if (Math.Abs(currentDiff.TotalSeconds) { closest = ts; } } //returns first element that is closest to number } return closest; } You can call this function by changing the time strings to TimeSpan object like as below: string Fajr = "05:04"; string Sunrise = "06:26"; string Dhuhr = "11:42"; string Asr= "14:38"; string Sunset = "16:15"; string Maghrib = "16:57"; string Isha = "18:15"; List list = new List (); list.Add(new TimeSpan(Convert.ToInt32(Fajr.Split(':')[0]), Convert.ToInt32(Fajr.Split(':')[1]), 0)); list.Add(new TimeSpan(Convert.ToInt32(Sunrise.Split(':')[0]), Convert.ToInt32(Sunrise.Split(':')[1]), 0)); list.Add(new TimeSpan(Convert.ToInt32(Dhuhr.Split(':')[0]), Convert.ToInt32(Dhuhr.Split(':')[1]), 0)); list.Add(new TimeSpan(Convert.ToInt32(Asr.Split(':')[0]), Convert.ToInt32(Asr.Split(':')[1]), 0)); list.Add(new TimeSpan(Convert.ToInt32(Sunset.Split(':')[0]), Convert.ToInt32(Sunset.Split(':')[1]), 0)); list.Add(new TimeSpan(Convert.ToInt32(Maghrib.Split(':')[0]), Convert.ToInt32(Maghrib.Split(':')[1]), 0)); list.Add(new TimeSpan(Convert.ToInt32(Isha.Split(':')[0]), Convert.ToInt32(Isha.Split(':')[1]), 0)); TimeSpan ts = new TimeSpan(15, 56, 0); TimeSpan tr = objClass.getClosestTime(ts, list); Console.Write(tr.Hours + ":" + tr.Minutes); It is better to split string into arr variable and then use it. Hope it may be useful. Thanks

ikrami sami · Answer

05:04 06:26 11:42 14:38 16:57 16:57 18:15

Jaganathan Bantheswaran · Answer

Use string array of timespan & get the nearest prayer time by comparing the timespan. Can you post the time xml string?

sha ik · Answer

Might help.. public TimeSpan FindTime() { TimeSpan actualTS; string currentTime = "14:38"; DateTime[] startDate = new DateTime[] { Convert.ToDateTime("16:57"), Convert.ToDateTime("11:42"), Convert.ToDateTime("06:26"), Convert.ToDateTime("14:38"), Convert.ToDateTime("18:15"), Convert.ToDateTime("05:04"), Convert.ToDateTime("16:57") }; List lstDT = startDate.ToList(); lstDT.Sort(); int timeIndex = lstDT.FindIndex(i => i.TimeOfDay == Convert.ToDateTime(currentTime).TimeOfDay); if (timeIndex != 0) { TimeSpan ts1 = lstDT[timeIndex].TimeOfDay - lstDT[timeIndex - 1].TimeOfDay; TimeSpan ts2 = lstDT[timeIndex + 1].TimeOfDay - lstDT[timeIndex].TimeOfDay; if (ts1 { actualTS = ts1; } else { actualTS = ts2; } } else { actualTS = lstDT[timeIndex +1].TimeOfDay; } return actualTS; }

ikrami sami · Answer

Ok i will give you my real example : i have app which caculate prayer times, so i get the actual times through the webservice, 7 times for prayers, so i need to show just the closest prayer time : foreach (XmlNode node in nodes) { string Fajr = node["Fajr"].InnerText; string Sunrise = node["Sunrise"].InnerText; string Dhuhr = node["Dhuhr"].InnerText; string Asr = node["Asr"].InnerText; string Sunset = node["Sunset"].InnerText; string Maghrib = node["Maghrib"].InnerText; string Isha = node["Isha"].InnerText; // so her i need to just store the closest prayer time and this will be run every 1 min this.ParyerLabel.Text = ???

Jaganathan Bantheswaran · Answer

Yes i got it. We can do that. Before we go to solution, May i know that what are you trying to achieve here.

ikrami sami · Answer

i mean that i have Time values : Textbox1 = 05:04 Textbox2 = 06:26 Textbox3 = 11:42 Textbox4 = 14:38 Textbox5 = 16:57 Textbox6 = 16:57 Textbox6 = 18:15 and if my time now is = 10:00 so i need to have code to give me ( Textbox3 ) which has value ( 11:42 ) the closest time to my actual time now

Jaganathan Bantheswaran · Answer

Question is not clear. what you mean by nearest textbox value to time now?

Find nearest time from list of time to TimeNow

Answers (10)