Round up the time to the nearest 30 minutes using C# in ASP.Net

irshad12...

SOLVED CLOSED ACTIVE ANSWERED
User: irshad1231
Posted: on Aug 28, 2017 01:33 AM
Forum: ASP.Net Web Forms
Answer: 3
Views: 13361

Hello.

I have meeting room booking system in which user can select meeting rooms. We have dropdown list for the timings as 8:00 AM, 8:30 Am, 9:00 AM … and so on. I want to show upcoming meeting like suppose the meeting room is booked at today 2017-08-28 10:00:00.000 and the current time is 2017-08-28 09:57 so no records is displayed. I want if the time is in between 08:00 – 08:29 it should covert time to 08:30 and if the time is between 08:31 – 08:59 it should convert to 09:00 and so on for the time till 05:00 PM.

If Time 08:00 – 08:29 then 08:30 else 08:31 – 08:59 then 09:00

 protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection(connectionString);
        SqlCommand cmd = new SqlCommand("Select * from Meetings", con);
        SqlDataAdapter sda = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        sda.Fill(dt);
        string date = dt.Rows[0]["meetingstarttime"].ToString();
        DateTime datesql = Convert.ToDateTime(date);

       
        DateTime s = DateTime.Now;
        TimeSpan ts = new TimeSpan(10, 30, 0);
        
      
         string currentdate = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
         var newDate = DateTime.ParseExact(currentdate, "yyyy-MM-dd HH:mm", System.Globalization.CultureInfo.InvariantCulture);

         TimeSpan ts1 = new TimeSpan(00, 30, 0);
         s = newDate.Date + ts1;


        SqlCommand cmd1 = new SqlCommand("Select * from Meetings where meetingstarttime= '" + currentdate +"' ", con);
        SqlDataAdapter sda1 = new SqlDataAdapter(cmd1);
        DataTable dt1 = new DataTable();
        sda1.Fill(dt1);
       

        Label2.Text = dt.Rows[0]["meetingstarttime"].ToString();
        Label4.Text = dt.Rows[0]["meetingtitle"].ToString();
    }

<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" CausesValidation="True"
                    ValidationGroup="1" Width="145px" CssClass="form" 
                    onselectedindexchanged="DropDownList1_SelectedIndexChanged">
                    <asp:ListItem Value=" 12:00:00 AM">&lt;From Time&gt;</asp:ListItem>
                    <asp:ListItem Value=" 7:01:00 AM"> 7:00:00 AM</asp:ListItem>
                    <asp:ListItem Value=" 7:31:00 AM"> 7:30:00 AM</asp:ListItem>
                    <asp:ListItem Value=" 8:01:00 AM"> 8:00:00 AM</asp:ListItem>
                    <asp:ListItem Value=" 8:31:00 AM"> 8:30:00 AM</asp:ListItem>
                    <asp:ListItem Value=" 9:01:00 AM"> 9:00:00 AM</asp:ListItem>
                    <asp:ListItem Value=" 9:31:00 AM"> 9:30:00 AM</asp:ListItem>
                    <asp:ListItem Value=" 10:01:00 AM"> 10:00:00 AM</asp:ListItem>
                    <asp:ListItem Value=" 10:31:00 AM"> 10:30:00 AM</asp:ListItem>
                    <asp:ListItem Value=" 11:01:00 AM"> 11:00:00 AM</asp:ListItem>
                    <asp:ListItem Value=" 11:31:00 AM"> 11:30:00 AM</asp:ListItem>
                    <asp:ListItem Value=" 12:01:00 PM"> 12:00:00 PM</asp:ListItem>
                    <asp:ListItem Value=" 12:31:00 PM"> 12:30:00 PM</asp:ListItem>
                    <asp:ListItem Value=" 01:00:00 PM"> 01:00:00 PM</asp:ListItem>
                    <asp:ListItem Value=" 01:31:00 PM"> 01:30:00 PM</asp:ListItem>
                    <asp:ListItem Value=" 02:01:00 PM"> 02:00:00 PM</asp:ListItem>
                    <asp:ListItem Value=" 02:31:00 PM"> 02:30:00 PM</asp:ListItem>
                    <asp:ListItem Value=" 03:01:00 PM"> 03:00:00 PM</asp:ListItem>
                    <asp:ListItem Value=" 03:31:00 PM"> 03:30:00 PM</asp:ListItem>
                    <asp:ListItem Value=" 04:01:00 PM"> 04:00:00 PM</asp:ListItem>
                    <asp:ListItem Value=" 04:31:00 PM"> 04:30:00 PM</asp:ListItem>
                </asp:DropDownList>

Thanks

AnandM

0 1

Reply
ANSWER
User: AnandM
Replied: on Aug 28, 2017 05:29 AM
Report

irshad1231 says:
DateTime s = DateTime.Now;

       TimeSpan ts = new TimeSpan(10, 30, 0);





        string currentdate = DateTime.Now.ToString("yyyy-MM-dd HH:mm");

        var newDate = DateTime.ParseExact(currentdate, "yyyy-MM-dd HH:mm", System.Globalization.CultureInfo.InvariantCulture);

        TimeSpan ts1 = new TimeSpan(00, 30, 0);

        s = newDate.Date + ts1;

       SqlCommand cmd1 = new SqlCommand("Select * from Meetings where meetingstarttime= '" + currentdate +"' ", con);

replace above with below

string currentdate = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
var newDate = DateTime.ParseExact(currentdate, "yyyy-MM-dd HH:mm", System.Globalization.CultureInfo.InvariantCulture);
TimeSpan ts1;
int minutes = newDate.Minute;
if (minutes > 0 && minutes < 30)
{
    ts1 = new TimeSpan(newDate.Hour, 30, 0);
}
else
{
    ts1 = new TimeSpan(newDate.Hour + 1, 00, 0);
}
newDate = new DateTime(newDate.Year, newDate.Month, newDate.Day, ts1.Hours, ts1.Minutes, newDate.Millisecond);
SqlCommand cmd1 = new SqlCommand("Select * from Meetings where meetingstarttime= '" + newDate + "' ", con);

irshad12...

0 2

Reply
User: irshad1231
Replied: on Aug 28, 2017 06:24 AM
Report

@AnandM

Thank you for your reply. the new date output is

8/28/2017 3:30:00 PM

and data stored in sql server in the below format

2017-08-28 03:30:00.000

Due to PM no records found from the DB.

Thanks

AnandM

0 3

Reply
ANSWER
User: AnandM
Replied: on Aug 28, 2017 06:45 AM
Report

Hi irshad1231,

Read the documentation on Custom Date and Time Format Strings.

hh is documented as

The hour, using a 12-hour clock from 01 to 12.

HH is documented as:

The hour, using a 24-hour clock from 00 to 23.

Refer below code.

string currentdate = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
var newDate = DateTime.ParseExact(currentdate, "yyyy-MM-dd HH:mm", System.Globalization.CultureInfo.InvariantCulture);
TimeSpan ts1;
int minutes = newDate.Minute;
if (minutes > 0 && minutes < 30)
{
    ts1 = new TimeSpan(newDate.Hour, 30, 0);
}
else
{
    ts1 = new TimeSpan(newDate.Hour + 1, 00, 0);
}
newDate = new DateTime(newDate.Year, newDate.Month, newDate.Day, ts1.Hours, ts1.Minutes, newDate.Millisecond);
currentdate = newDate.ToString("yyyy-MM-dd hh:mm");

SqlCommand cmd1 = new SqlCommand("Select * from Meetings where meetingstarttime= '" + currentdate + "' ", con);

irshad12...

0 4

Reply
User: irshad1231
Replied: on Aug 28, 2017 07:25 AM
Report

@AnandM

Label2.Text =currentdate;

The output I get is

Upcoming Meetings: 2017-08-28 04:30

Can i change the format 28-August-2017 04:30 PM

Thanks

AnandM

0 5

Reply
ANSWER
User: AnandM
Replied: on Aug 29, 2017 12:30 AM
Report

Hi irshad1231,

In below link all the formats are mentioned which can apply to the string format.

Refer below link and if your wanted format is not present then you need to customize the format according to your need.

Round up the time to the nearest 30 minutes using C# in ASP.Net

Formats for DateTime.ToString() in ASP.Net

Formats for DateTime.ToString() in ASP.Net

Company

Explore

Follow us

Contact Us