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(000); 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?