partial void DeleteRegistationTable(RegistationTable instance);
partial void InsertRegistationTable(RegistationTable instance);
partial void UpdateRegistationTable(RegistationTable instance);
private void button1_Click(object sender, EventArgs e) { CarDataContext c = new CarDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\adi\Documents\New folder\csms.mdf;Integrated Security=True;Connect Timeout=30"); try { RegistationTable rt = new RegistationTable { First_Name = textBox1.Text, Last_Name = textBox2.Text, Gender = gcombo.SelectedItem.ToString(), phone = textBox4.Text, Email = textBox5.Text, Address = textBox6.Text, Username = textBox7.Text, Password = textBox8.Text }; CustomerTable cta = new CustomerTable { First_Name = textBox1.Text, Last_Name = textBox2.Text, Email = textBox5.Text, Phone = textBox4.Text }; try { if (textBox1.Text == "") { MessageBox.Show("Provide Your First Name"); } else if (textBox2.Text == "") { MessageBox.Show("Provide Your Last Name"); } else if (textBox4.Text == "") { MessageBox.Show("Phone Number can't be empty"); } else if (!textBox4.Text.StartsWith("016") && !textBox4.Text.StartsWith("017")) { MessageBox.Show("Provide a valid phone number "); } else if (textBox4.Text.Length < 11) { MessageBox.Show("Provide a 11 digit valid phone number"); } else if (textBox5.Text == "") { MessageBox.Show("Provide your email address"); } else if (textBox7.Text == "") { MessageBox.Show("Provide your username"); } else if (textBox8.Text == "") { MessageBox.Show("Provide a password"); } else if (textBox7.Text != "") { var j = (from a in c.RegistationTables where a.Username == textBox7.Text select a); if (textBox7.Text == j.First().Username) { MessageBox.Show("username is not available. provide anything new"); } } } catch (Exception ex) { c.RegistationTables.InsertOnSubmit(rt); c.CustomerTables.InsertOnSubmit(cta); c.SubmitChanges(); MessageBox.Show("Registration Succesfull"); this.Hide(); LoginPage f1 = new LoginPage(); f1.Show(); } } catch (Exception ex) { MessageBox.Show("Registration failed. Please provide all the information correctly."); } }