private void button3_Click(object sender, EventArgs e)
{
this.Hide();
assignproject ee = new assignproject();
ee.Show();
}
private void button7_Click(object sender, EventArgs e)
{
this.Refresh();
Refresh();
this.Hide();
assignproject ss = new assignproject();
ss.Show();
}
private void button5_Click(object sender, EventArgs e)
{
conn.Open();
string advisor = comboBox1.SelectedItem.ToString();
string proadd = "SELECT Id FROM Lookup WHERE Category= 'ADVISOR_ROLE' AND Value ='" + advisor + "' ";
SqlCommand InvAmount = new SqlCommand(proadd, conn);
int advisorvalu = Convert.ToInt32(InvAmount.ExecuteScalar());
string adname = Convert.ToString(comboBox3.SelectedItem.ToString());
string addd = "SELECT Advisor.Id FROM [dbo].[Advisor] JOIN [dbo].[Person] ON Advisor.Id = Person.Id WHERE Concat(FirstName, ' ' , LastName)='" + adname + "' ";
SqlCommand InvAmoun = new SqlCommand(addd, conn);
int adid = Convert.ToInt32(InvAmoun.ExecuteScalar());
string pro = Convert.ToString(comboBox2.SelectedItem.ToString());
string prooo = "SELECT Id FROM Project WHERE Title='" + pro + "' ";
SqlCommand InvAmou = new SqlCommand(prooo, conn);
int proid = Convert.ToInt32(InvAmou.ExecuteScalar());
DateTime dt = DateTime.Today;
try
{
String insert1 = "insert into ProjectAdvisor values('" + adid + "','" + proid + "','" + advisorvalu + "','" + dt + "' ) ";
SqlCommand sql1 = new SqlCommand(insert1, conn);
int i1 = sql1.ExecuteNonQuery();
if (i1 >= 1)
{
MessageBox.Show("Project Assigned ");
this.Refresh();
}
else
{
{ MessageBox.Show(" Project not Assigned"); }
}
this.Refresh();
Refresh();
this.Hide();
assignproject ss = new assignproject();
ss.Show();
}
catch (Exception ex)
{
MessageBox.Show("Already assigned");
}
conn.Close();
}
