private void AddProjectAdvisorDataGridView_CellContentClick(object sender, DataGridViewCellEventArgs e) { int currentRow = int.Parse(e.RowIndex.ToString()); int curentcolumnindex = int.Parse(e.ColumnIndex.ToString()); int AdvisorId = Convert.ToInt32(AddProjectAdvisorDataGridView.Rows[currentRow].Cells[1].Value); if (curentcolumnindex == 0) { SqlConnection conn = new SqlConnection(conURL); conn.Open(); String AddCMD = "INSERT INTO ProjectAdvisor (AdvisorId, ProjectId, AdvisorRole, AssignmentDate) VALUES (@adid, @prid, @arole, @asgnDate)"; SqlCommand AddCommand = new SqlCommand(AddCMD, conn); AddCommand.Parameters.Add(new SqlParameter("adid", AdvisorId)); AddCommand.Parameters.Add(new SqlParameter("prid", projectId)); String getAdvisorRoleIdCMD = String.Format("SELECT Id FROM Lookup WHERE Value = '{0}'", AdvisorRoleComboBox.Text); SqlCommand getAdvisorRoleIdCommand = new SqlCommand(getAdvisorRoleIdCMD, conn); int AdvisorRoleId = (Int32)getAdvisorRoleIdCommand.ExecuteScalar(); AddCommand.Parameters.Add(new SqlParameter("arole", AdvisorRoleId)); AddCommand.Parameters.Add(new SqlParameter("asgnDate", DateTime.Today)); int count = AddCommand.ExecuteNonQuery(); AddProjectAdvisor form = new AddProjectAdvisor(projectId); form.Show(); this.Hide(); } }
private void ProjectsGridView_CellContentClick(object sender, DataGridViewCellEventArgs e) { int currentRow = int.Parse(e.RowIndex.ToString()); int curentcolumnindex = int.Parse(e.ColumnIndex.ToString()); int ProjectId = Convert.ToInt32(ProjectsGridView.Rows[currentRow].Cells[2].Value); if (curentcolumnindex == 0) { AddProjectAdvisor form = new AddProjectAdvisor(ProjectId); form.Show(); this.Hide(); } if (curentcolumnindex == 1) { ViewProjectAdvisor form = new ViewProjectAdvisor(ProjectId); form.Show(); this.Hide(); } }