private void btnSearch_Click(object sender, EventArgs e) { int id = Convert.ToInt32(txtCustomerId.Text); using (AdventureEntities context = new AdventureEntities()) { IQueryable <Customer> cliente = from q in context.Customer where q.CustomerID == id select q; List <Customer> lista = cliente.ToList(); var oCliente = lista[0]; ckbNameStyle.Checked = oCliente.NameStyle; txtTitle.Text = oCliente.Title; txtFirstName.Text = oCliente.FirstName; txtMiddleName.Text = oCliente.MiddleName; txtLastName.Text = oCliente.LastName; txtSuflix.Text = oCliente.Suffix; txtCompany.Text = oCliente.CompanyName; txtSalePerson.Text = oCliente.SalesPerson; txtEmail.Text = oCliente.EmailAddress; txtPhone.Text = oCliente.Phone; txtPassHash.Text = oCliente.PasswordHash; txtPassSalt.Text = oCliente.PasswordSalt; } }
private void Actualizar() { int id = Convert.ToInt32(txtCustomerId.Text); using (AdventureEntities context = new AdventureEntities()) { Customer oCliente = context.Customer.SingleOrDefault(p => p.CustomerID == id); //MessageBox.Show(oCliente.LastName); oCliente.NameStyle = ckbNameStyle.Checked; oCliente.Title = txtTitle.Text; oCliente.FirstName = txtFirstName.Text; oCliente.MiddleName = txtMiddleName.Text; oCliente.LastName = txtLastName.Text; oCliente.Suffix = txtSuflix.Text; oCliente.CompanyName = txtCompany.Text; oCliente.SalesPerson = txtSalePerson.Text; oCliente.EmailAddress = txtEmail.Text; oCliente.Phone = txtPhone.Text; oCliente.PasswordHash = txtPassHash.Text; oCliente.PasswordSalt = txtPassSalt.Text; context.SaveChanges(); } }
private void CargarGrid() { using (AdventureEntities context = new AdventureEntities()) { /* * IQueryable: Proporciona funcionalidad para evaluar consultas con * respecto a un origen de datos concreto en el que se especifica el tipo de los datos. * Util para aplicar consultas LINQ */ IQueryable <Customer> cliente = from q in context.Customer select q; List <Customer> lista = cliente.ToList(); dgvCustomer.DataSource = lista; dgvCustomer.Refresh(); } }
private void Insertar() { try { using (AdventureEntities context = new AdventureEntities()) { Customer oCliente = new Customer { NameStyle = ckbNameStyle.Checked, Title = txtTitle.Text, FirstName = txtFirstName.Text, MiddleName = txtMiddleName.Text, LastName = txtLastName.Text, Suffix = txtSuflix.Text, CompanyName = txtCompany.Text, SalesPerson = txtSalePerson.Text, EmailAddress = txtEmail.Text, Phone = txtPhone.Text, PasswordHash = txtPassHash.Text, PasswordSalt = txtPassSalt.Text, ModifiedDate = DateTime.Now }; context.Customer.Add(oCliente); context.SaveChanges(); } } catch (DbEntityValidationException ex) { foreach (var validationErrors in ex.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { MessageBox.Show(string.Format("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage)); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { CargarGrid(); } }
private void btnDelete_Click(object sender, EventArgs e) { int id = Convert.ToInt32(txtCustomerId.Text); using (AdventureEntities context = new AdventureEntities()) { //Ejemplo 1: //Customer oCliente = context.Customer.SingleOrDefault(p => p.CustomerID == id); //Ejemplo 2: Customer oCliente = (from q in context.Customer where q.CustomerID == id select q).First(); try { context.Customer.Remove(oCliente); context.SaveChanges(); CargarGrid(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } }