Asp.net: How to frequently refresh page using json Ajax request.

Aspx page

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="3way.aspx.cs" Inherits="Bettingdisplays1" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<%--<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js" type="text/javascript"></script>--%>

setInterval(function ShowCurrentTime() {

$.ajax({

type: "POST",

url: "3way.aspx/BindMarketSubbetType",

data: '{id: "' + $("#<%=hdneventId.ClientID%>")[0].value + '" }',

contentType: "application/json; charset=utf-8",

dataType: "json",

success: OnSuccess,

failure: function(response) {

}

});

}, 3000);

function OnSuccess(response) {

$('#divMarket').html(response.d);

}

</script>

</head>

<body>

<asp:HiddenField ID="hdneventId" runat="server" Value="0" />

<asp:Panel ID="pnlMarket" runat="server" Visible="">

</div>

</asp:Panel>

<asp:Panel ID="Panel1" runat="server" Visible="false">

Please Pass the eventId in URL.

</div>

</asp:Panel>

</div>

</form>

</body>

</html>

webMethod

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

using System.Text;

using TurfSportOnline.Library;

using TurfSportOnline.Library.Template;

using TurfSportOnline.Library.WSBackOfficeSec;

using TurfSportOnline;

using System.Configuration;

using System.Data.SqlClient;

using Properties;

using Helper;

using DataAccessLayer;

using System.Data.Common;

public partial class Bettingdisplays1 : System.Web.UI.Page

{

string tournamentID = string.Empty;

string tournamentDates = string.Empty;

string name = string.Empty;

SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);

private static DBHelper objDALHelper = new DBHelper();

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

if (Request.QueryString["eventId"] != null)

hdneventId.Value = Request.QueryString["eventId"];

else

Panel1.Visible=true;

}

private DataTable GetNextList()

{

DataTable dts = new DataTable();

try

{

SqlCommand cmd = new SqlCommand("spTournamentsLVINP", con);

cmd.CommandType = CommandType.StoredProcedure;

SqlDataAdapter da = new SqlDataAdapter(cmd);

da.Fill(dts);

}

catch (Exception ex)

{

throw ex;

}

return dts;

}

private static DataTable CreateTableEvent()

{

DataTable dt = new DataTable();

dt.Columns.Add("eventId", Type.GetType("System.Int32"));

dt.Columns.Add("tournamentId", Type.GetType("System.Int32"));

dt.Columns.Add("eventDate", Type.GetType("System.DateTime"));

dt.Columns.Add("payPlaces", Type.GetType("System.Int32"));

return dt;

}

private static void AddThisRowEventRow(ref DataTable dt, int? eventId, int? tournamentId, DateTime eventDate, int? payPlaces)

{

DataRow dr = dt.NewRow();

dr["eventId"] = eventId;

dr["tournamentId"] = tournamentId;

dr["eventDate"] = eventDate;

dr["payPlaces"] = payPlaces;

dt.Rows.Add(dr);

}

protected void rptTour_OnItemDataBound(object sender, RepeaterItemEventArgs e)

{

if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)

{

HiddenField hd = (HiddenField)e.Item.FindControl("tID");

CheckBox chk = (CheckBox)e.Item.FindControl("chkID");

chk.Attributes.Add("onclick", "setvalue(this," + hd.Value + ")");

}

public static List<Pro_NextEventList> GetEventListByTournament(int eventId)

{

objDALHelper = new DBHelper();

List<Pro_NextEventList> objPro_NextEventList2 = new List<Pro_NextEventList>();

try

{

objDALHelper.Command.Parameters.Clear();

objDALHelper.AddParameter("@eventId", eventId);

using (DbDataReader dr = (DbDataReader)objDALHelper.ExecuteReader("spSelectLPeventById", CommandType.StoredProcedure))

{

while (dr.Read())

{

Pro_NextEventList objPro_NextEventList = new Pro_NextEventList();

// objPro_NextEventList.Id = CommanLogic.GetIntValue(dr["id"], 0);

// objPro_NextEventList.sportId = CommanLogic.GetIntValue(dr["sportId"], 0);

objPro_NextEventList.tournamentId = CommanLogic.GetIntValue(dr["tournamentId"], 0);

objPro_NextEventList.eventId = CommanLogic.GetIntValue(dr["eventId"], 0);

objPro_NextEventList.betType = CommanLogic.GetIntValue(dr["betType"], 0);

objPro_NextEventList.subBetTypes = CommanLogic.GetIntValue(dr["subBetTypes"], 0);

objPro_NextEventList.eventName = CommanLogic.GetStringValue(dr["eventName"], string.Empty);

objPro_NextEventList.eventNumber = CommanLogic.GetStringValue(dr["eventNumber"], string.Empty);

objPro_NextEventList.eventDate = CommanLogic.GetDateTimeValue(dr["eventDate"]);

objPro_NextEventList.eventStatus = CommanLogic.GetIntValue(dr["eventStatus"], 0);

objPro_NextEventList.wagerStart = CommanLogic.GetDateTimeValue(dr["wagerStart"]);

objPro_NextEventList.wagerEnd = CommanLogic.GetDateTimeValue(dr["wagerEnd"]);

objPro_NextEventList.displayStart = CommanLogic.GetDateTimeValue(dr["displayStart"]);

objPro_NextEventList.displayEnd = CommanLogic.GetDateTimeValue(dr["displayEnd"]);

objPro_NextEventList.CloseOnWagerEnd = CommanLogic.GetBoolValue(dr["CloseOnWagerEnd"], false);

objPro_NextEventList.PlacePerc = CommanLogic.GetIntValue(dr["PlacePerc"], 0);

objPro_NextEventList.PayPlaces = CommanLogic.GetIntValue(dr["PayPlaces"], 0);

objPro_NextEventList.LiveInRunning = CommanLogic.GetIntValue(dr["LiveInRunning"], 0);

objPro_NextEventList.LongtermAntePost = CommanLogic.GetIntValue(dr["LongtermAntePost"], 0);

objPro_NextEventList.CurrentBetting = CommanLogic.GetIntValue(dr["CurrentBetting"], 0);

objPro_NextEventList.spreadBetting = CommanLogic.GetIntValue(dr["spreadBetting"], 0);

objPro_NextEventList.exoticBetting = CommanLogic.GetIntValue(dr["exoticBetting"], 0);

objPro_NextEventList.comments = CommanLogic.GetStringValue(dr["comments"], string.Empty);

objPro_NextEventList2.Add(objPro_NextEventList);

}

catch (Exception ex)

{

throw ex;

}

finally

{ objDALHelper = null; }

return objPro_NextEventList2;

}

[System.Web.Services.WebMethod]

public static string BindMarketSubbetType(string id)

{

StringBuilder sb = new StringBuilder();

if (!string.IsNullOrEmpty(id))

{

int tId = Convert.ToInt32(id);

// pnlMarket.Visible = true;

// pnlTournament.Visible = false;

DataTable tdt = CreateTableEvent();

int v, d;

List<Properties.Pro_NextEventList> obj_pro_nexteventlist = new List<Properties.Pro_NextEventList>();

obj_pro_nexteventlist = GetEventListByTournament(Convert.ToInt32(tId));

for (int ii = 0; ii < obj_pro_nexteventlist.Count; ii++)

AddThisRowEventRow(ref tdt, obj_pro_nexteventlist[ii].eventId, obj_pro_nexteventlist[ii].tournamentId, obj_pro_nexteventlist[ii].eventDate, obj_pro_nexteventlist[ii].PayPlaces);

DataView dv1 = tdt.DefaultView;

dv1.Sort = "eventDate asc";

tdt = dv1.ToTable();

List<TurfSportOnline.Library.MarketList> obj_marketlist = new List<TurfSportOnline.Library.MarketList>();

Event event2 = null;

if (tdt.Rows.Count > 0)

{

// if (Request.QueryString["name"] == null)

//{

sb.Append("<div id='sliderwrap'>");

bool added = false;

for (int j = 0; j < 1; j++)

{

event2 = new Event(Convert.ToInt32(tdt.Rows[j]["eventId"]));

event2.Load();

event2.MarketList.Sort(new TurfSportOnline.Library.MarketList.MarketComparer());

// if (event2.MarketList[0].EventDate >= DateTime.Now && added == false)

// {

added = true;

sb.Append("<div class='contentslider'>");

sb.Append("<div class='tbl'>");

sb.Append("<table width='100%' class='uk-table uk-table-striped uk-table-condensed uk-text-nowrap' border='0' align='left' cellpadding='0' cellspacing='0'>");

sb.Append("<tr>");

//sb.Append("<h2>");

//// sb.Append("<em class='font35'>" + event2.MarketList[0].TournamentName + " (" + event2.MarketList[0].WagerEnd.ToString("dd MMM yyyy") + ")" + event2.MarketList[0].WagerEnd.ToString(" HH:mm") + " Race " + event2.MarketList[0].EventNumber + " [ " + tdt.Rows[j]["payPlaces"] + " Places ] </em></h2>");

//sb.Append("<em class='font35'> DateTime : " + DateTime.Now + " </em></h2>");

sb.Append("<h1 style='color:#005B31'>LIVE IN-PLAY BETTING <h2 style='color:#005B31'>");

// sb.Append("<em class='font35'>" + event2.MarketList[0].TournamentName + " (" + event2.MarketList[0].WagerEnd.ToString("dd MMM yyyy") + ")" + event2.MarketList[0].WagerEnd.ToString(" HH:mm") + " Race " + event2.MarketList[0].EventNumber + " [ " + tdt.Rows[j]["payPlaces"] + " Places ] </em></h2>");

sb.Append(event2.MarketList[0].EventName + "(3 ways odd)</h2></h1>");

sb.Append("</tr>");

sb.Append("<tr>");

//sb.Append("<td td width='15%' align='center' >");

//sb.Append("<h2>");

//sb.Append("<em class='font35'>NO</em></h2>");

//sb.Append("</td>");

sb.Append("<td width='66%'>");

sb.Append("<h2>");

sb.Append("MARKET NAME</h2>");

sb.Append("</td>");

sb.Append("<td width='19%' align='center'>");

sb.Append("<h2>");

sb.Append("HOME</h2>");

sb.Append("</td>");

sb.Append("<td width='15%' align='center'>");

sb.Append("<h2>");

sb.Append("DRAW</h2>");

sb.Append("</td>");

sb.Append("<td width='15%' align='center'>");

sb.Append("<h2>");

sb.Append("AWAY</h2>");

sb.Append("</td>");

//sb.Append("<td width='15%' align='center'>");

//sb.Append("<h2>");

//sb.Append("<em class='font35'>STATUS</em></h2>");

//sb.Append("</td>");

sb.Append("</tr>");

for (int i = 0; i < event2.MarketList.Count; i++)

{

if (event2.MarketList[i].Status != MarketStatus.Closed)

{

sb.Append("<tr>");

//sb.Append("<td width='15%' align='center'>");

//sb.Append("<h2>");

//sb.Append("<em class='font35'>" + event2.MarketList[i].Id + "</em></h2>");

//sb.Append("</td>");

sb.Append("<td width='66%' align='left'>");

sb.Append("<h2>");

if (event2.MarketList[i].Status == MarketStatus.Scratched)

sb.Append( event2.MarketList[i].MarketName + " (" + event2.MarketList[i].ScratchingDeduction.ToString("0.##") + "%)" + "</h2>");

else

sb.Append( event2.MarketList[i].MarketName + "</h2>");

sb.Append("</td>");

sb.Append("<td width='15%' align='center'>");

sb.Append("<h2>");

sb.Append(event2.MarketList[i].HomePrice.ToString("0.00") + "</h2>");

sb.Append("</td>");

sb.Append("<td width='15%' align='center'>");

sb.Append("<h2>");

sb.Append(event2.MarketList[i].DrawPrice.ToString("0.00") + "</h2>");

sb.Append("</td>");

sb.Append("<td width='15%' align='center'>");

sb.Append("<h2>");

sb.Append(event2.MarketList[i].AwayPrice.ToString("0.00") + "</h2>");

sb.Append("</td>");

//sb.Append("<td width='15%' align='center'>");

//sb.Append("<h2>");

//sb.Append("<em class='font35'>" + event2.MarketList[i].Status + "</em></h2>");

//sb.Append("</td>");

sb.Append("</tr>");

}

sb.Append("</table>");

sb.Append("</div>");

//}

// sb.Append("</div>");

}

sb.Append("</div>");

// divMarket.InnerHtml = sb.ToString();

}

// }

// else

// {

//Response.Redirect("Bettingdisplays.aspx");

//string url = HttpContext.Current.Request.Url.AbsoluteUri;

//Response.Redirect(url);

// }

}

return sb.ToString();

}

Friday, November 6, 2015

How to frequently refresh page using json Ajax request.

No comments:

Post a Comment

About Me

Pageviews

Followers