예제 #1
0
        private void BackButton_Click(object sender, EventArgs e)
        {
            ManageAssignAdvisorToProject form = new ManageAssignAdvisorToProject();

            form.Show();
            this.Close();
        }
예제 #2
0
        /*private void GoToGroupsForm_Click(object sender, EventArgs e)
         * {
         *  ManageGroups form = new ManageGroups();
         *  form.Show();
         *  this.Hide();
         * }*/

        /*private void AssignProjectButton_Click(object sender, EventArgs e)
         * {
         *  GroupProjects form = new GroupProjects();
         *  form.Show();
         *  this.Hide();
         * }*/

        private void ProjectAdvsiors_Click(object sender, EventArgs e)
        {
            ManageAssignAdvisorToProject form = new ManageAssignAdvisorToProject();

            form.Show();
            this.Hide();
        }
예제 #3
0
        private void AssignAdvisorButton_Click(object sender, EventArgs e)
        {
            try
            {
                if (ProjectsComboBox.Text == "" || AdvisorComboBox.Text == "" || RoleComboBox.Text == "")
                {
                    throw new ArgumentException();
                }
                string        projectTitle = ProjectsComboBox.Text;
                string        AdvisorName  = AdvisorComboBox.Text;
                SqlConnection conn         = new SqlConnection(connString);
                conn.Open();
                string     query1 = string.Format("SELECT Id FROM Project WHERE Title = '{0}'", projectTitle);
                SqlCommand cmd    = new SqlCommand(query1, conn);
                int        pid    = (Int32)cmd.ExecuteScalar();

                cmd.CommandText = string.Format("SELECT Advisor.Id FROM Person JOIN Advisor ON Person.Id = Advisor.Id WHERE CONCAT(FirstName,' ', LastName) = '{0}'", AdvisorName);
                int Aid = (Int32)cmd.ExecuteScalar();

                cmd.CommandText = string.Format("SELECT Id FROM LookUp WHERE Value = '{0}' AND CATEGORY = 'ADVISOR_ROLE'", RoleComboBox.Text);
                int Rid = (Int32)cmd.ExecuteScalar();
                if (value != "edit")
                {
                    string query = string.Format("INSERT INTO ProjectAdvisor(AdvisorId, ProjectId, AdvisorRole, AssignmentDate) Values('{0}', '{1}', '{2}', '{3}')", Aid, pid, Rid, DateTime.Now);
                    cmd.CommandText = query;
                    cmd.ExecuteNonQuery();
                    MessageBox.Show(string.Format("Advisor assigned to project '{0}'", projectTitle));
                }
                else if (value == "edit")
                {
                    cmd.CommandText = string.Format("UPDATE ProjectAdvisor SET AdvisorRole = '{0}' WHERE ProjectId = '{1}' AND AdvisorId = '{2}'", Rid, pid, Aid);
                    cmd.ExecuteNonQuery();
                    MessageBox.Show("Advisor Role Updated!");
                }
                ManageAssignAdvisorToProject form = new ManageAssignAdvisorToProject();
                form.Show();
                this.Close();
            }
            catch (Exception)
            {
                MessageBox.Show("Please select project, advisor and advisor role from drop-down list");
            }
        }