protected void Button1_Click(object sender, EventArgs e) { using (CompanyEntities_2 Ent = new CompanyEntities_2()) { if (Label1.Text != string.Empty) { int Id = int.Parse(Label1.Text); var UserToEdit = Ent.Users.Where(R => R.IdUsuario == Id).First(); UserToEdit.Name = TextBox1.Text; UserToEdit.email = TextBox2.Text; UserToEdit.birthDate = TextBox3.Text; Ent.SaveChanges(); CleanControls(); } else { User Newuser = new User(); Newuser.Name = TextBox1.Text; Newuser.email = TextBox2.Text; Newuser.birthDate = TextBox3.Text; Ent.Users.Add(Newuser); Ent.SaveChanges(); } } GridViewReloadData(); }
private void GridViewReloadData() { using (CompanyEntities_2 ent = new CompanyEntities_2()) { GridView1.DataSource = ent.Users.ToList(); GridView1.DataBind(); } }
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { int idUser = int.Parse(GridView1.Rows[e.RowIndex].Cells[1].Text); using (CompanyEntities_2 ent = new CompanyEntities_2()) { var UserToDelete = ent.Users.Where(R => R.IdUsuario == idUser).First();; ent.Users.Remove(UserToDelete); ent.SaveChanges(); } GridViewReloadData(); }
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) { int idUser = int.Parse(GridView1.Rows[e.NewEditIndex].Cells[1].Text); using (CompanyEntities_2 ent = new CompanyEntities_2()) { var UserToEdit = ent.Users.Where(R => R.IdUsuario == idUser).First();; Label1.Text = UserToEdit.IdUsuario.ToString(); TextBox1.Text = UserToEdit.Name; TextBox2.Text = UserToEdit.email; TextBox3.Text = UserToEdit.birthDate; ent.SaveChanges(); } GridViewReloadData(); }