protected void btnSearch_Click(object sender, EventArgs e)
{
perlabEntities db = new perlabEntities();
eventsfeed obj = new eventsfeed();
var key = (txtSearch.Text);
var result = from ev in db.eventsfeeds
where ev.descrip.Contains(key)
select new { ev.title, ev.descrip, ev.call, ev.deadline };
GridView1.DataSource = result.ToList();
GridView1.DataBind();
DeleteTxt();
}
protected void btnDelete_Click(object sender, EventArgs e)
{
perlabEntities db = new perlabEntities();
eventsfeed obj = new eventsfeed();
obj.event_id = int.Parse((txtEventId.Text));
var result = (from p in db.eventsfeeds
where p.event_id == obj.event_id
select p).Single();
db.eventsfeeds.Remove(result);
db.SaveChanges();
BindGridView();
DeleteTxt();
}
protected void btnEdit_Click(object sender, EventArgs e)
{
perlabEntities db = new perlabEntities();
eventsfeed obj = new eventsfeed();
obj.event_id = int.Parse((txtEventId.Text));
var result = (from p in db.eventsfeeds
where p.event_id == obj.event_id
select p).Single();
result.call = txtCall.Text;
result.link = txtLink.Text;
result.deadline = txtDeadline.Text;
result.active = (int.Parse(dropActive.SelectedItem.Text) == 1) ? true : false;
result.descrip = txtDescrip.Text;
db.eventsfeeds.Add(result);
db.SaveChanges();
BindGridView();
DeleteTxt();
}
