protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { GridViewRow row = GridView1.Rows[e.RowIndex]; int intrebareId = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0]); using (var ctx = new TalantContext()) { var intrebare = ctx.Intrebari.First(a => a.Id == intrebareId); //foreach (var el in intrebare.Referinte) { if (intrebare.Referinte.Count > 0) { ctx.Referinte.Remove(intrebare.Referinte[0]); } //ctx.SaveChanges(); } ctx.Intrebari.Remove(intrebare); ctx.SaveChanges(); _listIntrebari = ctx.Intrebari.ToList(); GridView1.DataSource = _listIntrebari; GridView1.DataBind(); } GridView1.EditIndex = -1; GridView1.DataBind(); }
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { GridView1.DataSource = _listIntrebari; // GridView1.DataBind(); GridViewRow row = GridView1.Rows[e.RowIndex]; int intrebareId = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0]); string tip = (row.Cells[2].Controls[0] as TextBox).Text; string categorie = (row.Cells[3].Controls[0] as TextBox).Text; string enunt = (row.Cells[4].Controls[0] as TextBox).Text; string punctaj = (row.Cells[5].Controls[0] as TextBox).Text; string editie = (row.Cells[6].Controls[0] as TextBox).Text; string raspuns = (row.Cells[7].Controls[0] as TextBox).Text; using (var ctx = new TalantContext()) { var intrebare = ctx.Intrebari.FirstOrDefault(a => a.Id == intrebareId); if (intrebare == null) { intrebare = new Intrebare(); ctx.Intrebari.Add(intrebare); } intrebare.Tip = Convert.ToInt16(tip); intrebare.Categorie = Convert.ToInt16(categorie); intrebare.Enunt = Convert.ToString(enunt); intrebare.Punctaj = Convert.ToInt16(punctaj); intrebare.Editie = Convert.ToInt16(editie); intrebare.Raspuns = Convert.ToString(raspuns); ctx.SaveChanges(); _listIntrebari = ctx.Intrebari.ToList(); GridView1.DataSource = _listIntrebari; } GridView1.EditIndex = -1; GridView1.DataBind(); }