protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { ColProcedureParam[] Coloumns = new ColProcedureParam[1]; Coloumns[0] = new ColProcedureParam("SubNesourceID", Request.QueryString["NID"].ToString()); DataTable dataTable = new DataTable(); dataTable = DBop.cobject.SelectDataSetProcedureTable("myChannel", Coloumns).Tables[0]; if ((dataTable != null) && (dataTable.Rows.Count > 0)) { laName.Text = Convert.ToString(dataTable.Rows[0]["SubNesourceName"]); lafollowers.Text = " عدد المتابعين " + Convert.ToString(dataTable.Rows[0]["Followers"]); UserImageURL = Convert.ToString(dataTable.Rows[0]["ChannelImage"]); UserImageBackgroundURL = Convert.ToString(dataTable.Rows[0]["BacugroundPicture"]); } //SqlDataSource1.SelectParameters["NewsID"].DefaultValue = "0"; //SqlDataSource1.SelectParameters["EndTo"].DefaultValue = "20"; } ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "HideLoading();", true); // rest button //DBop.cobject.DeletedRow("UserFollowing", "UserID=" + UserID + " and SubNesourceID=" + SubNesourceID) }
protected void BuLoadMore_Click(object sender, EventArgs e) { // SqlDataSource1.SelectParameters["EndTo"].DefaultValue = Convert.ToString(DataList1.Items.Count + 20); //ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "MoveScroll();", true); //HFMaxScrol.Value = "0"; // HeaderMessage.Visible = false; if (HFMaxScrol.Value == "-1") { SqlDataSource1.SelectParameters["NewsID"].DefaultValue = "0"; SqlDataSource1.SelectParameters["EndTo"].DefaultValue = "30"; // newfeedDiv.Visible = false; // ScriptManager.RegisterStartupScript(this, this.GetType(), "Popa", "HideNewNewsDiv();", true); // ScriptManager.RegisterStartupScript(this, this.GetType(), "Popb", "ShowNoMoreNews();", true); DataList1.DataBind(); // HeaderMessage.Visible = true; } else if (HFMaxScrol.Value == "30") { SqlDataSource1.SelectParameters["NewsID"].DefaultValue = DataList1.DataKeys[0].ToString(); SqlDataSource1.SelectParameters["EndTo"].DefaultValue = Convert.ToString(DataList1.Items.Count + 50); // ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "MoveScroll();", true); DataList1.DataBind(); } else { // check if there is new news DataTable dataTable = new DataTable(); //password = Myenc.GetMD5Data(Encoding.Default.GetBytes(password)); ColProcedureParam[] Coloumns = new ColProcedureParam[3]; Coloumns[0] = new ColProcedureParam("UserID", Convert.ToString(Request.QueryString["id"])); // temp be 1 Coloumns[1] = new ColProcedureParam("SubNesourceID", "0"); Coloumns[2] = new ColProcedureParam("NewsID", DataList1.DataKeys[0].ToString()); // Coloumns[3] = new ColProcedureParam("NewsID", DataList1.DataKeys[0].ToString()); dataTable = DBop.cobject.SelectDataSetProcedureTable("IsGetNews", Coloumns).Tables[0]; if ((!Convert.ToString(dataTable.Rows[0]["CountItem"]).Equals("0"))) { // LiMessage.Text = "<strong>Warning!</strong> " + DBop.cobject.ErrorMessage; // ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "ShowNewNewsDiv();", true); SqlDataSource1.SelectParameters["NewsID"].DefaultValue = "0"; SqlDataSource1.SelectParameters["EndTo"].DefaultValue = "30"; DataList1.DataBind(); } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "NewNewsempty();", true); } } // HFMaxScrol.Value = "0"; // HeaderMessageLoading.Visible = false; ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "HideLoading();", true); }
public string GetSubNesources(int NesourceID, int UserID) /// get list of notes { JavaScriptSerializer ser = new JavaScriptSerializer(); DBConnection DBop = new DBConnection(); DataTable dataTable = new DataTable(); string[] SubResourcesName = null; // for samll size string[] SubNesourceID = null; string[] IsFollow = null; string[] NumberOfFollowers = null; string[] ChannelImage = null; // string[] NesourceID = null; // int HasNewNews = 0; ColProcedureParam[] Coloumns = new ColProcedureParam[2]; Coloumns[0] = new ColProcedureParam("NesourceID", NesourceID.ToString());// Request.QueryString["id"]);// temp be 1 Coloumns[1] = new ColProcedureParam("UserID", UserID.ToString()); dataTable = DBop.cobject.SelectDataSetProcedureTable("GetSubNesources", Coloumns).Tables[0]; if ((dataTable != null) && (dataTable.Rows.Count > 0)) { SubResourcesName = new string[dataTable.Rows.Count]; SubNesourceID = new string[dataTable.Rows.Count]; IsFollow = new string[dataTable.Rows.Count]; NumberOfFollowers = new string[dataTable.Rows.Count]; ChannelImage = new string[dataTable.Rows.Count]; //HasNewNews = 1; for (int i = 0; i < dataTable.Rows.Count; i++) { //SubResourcesName[i] = "{'name': '" + Convert.ToString(dataTable.Rows[i]["SubNesourceName"]) + "'}"; SubResourcesName[i] = Convert.ToString(dataTable.Rows[i]["SubNesourceName"]); SubNesourceID[i] = Convert.ToString(dataTable.Rows[i]["SubNesourceID"]); IsFollow[i] = Convert.ToString(dataTable.Rows[i]["IsFollow"]); NumberOfFollowers[i] = Convert.ToString(dataTable.Rows[i]["NumberOfFollowers"]); ChannelImage[i] = Convert.ToString(dataTable.Rows[i]["ChannelImage"]); } } var jsonData = new { Tag = "SubResources", ResourcesName = SubResourcesName, SubNesourceID = SubNesourceID, IsFollow = IsFollow, NumberOfFollowers = NumberOfFollowers, ChannelImage = ChannelImage }; return(ser.Serialize(jsonData)); //products.ToString(); }
public string InitializeAccount(string MAC) /// get list of notes { JavaScriptSerializer ser = new JavaScriptSerializer(); DBConnection DBop = new DBConnection(); // add acount DataTable dataTable = new DataTable(); Boolean AlreadyRegistered = true; dataTable = DBop.cobject.SelectDataSet("Users", "PhoneMac", "PhoneMac='" + MAC + "'").Tables[0]; if ((dataTable == null) || (dataTable.Rows.Count == 0)) { // if the phone is not already registered ColoumnParam[] Coloumns = new ColoumnParam[2]; Coloumns[0] = new ColoumnParam("DateRegister", ColoumnType.DateTime, DateTime.Now.ToString()); Coloumns[1] = new ColoumnParam("PhoneMac", ColoumnType.varchar50, MAC); DBop.cobject.InsertRow("Users", Coloumns); AlreadyRegistered = false; } string UserID = ""; // get user info dataTable = DBop.cobject.SelectDataSet("Users", "UserID", "PhoneMac='" + MAC + "'").Tables[0]; if ((dataTable != null) && (dataTable.Rows.Count > 0)) { UserID = Convert.ToString(dataTable.Rows[0]["UserID"]); if (AlreadyRegistered == false) { // only for first time install we add him ColProcedureParam[] Coloumns = new ColProcedureParam[1]; Coloumns[0] = new ColProcedureParam("UserID", UserID.ToString()); // Request.QueryString["id"]);// temp be 1 try { DBop.cobject.SelectDataSetProcedureTable("AddDefultChannels", Coloumns); } catch (Exception ex) { } } } var jsonData = new { IsAdded = AlreadyRegistered, UserID = UserID }; return(ser.Serialize(jsonData)); //products.ToString(); }
public void UsersPhoneLocations(string UserUID) { DBConnection DBop = new DBConnection(); ResponsePhoneInfo messeageResponsePhoneInfo = new ResponsePhoneInfo(); DataTable dataTable = new DataTable(); JavaScriptSerializer ser = new JavaScriptSerializer(); dataTable = DBop.NewConectionDLL.SelectDataSet("Admins", " UserID ", " UserUID = '" + UserUID + "'").Tables[0]; if ((dataTable == null) || (dataTable.Rows.Count == 0)) { messeageResponsePhoneInfo.ErrorID = (int)ErrorNumbers.NotFound; HttpContext.Current.Response.Write(ser.Serialize(messeageResponsePhoneInfo)); return; } int UserID = (int)dataTable.Rows[0]["UserID"]; ColProcedureParam[] Coloumns1 = new ColProcedureParam[1]; Coloumns1[0] = new ColProcedureParam("UserID", Convert.ToString(UserID)); dataTable = DBop.NewConectionDLL.SelectDataSetProcedureTable("GetUpdateLocation", Coloumns1).Tables[0]; if ((dataTable != null) && (dataTable.Rows.Count > 0)) { PhonesInfo[] phonelist = new PhonesInfo[dataTable.Rows.Count]; for (int i = 0; i < dataTable.Rows.Count; i++) { phonelist[i] = new PhonesInfo( Convert.ToString(dataTable.Rows[i]["PhoneUID"]), Convert.ToString(dataTable.Rows[i]["PhoneName"]), (int)dataTable.Rows[i]["BatteryLevel"], Convert.ToDouble(dataTable.Rows[i]["Latitude"]), Convert.ToDouble(dataTable.Rows[i]["longitude"]), Convert.ToString(dataTable.Rows[i]["DateRecord"])); } messeageResponsePhoneInfo.UsersPhonesInfo = phonelist; messeageResponsePhoneInfo.ErrorID = (int)ErrorNumbers.Found; HttpContext.Current.Response.Write(ser.Serialize(messeageResponsePhoneInfo)); return; } else { messeageResponsePhoneInfo.ErrorID = (int)ErrorNumbers.NotFound; HttpContext.Current.Response.Write(ser.Serialize(messeageResponsePhoneInfo)); return; } }
public void GetOneSubNesources(int UserID, int VarSubNesourceID = 0) /// get list of notes { JavaScriptSerializer ser = new JavaScriptSerializer(); DBConnection DBop = new DBConnection(); DataTable dataTable = new DataTable(); string SubResourcesName = null; // for samll size string SubNesourceID = null; string IsFollow = null; string NumberOfFollowers = null; string ChannelImage = null; // string[] NesourceID = null; // int HasNewNews = 0; ColProcedureParam[] Coloumns = new ColProcedureParam[2]; Coloumns[0] = new ColProcedureParam("UserID", UserID.ToString()); Coloumns[1] = new ColProcedureParam("SubNesourceID", VarSubNesourceID.ToString()); dataTable = DBop.cobject.SelectDataSetProcedureTable("GetOneSubNesources", Coloumns).Tables[0]; if ((dataTable != null) && (dataTable.Rows.Count > 0)) { //HasNewNews = 1; //SubResourcesName[i] = "{'name': '" + Convert.ToString(dataTable.Rows[i]["SubNesourceName"]) + "'}"; SubResourcesName = Convert.ToString(dataTable.Rows[0]["SubNesourceName"]); SubNesourceID = Convert.ToString(dataTable.Rows[0]["SubNesourceID"]); IsFollow = Convert.ToString(dataTable.Rows[0]["IsFollow"]); NumberOfFollowers = Convert.ToString(dataTable.Rows[0]["NumberOfFollowers"]); ChannelImage = Convert.ToString(dataTable.Rows[0]["ChannelImage"]); } var jsonData = new { ResourcesName = SubResourcesName, SubNesourceID = SubNesourceID, IsFollow = IsFollow, NumberOfFollowers = NumberOfFollowers, ChannelImage = ChannelImage }; // return ser.Serialize(jsonData); //products.ToString(); HttpContext.Current.Response.Write(ser.Serialize(jsonData)); }
public void IsGetNews(string UserID, string NewsID, string q, string SubNesourceID) { if (q.Equals("@")) { q = "%"; } else { q = "%" + q.Trim() + "%"; } JavaScriptSerializer ser = new JavaScriptSerializer(); DBConnection DBop = new DBConnection(); // check if there is new news DataTable dataTable = new DataTable(); //password = Myenc.GetMD5Data(Encoding.Default.GetBytes(password)); ColProcedureParam[] Coloumns = new ColProcedureParam[4]; Coloumns[0] = new ColProcedureParam("UserID", UserID);// temp be 1 Coloumns[1] = new ColProcedureParam("SubNesourceID", SubNesourceID); Coloumns[2] = new ColProcedureParam("NewsID", NewsID); Coloumns[3] = new ColProcedureParam("q", q); dataTable = DBop.cobject.SelectDataSetProcedureTable("IsGetNews", Coloumns).Tables[0]; if ((!Convert.ToString(dataTable.Rows[0]["CountItem"]).Equals("0"))) { var r = new { Tag = 1, newData = "newNews" }; HttpContext.Current.Response.Write(ser.Serialize(r)); } else { var r = new { Tag = 0, newData = "NonewNews" }; HttpContext.Current.Response.Write(ser.Serialize(r)); } }
[WebMethod] // display new news is comming public static string NewNewsComming(string Tag, string UserID, string NewsID, string q) { DBConnection DBop = new DBConnection(); // check if there is new news DataTable dataTable = new DataTable(); //password = Myenc.GetMD5Data(Encoding.Default.GetBytes(password)); ColProcedureParam[] Coloumns = new ColProcedureParam[4]; Coloumns[0] = new ColProcedureParam("UserID", UserID); // temp be 1 Coloumns[1] = new ColProcedureParam("SubNesourceID", "0"); Coloumns[2] = new ColProcedureParam("NewsID", NewsID); Coloumns[3] = new ColProcedureParam("q", q); dataTable = DBop.cobject.SelectDataSetProcedureTable("IsGetNews", Coloumns).Tables[0]; if ((!Convert.ToString(dataTable.Rows[0]["CountItem"]).Equals("0"))) { return("newNews"); } else { return("NonewNews"); } }
public void GetNewsNow(string UserID, string StratFrom, string EndTo, string SubNesourceID, string NewsID, string q, string Type) { if (q.Equals("@")) { q = "%"; } else { q = "%" + q.Trim() + "%"; } //definaltions MyNewDetails[] myresourcesn = null; JavaScriptSerializer ser = new JavaScriptSerializer(); DBConnection DBop = new DBConnection(); // check if there is new news DataTable dataTable = new DataTable(); //password = Myenc.GetMD5Data(Encoding.Default.GetBytes(password)); ColProcedureParam[] Coloumns = new ColProcedureParam[7]; Coloumns[0] = new ColProcedureParam("UserID", UserID);// temp be 1 Coloumns[1] = new ColProcedureParam("StratFrom", StratFrom); Coloumns[2] = new ColProcedureParam("EndTo", EndTo); Coloumns[3] = new ColProcedureParam("SubNesourceID", SubNesourceID); Coloumns[4] = new ColProcedureParam("NewsID", NewsID); Coloumns[5] = new ColProcedureParam("q", q); Coloumns[6] = new ColProcedureParam("Type", Type); try { dataTable = DBop.cobject.SelectDataSetProcedureTable("GetNews", Coloumns).Tables[0]; if ((dataTable != null) && (dataTable.Rows.Count > 0)) { myresourcesn = new MyNewDetails[dataTable.Rows.Count]; for (int i = 0; i < dataTable.Rows.Count; i++) { myresourcesn[i] = new MyNewDetails(); myresourcesn[i].Row = Convert.ToString(dataTable.Rows[i]["Row"]); myresourcesn[i].NewsTitle = Convert.ToString(dataTable.Rows[i]["NewsTitle"]); myresourcesn[i].SubNesourceID = Convert.ToString(dataTable.Rows[i]["SubNesourceID"]); myresourcesn[i].PicturLink = Convert.ToString(dataTable.Rows[i]["PicturLink"]); myresourcesn[i].InvestmentLink = Convert.ToString(dataTable.Rows[i]["InvestmentLink"]); myresourcesn[i].NewsDateN = Convert.ToString(dataTable.Rows[i]["NewsDateN"]); myresourcesn[i].NewsID = Convert.ToString(dataTable.Rows[i]["NewsID"]); myresourcesn[i].SubNesourceName = Convert.ToString(dataTable.Rows[i]["SubNesourceName"]); myresourcesn[i].ChannelImage = Convert.ToString(dataTable.Rows[i]["ChannelImage"]); myresourcesn[i].readers = Convert.ToString(dataTable.Rows[i]["readers"]); } var r = new { Tag = 1, newData = myresourcesn }; HttpContext.Current.Response.Write(ser.Serialize(r)); } else { var r = new { Tag = 0, // no news newData = "" }; HttpContext.Current.Response.Write(ser.Serialize(r)); } } catch (Exception ex)//incuase error return { var r = new { Tag = 0, // no news newData = "" }; HttpContext.Current.Response.Write(ser.Serialize(r)); } }
public string GetMyResources(int UserID) /// get list of notes { JavaScriptSerializer ser = new JavaScriptSerializer(); DBConnection DBop = new DBConnection(); DataTable dataTable = new DataTable(); DataTable dataTableSubResources = new DataTable(); string[] ResourcesName = null; string[] NesourceID = null; string[] ImageLink = null; // int HasNewNews = 0; myresources[] myresourcesn = null; dataTable = DBop.cobject.SelectDataSet("ResourcesForUser", "ResourcesName,NesourceID,ImageLink", "UserID=" + UserID, "ResourcesName").Tables[0]; if ((dataTable != null) && (dataTable.Rows.Count > 0)) { ResourcesName = new string[dataTable.Rows.Count]; NesourceID = new string[dataTable.Rows.Count]; ImageLink = new string[dataTable.Rows.Count]; myresourcesn = new myresources[dataTable.Rows.Count]; //HasNewNews = 1; for (int i = 0; i < dataTable.Rows.Count; i++) { // sub rsourcess class string[] SubResourcesName = null; // for samll size string[] SubNesourceID = null; string[] IsFollow = null; string[] NumberOfFollowers = null; string[] ChannelImage = null; ColProcedureParam[] Coloumns = new ColProcedureParam[2]; Coloumns[0] = new ColProcedureParam("NesourceID", Convert.ToString(dataTable.Rows[i]["NesourceID"]));// Request.QueryString["id"]);// temp be 1 Coloumns[1] = new ColProcedureParam("UserID", UserID.ToString()); dataTableSubResources = DBop.cobject.SelectDataSetProcedureTable("GetMySubNesources", Coloumns).Tables[0]; if ((dataTableSubResources != null) && (dataTableSubResources.Rows.Count > 0)) { // get all sub rsourcs for every resources SubResourcesName = new string[dataTableSubResources.Rows.Count]; SubNesourceID = new string[dataTableSubResources.Rows.Count]; IsFollow = new string[dataTableSubResources.Rows.Count]; NumberOfFollowers = new string[dataTableSubResources.Rows.Count]; ChannelImage = new string[dataTableSubResources.Rows.Count]; //HasNewNews = 1; for (int j = 0; j < dataTableSubResources.Rows.Count; j++) { //SubResourcesName[i] = "{'name': '" + Convert.ToString(dataTable.Rows[i]["SubNesourceName"]) + "'}"; SubResourcesName[j] = Convert.ToString(dataTableSubResources.Rows[j]["SubNesourceName"]); SubNesourceID[j] = Convert.ToString(dataTableSubResources.Rows[j]["SubNesourceID"]); IsFollow[j] = Convert.ToString(dataTableSubResources.Rows[j]["IsFollow"]); NumberOfFollowers[j] = Convert.ToString(dataTableSubResources.Rows[j]["NumberOfFollowers"]); ChannelImage[j] = Convert.ToString(dataTableSubResources.Rows[j]["ChannelImage"]); } } myresourcesn[i] = new myresources(); myresourcesn[i].ResourcesName = Convert.ToString(dataTable.Rows[i]["ResourcesName"]); myresourcesn[i].NesourceID = Convert.ToString(dataTable.Rows[i]["NesourceID"]); myresourcesn[i].ImageLink = Convert.ToString(dataTable.Rows[i]["ImageLink"]); myresourcesn[i].SubNesourceID = SubNesourceID; myresourcesn[i].IsFollow = IsFollow; myresourcesn[i].NumberOfFollowers = NumberOfFollowers; myresourcesn[i].ChannelImage = ChannelImage; myresourcesn[i].SubResourcesName = SubResourcesName; } } var r = new { imageLink = myresourcesn }; return(ser.Serialize(r)); //products.ToString(); }
public void GetNewsDetials(int NewsIDvar, int UserID) { JavaScriptSerializer ser = new JavaScriptSerializer(); DBConnection DBop = new DBConnection(); DataTable dataTable = new DataTable(); string Row = null; string SubNesourceID = null; string NewsTitle = null; string PicturLink = null; string InvestmentLink = null; string NewsDateN = null; string NewsID = null; string SubNesourceName = null; string ChannelImage = null; string NewsDetails = null; int HasNewNews = 0; string ReadFromWebsiteLink = null; // get last news ColProcedureParam[] Coloumns1 = new ColProcedureParam[1]; Coloumns1[0] = new ColProcedureParam("NewsID", Convert.ToString(NewsIDvar)); dataTable = DBop.cobject.SelectDataSetProcedureTable("GetNewsDetials", Coloumns1).Tables[0]; if ((dataTable != null) && (dataTable.Rows.Count > 0)) { // //SaveNews is readed by person ColoumnParam[] Coloumns = new ColoumnParam[3]; Coloumns[0] = new ColoumnParam("NewsID", ColoumnType.Int, NewsIDvar); Coloumns[1] = new ColoumnParam("UserID", ColoumnType.Int, UserID); Coloumns[2] = new ColoumnParam("DateRead", ColoumnType.DateTime, DateTime.Now.ToString()); DBop.cobject.InsertRow("Readers", Coloumns); Row = Convert.ToString(dataTable.Rows[0]["Row"]); SubNesourceID = Convert.ToString(dataTable.Rows[0]["SubNesourceID"]); NewsTitle = Convert.ToString(dataTable.Rows[0]["NewsTitle"]); PicturLink = Convert.ToString(dataTable.Rows[0]["PicturLink"]); //InvestmentLink[i] = Convert.ToString(dataTable.Rows[i]["InvestmentLink"]); ; NewsDateN = Convert.ToString(dataTable.Rows[0]["NewsDateN"]); NewsID = Convert.ToString(dataTable.Rows[0]["NewsID"]); SubNesourceName = Convert.ToString(dataTable.Rows[0]["SubNesourceName"]); ChannelImage = Convert.ToString(dataTable.Rows[0]["ChannelImage"]); NewsDetails = Convert.ToString(dataTable.Rows[0]["NewsDetails"]); ReadFromWebsiteLink = Convert.ToString(dataTable.Rows[0]["ReadFromWebsiteLink"]); HasNewNews = 1; } var jsonData = new { HasNew = HasNewNews, Row = Row, SubNesourceID = SubNesourceID, NewsTitle = NewsTitle, PicturLink = PicturLink, InvestmentLink = InvestmentLink, NewsDateN = NewsDateN, NewsID = NewsID, SubNesourceName = SubNesourceName, ChannelImage = ChannelImage, NewsDetails = NewsDetails, ReadFromWebsiteLink = ReadFromWebsiteLink }; //return ser.Serialize(jsonData); //products.ToString(); HttpContext.Current.Response.Write(ser.Serialize(jsonData)); }
public string GetNews(int UserID, int StratFrom, int EndTo, int SubNesourceIDvar, string NewsIDvar, string q) { JavaScriptSerializer ser = new JavaScriptSerializer(); DBConnection DBop = new DBConnection(); DataTable dataTable = new DataTable(); string[] Row = null; string[] SubNesourceID = null; string[] NewsTitle = null; string[] PicturLink = null; string[] InvestmentLink = null; string[] NewsDateN = null; string[] NewsID = null; string[] SubNesourceName = null; string[] ChannelImage = null; int HasNewNews = 0; // get last news ColProcedureParam[] Coloumns1 = new ColProcedureParam[6]; Coloumns1[0] = new ColProcedureParam("UserID", Convert.ToString(UserID));// Request.QueryString["id"]);// temp be 1 Coloumns1[1] = new ColProcedureParam("SubNesourceID", Convert.ToString(SubNesourceIDvar)); Coloumns1[2] = new ColProcedureParam("NewsID", Convert.ToString(NewsIDvar)); Coloumns1[3] = new ColProcedureParam("q", q); Coloumns1[4] = new ColProcedureParam("StratFrom", Convert.ToString(StratFrom)); Coloumns1[5] = new ColProcedureParam("EndTo", Convert.ToString(EndTo)); dataTable = DBop.cobject.SelectDataSetProcedureTable("GetNews", Coloumns1).Tables[0]; if ((dataTable != null) && (dataTable.Rows.Count > 0)) { Row = new string[dataTable.Rows.Count]; SubNesourceID = new string[dataTable.Rows.Count]; NewsTitle = new string[dataTable.Rows.Count]; PicturLink = new string[dataTable.Rows.Count]; InvestmentLink = new string[dataTable.Rows.Count]; NewsDateN = new string[dataTable.Rows.Count]; NewsID = new string[dataTable.Rows.Count]; SubNesourceName = new string[dataTable.Rows.Count]; ChannelImage = new string[dataTable.Rows.Count]; //HasNewNews = 1; for (int i = 0; i < dataTable.Rows.Count; i++) { Row[i] = Convert.ToString(dataTable.Rows[i]["Row"]); SubNesourceID[i] = Convert.ToString(dataTable.Rows[i]["SubNesourceID"]); NewsTitle[i] = Convert.ToString(dataTable.Rows[i]["NewsTitle"]); PicturLink[i] = Convert.ToString(dataTable.Rows[i]["PicturLink"]); InvestmentLink[i] = Convert.ToString(dataTable.Rows[i]["InvestmentLink"]);; NewsDateN[i] = Convert.ToString(dataTable.Rows[i]["NewsDateN"]); NewsID[i] = Convert.ToString(dataTable.Rows[i]["NewsID"]); SubNesourceName[i] = Convert.ToString(dataTable.Rows[i]["SubNesourceName"]); ChannelImage[i] = Convert.ToString(dataTable.Rows[i]["ChannelImage"]); } HasNewNews = 1; } var jsonData = new { Row = Row, SubNesourceID = SubNesourceID, NewsTitle = NewsTitle, PicturLink = PicturLink, InvestmentLink = InvestmentLink, NewsDateN = NewsDateN, NewsID = NewsID, SubNesourceName = SubNesourceName, ChannelImage = ChannelImage }; return(ser.Serialize(jsonData)); //products.ToString(); }
public string IsGetNewsWithHeader(string NewsID, int UserID) /// get list of notes { JavaScriptSerializer ser = new JavaScriptSerializer(); DBConnection DBop = new DBConnection(); DataTable dataTable = new DataTable(); string[] NewsTitle = null; string[] NewsIDAr = null; int HasNewNews = 0; //************* deprectaed it should check new update for every 45 minutes to get news to server //dataTable = DBop.cobject.SelectDataSet("CheckService", " DATEDIFF(minute,[CheckDate],getdate()) as minuteleft", " DATEDIFF(minute,[CheckDate],getdate())>5").Tables[0]; //if ((dataTable != null) && (dataTable.Rows.Count > 0)) //{ // this mean we need to call the service agin to update news // // update last callservice date // ColoumnParam[] Coloumns = new ColoumnParam[1]; // Coloumns[0] = new ColoumnParam("CheckDate", ColoumnType.DateTime, DateTime.Now.ToString()); // if (DBop.cobject.UpdateRow("CheckService", Coloumns, "CheckID=1")) // { // // call all service to bring new news // // // //CallService cl = new CallService(); // //Thread signalRConnectionRecovery1 = new Thread(cl.SignalRConnectionRecovery); // //signalRConnectionRecovery1.IsBackground = true; // //signalRConnectionRecovery1.Start(); // // MethodInvoker simpleDelegate = new MethodInvoker(Foo); // // Calling Foo Async // // simpleDelegate.BeginInvoke(null, null); // } //} // get last news ColProcedureParam[] Coloumns1 = new ColProcedureParam[4]; Coloumns1[0] = new ColProcedureParam("UserID", Convert.ToString(UserID));// Request.QueryString["id"]);// temp be 1 Coloumns1[1] = new ColProcedureParam("SubNesourceID", "0"); Coloumns1[2] = new ColProcedureParam("NewsID", NewsID); Coloumns1[3] = new ColProcedureParam("q", "%عاجل%"); dataTable = DBop.cobject.SelectDataSetProcedureTable("IsGetNewsWithHeader", Coloumns1).Tables[0]; if ((dataTable != null) && (dataTable.Rows.Count > 0)) { NewsTitle = new string[dataTable.Rows.Count]; NewsIDAr = new string[dataTable.Rows.Count]; //HasNewNews = 1; for (int i = 0; i < dataTable.Rows.Count; i++) { NewsTitle[i] = Convert.ToString(dataTable.Rows[i]["NewsTitle"]); NewsIDAr[i] = Convert.ToString(dataTable.Rows[i]["NewsID"]); } HasNewNews = 1; } var jsonData = new { HasNews = HasNewNews, NewsTitle = NewsTitle, NewsIDAr = NewsIDAr }; return(ser.Serialize(jsonData)); //products.ToString(); }