private void linkLabel3_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { GroupEvaluation cg = new GroupEvaluation(); this.Hide(); cg.Show(); }
private void button11_Click(object sender, EventArgs e) { this.Hide(); GroupEvaluation ee = new GroupEvaluation(); ee.Show(); }
private void individualEvaluationToolStripMenuItem_Click(object sender, EventArgs e) { GroupEvaluation l = GroupEvaluation.getInstance(); l.Show(); this.Hide(); }
private void button8_Click(object sender, EventArgs e) { GroupEvaluation ge = new GroupEvaluation(); this.Hide(); ge.Show(); }
private void btnEvalGroups_Click(object sender, EventArgs e) { this.Hide(); GroupEvaluation GE = new GroupEvaluation(); GE.Show(); }
private void button6_Click(object sender, EventArgs e) { conn.Open(); int ad = Convert.ToInt32(comboBox3.SelectedItem.ToString()); //group id string reg = Convert.ToString(comboBox2.SelectedItem.ToString()); //evaluation name string prooo = "SELECT Id FROM Evaluation WHERE Name='" + reg + "' "; SqlCommand InvAmou = new SqlCommand(prooo, conn); int pro = Convert.ToInt32(InvAmou.ExecuteScalar()); string mark = textBox1.Text.ToString(); if (string.IsNullOrEmpty(mark) || !Regex.IsMatch(textBox1.Text, @"^[0-9]{1,3}$")) { MessageBox.Show("Invalid marks"); textBox1.Clear(); textBox1.BackColor = Color.DodgerBlue; conn.Close(); return; } int marks = Convert.ToInt32(textBox1.Text.ToString()); DateTime dt = DateTime.Today; try { String insert1 = "insert into GroupEvaluation values('" + ad + "','" + pro + "','" + marks + "','" + dt + "' ) "; SqlCommand sql1 = new SqlCommand(insert1, conn); int i1 = sql1.ExecuteNonQuery(); // to check if the student is registered or not if (i1 >= 1) { MessageBox.Show("Evaluation is marked against a group"); this.Refresh(); } else { { MessageBox.Show("Evaluation Not Marked"); } } this.Refresh(); Refresh(); this.Hide(); GroupEvaluation ss = new GroupEvaluation(); ss.Show(); conn.Close(); } catch (Exception ex) { MessageBox.Show("Already exists"); conn.Close(); } }
public static GroupEvaluation getInstance() { if (l == null) { l = new GroupEvaluation(); l.Show(); return(l); } else { return(l); } }
private void button5_Click(object sender, EventArgs e) { conn.Open(); int marks = Convert.ToInt32(textBox1.Text.ToString()); DateTime dt = DateTime.Today; try { String insert1 = "update GroupEvaluation set GroupId='" + IDD + "',EvaluationId='" + idd + "',ObtainedMarks='" + marks + "',EvaluationDate='" + dt + "' WHERE GroupId = '" + IDD + "' AND EvaluationId='" + idd + "'"; SqlCommand sql1 = new SqlCommand(insert1, conn); int i1 = sql1.ExecuteNonQuery(); // to check if the student is registered or not if (i1 >= 1) { MessageBox.Show("Updation Sucessful"); this.Refresh(); } else { { MessageBox.Show("Updation failed"); } } this.Refresh(); Refresh(); this.Hide(); GroupEvaluation ss = new GroupEvaluation(); ss.Show(); conn.Close(); } catch (Exception a) { MessageBox.Show(a.Message); conn.Close(); } }
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { conn.Open(); if (e.RowIndex == dataGridView1.NewRowIndex || e.RowIndex < 0) { return; } //Check if click is on specific column if (e.ColumnIndex == dataGridView1.Columns["DeleteButton"].Index) { int index = e.RowIndex; IDD = Convert.ToInt32(dataGridView1.Rows[index].Cells[2].Value.ToString()); idd = Convert.ToInt32(dataGridView1.Rows[index].Cells[3].Value.ToString()); try { string delete1 = String.Format("DELETE FROM GroupEvaluation WHERE GroupId = '" + IDD + "' AND EvaluationId='" + idd + "'"); SqlCommand de11 = new SqlCommand(delete1, conn); int i = de11.ExecuteNonQuery(); if (i >= 1) { MessageBox.Show(" Deletion Succesfull "); this.Refresh(); } else { MessageBox.Show(" Deletion Failed"); } this.Refresh(); Refresh(); this.Hide(); GroupEvaluation ss = new GroupEvaluation(); ss.Show(); } catch (Exception a) { MessageBox.Show(a.Message); } } else if (e.ColumnIndex == dataGridView1.Columns["EditButton"].Index) { panel5.Show(); button6.Hide(); button5.Show(); label2.Hide(); label5.Hide(); comboBox2.Hide(); comboBox3.Hide(); int indexx = e.RowIndex; IDD = Convert.ToInt32(dataGridView1.Rows[indexx].Cells[2].Value.ToString()); idd = Convert.ToInt32(dataGridView1.Rows[indexx].Cells[3].Value.ToString()); SqlCommand cmd; SqlDataAdapter da; DataSet ds; cmd = new SqlCommand("SELECT Id FROM [dbo].[Group]", conn); da = new SqlDataAdapter(cmd); ds = new DataSet(); da.Fill(ds); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { comboBox3.Items.Add(ds.Tables[0].Rows[i][0]); } cmd = new SqlCommand("select Name from Evaluation", conn); da = new SqlDataAdapter(cmd); ds = new DataSet(); da.Fill(ds); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { comboBox2.Items.Add(ds.Tables[0].Rows[i][0]); } } conn.Close(); }
private void button9_Click(object sender, EventArgs e) { GroupEvaluation id3 = new GroupEvaluation(); id3.Show(); }