Comments by dorababu407 (Top 45 by date)

@Raul lloc : Thank you , i implemented your suggestion , SQL lite with Wcf .

My application should scan tickets without internet it's a client requirement. so i need to get online data to local database.

i used array objects only, but not as output parameter

i tried previously by passing multiple images as array of objects but not as output parameter. i tried this solution before i posted question here but not succeed.

I think i have left that issue. i had done my work on my backup code.
please check this link it may be helpful.
http://forums.asp.net/t/1133305.aspx?FatalExecutionEngineError+was+detected

below solution works for me except in firefox.
http://www.codeproject.com/Tips/154801/How-to-end-user-session-when-browser-closed

yes , i thought the same , it is for checking closing the browser using X button.
but it is not working , i checked in chrome, firefox and IE10,11.

i put window.onbeforeunload in one of my view page, when i click other page it is logging out.
i need to call ajax post method on browser close only , not by clicking other links.

one issue.
i used your code without if condition [if (window.event.clientX < 0||window.event.clientY < 0)], works fine. by adding if condition not working, condition is not satisfying. what is that
window.event.clientX ,window.event.clientX

Thank you. works fine

Lazy Load is delays loading of images in long web pages. my application home page is not long. but it has slider images taking time to load.
https://www.bumpdocs.com/

IS there anything to add in config file ?
can u provide complete code snipppt

i am observing these method executes continuously

SignalR: Attempting to connect to 'http://www.test.com/signalr/poll?transport=longPolling&connectionToken=v…22name%22%3A%22chat%22%7D%5D&messageId=B%2C0%7CC%2C0%7CD%2C0%7CE%2C0&tid=5' using longPolling

i did it , but same error occurs

hi Griff,
i changed my code using filter, this time i applied Gzip compression through Coding by adding CompressFilter.cs class in App_start folder and then i add [CompressFilter] in Controllers.

First time i did Gzip compression using Web.config by adding Gzip.dll in <system.weserver> tag,
But it did't worked.

hi,
i applied Gzip Compression in my web.config file in Shared hosting, but it is not working(Gzip compression is not enable). i did same for my another site web.config(it is also shared hosting) but it is working fine.
i don't know what the difference between them. i used Visual Studio 2010 mvc4 for first one, Visual studio 2012 for second one, is that cause any difference?
plz help me

thanks for rply.
i just follow the link and change my global.asax page, Is that enough to decrease the page load time, i does'nt see time difference page loading

i just see about SignalR Concept, i think it is not useful for me, becoz it sends all Admin post to all customers. i just want face to face chat( Admin - Customer) chat. chat conversation of one customer will not be see by other customers.Registered customers only allowed to chat.

yes, its working fine now.
you are not slow and you are good in managing time by answering questions and doing your work.
Thank you..
can i have your EmailId ?

Thank you, for spending lot of time for my questions . its really helpful.
Do u have any blog? if there please give me URL

Here is the link for Results of my query
https://www.dropbox.com/s/zibpn3ptq0keaws/ZipCodes.txt

i think query calculating distance not exactly from given ZipCode,
that's why it showing distance very large values

please check it once

ya, i tried it but it shows the same error:
Invalid column name 'distance' .

why the distances is showing above 600 km from a given every Zipcode?

just for know forgot about WHERE and HAVING.
i just removed the distance comparasion in the query.
Now iam getting results all Zipcodes and distances from the ZipCode i given.
whatever the Zip Code i am giving it shows distnace in above 500 km.

here is the query:
SELECT zipcode, ( 3959 * acos( cos( radians(94595) ) * cos( radians(latitude ) ) * cos( radians(longitude)
- radians(94595) ) + sin( radians(94595) ) * sin( radians(latitude ) ) ) ) AS distance
FROM dbo.ZIP

here i gave Zipcode as 94595, in the results it showing distance 11355 km for the behind zipcode 94596.

Sql Server 2008R2

if having clause is used, it shows error:
Invalid column name 'distance'

here is the same query with having clause

SELECT zipcode, ( 3959 * acos( cos( radians(94595) ) * cos( radians(latitude ) ) * cos( radians(longitude)
- radians(94595) ) + sin( radians(94595) ) * sin( radians(latitude ) ) ) ) AS distance
FROM dbo.ZIP HAVING distance < 25 ORDER BY distance ASC

same query i write it again becoz of HAVING clause is not worked for
distance comparision(HAVING distance < 25).

here is the query

SELECT zipcode, ( 3959 * acos( cos( radians(94595) ) * cos( radians(latitude ) ) * cos( radians(longitude)
- radians(94595) ) + sin( radians(94595) ) * sin( radians(latitude ) ) ) ) AS distance
FROM dbo.ZIP

i just changed the type latitude/longitude to decimal(9,6). i got result for your command, but i think it was not accurate, because it showing distance above 600 miles.

here is the cmd

SELECT zipcode, ( 3959 * acos( cos( radians(94595) ) * cos( radians(latitude ) ) * cos( radians(longitude)
- radians(94595) ) + sin( radians(94595) ) * sin( radians(latitude ) ) ) ) AS distance
FROM dbo.ZIP where (( 3959 * acos( cos( radians(94595) ) * cos( radians(latitude ) ) * cos( radians(longitude )
- radians(94595) ) + sin( radians(94595) ) * sin( radians(latitude ) ) ) ) < 7500) ORDER BY distance ASC

what is 3959 in the query?

our values for latitude and longitudes are in vachar type, can you please suggest me how to convert them from varchar to geography or how to query the varchar type values with the above query. we are not even able to run the sql query. it is giving invalid columns as my datatype are in varchar type. please let me know a solution to the problem. Thanks

how can we write command for convert given radius to latitude and longitude .
my input is ZipCode and Radius(km) only.
in my database table has four fields, 1)ZIPCode 2)latitude 3) longitude 4)StateAbbreviation
how can i write code for this ? plz help me

i check my code using break point, i think here problem is progress bar is unable to show UI status when data downloading from SQL to XML. after data downloaded i write some code to excute(to kill sometime) at that time progress bar occurs shows.

hi phil.o,
thnks for rply.
here in BeginInvoke method i was unable to assign value to progressbar.
it was showing Error " Cannot convert Lambda expression to 'System.delegate' becoz it is non=delegate type"

hi Tejas Vaishnav ,thanks for rply.
i got solution after refer this link
http://stackoverflow.com/questions/7740693/big-issue-in-converting-string-to-datetime-using-linq-to-entities.

Convert.ToDateTime does,t works. i just done Date comparision in foreach loop after getting data from database using link query.
here is my code
public ActionResult UserCommonPage()
{
DateTime PresentDate = DateTime.Now.Date;
DateTime EndDate;

IEnumerable<usercommonpagemodel> Data = (from e in _repository.EventInfo
where e.WasEventLive == true
select new UserCommonPageModel
{
EndDate = e.EndDate,
EventEndDate = e.EndDate,
EventInfoId = e.EventInfoID,
EventTitle = e.EventTitle,
VenueName = e.VenueName,
EventLogoURL = e.EventLogo,
EventDescription = e.EventDescription,
EventStartDate = e.StartDate,
}).ToList();

List<usercommonpagemodel> obj = new List<usercommonpagemodel>();
int Count = Data.Count();

foreach (var item in Data)
{
EndDate = Convert.ToDateTime(item.EndDate);
if (EndDate.Date >= PresentDate.Date)
{
obj.Add(item);
}
}


return View(obj);

}

hi Tejas Vaishnav,
thanks for rply, here is my code.
iam trying to get records only EndDate is greater than PresentDate using Linq Query in MVC4.

DateTime PresentDate = DateTime.Now.Date;
var EventDetails = (from e in _repository.EventInfo
where e.WasEventLive == true && e.EndDate < PresentDate
select new UserCommonPageModel
{
EventInfoId = e.EventInfoID,
EventTitle = e.EventTitle,
EventEndDate = e.EndDate
}).ToList();
return View(EventDetails);

hi saguptamca, thks for rply

i checked the values are correct, data binding is fine, but filter of my last column(IsTicketValidated) not working after grid rebinding.