private void TxtCustomer_KeyPress(object sender, KeyPressEventArgs e) { if (e.KeyChar == (char)Keys.Return) { int VId = Convert.ToInt32(this.TxtCustomer.Text); using (AdventureWorksLT2012Entities context = new AdventureWorksLT2012Entities()) { IQueryable <Customer> Cliente = from q in context.Customer where q.CustomerID == VId select q; List <Customer> lista = Cliente.ToList(); var oCliente = lista[0]; ChkNamestyle.Checked = oCliente.NameStyle; TxtTitle.Text = oCliente.Title; TxtfirstName.Text = oCliente.FirstName; TxtmiddleName.Text = oCliente.MiddleName; TxtlastName.Text = oCliente.LastName; TxtSuffix.Text = oCliente.Suffix; TxtCompany.Text = oCliente.CompanyName; Txtsalesperson.Text = oCliente.SalesPerson; Txtemailaddress.Text = oCliente.EmailAddress; Txtphone.Text = oCliente.Phone; Txthash.Text = oCliente.PasswordHash; Txtsalt.Text = oCliente.PasswordSalt; } } }
private void Cargargrid() { using (AdventureWorksLT2012Entities Context = new AdventureWorksLT2012Entities()) { IQueryable <Customer> Cliente = from R in Context.Customer select R; List <Customer> lista = Cliente.ToList(); DGCostumer.DataSource = lista; DGCostumer.Refresh(); } }
private void Insertar() { try { using (AdventureWorksLT2012Entities context = new AdventureWorksLT2012Entities()) { Customer oCliente = new Customer { NameStyle = ChkNamestyle.Checked, Title = TxtTitle.Text, FirstName = TxtfirstName.Text, MiddleName = TxtmiddleName.Text, LastName = TxtlastName.Text, Suffix = TxtSuffix.Text, CompanyName = TxtCompany.Text, SalesPerson = Txtsalesperson.Text, EmailAddress = Txtemailaddress.Text, Phone = Txtphone.Text, PasswordHash = Txthash.Text, PasswordSalt = Txtsalt.Text, ModifiedDate = DateTime.Now }; MessageBox.Show(string.Format("Id ={0} - Lastname{1}", oCliente.CustomerID, oCliente.LastName)); context.Customer.Add(oCliente); context.SaveChanges(); } } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.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 button4_Click(object sender, EventArgs e) { int CusId = Convert.ToInt32(TxtCustomer.Text); using (AdventureWorksLT2012Entities context = new AdventureWorksLT2012Entities()) { //Customer ocliente = context.Customer.SingleOrDefault(p => p.CustomerID == CusId); Customer oCliente = (from q in context.Customer where q.CustomerID == CusId select q).First(); try { context.Customer.Remove(oCliente); context.SaveChanges(); Cargargrid(); } catch (Exception Ex) { MessageBox.Show(Ex.Message); } } }
private void Actualizar() { int Cusid = Convert.ToInt32(TxtCustomer.Text); using (AdventureWorksLT2012Entities context = new AdventureWorksLT2012Entities()) { Customer oCliente = context.Customer.SingleOrDefault(p => p.CustomerID == Cusid); oCliente.NameStyle = ChkNamestyle.Checked; oCliente.Title = TxtTitle.Text; oCliente.FirstName = TxtfirstName.Text; oCliente.MiddleName = TxtmiddleName.Text; oCliente.LastName = TxtlastName.Text; oCliente.Suffix = TxtSuffix.Text; oCliente.CompanyName = TxtCompany.Text; oCliente.SalesPerson = Txtsalesperson.Text; oCliente.EmailAddress = Txtemailaddress.Text; oCliente.Phone = Txtphone.Text; oCliente.PasswordHash = Txthash.Text; oCliente.PasswordSalt = Txtsalt.Text; context.SaveChanges(); } }