private void Cancel_Click(object sender, EventArgs e)
{
this.Hide();
ProjectAdvisorManagement datap = new ProjectAdvisorManagement();
datap.ShowDialog();
this.Close();// close the form
}
// goes to manage project advisors
private void button1_Click(object sender, EventArgs e)
{
ProjectAdvisorManagement pa = new ProjectAdvisorManagement();
pa.ShowDialog();
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(conURL);
// connection opens
con.Open();
int ID = buffer;
if (ID < 0)
{
try
{
// here check whether boxes are empty for not
if (String.IsNullOrEmpty(comboBoxNames.Text) || String.IsNullOrEmpty(comboBoxAdvisor.Text))
{
MessageBox.Show("Fill first name and advisor role must");
}
else
{
string cmdText = "INSERT INTO ProjectAdvisor (AdvisorId, ProjectId, AdvisorRole, AssignmentDate) VALUES ((SELECT Advisor.Id FROM (Person JOIN Advisor ON Advisor.Id = Person.Id) where FirstName=@FirstName AND LastName = @LastName), @ProjectId, (SELECT Id FROM [Lookup] where Category = 'ADVISOR_ROLE' AND Value = @Value), @AssignmentDate)";
// command store in string then execute it by passing into sqlcommand object
SqlCommand c = new SqlCommand(cmdText, con);
c.Parameters.Add(new SqlParameter("@FirstName", comboBoxNames.Text));
c.Parameters.Add(new SqlParameter("@LastName", comboBoxLast.Text));
c.Parameters.Add(new SqlParameter("@ProjectId", ProjectAdvisorManagement.projectID));
c.Parameters.Add(new SqlParameter("@Value", comboBoxAdvisor.Text));
c.Parameters.Add(new SqlParameter("@AssignmentDate", DateTime.Now));
//execute it
int result = c.ExecuteNonQuery();
if (result < 0)
{
MessageBox.Show("Error");
}
// show dialog box if added in table of database
MessageBox.Show("Successfully Added");
con.Close();
this.Hide();
ProjectAdvisorManagement datap = new ProjectAdvisorManagement();
datap.ShowDialog();
this.Close(); // close the form
}
}
catch (Exception)
{
MessageBox.Show("Enter name and role in correct Format!!");
}
}
else
{
try
{ // trycatch handles exceptions
// update data
if (!String.IsNullOrEmpty(comboBoxNames.Text) && !String.IsNullOrEmpty(comboBoxAdvisor.Text))
{
string cmdText2 = "Update ProjectAdvisor SET AdvisorId = (SELECT Advisor.Id FROM Person JOIN Advisor ON Advisor.Id = Person.Id where FirstName = @FirstName AND LastName = @LastName), AdvisorRole= (SELECT Id FROM [Lookup] where Category = 'ADVISOR_ROLE' AND Value = @Value) WHERE ProjectId = @ProjectId AND AdvisorId = @AdvisorId";
SqlCommand c2 = new SqlCommand(cmdText2, con);
c2.Parameters.Add(new SqlParameter("@ProjectId", ProjectAdvisorManagement.projectID));
c2.Parameters.Add(new SqlParameter("@AdvisorId", ID));
c2.Parameters.Add(new SqlParameter("@FirstName", comboBoxNames.Text));
c2.Parameters.Add(new SqlParameter("@LastName", comboBoxLast.Text));
c2.Parameters.Add(new SqlParameter("@Value", comboBoxAdvisor.Text));
c2.ExecuteNonQuery();
MessageBox.Show("Successfully Updated");
con.Close();
this.Hide();
ProjectAdvisorManagement datap = new ProjectAdvisorManagement();
datap.ShowDialog();
this.Close(); // close the form
}
else
{
throw new ArgumentNullException();
}
}
catch (Exception)
{
MessageBox.Show("Enter name and role in correct Format!!");
}
}
}
