private void ProAdvGrid_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex == 4) { DialogResult result = MessageBox.Show("Are you sure you want to delete this ProjectAdvisor?", "Project Advisor", MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { Delete_rec(); //Delete_rec(); } else if (result == DialogResult.No) { this.Hide(); ProjectAdvisor obj = new ProjectAdvisor(); obj.Show(); } } if (e.ColumnIndex == 5) { DialogResult result = MessageBox.Show("Are you sure you want to update this ProjectAdvisor", "ProjectAdvisor", MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { panel1.Hide(); editpan.Hide(); panel2.Show(); addpan.Hide(); } else if (result == DialogResult.No) { this.Hide(); ProjectAdvisor obj = new ProjectAdvisor(); obj.Show(); } } }
private void projectAdvisorToolStripMenuItem_Click(object sender, EventArgs e) { ProjectAdvisor l = ProjectAdvisor.getInstance(); l.Show(); this.Hide(); }
private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { ProjectAdvisor ad = new ProjectAdvisor(); this.Hide(); ad.Show(); }
private void Update_rec() { con.Open(); int index = ProAdvGrid.CurrentCell.RowIndex; ProAdvGrid.Rows[index].Selected = true; string advid = ProAdvGrid.SelectedCells[0].Value.ToString(); string proid = ProAdvGrid.SelectedCells[1].Value.ToString(); try { string desig = AdvR.Text.ToString(); int g = Advisor_look(desig); SqlCommand cmd = new SqlCommand(" UPDATE ProjectAdvisor SET AdvisorRole = '" + g + "' , AssignmentDate = '" + DateTime.Parse(Assgdate.Text) + "' WHERE ProjectId = '" + proid + "' AND AdvisorId = '" + advid + "';", con); cmd.ExecuteNonQuery(); ProAdvGrid.Rows.RemoveAt(index); ProAdvGrid.DataSource = dt; MessageBox.Show("Done"); this.Hide(); ProjectAdvisor obj = new ProjectAdvisor(); obj.Show(); } catch { MessageBox.Show("something went wrong."); } con.Close(); }
public static ProjectAdvisor getInstance() { if (l == null) { l = new ProjectAdvisor(); l.Show(); return(l); } else { return(l); } }
private void cmdalocatePAdvisor_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(conStr); con.Open(); string Insert; if (con.State == System.Data.ConnectionState.Open) { Insert = "INSERT INTO ProjectAdvisor(AdvisorId, ProjectId, AdvisorRole, AssignmentDate) VALUES ('" + Convert.ToInt32(cmbAdvisorId.Text) + "', (SELECT Id FROM Project WHERE Title = '" + Convert.ToString(cmbtitle.Text) + "'), (SELECT Lookup.Id FROM Lookup WHERE Lookup.Value = '" + Convert.ToString(cmbadvisorRole.Text) + "'), '" + Convert.ToDateTime(dTPAssigmentDay.Value) + "')"; SqlCommand cmd = new SqlCommand(Insert, con); cmd.ExecuteNonQuery(); MessageBox.Show("Succesfully Inserted"); // query = "INSERT INTO ProjectAdvisor(AdvisorId, ProjectId , AdvisorRole , AssignmentDate) VALUES('" + id + "','" + Convert.ToString(txtRegNo.Text) + "')"; } projectTitle(); //MessageBox.Show("SuccessFully Added"); this.Hide(); ProjectAdvisor a = new ProjectAdvisor(); a.Show(); }
private void button10_Click(object sender, EventArgs e) { ProjectAdvisor proadvfm = new ProjectAdvisor(); proadvfm.Show(); }
private void button4_Click_1(object sender, EventArgs e) { ProjectAdvisor id1 = new ProjectAdvisor(); id1.Show(); }
private void button8_Click(object sender, EventArgs e) { con.Close(); //outer if check if Project Id and advisor Id exists or not. //inner if check if there is any kind of primary key violation inside table con.Open(); SqlCommand check_User_Name = new SqlCommand("SELECT ID FROM Advisor WHERE ([ID] = @ID)", con); check_User_Name.Parameters.AddWithValue("ID", AdvId.Text); SqlDataReader reader1 = check_User_Name.ExecuteReader(); check_User_Name = new SqlCommand("SELECT ID FROM Project WHERE ([ID] = @ID)", con); check_User_Name.Parameters.AddWithValue("ID", ProId.Text); SqlDataReader reader2 = check_User_Name.ExecuteReader(); if (reader1.HasRows && reader2.HasRows) { con.Close(); con.Open(); SqlCommand check_User_Name3 = new SqlCommand("SELECT ProjectId,AdvisorId FROM ProjectAdvisor WHERE ([AdvisorId] = @AdvisorId and [ProjectId] = @ProjectId)", con); check_User_Name3.Parameters.AddWithValue("@AdvisorId", AdvId.Text); check_User_Name3.Parameters.AddWithValue("@ProjectId", ProId.Text); SqlDataReader reader3 = check_User_Name3.ExecuteReader(); if (reader3.HasRows) { con.Close(); MessageBox.Show("There must exists one advisor of one type for 1 project."); } else { con.Close(); con.Open(); SqlCommand cmd = new SqlCommand("Select COUNT(1) As pid from ProjectAdvisor WHERE ProjectId = '" + ProId.Text + "';", con); object countstd1 = cmd.ExecuteScalar(); int countstd = 0; if (!(countstd1 == DBNull.Value)) { countstd = Convert.ToInt32(countstd1); } if (countstd >= 3) { con.Close(); MessageBox.Show("No More Advisor can be added against this project Can Be Added."); } else { cmd = con.CreateCommand(); cmd = new SqlCommand("INSERT INTO ProjectAdvisor(AdvisorId, ProjectId,AdvisorRole,AssignmentDate) VALUES(@AdvisorId,@ProjectId,@AdvisorRole,@AssignmentDate)", con); cmd.Parameters.AddWithValue("@ProjectId", ProId.Text); cmd.Parameters.AddWithValue("@AdvisorId", AdvId.Text); string desig = AdvR.Text.ToString(); int g = Advisor_look(desig); cmd.Parameters.AddWithValue("@AdvisorRole", g); cmd.Parameters.AddWithValue("@AssignmentDate", DateTime.Parse(Assgdate.Text)); cmd.ExecuteNonQuery(); con.Close(); MessageBox.Show("Data Inserted Successfully"); this.Hide(); ProjectAdvisor pradfm = new ProjectAdvisor(); pradfm.Show(); } } } else { con.Close(); MessageBox.Show("Record does not exists."); } con.Close(); }