Find nearest time from list of time to TimeNow

ikrami sami

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

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes12y ago
Accepted 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;
0
ikrami sami12y ago
Thanks all,

i think the best solution for me Vuples answer it is good thanks al
0
Dhirendra Misra12y ago
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) < Math.Abs(closestDiff.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
0
ikrami sami12y ago
05:04
06:26
11:42
14:38
16:57
16:57
18:15
0
Jaganathan Bantheswaran12y ago
Use string array of timespan & get the nearest prayer time by comparing the timespan.

Can you post the time xml string?
0
sha ik12y ago
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 < ts2)
{
actualTS = ts1;
}
else
{
actualTS = ts2;
}
}
else
{
actualTS = lstDT[timeIndex +1].TimeOfDay;
}
return actualTS;
}
0
ikrami sami12y ago
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 = ???
0
Jaganathan Bantheswaran12y ago
Yes i got it. We can do that. Before we go to solution, May i know that what are you trying to achieve here.
0
ikrami sami12y ago
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
0
Jaganathan Bantheswaran12y ago
Question is not clear. what you mean by nearest textbox value to time now?
0