Re: Telerik grid vs. Kendo grid and Ajax calls - ASP.NET Discussion Boards

joginder-banger6-Feb-14 4:27

6-Feb-14 4:27

Yes sir it's very difficult understand about the forms Authentication, I have used many time in live project, but every time new problem faced.After some searching on google some idea get, then resolve problem. I used every time web config Authentication, it's simple according to me.

ASP.NET MVC Web API - filter query with pagesize

miss7865-Feb-14 22:39

miss786

5-Feb-14 22:39

Hello,

If I search (api/test/cusip=00163&isin=555), I get 10 records showing both of cusip and isin value and 9 records with price_type= cr and 1 record price_type= tk.

However, if I run the following query (api/test?cusip=00163&isin=555&price_type=cr), i only get results from cusip parameters (00163) and nothing from isin and they are also not in a descending order.

This is what I have so far:

public HttpResponseMessage Get([FromUri] Query query)
        {
            var data = db.database.AsQueryable();

            int pageSize = 10;

            if (query.price_type != null)
            {
                data = data.Where(c => c.Cover == query.price_type);
            }
            
            int total = data.Count();
            // If any other filters are specified, return records which match any of them:
            var filteredData = new List<IQueryable<database_BWICs>>();

            if (!string.IsNullOrEmpty(query.isin))
            {
                var ids = query.isin.Split(',');
                foreach (string i in ids)
                {
                    filteredData.Add(data.Where(c => c.ISINs != null && c.ISINs.Contains(i)));
                }
            }

            if (!string.IsNullOrEmpty(query.cusip))
            {
                var ids = query.cusip.Split(',');
                foreach (string i in ids)
                {
                    filteredData.Add(data.Where(c => c.CUSIP != null && c.CUSIP.Contains(i)));
                }
            }


            // If no filters passed, return all data.
            // Otherwise, combine the individual filters using the Union method
            // to return all records which match at least one filter.
            
            if (filteredData.Count != 0)
            {
                data = filteredData.Aggregate(Queryable.Union).OrderByDescending(c => c.UploadDate).Take(pageSize);
            }

           
            if (!data.Any())
            {
                var message = string.Format("No data was found");
                return Request.CreateErrorResponse(HttpStatusCode.NotFound, message);
            }

            if (query.price_type != null)
            {
                data = data.OrderByDescending(c => c.Cover == query.price_type).Take(pageSize);
            }
            

            //return Request.CreateResponse(HttpStatusCode.OK, data);
            return Request.CreateResponse(HttpStatusCode.OK, new { total, data });
        }
    }

I have tried debugging the issue many times on the following line with search string - http://localhost:32118/api/test?cusip=00163&isin=555&price_type=cr . The application crashes on the data parameter "data = {System.Data.Entity.DbSet<multi.database>} ". I am little unclear what this issue mean?

if (query.price_type != null)
            {
                data = data.Where(c => c.Cover == query.price_type);
            }

Am I missing something? if so, is their a better way to do this? Thanks in advance for your help and time.

modified 7-Feb-14 5:28am.

Re: filter query with pagesize

Ali Al Omairi(Abu AlHassan)6-Feb-14 1:55

Ali Al Omairi(Abu AlHassan)

6-Feb-14 1:55

Sir;
I don't know what are you trying to do, but I believe that you chooses to do it with the hard way. I don't understand why you applied the each filter alone then you applied 'Union All'.

and I think that you need to mention that you are using ASP.NET MVC Web API.

Help people,so poeple can help you.

Re: filter query with pagesize

miss7866-Feb-14 23:27

miss786

6-Feb-14 23:27

Hi,

I have updated my original post and managed to get half of the issue resolved. I am currently stuck on the price_type parameter on filtering query with pagesize and orderby function.

If anyone could help me out on this issue explained in my original post, that would be very helpful.
Many thanks.

Re: filter query with pagesize

Ali Al Omairi(Abu AlHassan)7-Feb-14 11:25

Ali Al Omairi(Abu AlHassan)

7-Feb-14 11:25

Ma'am;
From your code, I can extract that your data table has columns:

Cover: to be match with price type(restrict the data set)
ISINs: filter
CUSIP:filter
UploadDate: descending order

first,you restrict the data to price type. Then you select ISIN matching records and the CUSIP matching ones from the restricted data. lastly, you order the filtered data according to the upload date.
After that you reorder the overall data according to the price type.

In the first request query 'cusip=00163&isin=555' you didn't specify a value for price_type so the lines

if (query.price_type != null)
{
    data = data.OrderByDescending(c => c.Cover == query.price_type).Take(pageSize);
}

wont execute. But inn the request 'cusip=00163&isin=555&price_type=cr' you restrict the data to cr price type and execute the above statement which will cancel all ordering.

my recommendation is to remove these lines, and accept me as a friend on facebook.

if you need any further help you should tell me what your data is and what you want to do with it.

by the way what about the number 786?!!

Help people,so poeple can help you.

Re: filter query with pagesize

miss78610-Feb-14 0:37

miss786

10-Feb-14 0:37

Thank you for your response. I am writing to inform, I manage to get the issue resolved by adding the orderby and pagesize filter to filterdata method.

Thank you for your time and suggestions.

Telerik grid vs. Kendo grid and Ajax calls

littleGreenDude5-Feb-14 8:36

littleGreenDude

5-Feb-14 8:36

Anybody familiar with Telerik's grid products...

We had code that previously implemented the telerik grid

@(Html.Telerik().Grid()<myTransactions>
    .Name("Transactions")
        .ClientEvents(events => events.OnLoad("TransactionsGrid_onLoad"))
        .ClientEvents(events => events.OnDataBound("TransactionsGrid_onDataBound"))
    .DataBinding(dataBinding => dataBinding
        .Ajax()
        .OperationMode(GridOperationMode.Client)
        .Select("TransactionsAjax", controller))

We have recently migrated to Telerik's Kendo grid, and changed the code to the following:

@(Html.Kendo().Grid<myTransactions>()
    .Name("Transactions")
    .AutoBind(true)
    .Events(events => events.DataBound("TransactionsGrid_onDataBound"))
        .DataSource(dataSource => dataSource
        .Ajax()
        .ServerOperation(false)
        .Read(read => read.Action("TransactionsAjax", controller))
        .PageSize(15))

In addition to the grid, the page has 3 other fields; a combobox and 2 date fields that filter the grid. The filtering works fine.

However, the printer friendly button calls TransactionsAjax for the Kendo grid and removes all filtering that was applied. The original Telerik just rendered the existing grid as print friendly without making a redundant call to TransactionsAjax.

Since the desired data to be printed is already filtered and available on the screen there is no reason to repeat the call. Is there some grid configuration setting I am missing that would stop the undesired call from happening?

Re: Telerik grid vs. Kendo grid and Ajax calls

littleGreenDude7-Feb-14 3:10

littleGreenDude

7-Feb-14 3:10

Posting my findings in case somebody runs on to a similar issue, maybe it will be helpful (plus the code to set the select elements in the cloned div is cool Cool | :cool:

).

I've worked around the issue. Something about the first line of javascript in our printer friendly function causes the Ajax call to occur with the Kendo grid where it didn't cause it with the original Telerik grid. Changed javascript function to use jQuery clone and things are working now.

Old code:

JavaScript

function ShowPrinterFriendly() {
    $("#printerFriendlyContent").html($("#mainContent").html());

New code:

JavaScript

function ShowPrinterFriendly() {

var $originalDiv = $("#mainContent");
var $clonedDiv = $originalDiv.clone();

//get original selects
var $originalSelects = $originalDiv.find("select");

//for all cloned selection objects
$clonedDiv.find("select").each(function(index, item) {
//set new select to value of old select
$(item).val($originalSelects.eq(index).val());
});
$clonedDiv.appendTo("#printerFriendlyContent");

RDLC Report Designing

Dnyaneshwar@Pune5-Feb-14 0:48

Dnyaneshwar@Pune

5-Feb-14 0:48

Suppose my stored procedure returns multiple datatable then how to manage that datatable in DataSet.xsd file

modified 6-Feb-14 3:30am.

Re: RDLC Report Designing

Zohaib Asad11-Feb-14 21:13

Zohaib Asad

11-Feb-14 21:13

Unfortunately If multiple result sets are retrieved through a single query, only the first result set is processed, and all other result sets are ignored.

Therefore, I suggest using one of two possibilities:

(1) Split the procedure into two separate procedures - one which returns data from EMP, and one from DEPT - and access the new procedures as two separate datasets.

(2) Union the two separate queries (with an additional column to indicate which query produced each row) and filter or conditionally format your report appropriately. The unioned query might look something like this:

SQL

SELECT EMPID ID, ENAME NAME, JOB JOB_LOC, SAL, DEPTID, 'EMP' SOURCE 
FROM EMP
UNION ALL
SELECT DEPTID ID, DNAME NAME, LOC JOB_LOC, NULL SAL, DEPTID DEPTID, 'DEPT' SOURCE
FROM DEPT

Question Event does not run when I click image that has event attached to it

versm1ca4-Feb-14 22:21

versm1ca

4-Feb-14 22:21

Hello Everybody,

I would like to know if there is something I am missing why my ASP.NET is not running the script that is embedded in the master page, I imagine that it should be running in any page using the master page (where I have the event embedded) as shown in my screenshot but to my surprise it doesn't run the alert message ..

When I click any of the images I am not seeing the alert box that I am expecting as a response to the click event ..

My code is shown below .. any help much appreciated .. thanks again:

ASP.NET

<%@ Master Language="C#" AutoEventWireup="true" CodeFile="Site.master.cs" Inherits="SiteMaster" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head runat="server">
    <title></title>
    <link href="~/Styles/Site.css" rel="stylesheet" type="text/css" />
    <script src="Scripts/jquery-1.4.1.js" type="text/javascript" >
    
        $('.main').ready(
             function () {
                 alert('hello');
             });

        $('img').click(
             function () {
                 alert('hello from image');
             
             });

    </script>
    <script src="Scripts/myJavascriptTools.js" type="text/javascript" >
    </script>
    <asp:ContentPlaceHolder ID="HeadContent" runat="server">
    </asp:ContentPlaceHolder>
</head>
<body>

Re: Question Event does not run when I click image that has event attached to it

Deflinek5-Feb-14 0:48

Deflinek

5-Feb-14 0:48

After http://www.w3schools.com/tags/tag_script.asp[^]

Quote:
If the "src" attribute is present, the <script> element must be empty.

Put your script in separate element after jquery and it should run correctly.
<div class="signature">--
"My software never has bugs. It just develops random features."</div>

Re: Question Event does not run when I click image that has event attached to it

versm1ca5-Feb-14 7:19

versm1ca

5-Feb-14 7:19

I am so excited it is starting to work .. I moved the script to a separate script tag as shown (just as you have advised) and it started showing up the "hello" message every time I open up a page attached to the master file .. yeeeey ... Smile | :)

$('.main').ready -------------- this event is working perfect

The way the code was written when the beautiful thing event I report happens is shown below:

XML

<%@ Master Language="C#" AutoEventWireup="true" CodeFile="Site.master.cs" Inherits="SiteMaster" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head runat="server">
    <title></title>
    <link href="~/Styles/Site.css" rel="stylesheet" type="text/css" />
    <script src="Scripts/jquery-1.4.1.js" type="text/javascript" >



    </script>
    <script  type="text/javascript" >

        $('.main').ready(
             function () {
                 alert('hello');
             });

        $('img').click(
             function () {
                 alert('hello from image');

             });

    </script>
    <asp:ContentPlaceHolder ID="HeadContent" runat="server">
    </asp:ContentPlaceHolder>
</head>

The one I find odd however is that the click event is still not getting triggered
for some reason .. so what I did next was try to change it to a different tag targeting paragraph tag instead of img but retain it in the same spot i.e.

$('p').click(

The result is that it still is not triggered when I click from a paragraph the way it was not working when I was clicking from an image using the original code which used the img tag.

So I decided to try changing the event to a mouseover instead of a click as shown below:

$('p').mouseover(

Unfortunately the event is still not get triggered when I move my mouse over the paragraph elements ..

So at this point I am thinking it does not seem to have
anything to do with the tag selector or the event type ..
I decided to experiment and move the code as close to the
page being called (I'd wish of course that it could be
centralized in just one page i.e. Site.master) but just
for the sake of experiment I tried putting the code in the
page itself that is being called as shown below:

XML

<%@ Page Title="Home Page" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true"
    CodeFile="Default.aspx.cs" Inherits="_Default" %>

<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">
</asp:Content>
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
        <script  type="text/javascript" >

            $('p').click(
             function () {
                 alert('hello from click of paragraph');

             });

       </script>
    <h2>
        Testing this page.
        <asp:TreeView ID="TreeView1" runat="server">
        </asp:TreeView>
    </h2>
    <p> testing paragraph1
    </p>

    <p>
        testing paragraph2
    </p>

     <img src = "Image/coreTechnologies.png">


</asp:Content>

Unfortunately I still cannot get the click event to run
.. and right now I am scratching my head and trying to dig
in the books what I am still missing ... all help much appreciated ..thanks again and more power

Re: Question Event does not run when I click image that has event attached to it

Richard Deeming5-Feb-14 8:15

Richard Deeming

5-Feb-14 8:15

You're executing the script before the browser has finished loading the body of the document, so there are no <img> or <p> tags for it to process.

The simplest solution is to make sure your script doesn't run before the body has been loaded:

HTML

<script src="Scripts/jquery-1.4.1.js" type="text/javascript"></script>
<script type="text/javascript">

$(function(){
   
   // This script will not execute until the body has loaded.
   // However, it *might* execute before all images/videos/etc. have finished loading.
   
   $('img').click(function(){
      alert('hello from image');
   });
   
});

</script>

It's also a good idea to move your scripts to the bottom of the page, just before the closing </body> tag.

If the content of the document might change after it's loaded, and you want the event handler to work on any new tags that get added, you can use jQuery's on method[^] to attach the handler at the document level:

JavaScript

$(document).on('click', 'img', function(){
    alert('hello from image');
});

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

CLOSED --- Re: Question Event does not run when I click image that has event attached to it

versm1ca5-Feb-14 14:00

versm1ca

5-Feb-14 14:00

Awesome ... thanks so much ... this has solved the problem I was having ...

It is my first time to ask a question here and not sure how to close a question Thumbs Up | :thumbsup:

I do not know how to give this answer the five stars it deserves .. thumbs up in text
above indicates this to be the answer .. thanks again

radiobuttonlist change event with javascript

ptvce4-Feb-14 1:21

ptvce

4-Feb-14 1:21

I have 2 RadioButtonList
rdBtnPersonel_Status and rdBtnPersonel_FoodStatus

i wrote :

XML

<asp:RadioButtonList runat="server" ID="rdBtnPersonel_Status" RepeatDirection="Horizontal" Width="100%"
                                                                                DataSourceID="ObjDsPersonelStatuses" onclick="javascript:radioButtonListOnClick('<%#((RadiobuttonList)Container.FindControl("rdBtnPersonel_Status")).ClientID %>');">

                                                                            </asp:RadioButtonList>

i want when i click rdBtnPersonel_Status , if the valu eual A the rdBtnPersonel_FoodStatus be disabled. (with javascript)

can any body help me?

Flash Banner in Mobile asp.net

Fcode-20143-Feb-14 21:28

Fcode-2014

3-Feb-14 21:28

I tried to change the flash banner text from 50% to 60% and its only show 60% in Desktops not in mobile.
Please let me know if any one have the solution detail and steps of how to fix it Frown | :(

modified 4-Feb-14 4:01am.

If else structure problem

Hunain Hafeez3-Feb-14 18:44

Hunain Hafeez

3-Feb-14 18:44

In if else structure when null arguments are passed to two string variables then it always hit the condition when i have set Var1 != "" && Var2 != "" why ? since nulls are passed to both then why it hits this condition ?

code:

public ActionResult ShowCalTextBox(String DateFrom, String DateTo)
        {

           if (DateFrom != "" && DateTo == "")
            {
                IEnumerable<GetEmpRec_DateResult> EmpRec_DateFrom = DataContext.GetEmpRec_Date(DateFrom, null).ToList();
                ViewBag.Dates = "Records for"+" "+ DateFrom ;
                return View(EmpRec_DateFrom);

            }
            else if (DateFrom == "" && DateTo != "")
            {
                IEnumerable<GetEmpRec_DateResult> EmpRec_DateTo = DataContext.GetEmpRec_Date(null, DateTo).ToList();
                ViewBag.Dates = "Records for" + " " + DateTo;
                return View(EmpRec_DateTo);
            }
            else if (DateFrom != "" && DateTo != "")
            {
                IEnumerable<GetEmpRec_DateResult> EmpRec_ByDate = DataContext.GetEmpRec_Date(DateFrom, DateTo).ToList();
                ViewBag.Dates = "Records from" + " " + DateFrom +" "+"to"+" "+DateTo;
                return View(EmpRec_ByDate);
            }
            else if (DateFrom == "" && DateTo == "")
            {
                IEnumerable<GetEmpRec_DateResult> EmpRec_Default = DataContext.GetEmpRec_Date(null, null).ToList();
                ViewBag.Dates = "No date selection";
                return View(EmpRec_Default);
            }

            return View();
        }

it hits this one when i first browse this action or run this action.

else if (DateFrom == "" && DateTo != "")

Re: If else structure problem

Kornfeld Eliyahu Peter3-Feb-14 20:17

Kornfeld Eliyahu Peter

3-Feb-14 20:17

null isn't "" (empty string)!!!
You should use String.IsNullOrEmpty(string_var) to check for both...

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

Retry on duplicate keys ex

byka3-Feb-14 6:50

byka

3-Feb-14 6:50

How can I catch and retry if I got a duplicate keys error?
If InsertProviderMasterCommand failed due to dups go to GenerateKeys
and try again???

Try
    GenerateKeys(myRow)
    If InsertProviderMasterCommand(myRow) = True Then
          MasterInsertCount += 1
    End If
Catch ex As Exception
     Throw ex
  End Try

Re: Retry on duplicate keys ex

Kornfeld Eliyahu Peter3-Feb-14 9:52

Kornfeld Eliyahu Peter

3-Feb-14 9:52

If you want to retry than why waste on try-catch block - do a simple while loop around the insert part...

bool bDo = true;

while(bDo)
{
  GenerateKeys(myRow);
  if(InsertProviderMasterCommand(myRow))
  {
    MasterInsertCount += 1;
    bDo = false;
  }
}

(I know you are a VB fan - but I can't bring myself to write that kind of code - sorry Wink | ;)

)

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

ASP.Net Best Practices

DotnetCoders0012-Feb-14 5:10

DotnetCoders001

2-Feb-14 5:10

Hi Friends,

I want to know some good books to refer for "ASP.Net best practices" ,I have googled the same and there are so many books available.So can any of you tell me some good book to refer depending upon your reading experiences.

Regards

Re: ASP.Net Best Practices

Snehasish_Nandy2-Feb-14 19:12

Snehasish_Nandy

2-Feb-14 19:12

It's my personal choice
http://www.charlespetzold.com/dotnet/[^] Thumbs Up | :thumbsup:

Re: ASP.Net Best Practices

Richard MacCutchan2-Feb-14 22:00

Richard MacCutchan

2-Feb-14 22:00

Snehasish_Nandy wrote:
It's my personal choice

But it has nothing to do with ASP.NET.

Veni, vidi, abiit domum

Re: ASP.Net Best Practices

thatraja2-Feb-14 20:35

thatraja

2-Feb-14 20:35

Check this one[^] but the version is 3.5 & out of print. Book was from Apress.

Why only Books? Education Needed[^]

In Codeproject you could find more than bunch of articles on ASP.NET Best practices.

thatraja

Code converters | Education Needed
No thanks, I am all stocked up. - Luc Pattyn
When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is - Henry Minute

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