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