private void Add_New_FormClosed(object sender, FormClosedEventArgs e)
{
this.Hide();
Form1R fm = new Form1R();
fm.Show();
}
public void submitEntry()
{
if (name.Text == "" || address.Text == "" || nic.Text == "" || telephone.Text == "" || mobile.Text == "" || email.Text == "" || (male.Checked == false && female.Checked == false))
{
MessageBox.Show("Enter full details");
}
else if (IsValidEmail(email.Text) == false)
{
MessageBox.Show("Invalide Email");
}
else if (IsPhoneNumber(mobile.Text) != true)
{
MessageBox.Show("Invalide Mobile Number");
}
else if (IsPhoneNumber(telephone.Text) != true)
{
MessageBox.Show("Invalide Telephone Number");
}
else
{
try
{
if (male.Checked == true)
{
Cgender = "male";
}
else if (female.Checked == true)
{
Cgender = "female";
}
con.Open();
String sql = "Insert into customer (Name,Address,Gender,NIC,Telephone,Mobile,Email) values('" + name.Text + "','" + address.Text + "','" + Cgender + "','" + nic.Text + "','" + telephone.Text + "','" + mobile.Text + "','" + email.Text + "')";
SqlDataAdapter sda = new SqlDataAdapter(sql, con);
sda.SelectCommand.ExecuteNonQuery();
MessageBox.Show("Data Submitted");
clear();
this.Hide();
Form1R fm = new Form1R();
fm.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.Close();
}
}
}
private void button2_Click(object sender, EventArgs e)
{
Form1R cusman = new Form1R();
cusman.Show();
}
