private void Cancel_Click(object sender, EventArgs e)
{
this.Hide();
Advisor ps = new Advisor();
ps.ShowDialog();
this.Close();
}
// when save button clicks
private void button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(conURL);
// connection opens
con.Open();
if (buffer < 0) // for creation of new data
{
try
{
// here check whether boxes are empty for not
if (String.IsNullOrEmpty(textBoxName.Text) || String.IsNullOrEmpty(textBoxEmail.Text) || String.IsNullOrEmpty(comboBox1.Text))
{
MessageBox.Show("Fill First Name, Email, Designation must");
}
else
{
if (isalphaTest(textBoxName.Text) && (String.IsNullOrEmpty(textBoxLast.Text) || (!String.IsNullOrEmpty(textBoxLast.Text) && (isalphaTest(textBoxLast.Text)))) && Convert.ToDouble(textBoxSalary.Text) >= 0 && (String.IsNullOrEmpty(textBoxContact.Text) || (!String.IsNullOrEmpty(textBoxContact.Text) && contactNoValid(textBoxContact.Text))))
{
// getting value of radio button
string val = "";
bool isCheck = male.Checked;
if (isCheck)
{
val = male.Text;
}
bool isCheck2 = female.Checked;
if (isCheck2)
{
val = female.Text;
}
System.Text.RegularExpressions.Regex expr = new System.Text.RegularExpressions.Regex(@"^[a-zA-Z][\w\.-]{2,28}[a-zA-Z0-9]@[a-zA-Z0-9][\w\.-]*[a-zA-Z0-9]\.[a-zA-Z][a-zA-Z\.]*[a-zA-Z]$");
if (expr.IsMatch(textBoxEmail.Text))
{
string cmdText = "INSERT INTO Person (FirstName,LastName, Contact, Email, DateOfBirth, Gender ) VALUES (@FirstName,@LastName, @Contact, @Email, @DateOfBirth, (SELECT Id FROM Lookup WHERE Category = 'Gender' AND Value = @Value))";
SqlCommand c = new SqlCommand(cmdText, con);
c.Parameters.Add(new SqlParameter("@FirstName", textBoxName.Text));
c.Parameters.Add(new SqlParameter("@LastName", textBoxLast.Text));
c.Parameters.Add(new SqlParameter("@Contact", textBoxContact.Text));
c.Parameters.Add(new SqlParameter("@Email", textBoxEmail.Text));
c.Parameters.Add(new SqlParameter("@DateOfBirth", dateTimePicker1.Text));
c.Parameters.Add(new SqlParameter("@Value", val));
//execute it
int result = c.ExecuteNonQuery();
if (result < 0)
{
MessageBox.Show("Error");
}
string cmdText3 = "INSERT INTO Advisor (Id, Designation, Salary) VALUES((SELECT Id FROM Person WHERE Email = @Email AND Contact = @Contact AND FirstName = @FirstName), (SELECT Id FROM Lookup WHERE Category = 'DESIGNATION' AND Value = @Value), @Salary)";
SqlCommand c3 = new SqlCommand(cmdText3, con);
c3.Parameters.Add(new SqlParameter("@FirstName", textBoxName.Text));
c3.Parameters.Add(new SqlParameter("@Contact", textBoxContact.Text));
c3.Parameters.Add(new SqlParameter("@Email", textBoxEmail.Text));
c3.Parameters.Add(new SqlParameter("@Value", comboBox1.Text));
c3.Parameters.Add(new SqlParameter("@Salary", textBoxSalary.Text));
c3.ExecuteNonQuery();
// connection closed
// show dialog box if added
MessageBox.Show("Successfully Added");
con.Close();
this.Hide();
Advisor datap = new Advisor();
datap.ShowDialog();
this.Close(); // close the form
}
else
{
throw new ArgumentNullException();
}
}
else
{
throw new ArgumentNullException();
}
}
}
catch (Exception)
{
MessageBox.Show("Enter Name, Email, Salary in correct Format!! Name should be all alphabets, no extra spaces. email should have at least 4 chars before @ . contact should have digits");
}
}
else // for updation of data
{
try
{
if (isalphaTest(textBoxName.Text) && (String.IsNullOrEmpty(textBoxLast.Text) || (!String.IsNullOrEmpty(textBoxLast.Text) && (isalphaTest(textBoxLast.Text)))) && Convert.ToDouble(textBoxSalary.Text) >= 0 && (String.IsNullOrEmpty(textBoxContact.Text) || (!String.IsNullOrEmpty(textBoxContact.Text) && contactNoValid(textBoxContact.Text))))
{
string val = "";
bool isCheck = male.Checked;
if (isCheck)
{
val = male.Text;
}
bool isCheck2 = female.Checked;
if (isCheck2)
{
val = female.Text;
}
System.Text.RegularExpressions.Regex expr = new System.Text.RegularExpressions.Regex(@"^[a-zA-Z][\w\.-]{2,28}[a-zA-Z0-9]@[a-zA-Z0-9][\w\.-]*[a-zA-Z0-9]\.[a-zA-Z][a-zA-Z\.]*[a-zA-Z]$");
if (expr.IsMatch(textBoxEmail.Text))
{
string cmdText2 = "Update Person SET FirstName = @FirstName ,LastName =@LastName , Contact = @Contact, Email = @Email, DateOfBirth = @DateOfBirth, Gender = (SELECT Id FROM Lookup WHERE Category = 'Gender' AND Value = @Value) WHERE Id = @Id";
SqlCommand c2 = new SqlCommand(cmdText2, con);
c2.Parameters.Add(new SqlParameter("@Id", buffer));
c2.Parameters.Add(new SqlParameter("@FirstName", textBoxName.Text));
c2.Parameters.Add(new SqlParameter("@LastName", textBoxLast.Text));
c2.Parameters.Add(new SqlParameter("@Contact", textBoxContact.Text));
c2.Parameters.Add(new SqlParameter("@Email", textBoxEmail.Text));
c2.Parameters.Add(new SqlParameter("@DateOfBirth", dateTimePicker1.Text));
c2.Parameters.Add(new SqlParameter("@Value", val));
c2.ExecuteNonQuery();
string cmdText3 = "Update Advisor SET Designation = (SELECT Id FROM Lookup WHERE Category = 'DESIGNATION' AND Value = @Value), Salary = @Salary where Id = @Id";
SqlCommand c3 = new SqlCommand(cmdText3, con);
c3.Parameters.Add(new SqlParameter("@Id", buffer));
c3.Parameters.Add(new SqlParameter("@Value", comboBox1.Text));
c3.Parameters.Add(new SqlParameter("@Salary", textBoxSalary.Text));
c3.ExecuteNonQuery();
MessageBox.Show("Successfully Updated!!");
con.Close();
this.Hide();
Advisor datap = new Advisor();
datap.ShowDialog();
this.Close(); // close the form
}
else
{
throw new ArgumentNullException();
}
}
else
{
throw new ArgumentNullException();
}
}
catch (Exception)
{
MessageBox.Show("Enter Name, Email, Salary in correct Format!! Name should be all alphabets, no extra spaces and Enter Name, Email, Designation must. email should have at least 4 chars before @. contact should have digits!!");
}
}
}
// goes to manage advisors
private void Madvisors_Click(object sender, EventArgs e)
{
Advisor st = new Advisor();
st.ShowDialog();
}
