private void Bind_dtlList()
{
List<NewsInfo> list = new CNews(CCommon.LANG).Getlistrelated(Relateditem);
(new GenericList<NewsInfo>()).Bind_DataList(rptList, null, list, 0);
pnlList.Visible = list != null && list.Count > 0;
return;
}
protected void cmdCopyOk_Click(object sender, EventArgs e)
{
try
{
string iidstr = txtIidstr.Value;
int dest_cid = int.Parse(ddlCopycid.SelectedValue);
lstError = new List<Errorobject>();
if (CFunctions.IsNullOrEmpty(iidstr) || dest_cid == 0)
{
lstError = Form_GetError(lstError, Errortype.Error, Definephrase.Copy_error, "", null);
Master.Form_ShowError(lstError);
return;
}
CNews BLL = new CNews(CCommon.LANG);
string[] iidarr = iidstr.Split(',');
for (int i = 0; i < iidarr.Length; i++)
{
NewsInfo info = BLL.Wcmm_Getinfo(int.Parse(iidarr[i]));
this.Copy_Info(info, dest_cid, BLL);
}
cmdCopyOk.Enabled = false;
lstError = Form_GetError(lstError, Errortype.Completed, Definephrase.Copy_completed, "", null);
Master.Form_ShowError(lstError);
}
catch (Exception ex)
{
CCommon.CatchEx(ex);
}
}
public void Set(string relateditem)
{
try
{
string vlreturn = "<table id=\"RN_listselectedNews\" class=\"RN_listselectedNews\">";
List<NewsInfo> list = new List<NewsInfo>();
if (!CFunctions.IsNullOrEmpty(relateditem))
{
list = new CNews(CCommon.LANG).Wcmm_Getlist(relateditem);
if (list != null && list.Count > 0)
{
for (int i = 0; i < list.Count; i++)
{
NewsInfo info = (NewsInfo)list[i];
vlreturn += "<tr id=\"rnrowi" + i + "\" class=\"rnrowi\">"
+ "<td class=\"rnnote\">" + info.Name + "</td>"
+ "<td class=\"rnsort\">" + info.Cname + "</td>"
+ "<td class=\"rncomd\"><a href=\"javascript:RNremove(" + info.Id + "," + i + ");\">x</a></td></tr>";
}
}
}
RN_containerNews.InnerHtml = vlreturn + "</table>";
RN_containerNews.Attributes.Add("title", list == null ? "0" : list.Count.ToString());
RN_txtRelatedid.Value = relateditem;
return;
}
catch (Exception ex)
{
CCommon.CatchEx(ex);
}
}
public void ProcessRequest(HttpContext context)
{
string cid = context.Request.QueryString["cid"];
string vlreturn = "";
if (!CFunctions.IsNullOrEmpty(cid) && cid != "0")
{
vlreturn = "{\"newsinfo\":[";
List<NewsInfo> list = new CNews(CCommon.LANG).Wcmm_Getlist(int.Parse(cid));
if (list != null && list.Count > 0)
{
for (int i = 0; i < list.Count; i++)
{
NewsInfo info = (NewsInfo)list[i];
vlreturn += "{\"newsname\":\"" + info.Name.Replace("\"", "\\\"") + "\", \"newsid\":\"" + info.Id + "\"}" + (i == list.Count - 1 ? "" : ",");
}
}
vlreturn += "]}";
}
string iid = context.Request.QueryString["iid"];
if (!CFunctions.IsNullOrEmpty(iid))
{
vlreturn = "{\"newsinfo\":[";
List<NewsInfo> list = new CNews(CCommon.LANG).Wcmm_Getlist(iid);
if (list != null && list.Count > 0)
{
for (int i = 0; i < list.Count; i++)
{
NewsInfo info = (NewsInfo)list[i];
vlreturn += "{\"newsname\":\"" + info.Name.Replace("\"", "\\\"") + "\", \"newsid\":\"" + info.Id + "\", \"newscategory\":\"" + info.Cname + "\"}" + (i == list.Count - 1 ? "" : ",");
}
}
vlreturn += "]}";
}
context.Response.ContentType = "text/plain";
context.Response.Write(vlreturn);
}
public List<CategoryInfo> Getlist(int cid, int pid, ListOptions options, out int numResults)
{
try
{
List<CategoryInfo> arr = null;
using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM))
{
string SQL = SQL_GETIFOPAGING.Replace(Queryparam.Varstring.VAR_SORTEXPRESSION, CFunctions.Expression_GetSort(options.SortExp, options.SortDir));
SQL += " AND A.status<>" + (int)CConstants.State.Status.Waitactive;
SQL += " AND A.status<>" + (int)CConstants.State.Status.Disabled;
SQL += options.Markas == (int)CConstants.State.MarkAs.None ? "" : " AND A.markas=" + options.Markas;
SQL += cid == 0 ? "" : " AND A.cid=" + cid;
SQL += pid == -1 ? "" : " AND A.pid=" + pid;
SQL = "SELECT * FROM(" + SQL + ") AS T WHERE id<>0 " + CFunctions.Expression_GetLimit(options.PageIndex, options.PageSize);
using (iSqlDataReader dar = HELPER.executeReader(iConn, SQL))
{
while (dar.Read())
{
CategoryInfo info = this.getDataReader(dar);
if (arr == null)
arr = new List<CategoryInfo>();
arr.Add(info);
}
dar.Close();
}
numResults = this.Getlistcount(iConn, cid, pid);
if(arr != null)
{
foreach (var cate in arr)
{
if (cate.Pid == 61)
{
CNews news = new CNews("vn");
cate.dictCount = news.GetDictCount(iConn, cate.Id.ToString());
}
}
}
iConn.Close();
}
return arr;
}
catch (Exception ex)
{
throw ex;
}
}
public CategoryInfo Getinfo(int id)
{
if (id == -1) return null;
try
{
CategoryInfo info = null;
using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM))
{
string SQL = SQL_GETIFO + " AND A.id=@ID";
SQL += " AND A.status<>" + (int)CConstants.State.Status.Waitactive;
SQL += " AND A.status<>" + (int)CConstants.State.Status.Disabled;
iSqlParameter[] parms = new iSqlParameter[]{
new iSqlParameter(PARM_ID, iSqlType.Field_tInterger),
};
int i = -1;
parms[++i].Value = id;
using (iSqlDataReader dar = HELPER.executeReader(iConn, iCommandType.Text, SQL, parms))
{
if (dar.Read())
{
info = this.getDataReader(dar);
}
}
if(info != null)
{
CNews news = new CNews("vn");
info.dictCount = news.GetDictCount(iConn,info.Id.ToString());
}
iConn.Close();
}
return info;
}
catch (Exception ex)
{
throw ex;
}
}
private void Load_Info(int iid)
{
CNews DAL = new CNews(CCommon.LANG);
NewsInfo info = DAL.Getinfo(iid);
if (info != null)
{
if (info.Allowcomment > 0)
{
CommentInfo comment = new CComment(CCommon.LANG).Getinforating(Webcmm.Id.News, info.Id);
if (comment != null)
{
if ((comment.Viewcounter + 1) != info.Allowcomment)
{
info.Allowcomment = comment.Viewcounter + 1;
DAL.Updatenum(info.Id.ToString(), Queryparam.Sqlcolumn.Allowcomment, info.Allowcomment);
}
info.Rating = comment.Rating / (comment.Viewcounter == 0 ? 1 : comment.Viewcounter);
}
}
List<NewsInfo> list = new List<NewsInfo>();
list.Add(info);
(new GenericList<NewsInfo>()).Bind_DataList(rptInfo, null, list, 0);
DAL.Updatenum(iid.ToString(), Queryparam.Sqlcolumn.Viewcounter, CConstants.NUM_INCREASE);
Master.AddMeta_Title(info.Name);
Master.AddMeta_Description(info.Introduce);
Master.AddMeta_Keywords(info.Tag);
}
pnlListfollow.Visible = pnlInfo.Visible = info != null;
}
private void Move_Info(NewsInfo source_info, int dest_cid, CNews BLL)
{
if (source_info == null) return;
NewsInfo info_copy = source_info.copy();
info_copy.Cid = dest_cid;
info_copy.Status = CCommon.GetStatus_upt();
info_copy.Username = CCommon.Get_CurrentUsername();
info_copy.Timeupdate = DateTime.Now;
BLL.Save(info_copy);
}
private void Copy_Info(NewsInfo source_info, int dest_cid, CNews BLL)
{
if (source_info == null) return;
NewsInfo info_copy = source_info.copy();
info_copy.Id = 0;
info_copy.Cid = dest_cid;
info_copy.Status = CCommon.GetStatus_upt();
info_copy.Username = CCommon.Get_CurrentUsername();
info_copy.Timeupdate = DateTime.Now;
info_copy.Allowcomment = source_info.Allowcomment > 0 ? 1 : 0;
info_copy.Orderd = 0;
BLL.Save(info_copy);
}
protected void cmdUpdateorder_Click(object sender, ImageClickEventArgs e)
{
try
{
if (grdView.Rows.Count == 0) return;
CNews BLL = new CNews(CCommon.LANG);
foreach (GridViewRow row in grdView.Rows)
{
HiddenField txtId = (HiddenField)row.FindControl("txtId");
TextBox txtOrderd = (TextBox)row.FindControl("txtOrderd");
if (txtId != null && txtOrderd != null)
{
int id = int.Parse(txtId.Value);
int orderd = 0;
int.TryParse(txtOrderd.Text, out orderd);
BLL.Updatenum(id.ToString(), Queryparam.Sqlcolumn.Orderd, orderd);
}
lstError = new List<Errorobject>();
lstError = Form_GetError(lstError, Errortype.Completed, Definephrase.Saveorderd_completed, "", null);
Master.Form_ShowError(lstError);
}
}
catch
{
lstError = new List<Errorobject>();
lstError = Form_GetError(lstError, Errortype.Error, Definephrase.Saveorderd_error, "", null);
Master.Form_ShowError(lstError);
}
}
protected void cmdSave_Click(object sender, EventArgs e)
{
try
{
string iid = CCommon.Get_FormString(Queryparam.Chkcheck);
if (CFunctions.IsNullOrEmpty(iid)) return;
int rssId = 0;
string websiteUrl = "", nodeContent = "", nodeTitle = "", nodeIntroduce = "";
foreach (RepeaterItem row in rptList.Items)
{
HiddenField txtId = (HiddenField)row.FindControl("txtId");
rssId = txtId == null ? 0 : int.Parse(txtId.Value);
websiteUrl = ((HiddenField)row.FindControl("txtWebsiteUrl")).Value;
nodeContent = ((HiddenField)row.FindControl("txtNodecontent")).Value;
nodeTitle = ((HiddenField)row.FindControl("txtNodetitle")).Value;
nodeIntroduce = ((HiddenField)row.FindControl("txtNodeintroduce")).Value;
}
iid = "," + iid + ",";
CNews DAL = new CNews(CCommon.LANG);
foreach (GridViewRow row in grdView.Rows)
{
HiddenField txtId = (HiddenField)row.FindControl("txtId");
HiddenField txtTitle = (HiddenField)row.FindControl("txtTitle");
HiddenField txtDescription = (HiddenField)row.FindControl("txtDescription");
HiddenField txtLink = (HiddenField)row.FindControl("txtLink");
if (txtId != null)
{
string id = txtId.Value;
if (iid.IndexOf("," + id + ",") != -1)
{
NewsInfo info = new NewsInfo();
info.Name = txtTitle.Value;
info.Code = "";
info.Introduce = txtDescription.Value;
info.Description = radSavetype.SelectedIndex == 0 ? this.Get_NewsContent(txtLink.Value, websiteUrl, nodeContent, nodeTitle, nodeIntroduce) : "";
info.Url = radSavetype.SelectedIndex == 0 ? "" : txtLink.Value;
info.Author = websiteUrl.Replace("http://", "");
info.Cid = int.Parse(ddlCid.SelectedValue);
info.Cname = ddlCid.SelectedItem.Text.Replace("-", "");
info.Timeexpire = CFunctions.Get_Datetime(CFunctions.Set_Datetime(DateTime.Now.AddDays(365)));
info.Status = CCommon.GetStatus_upt();
info.Username = CCommon.Get_CurrentUsername();
info.Timeupdate = DateTime.Now;
DAL.Save(info);
}
}
}
lstError = new List<Errorobject>();
lstError = Form_GetError(lstError, Errortype.Completed, Definephrase.Save_completed, "", null);
Master.Form_ShowError(lstError);
(new CRSSResource(CCommon.LANG)).Updatestr(rssId.ToString(), "timelastestget", DateTime.Now);
}
catch
{
lstError = new List<Errorobject>();
lstError = Form_GetError(lstError, Errortype.Error, Definephrase.Save_error, "", null);
Master.Form_ShowError(lstError);
}
}
private void Load_Info(int iid)
{
CNews DAL = new CNews(CCommon.LANG);
NewsInfo info = DAL.Getinfo(iid);
if (info != null)
{
if (info.Allowcomment > 0)
{
CommentInfo comment = new CComment(CCommon.LANG).Getinforating(Webcmm.Id.News, info.Id);
if (comment != null)
{
if ((comment.Viewcounter + 1) != info.Allowcomment)
{
info.Allowcomment = comment.Viewcounter + 1;
DAL.Updatenum(info.Id.ToString(), Queryparam.Sqlcolumn.Allowcomment, info.Allowcomment);
}
info.Rating = comment.Rating / (comment.Viewcounter == 0 ? 1 : comment.Viewcounter);
}
}
List<NewsInfo> list = new List<NewsInfo>();
list.Add(info);
list = list.OrderBy(m => m.Name).ToList();
(new GenericList<NewsInfo>()).Bind_DataList(rptInfo, null, list, 0);
DAL.Updatenum(iid.ToString(), Queryparam.Sqlcolumn.Viewcounter, CConstants.NUM_INCREASE);
breadcrums += tach;
string linkCat = "<a href=\"/tu-dien-thuat-ngu-" + Langview + "/" + info.eUrl2 + "\">" + info.Name + "</a>";
breadcrums += linkCat;
Master.AddMeta_Title(info.Name);
Master.AddMeta_Description(info.Introduce);
Master.AddMeta_Keywords(info.Tag);
}
pnlListfollow.Visible = pnlInfo.Visible = info != null;
}
