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(); }