ASP.NET Discussion Boards

miss78617-Oct-13 0:01

17-Oct-13 0:01

Dear all,

I am currently an novice user in the asp.net environment and would like to request assistance on the following topic below:

I am using 'c.Cover' as field name from database table, which has three types (i.e. talk, cvr, trd). I would like to filter my query, so it prints out yesterday's data with only cvr and trd types only.

from the code below, I am unable to filter my data using the following link below. I still not getting the correct response output from the client side.

http://localhost:38853/api/test?type=CVR&TRD</a>[^]

public IEnumerable<database_WICs> GetPriceType(string type)
        {
            DateTime yesterday = DateTime.Today.AddDays(-2);

            var data = from c in db.database_WICs
                       where c.UploadDate <= yesterday &&
                       c.Cover == type &&
                       c.Cover == type
                       select c;
            return data.ToList();
        }

Any help would be much appreciated.

Many thanks for your time and help.

Re: Filtering - web api c#

Bernhard Hiller17-Oct-13 2:29

Bernhard Hiller

17-Oct-13 2:29

There are a few issues. The ampersand "&" actually separates parameters from each other. Consequently, type has the value of CVR only, and there is a second parameter named TRD without extra information. You need a different separator, what about a pipe | or + or....
Next, you do not want to get elements where the Cover column has both values at the same time - that does not make sense. It is sufficient when one of them matches. In boolean operators, that is an OR.
Instead of

c.Cover == type &&
c.Cover == type

you'll need a

(c.Cover == type1 ||
c.Cover == type2)

Note that you have to split the type parameter into type1 and type2.

Re: Filtering - web api c#

Kornfeld Eliyahu Peter17-Oct-13 2:30

Kornfeld Eliyahu Peter

17-Oct-13 2:30

First - your localhost can't help us!!!
Second - yesterday is today -1 not -2!!!
Third - you pass in type and do

c.Cover == type && c.Cover == type

what you mean is

c.Cover == "cvr" || c.Cover == "trd"

I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is (V).

Re: Filtering - web api c#

miss78617-Oct-13 3:51

miss786

17-Oct-13 3:51

Hello,
thank you so much for your response.

I updated my code but now I am expericing the an application error:
A potentially dangerous Request.Path value was detected from the client

public IEnumerable<database_BWICs> GetDatePrice(string type, string trd)
      {
          DateTime yesterday = DateTime.Today.AddDays(-1);

          var data = from c in db.database_BWICs
                     where c.UploadDate <= yesterday &&
                     c.Cover == type ||
                     c.Cover == trd
                     select c;
          return data.ToList();
      }

http://localhost:38853/api/daily/type=cvr&trd=talk[^]

I am working on putting the application onto the server. Please bear with me, I shall forward you an appropriate link in couple of minutes time.

Thank you for your time and help.

Re: Filtering - web api c#

Kornfeld Eliyahu Peter17-Oct-13 4:23

Kornfeld Eliyahu Peter

17-Oct-13 4:23

http://msdn.microsoft.com/en-us/library/system.web.configuration.httpruntimesection.requestpathinvalidcharacters.aspx[^]
It means that & is a invalid char...

I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is (V).

Re: Filtering - web api c#

miss78617-Oct-13 4:39

miss786

17-Oct-13 4:39

Thank you once again for your reply, I manage to update my code again, by adding spit function, but the api is still reading the first type. I removed the date parameter, so I can get the code to output only the types 'cvr' and 'talk' data types.

I am still struggling to get the correct output.

Any help would be very much appreciated.

[HttpGet]
public IEnumerable<database_WICs> GetPriceType(string type)
{
    //split the type that is passed in
    var trd = type.Split('&');

    var data = from c in db.database_WICs
               where trd.Contains(c.Cover)
               select c;
    return data.ToList();
}

Re: Filtering - web api c#

Kornfeld Eliyahu Peter17-Oct-13 7:13

Kornfeld Eliyahu Peter

17-Oct-13 7:13

The LINQ code is looks just right.
It is possible that type does not get the expected value?

I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is (V).

Re: Filtering - web api c#

Richard Deeming17-Oct-13 4:30

Richard Deeming

17-Oct-13 4:30

Rather than implementing the filtering yourself, you might want to look at OData[^].

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Displaying "File Name: 002.txt" in Hebrew

civic06016-Oct-13 4:42

civic060

16-Oct-13 4:42

Changing the language of the site to Hebrew sets the .net culture appropriately (culture="he-IL"). However, the text "File Name: 002.txt" in Hebrew isn't coming up correctly 002.txt

שם קובץ: 002.txt

Re: Displaying "File Name: 002.txt" in Hebrew

Kornfeld Eliyahu Peter16-Oct-13 5:57

Kornfeld Eliyahu Peter

16-Oct-13 5:57

Can you show how the name comes to be part of the page you display?
It's highly possible that you need something like

HTML

<body dir="rtl">

I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is (V).

Re: Displaying "File Name: 002.txt" in Hebrew

civic06016-Oct-13 9:46

civic060

16-Oct-13 9:46

Thanks! That works!

Add dynamic pages to Google Search

Blikkies16-Oct-13 0:53

Blikkies

16-Oct-13 0:53

Hey all,

I have created a blog where all the posts are stored in MS SQL.

I have created user-friendly url for each of the post using ASP Routing.

My question is, how do I submit the dynamic pages urls to google? Do I have to dynamically add the post url to the Sitemap and submit it to google when there is a new post?

Thank you in advance

Re: Add dynamic pages to Google Search

Richard Deeming16-Oct-13 1:41

Richard Deeming

16-Oct-13 1:41

I tend to use a dynamic sitemap file generated by a generic handler (sitemap.ashx). Google re-reads the file on a regular basis, so there's no need to re-submit it.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: Add dynamic pages to Google Search

Blikkies16-Oct-13 2:03

Blikkies

16-Oct-13 2:03

Thank you for you response Smile | :)

So I only have so submit it once so that google knows about the handler, correct?

Re: Add dynamic pages to Google Search

Richard Deeming16-Oct-13 2:10

Richard Deeming

16-Oct-13 2:10

That's been my experience using their Webmaster Tools[^]. It's also a good idea to add the link to your robots.txt file, so that other search engines will pick it up:

Sitemap: http://your.domain.com/sitemap.ashx

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: Add dynamic pages to Google Search

Blikkies16-Oct-13 2:39

Blikkies

16-Oct-13 2:39

Thanks a mil!! Thumbs Up | :thumbsup:

How to draw horizontal line using Gios Pdf in C#,ASP.NEt

Member 1020836815-Oct-13 2:26

Member 10208368

15-Oct-13 2:26

Hi:

I had tried to draw horizontal line in gios pdf report.Please Help ME

Dashboard in ASP.NET

ashu200114-Oct-13 19:19

ashu2001

14-Oct-13 19:19

I need to give a dashboard in asp.net(with or without ajax / telerik) for production data like machine efficiency, total production,machine utilization, different type of products etc. Can some one help me with some design idea or templates(i have already seen sales dashboard,executive dashboard by telerik)

Please help.

ashish sharma

Re: Dashboard in ASP.NET

thatraja14-Oct-13 21:33

thatraja

14-Oct-13 21:33

ashu2001 wrote:
i have already seen sales dashboard,executive dashboard by telerik

I think that's enough. Anyway check this one.
Simple Dashboard[^]

All you have to do is customization.

thatraja

FREE Code Conversion VB6 ASP VB.NET C# ASP.NET C++ JAVA PHP DELPHI ColdFusion
HTML Marquee & its alternatives

Nobody remains a virgin, Life screws everyone Sigh | :sigh:

Re: Dashboard in ASP.NET

ashu200115-Oct-13 18:41

ashu2001

15-Oct-13 18:41

@thatraja Thanks for the reply but i saw this dashboard as well. but its design is not so appealing for me i want to explore some more option.

ashish sharma

Re: Dashboard in ASP.NET

CodeBlack15-Oct-13 20:40

CodeBlack

15-Oct-13 20:40

Dashboard for web forms or MVC ?

Regards,
CodeBlack

Re: Dashboard in ASP.NET

ashu200115-Oct-13 21:27

ashu2001

15-Oct-13 21:27

Web forms only no MVC or LINQ

ashish sharma

Re: Dashboard in ASP.NET

CodeBlack15-Oct-13 21:31

CodeBlack

15-Oct-13 21:31

Demo Link:

http://dropthings.omaralzabir.com/[^]

Download Link :

http://dropthings.codeplex.com/[^]

Regards,
CodeBlack

Re: Dashboard in ASP.NET

Abhinav S16-Oct-13 18:34

Abhinav S

16-Oct-13 18:34

Try Widget Toolkit[^].

Apps - Color Analyzer | Arctic | XKCD | Sound Meter | Speed Dial

Fetching Questions.!

Member 1031225714-Oct-13 18:58

Member 10312257

14-Oct-13 18:58

Hey, Friends...
I am creating OnlineExam Application in .net, i am done with all the pages but am a bit muddeled how do i fetch the questions from the database...there is a page select question where user will select the questionpaper and the ID would be senr to the next page...i am done with this part but the problem is how do i call the questions from the "QuestionsTable"and then verify it with the correct answer.!

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.