private void Confirm_Click(object sender, EventArgs e) { if (textBox2.Text == "" || textBox4.Text == "" || textBox6.Text == "" || comboBox1.Text == "" || textBox3.Text == "") { MessageBox.Show("Error!Please fill the blanks with (*)."); } else { context = new SA45Team13bLibraryEntities(); int i = Int32.Parse(textBox1.Text); LibraryMember lb = new LibraryMember(); lb = context.LibraryMembers.Where(x => x.CustomerID == i).First(); lb.CustomerName = textBox2.Text; lb.Age = Int16.Parse(textBox3.Text); lb.Address = textBox4.Text; lb.PostalCode = textBox5.Text; lb.DocumentNo = textBox6.Text; lb.DocumentType = comboBox1.Text; lb.PhoneNumber = textBox8.Text; lb.EmailAddress = textBox9.Text; lb.AltPhoneNumber = textBox10.Text; context.SaveChanges(); MessageBox.Show("Submit success!"); this.Close(); } }
private void Confirm_Click_1(object sender, EventArgs e) { m = new LibraryMember(); context = new SA45Team13bLibraryEntities(); if (CustomerNameBox.Text == "" || AddressBox.Text == "" || DocumentNoBox.Text == "" || DocumentTypeBox.Text == "" || AgeBox.Text == "") { MessageBox.Show("Error!Please fill the blanks with (*)."); } else if (System.Text.RegularExpressions.Regex.IsMatch(AgeBox.Text, "[^0-9]")) { MessageBox.Show("Please enter correct age."); } else { m.CustomerName = CustomerNameBox.Text; m.Age = Int16.Parse(AgeBox.Text); m.Address = AddressBox.Text; m.PostalCode = PostalCodeBox.Text; m.DocumentNo = DocumentNoBox.Text; m.DocumentType = DocumentTypeBox.Text; m.PhoneNumber = PhoneNumberBox.Text; m.EmailAddress = EmailAddressBox.Text; m.AltPhoneNumber = AltPhoneNumberBox.Text; context.LibraryMembers.Add(m); context.SaveChanges(); MessageBox.Show("Submit success!"); Refresh(); this.Close(); } }
private void Confirm_Click(object sender, EventArgs e) { m = new LibraryMember(); using (TransactionScope ts = new TransactionScope()) { context = new SA45Team13bLibraryEntities(); m.CustomerName = textBox2.Text; var k = Int16.Parse(textBox3.Text); m.Age = Int16.Parse(textBox3.Text); m.Address = textBox4.Text; m.PostalCode = textBox5.Text; m.DocumentNo = textBox6.Text; m.DocumentType = comboBox1.Text; m.PhoneNumber = textBox8.Text; m.EmailAddress = textBox9.Text; m.AltPhoneNumber = textBox10.Text; context.LibraryMember.Add(m); context.SaveChanges(); ts.Complete(); MessageBox.Show("Submit success!"); this.Close(); } }
private void textBox1_TextChanged(object sender, EventArgs e) //CustomerID textBox changed { textBox2.Text = null; List <int> IDList = context.LibraryMembers.Select(x => x.CustomerID).ToList(); foreach (int i in IDList) { if (i.ToString() == textBox1.Text) { lM = context.LibraryMembers.Where(x => x.CustomerID == i).First(); textBox2.Text = lM.CustomerName; } } }
private void Delete_Click(object sender, System.EventArgs e) { if (dataGridView1.SelectedRows.Count != 0) { string xx = dataGridView1.CurrentRow.Cells[1].Value.ToString(); LibraryMember lb = context.LibraryMembers.Where(x => x.CustomerName == xx).First(); context.LibraryMembers.Remove(lb); DialogResult result = MessageBox.Show("Are you sure to delete?", "Confirm", MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { MessageBox.Show("Delete Success!"); context.SaveChanges(); refresh(); } } else { MessageBox.Show("Please Search Member First"); return; } }