protected void grdLinkWeb_ItemCommand(object source, DataGridCommandEventArgs e) { string strCA = e.CommandArgument.ToString(); switch (e.CommandName) { case "Edit": Insert = false; Id = strCA; dt = LinkWebService.LinkWeb_GetByTop("1", "Id=" + Id, ""); txtName.Text = dt.Rows[0]["Name"].ToString(); txtLink.Text = dt.Rows[0]["Link"].ToString(); PageHelper.LoadDropDownListLanguage(ddlLanguage); ddlLanguage.SelectedValue = dt.Rows[0]["Lang"].ToString(); txtOrd.Text = dt.Rows[0]["Ord"].ToString(); chkActive.Checked = dt.Rows[0]["Active"].ToString() == "1" || dt.Rows[0]["Active"].ToString() == "True"; pnView.Visible = false; pnUpdate.Visible = true; break; case "Active": string strA = ""; string str = e.Item.Cells[2].Text; strA = str == "1" ? "0" : "1"; SqlDataProvider sql = new SqlDataProvider(); sql.ExecuteNonQuery("Update [LinkWeb] set Active=" + strA + " Where Id='" + strCA + "'"); BindGrid(); break; case "Delete": LinkWebService.LinkWeb_Delete(strCA); BindGrid(); break; } }
protected void Update_Click(object sender, EventArgs e) { if (Page.IsValid) { Data.LinkWeb obj = new Data.LinkWeb(); obj.Id = Id; obj.Name = txtName.Text; obj.Link = txtLink.Text; obj.Lang = ddlLanguage.SelectedValue; obj.Ord = txtOrd.Text != "" ? txtOrd.Text : "1"; obj.Active = chkActive.Checked ? "1" : "0"; if (Insert == true) { LinkWebService.LinkWeb_Insert(obj); } else { LinkWebService.LinkWeb_Update(obj); } BindGrid(); pnView.Visible = true; pnUpdate.Visible = false; Insert = false; } }
private void BindGrid() { grdLinkWeb.DataSource = LinkWebService.LinkWeb_GetByTop("", "", "Ord"); grdLinkWeb.DataBind(); if (grdLinkWeb.PageCount <= 1) { grdLinkWeb.PagerStyle.Visible = false; } else { grdLinkWeb.PagerStyle.Visible = true; } }
protected void DeleteButton_Click(object sender, EventArgs e) { DataGridItem item = default(DataGridItem); for (int i = 0; i < grdLinkWeb.Items.Count; i++) { item = grdLinkWeb.Items[i]; if (item.ItemType == ListItemType.AlternatingItem | item.ItemType == ListItemType.Item) { if (((CheckBox)item.FindControl("ChkSelect")).Checked) { string strId = item.Cells[1].Text; LinkWebService.LinkWeb_Delete(strId); } } } grdLinkWeb.CurrentPageIndex = 0; BindGrid(); }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { if (Request.Cookies["CurrentLanguage"] != null) { Lang = Request.Cookies["CurrentLanguage"].Value; } DataTable dtVanBan = NewsService.News_GetByTop("", "Active=1 AND GroupNewsId IN (Select Id from GroupNews where Active=1 AND [Index]=1 AND Language='" + Lang + "') AND Language='" + Lang + "'", "Date DESC"); if (dtVanBan.Rows.Count > 0) { rptVanBan.DataSource = PageHelper.ModifyData(dtVanBan, Consts.CON_VAN_BAN); rptVanBan.DataBind(); rptVanBan01.DataSource = dtVanBan; rptVanBan01.DataBind(); } dtVanBan.Clear(); dtVanBan.Dispose(); DataTable dtVideo = VideosService.Videos_GetByTop("10", "Active=1 AND Language='" + Lang + "'", "Ord"); if (dtVideo.Rows.Count > 0) { vId = dtVideo.Rows[0]["Link"].ToString(); VideoName = dtVideo.Rows[0]["Name"].ToString(); rptVideo.DataSource = dtVideo; rptVideo.DataBind(); } DataTable dtNews = NewsService.News_GetByTop("10", "Active=1 AND GroupNewsId IN (Select Id from GroupNews where Active=1 AND [Index]=0) AND Language='" + Lang + "'", "Views DESC"); rptReadMost.DataSource = PageHelper.ModifyData(dtNews, Consts.CON_TIN_TUC); rptReadMost.DataBind(); DataTable dtLink = LinkWebService.LinkWeb_GetByTop("", "Active=1 AND Lang='" + Lang + "'", "Ord"); rptLinkWeb.DataSource = dtLink; rptLinkWeb.DataBind(); } } catch (Exception ex) { MailSender.SendMail("", "", "Error System", ex.Message); } }