Linq query conditions.

Question

3.00/5 (1 vote)

See more:

User1 has the following fieldnames enabled:

TrialStartDate: 26/05/2013
TrialExpiryDate: 31/05/2013
WIC_ALL: true
Price_StartDate: 28/05/2013
Price_ExpiryDate: 31/05/2013

If User1 has trialStart and trialExpiry Date setup, then user becomes a newsUser. However , when the user1 also has wic_all, PriceStart and PriceExpiry Date setup too, then user1 becomes full user, making it overide the (NewsTrials) query.

My issue is that I am unable to login user1 as FullUser using the (full-test) query. I would like to know how can overide the newsTrial query?

Please help.

C#

public UserDetail NewsTrial(string username, string password)
{

    var query = from s in db.Subscriptions
                join u in db.UserDetails on s.sUID equals u.uID
                where s.sTrialExpiryDate >= DateTime.Now &&
                s.sPID.Value == 163 &&
                u.uUsername == username &&
                u.uPassword == password
                select u; //
    return query.FirstOrDefault();

}

public UserDetail full_test(string username, string password)
{
    var query = from s in db.Subscriptions
                join u in db.UserDetails on s.sUID equals u.uID
                where s.sPrice_ExpiryDate >= DateTime.Now &&
                s.sPID.Value == 163 &&
                s.sWIC_All.Value == true &&
                u.uUsername == username &&
                u.uPassword == password
                select u;
    return query.FirstOrDefault();
}

Many thanks.

Posted 6-Jun-14 3:31am

miss786

Updated 6-Jun-14 4:32am

v3

Add a Solution

Comments

ZurdoDev 6-Jun-14 9:54am

I don't understand your question.

miss786 6-Jun-14 10:27am

Apology for not making question clearer. when user1 has only trialexpiry and trialstart date, then user1 is known as newsUser, however when the user1 also has wic_all,priceStart and priceExpiryDate, then the user1 becomes a full user. Currently, I cannot get the user1 to login as full-test, this is my current issue at the moment. please advice, if possible.

_Maxxx_ 6-Jun-14 10:38am

Are you simply saying that passing the same username and password to each of the two methods, NewsTrial returns a record and full_test returns null?
If that is the case, I can't see anything wrong with the query, so it is likely a problem with the data
I would run in debug, break on the query and check the data at runtime.
If it still looks OK I would try removing lines from select 1 by 1 until you DO get a record, and then you know which bit is failing

miss786 6-Jun-14 10:46am

Many thanks for your feedback.

I have a web-api application, where I have the following two queries set-up, newsTrial(query), leads to [Newspage] and fullTest(query), leads to [fullPage]. when I login as user1, it leads to [Newspage] instead of [fullPage]. However, I have tested the user1 against the following sql query and it shows user1 records in the sql query below, but using the trial sql query.

select u.[uID], u.[uUsername], u.[uPassword], s.[sPriceABS_ExpiryDate]
from [dbo].[UserDetails] u
join [dbo].[Subscriptions] s
on u.uID = s.sUID
where s.[sPrice_ExpiryDate]>= getdate()
and s.[sWIC_All] = '1'
and s.sPID = '163'

_Maxxx_ 6-Jun-14 10:58am

Given that the dates you show in your sample data are all in 2013, that seems unlikely!
As I said, I would debug it to try to find out what is happening -

One thought does occur - if BOTH queries return a record, then the page you go to will depend on the order in which you run them - so perhaps run the full test first?

miss786 6-Jun-14 12:40pm

thank you for your response. Taking your consideration into account, the application executes the (NewsTrials) query first. So i tried merging the two and I am trying to create method which executes query1 first then query:

public UserDetail full(string username, string password)
{
var query1 = from s in db.Subscriptions
join u in db.UserDetails on s.sUID equals u.uID
where s.sPrice_ExpiryDate >= DateTime.Now &&
s.sPID.Value == 163 &&
s.sWIC_All.Value == true &&
u.uUsername == username &&
u.uPassword == password
select u;

var query = from s in db.Subscriptions
join u in db.UserDetails on s.sUID equals u.uID
where s.sTrialExpiryDate >= DateTime.Now &&
s.sPID.Value == 163 &&
u.uUsername == username &&
u.uPassword == password
select u;

if (query1 != null)
{
return query1.FirstOrDefault();
}

return query.FirstOrDefault();
}

Currently, user1 is still falling under var query, instead of query1. Could you please advice, how could i make the order of the query work? Thank you.

_Maxxx_ 8-Jun-14 5:46am

As I said before I think, you need to debug the quewries and make sure they are doing what you expect with the data you have.
The dates you showed in your example are earlier than today, so as shown, neither query will return a value.
Your queries differ only by the different dates and the bool value - so try commenting out both, - they should now return a value.
Next uncomment one and see if it returns a value - if it doesn't then that line is likely to be your issue - and hopefully you can work out why!
And run it in debug - look at the returned values - see if you can figure it out.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)