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();
}
