ASP.NET Comparing data from Database

Question

I'm currently working on a project which needs to check for the day and time, then compare these with values in my database. This needs to be done for an Live Chat, while we have opened. I'm new to ASP.Net and this is giving me an headache.

I Have a table which contains these Rows: - weekday - starttime - endtime

In my Controller for the Chat I have tried this so far

private Model1Container db = new Model1Container();

    public ActionResult Index(Openinghours openinghours)
    {
        ViewBag.Opening = db.OpeninghoursSatz.ToList();

        string CurrentDay = DateTime.Now.DayOfWeek.ToString();
        string CurrentTime = DateTime.Now.TimeOfDay.ToString();

        bool IsWeekDay= db.OpeninghoursSatz.Where(i => i.weekday == CurrentDay).Any();
        var Starttime = db.OpeninghoursSatz.Find(CurrentDay);
        Debug.Write("!!++" + Starttime);

My exact Problem is to compare the time with the two rows from my table. I thought about putting the values in a variable and then compare them, but there must be a cleaner way for this.

I hope I was able to point out what my problem is, if not please ask.

With regards,

Nico

EDIT: Maybe I should say that the database holds the hour it opens and the hour it closes (e.g. 9 and 17). I need to check if the current time is between these two.

you want to compare the start days of two row ? , and after comparision something need to be done , or just u want to calculate ? — Dreamweaver
– Dreamweaver, Commented Jun 11, 2015 at 8:33
I have the row starttime and endtime. in starttime is the int value 9 and in endtime the value 17. The current time is 10:43 AM. so it is betwen 9 AM and 5 PM. Thats what I want to check. If the time is between these values I activate the chat and if not I deactivate the chat. — Nico
– Nico, Commented Jun 11, 2015 at 8:45

Dreamweaver · Accepted Answer · 2015-06-11 11:48:35Z

1

      int getStartHour = DateTime.Now.Hour;
        int weekDay= (int)DateTime.Now.DayOfWeek;
 bool value =    db.OpeninghoursSatz.Where(m => getStartHour >= m.Starttime  && getStartHour <= m.EndTime && m.weekday == weekDay).Any()

    /// if everything is in int. or if in string 
     string getStartHour = DateTime.Now.Hour.ToString();
        string weekDay= DateTime.Now.DayOfWeek.ToString();
 bool value =    db.OpeninghoursSatz.Where(m => getStartHour >= m.Starttime  && getStartHour <= m.EndTime && m.weekday == weekDay).Any();

But in this case for Thursday , we will get Thursday, but in Int we will get 4.

edited Jun 11, 2015 at 11:48

answered Jun 11, 2015 at 9:01

Dreamweaver

1,37611 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Nico Over a year ago

I think there is an Problem with this Code. db.OpeninghoursSatz.Any is not possible. I get the message that Any is not defined in DBset<Models.Openinghours>. And should .Any not be at the and? so I should replace .any with find/equals or something like that.

Dreamweaver Over a year ago

Try now with the edited one, but it doesnt make sense, I used intelligence to build the query only difference was the class name.. :(

Nico Over a year ago

This is weird. after rebuilding the project he isn't saying not defined anymore. but now he wantso something different in .Any(. After m => getStartHour > = he says = is not legit and after that he wants an ")". Maybe I'm just stupid.

Nico Over a year ago

directupload.net/file/d/4015/63tbs2na_png.htm directupload.net/file/d/4015/wpbs9ian_png.htm This is what he shows me now

Nico Over a year ago

Now its working :) Thank you a lot. it was my bad that I overlooked the whitespace and I also had some trouble with my database. Now everything is working. Thank you sir.

Peter · Accepted Answer · 2015-06-11 08:24:55Z

0

The line looks odd to me:

var Starttime = db.OpeninghoursSatz.Find(CurrentDay);

I guess you should change it to something like:

if (IsWeekDay){
    var Starttime = db.OpeninghoursSatz.Where(i => i.weekday == CurrentDay).First().StartTime;
    Debug.Write("!!++" + Starttime);
}

answered Jun 11, 2015 at 8:24

Peter

28k8 gold badges69 silver badges85 bronze badges

1 Comment

Nico Over a year ago

It seems like my variable CurrentDay is the Problem. I get the Error "Microsoft.CSharp.RuntimeBinder.RuntimeBinderException`. But this gives me an Idea for a new way.

Collectives™ on Stack Overflow

ASP.NET Comparing data from Database

2 Answers 2

5 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related