How to compare time from current time in C#

Question

HI I am making a payroll software where i want to add a function for attendance where when a employee Login his time will save in Database but if Employee is 20 Mint. Late from their shift time it will automatic create Half Day. I added this code there. private void btntimecheck_Click(object sender EventArgs e) { if (System.DateTime.Now.Hour >= 10) { lbltimecheck.Text = On Time; } else { lbltimecheck.Text = Late; } } in this code i can not compare minutes. like 10:20 i can compare only hours. so please any one know its solution please give me that code.

Vulpes · Answer

You could also work in total minutes since midnight: TimeSpan tod = DateTime.Now.TimeOfDay; int nowMins = (int)tod.TotalMinutes; int lateMins = 10 * 60 + 20; // 10:20 am if (nowMins >= lateMins) { Console.WriteLine(LATE); } else { Console.WriteLine(ON TIME); }

Karthik Indurthi · Answer

if (time.Hour > 10 | | (time.Hour==10 && time.Minute > 19)) { Console.WriteLine( LATE); } else { Console.WriteLine(ON TIME); } This would record 10.20.00 as late

Javeed M Shaikh · Answer

here is one more sample: if (System.DateTime.Now.Hour { Console.WriteLine(On Time); // if current time is less then 9 he is ontime } else if (System.DateTime.Now.Hour > 9) { Console.WriteLine(Late); // if current time is more then 9 he is late } else { if (System.DateTime.Now.Hour == 9) { if (System.DateTime.Now.Minute > 20) { Console.WriteLine(Late); // if current time is 9 and pass 20 mins he is late } else { Console.WriteLine(On Time); // if current time is 9 and less then 20 mins he is on time } } }

Javeed M Shaikh · Answer

it has to be AM and not PM if the time is PM it will always show late.

Shourya Verdhan · Answer

it always says Late

Javeed M Shaikh · Answer

at 10:45 it should have shown Late and at 10:09 it should have shown On Time what was the output in your case?

Shourya Verdhan · Answer

its 10 45 now at that it was 10 09 but i got late at that time

Javeed M Shaikh · Answer

what is the current time in your system

Shourya Verdhan · Answer

time and date are coming from from another system but time is same as my working system and database system

Javeed M Shaikh · Answer

you need to sue the time and date you are retreiving from your database in the code  i see you are still using System.DateTime.Now.Hour and System.DateTime.Now.Minute can you tell me what value you see in txttime.Text and txtdate.Text

Shourya Verdhan · Answer

First Of all i got time and date from this code String strConnection = data source=NDTS11\SQLEXPRESS; initial Catalog=payroll; User Id=sa; Password=@@@@@;; SqlConnection con = new SqlConnection(strConnection); SqlDataAdapter ada1 = new SqlDataAdapter(SELECT CONVERT(varchar(15) CAST(GETDATE() AS TIME) 100) con); con.Open(); DataSet ds1 = new DataSet(); ada1.Fill(ds1); txttime.Text = ds1.Tables[0].Rows[0][column1].ToString(); SqlDataAdapter ada2 = new SqlDataAdapter(SELECT {fn curdate()}  con); DataSet ds2 = new DataSet(); ada2.Fill(ds2); txtdate.Text = ds2.Tables[0].Rows[0][column1].ToString(); then i used this code if (System.DateTime.Now.Hour { MessageBox.Show(On Time); } else if (System.DateTime.Now.Hour > 10) { MessageBox.Show(Late); } else { if (System.DateTime.Now.Hour == 10) { if (System.DateTime.Now.Minute > 15) { MessageBox.Show(Late); } else { MessageBox.Show(On Time); } } }

Javeed M Shaikh · Answer

ok paste the code here and the value of the parameter you are testing with.

Shourya Verdhan · Answer

Yes Javed i know i changed my time according to my requirment. if (System.DateTime.Now.Hour { MessageBox.Show(On Time); } else if (System.DateTime.Now.Hour > 10) { MessageBox.Show(Late); } else { if (System.DateTime.Now.Hour == 10) { if (System.DateTime.Now.Minute > 15) { MessageBox.Show(Late); } else { MessageBox.Show(On Time); } } }

Javeed M Shaikh · Answer

paste your code here and remember this will work on current time so what is the current time right now on the machine you are running this code. Change the current time with the variable parameter.

Shourya Verdhan · Answer

No Javed this condition always says ontime like my code i am still in first situation

Javeed M Shaikh · Answer

ok can you check the above example and replace with your parameters accordingly and see if that works.

Shourya Verdhan · Answer

Ok let me try this code i think it will works.

Shourya Verdhan · Answer

just i want to add a function where employee will add their attendance self from login in the software where when employee login in the software the current time of Server system will compare with Shift time where if employee 15 mint late from their sift then software auto genrate halfday of perticular employee. and shift time is fix in the software. like 10 Am

Javeed M Shaikh · Answer

that was just a sample on how to get the minute of the current hour and not the exact code please tell me your requirements.

Shourya Verdhan · Answer

HI Javeed  i tried this this code but its not working its take else situation. if (System.DateTime.Now.Hour >= 10 && System.DateTime.Now.Minute { lbltimecheck.Text = On Time; } else { lbltimecheck.Text = Late; } do you have any other option

Javeed M Shaikh · Answer

is this what you are looking for : if (System.DateTime.Now.Hour >= 10 && System.DateTime.Now.Minute <= 20)