protected void btnSearch_Click(object sender, EventArgs e)
{
perlabEntities db = new perlabEntities();
newsfeed obj = new newsfeed();
var key = (txtSearch.Text);
var result = from ne in db.newsfeeds
where ne.title.Contains(key)
select new { ne.news_id, ne.title, ne.link, ne.active, ne.descrip };
GridView1.DataSource = result.ToList();
GridView1.DataBind();
DeleteTxt();
}
protected void btnDelete_Click(object sender, EventArgs e)
{
perlabEntities db = new perlabEntities();
newsfeed obj = new newsfeed();
obj.news_id = int.Parse((txtNewsId.Text));
var result = (from n in db.newsfeeds
where n.news_id == obj.news_id
select n).Single();
db.newsfeeds.Remove(result);
db.SaveChanges();
BindGridView();
DeleteTxt();
}
protected void btnEdit_Click(object sender, EventArgs e)
{
perlabEntities db = new perlabEntities();
newsfeed obj = new newsfeed();
obj.news_id = int.Parse((txtNewsId.Text));
var result = (from n in db.newsfeeds
where n.news_id == obj.news_id
select n).Single();
result.title = txtTitle.Text;
result.link = txtLink.Text;
result.descrip = txtDescrip.Text;
result.active = (dropActive.SelectedItem.Text) == "Yes"?true:false;
result.descrip = txtDescrip.Text;
db.newsfeeds.Add(result);
db.SaveChanges();
BindGridView();
DeleteTxt();
}
