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.");
}
}