private void button9_Click(object sender, EventArgs e)
{
this.Hide();
advisor f1 = new advisor();
f1.Show();
}
private void button2_Click(object sender, EventArgs e)
{
this.Hide();
advisor r = new advisor();
r.Show();
}
private void button7_Click(object sender, EventArgs e)
{
this.Refresh();
Refresh();
this.Hide();
advisor ss = new advisor();
ss.Show();
}
private void button6_Click(object sender, EventArgs e)
{
conn.Open();
string fn = textBox1.Text;
string ln = textBox2.Text;
string con = textBox3.Text;
string email = textBox4.Text;
string salary = textBox6.Text;
if (string.IsNullOrEmpty(fn) || !Regex.IsMatch(textBox1.Text, @"[A-Za-z]+$"))
{
MessageBox.Show("Invalid First Name.Should be letters");
textBox1.BackColor = Color.DodgerBlue;
textBox1.Clear();
conn.Close();
return;
}
textBox1.BackColor = Color.White;
if (string.IsNullOrEmpty(ln) || !Regex.IsMatch(textBox2.Text, @"[A-Za-z]+$"))
{
MessageBox.Show("Invalid last Name.Should be letters");
textBox2.BackColor = Color.DodgerBlue;
textBox2.Clear();
conn.Close();
return;;
}
textBox2.BackColor = Color.White;
if (string.IsNullOrEmpty(con) || !Regex.IsMatch(textBox3.Text, @"^[0-9]{10,12}$"))
{
MessageBox.Show("Invalid contact ,should be 11 digits");
textBox3.BackColor = Color.DodgerBlue;
textBox3.Clear();
conn.Close();
return;
}
textBox3.BackColor = Color.White;
if (string.IsNullOrEmpty(email) || !Regex.IsMatch(textBox4.Text, @"^([\w]+)@([\w]+)\.([\w]+)$"))
{
MessageBox.Show("Invalid email ");
textBox4.BackColor = Color.DodgerBlue;
textBox4.Clear();
conn.Close();
return;
}
textBox4.BackColor = Color.White;
if (string.IsNullOrEmpty(salary) || !Regex.IsMatch(textBox6.Text, @"^[0-9]*$"))
{
MessageBox.Show("Invalid salary,should be digits ");
textBox6.BackColor = Color.DodgerBlue;
textBox6.Clear();
conn.Close();
return;
}
textBox6.BackColor = Color.White;
DateTime dt = dateTimePicker1.Value;
string design = comboBox2.SelectedItem.ToString();
try
{
//getting designation
string designn = "SELECT Id FROM Lookup WHERE Category= 'DESIGNATION' AND Value ='" + design + "' ";
SqlCommand InvAmountcom = new SqlCommand(designn, conn);
int desigination = Convert.ToInt32(InvAmountcom.ExecuteScalar().ToString());
string gen = comboBox1.SelectedItem.ToString();
//getting gender value from lookup
string genvalue = "SELECT Id FROM Lookup WHERE Category= 'GENDER' AND Value ='" + gen + "' ";
SqlCommand genint = new SqlCommand(genvalue, conn);
genint.ExecuteNonQuery();
int gender = Convert.ToInt32(genint.ExecuteScalar());
//inserting value in person
String insert1 = "update Person set FirstName = '" + fn + "',LastName='" + ln + "',Contact='" + con + "',Email='" + email + "',DateOfBirth='" + dt + "',Gender='" + gender + "'where Id='" + IDD + "'";
SqlCommand sql1 = new SqlCommand(insert1, conn);
int i1 = sql1.ExecuteNonQuery();
//getting id from person for advisor
string sid = String.Format("SELECT Id FROM Person Where Email ='{0}'", email);
SqlCommand stuid = new SqlCommand(sid, conn);
int id = Convert.ToInt32(stuid.ExecuteScalar());
String insert2 = "update Advisor set Designation = '" + desigination + "',Salary='" + salary + "'where Id='" + IDD + "'";
SqlCommand sql2 = new SqlCommand(insert2, conn);
int i2 = sql2.ExecuteNonQuery();
// to check if the student is registered or not
if (i1 >= 1 && i2 >= 1)
{
MessageBox.Show("Edited Succesfully");
this.Refresh();
}
else
{
{ MessageBox.Show("Edition failed"); }
}
this.Refresh();
Refresh();
this.Hide();
advisor ss = new advisor();
ss.Show();
conn.Close();
}
catch (Exception a)
{
MessageBox.Show(a.Message);
conn.Close();
}
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
conn.Open();
if (e.RowIndex == dataGridView1.NewRowIndex || e.RowIndex < 0)
{
return;
}
//Check if click is on specific column
if (e.ColumnIndex == dataGridView1.Columns["DeleteButton"].Index)
{
int index = e.RowIndex;
int ID = Convert.ToInt32(dataGridView1.Rows[index].Cells[3].Value.ToString());
try
{
string delete3 = String.Format("DELETE FROM ProjectAdvisor WHERE AdvisorId = '{0}'", ID);
SqlCommand de13 = new SqlCommand(delete3, conn);
int k = de13.ExecuteNonQuery();
string delete1 = String.Format("DELETE FROM Advisor WHERE Id = '{0}'", ID);
SqlCommand de11 = new SqlCommand(delete1, conn);
int i = de11.ExecuteNonQuery();
string delete2 = string.Format("DELETE FROM Person WHERE Id = '{0}'", ID);
SqlCommand del2 = new SqlCommand(delete2, conn);
int j = del2.ExecuteNonQuery();
// to check if the student is registered or not
if (i >= 1 && j >= 1)
{
MessageBox.Show(" Advisor Deleted ");
this.Refresh();
}
else
{
MessageBox.Show(" Advisor not Deleted");
}
this.Refresh();
Refresh();
this.Hide();
advisor ss = new advisor();
ss.Show();
}
catch (Exception a)
{
MessageBox.Show(a.Message);
}
}
else if (e.ColumnIndex == dataGridView1.Columns["EditButton"].Index)
{
int indexx = e.RowIndex;
IDD = Convert.ToInt32(dataGridView1.Rows[indexx].Cells[3].Value.ToString());
panel5.Show();
button5.Hide();
button6.Show();
try
{
string fn = "SELECT FirstName FROM Person WHERE Id = '" + IDD + "' ";
SqlCommand fnn = new SqlCommand(fn, conn);
fnn.ExecuteNonQuery();
string first = Convert.ToString(fnn.ExecuteScalar());
textBox1.Text = first;
string ln = "SELECT LastName FROM Person WHERE Id = '" + IDD + "' ";
SqlCommand lnn = new SqlCommand(ln, conn);
lnn.ExecuteNonQuery();
string last = Convert.ToString(lnn.ExecuteScalar());
textBox2.Text = last;
string con = "SELECT Contact FROM Person WHERE Id = '" + IDD + "' ";
SqlCommand cont = new SqlCommand(con, conn);
cont.ExecuteNonQuery();
string contact = Convert.ToString(cont.ExecuteScalar());
textBox3.Text = contact;
string em = "SELECT Email FROM Person WHERE Id = '" + IDD + "' ";
SqlCommand emi = new SqlCommand(em, conn);
emi.ExecuteNonQuery();
string email = Convert.ToString(emi.ExecuteScalar());
textBox4.Text = email;
string sal = "SELECT Salary FROM Advisor WHERE Id = '" + IDD + "' ";
SqlCommand sall = new SqlCommand(sal, conn);
sall.ExecuteNonQuery();
string salary = Convert.ToString(sall.ExecuteScalar());
textBox6.Text = salary;
string gen = "SELECT Gender FROM Person WHERE Id = '" + IDD + "' ";
SqlCommand gender = new SqlCommand(gen, conn);
gender.ExecuteNonQuery();
int genn = Convert.ToInt32(gender.ExecuteScalar());
string designn = "SELECT Value FROM Lookup WHERE Category= 'GENDER' AND Id ='" + genn + "' ";
SqlCommand InvAmountcom = new SqlCommand(designn, conn);
string mf = Convert.ToString(InvAmountcom.ExecuteScalar().ToString());
comboBox1.Text = mf;
string de = "SELECT Designation FROM Advisor WHERE Id = '" + IDD + "' ";
SqlCommand des = new SqlCommand(de, conn);
des.ExecuteNonQuery();
int desg = Convert.ToInt32(des.ExecuteScalar());
string design = "SELECT Value FROM Lookup WHERE Category= 'DESIGNATION' AND Id ='" + desg + "' ";
SqlCommand InvAmount = new SqlCommand(design, conn);
string mff = Convert.ToString(InvAmount.ExecuteScalar().ToString());
comboBox2.Text = mff;
}
catch (Exception a)
{
MessageBox.Show(a.Message);
}
}
else if (e.ColumnIndex == dataGridView1.Columns["DetailsButton"].Index)
{
this.Hide();
advidetails s1 = new advidetails();
s1.Show();
}
conn.Close();
}
private void button5_Click(object sender, EventArgs e)
{
conn.Open();
string fn = textBox1.Text;
string ln = textBox2.Text;
string con = textBox3.Text;
string email = textBox4.Text;
string salary = textBox6.Text;
if (string.IsNullOrEmpty(fn) || !Regex.IsMatch(textBox1.Text, @"[A-Za-z]+$"))
{
MessageBox.Show("Invalid First name. Should be letters ");
textBox1.BackColor = Color.DodgerBlue;
textBox1.Clear();
conn.Close();
return;
}
textBox1.BackColor = Color.White;
if (string.IsNullOrEmpty(ln) || !Regex.IsMatch(textBox2.Text, @"[A-Za-z]+$"))
{
MessageBox.Show("Invalid Last name. Should be letters");
textBox2.BackColor = Color.DodgerBlue;
textBox2.Clear();
conn.Close();
return;;
}
textBox2.BackColor = Color.White;
if (string.IsNullOrEmpty(con) || !Regex.IsMatch(textBox3.Text, @"^[0-9]{11}$"))
{
MessageBox.Show("Invalid contact number.Should be digits");
textBox3.BackColor = Color.DodgerBlue;
textBox3.Clear();
conn.Close();
return;
}
textBox3.BackColor = Color.White;
SqlCommand cmd = new SqlCommand("Select count(*) from Person where Email= @email", conn);
cmd.Parameters.AddWithValue("@email", this.textBox4.Text);
int result = Convert.ToInt32(cmd.ExecuteScalar());
if (result != 0)
{
MessageBox.Show("Email Exists");
conn.Close();
return;
}
if (string.IsNullOrEmpty(email) || !Regex.IsMatch(textBox4.Text, @"^([\w]+)@([\w]+)\.([\w]+)$"))
{
MessageBox.Show("Invalid email ");
textBox4.BackColor = Color.DodgerBlue;
textBox4.Clear();
conn.Close();
return;
}
textBox4.BackColor = Color.White;
if (string.IsNullOrEmpty(salary) || !Regex.IsMatch(textBox6.Text, @"^[0-9]{0,18}$"))
{
MessageBox.Show("Invalid salary.Should be digits ");
textBox6.BackColor = Color.DodgerBlue;
textBox6.Clear();
conn.Close();
return;
}
textBox6.BackColor = Color.White;
DateTime dt = dateTimePicker1.Value;
string design = comboBox2.SelectedItem.ToString();
//getting designation
try
{
string designn = "SELECT Id FROM Lookup WHERE Category= 'DESIGNATION' AND Value ='" + design + "' ";
SqlCommand InvAmountcom = new SqlCommand(designn, conn);
int desigination = Convert.ToInt32(InvAmountcom.ExecuteScalar().ToString());
string gen = comboBox1.SelectedItem.ToString();
//getting gender value from lookup
string genvalue = "SELECT Id FROM Lookup WHERE Category= 'GENDER' AND Value ='" + gen + "' ";
SqlCommand genint = new SqlCommand(genvalue, conn);
genint.ExecuteNonQuery();
int gender = Convert.ToInt32(genint.ExecuteScalar());
String insert1 = "insert into Person values('" + fn + "','" + ln + "','" + con + "','" + email + "','" + dt + "','" + gender + "' ) ";
SqlCommand sql1 = new SqlCommand(insert1, conn);
int i1 = sql1.ExecuteNonQuery();
//getting id from person for advisor
string sid = String.Format("SELECT Id FROM Person Where Email ='{0}'", email);
SqlCommand stuid = new SqlCommand(sid, conn);
int id = Convert.ToInt32(stuid.ExecuteScalar());
String insert2 = "insert into Advisor values('" + id + "','" + desigination + "','" + salary + "')";
SqlCommand sql2 = new SqlCommand(insert2, conn);
int i2 = sql2.ExecuteNonQuery();
// to check if the student is registered or not
if (i1 >= 1 && i2 >= 1)
{
MessageBox.Show("Advisor Registered ");
this.Refresh();
}
else
{
{ MessageBox.Show(" Advisor not Registered :"); }
}
this.Refresh();
Refresh();
this.Hide();
advisor ss = new advisor();
ss.Show();
}
catch (Exception a)
{
MessageBox.Show(a.Message);
}
conn.Close();
}
