private void button1_Click_1(object sender, EventArgs e) { try { using (programacionEntities1 db = new programacionEntities1()) { UserList userList = new UserList(); int Eliminar = Convert.ToInt32(txtId.Text); userList = db.UserList.Find(Eliminar); db.UserList.Remove(userList); db.SaveChanges(); } } catch (Exception EX) { MessageBox.Show(EX.ToString()); } }
public void deleteUser(int iD) { try { using (programacionEntities1 db = new programacionEntities1()) { int Eliminar = Convert.ToInt32(iD); UserList userList = db.UserList.Where(x => x.Id == Eliminar).Select(x => x).FirstOrDefault(); //int Eliminar = Convert.ToInt32(txtId.Text); //userList = db.UserList.Find(Eliminar); db.UserList.Remove(userList); db.SaveChanges(); } } catch (Exception EX) { MessageBox.Show(EX.ToString()); } }
private void button1_Click(object sender, EventArgs e) { try { using (programacionEntities1 db = new programacionEntities1()) { UserList userList = new UserList(); userList.NombreUsuario = txtNombre.Text; userList.Apellido = txtApellido.Text; userList.Edad = Convert.ToInt32(txtYear.Text); userList.Pass = txtPass.Text; db.UserList.Add(userList); db.SaveChanges(); MessageBox.Show("SAVE"); } } catch (Exception EX) { MessageBox.Show(EX.ToString()); } }
private void button1_Click_1(object sender, EventArgs e) { try { using (programacionEntities1 db = new programacionEntities1()) { int Eliminar = Convert.ToInt32(txtId.Text); UserList userList = db.UserList.Where(x => x.Id == Eliminar).Select(x => x).FirstOrDefault(); //int Eliminar = Convert.ToInt32(txtId.Text); //userList = db.UserList.Find(Eliminar); db.UserList.Remove(userList); db.SaveChanges(); } } catch (Exception EX) { MessageBox.Show(EX.ToString()); } Carga(); }
//public void SaveDatoUser(String Nombre, String Apellidos, int Edad, String Pass) //{ // try // { // using (programacionEntities1 db = new programacionEntities1()) // { // UserList userList = new UserList(); // userList.NombreUsuario = Nombre; // userList.Apellido = Apellidos; // userList.Edad = Edad; // userList.Pass = Pass; // db.UserList.Add(userList); // db.SaveChanges(); // MessageBox.Show("SAVE"); // } // } // catch (Exception EX) // { // MessageBox.Show(EX.ToString()); // } //} public void SaveDatoUser(UserList user) { try { using (programacionEntities1 db = new programacionEntities1()) { UserList userList = new UserList(); userList.NombreUsuario = user.NombreUsuario; userList.Apellido = user.Apellido; userList.Edad = user.Edad; userList.Pass = user.Pass; db.UserList.Add(userList); db.SaveChanges(); MessageBox.Show("SAVE"); } } catch (Exception EX) { MessageBox.Show(EX.ToString()); } }
private void button1_Click_2(object sender, EventArgs e) { try { using (programacionEntities1 db = new programacionEntities1()) { int update = Convert.ToInt32(txtId.Text); UserList userList = db.UserList.Where(x => x.Id == 205).Select(x => x).FirstOrDefault(); //UserList userList = new UserList(); //userList = db.UserList.Find(205); //userList.NombreUsuario = "Jose"; userList.NombreUsuario = txtNombre.Text; userList.Apellido = txtApellido.Text; userList.Edad = Convert.ToInt32(txtYear.Text); userList.Pass = txtPass.Text; db.SaveChanges(); } } catch (Exception Ex) { MessageBox.Show(Ex.ToString()); } Carga(); }
public void update(UserList user) { try { using (programacionEntities1 db = new programacionEntities1()) { int update = Convert.ToInt32(user.Id); UserList userList = db.UserList.Where(x => x.Id == update).Select(x => x).FirstOrDefault(); userList.NombreUsuario = user.NombreUsuario; userList.Apellido = user.Apellido; userList.Edad = user.Edad; userList.Pass = user.Pass; db.SaveChanges(); //Otra forma de hacer lo mismo //UserList userList = new UserList(); //userList = db.UserList.Find(205); //userList.NombreUsuario = "Jose"; } } catch (Exception Ex) { MessageBox.Show(Ex.ToString()); } }