private void BackBtn_Click(object sender, EventArgs e) { GroupStudent form = new GroupStudent(); form.Show(); this.Hide(); }
private void GroupEvaluationDataGridView_CellContentClick(object sender, DataGridViewCellEventArgs e) { int currentRow = int.Parse(e.RowIndex.ToString()); int curentcolumnindex = int.Parse(e.ColumnIndex.ToString()); int EvaluationId = Convert.ToInt32(GroupEvaluationDataGridView.Rows[currentRow].Cells[1].Value); if (curentcolumnindex == 0) { SqlConnection conn = new SqlConnection(conURL); conn.Open(); if (!String.IsNullOrEmpty(ObtainedMarksTextBox.Text)) { String AddCMD = "INSERT INTO GroupEvaluation (GroupId, EvaluationId, ObtainedMarks, EvaluationDate) VALUES (@gid, @eid, @marks, @evalDate)"; SqlCommand AddCommand = new SqlCommand(AddCMD, conn); AddCommand.Parameters.Add(new SqlParameter("status", 3)); AddCommand.Parameters.Add(new SqlParameter("eid", EvaluationId)); AddCommand.Parameters.Add(new SqlParameter("gid", groupId)); AddCommand.Parameters.Add(new SqlParameter("marks", Convert.ToInt32(ObtainedMarksTextBox.Text))); AddCommand.Parameters.Add(new SqlParameter("evalDate", DateTime.Today)); int count = AddCommand.ExecuteNonQuery(); } GroupStudent form = new GroupStudent(); form.Show(); this.Hide(); } }
private void AddGroupBtn_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(conURL); conn.Open(); String AddGroupCMD = "INSERT INTO [Group] (Created_On) VALUES (@cdate)"; SqlCommand AddGroupCommand = new SqlCommand(AddGroupCMD, conn); AddGroupCommand.Parameters.Add(new SqlParameter("cdate", DateTime.Today)); int count = AddGroupCommand.ExecuteNonQuery(); GroupStudent form = new GroupStudent(); form.Show(); this.Hide(); }
private void AddGroupProjectDataGridView_CellContentClick(object sender, DataGridViewCellEventArgs e) { int currentRow = int.Parse(e.RowIndex.ToString()); int curentcolumnindex = int.Parse(e.ColumnIndex.ToString()); int ProjectId = Convert.ToInt32(AddGroupProjectDataGridView.Rows[currentRow].Cells[1].Value); if (curentcolumnindex == 0) { SqlConnection conn = new SqlConnection(conURL); conn.Open(); String AddCMD = "INSERT INTO GroupProject (ProjectId, GroupId, AssignmentDate) VALUES (@prid, @gid, @asgnDate)"; SqlCommand AddCommand = new SqlCommand(AddCMD, conn); AddCommand.Parameters.Add(new SqlParameter("prid", ProjectId)); AddCommand.Parameters.Add(new SqlParameter("gid", groupId)); AddCommand.Parameters.Add(new SqlParameter("asgnDate", DateTime.Today)); int count = AddCommand.ExecuteNonQuery(); } GroupStudent form = new GroupStudent(); form.Show(); this.Hide(); }
private void StdGroupDataGridView_CellContentClick(object sender, DataGridViewCellEventArgs e) { int currentRow = int.Parse(e.RowIndex.ToString()); int curentcolumnindex = int.Parse(e.ColumnIndex.ToString()); string gid = StdGroupDataGridView.Rows[currentRow].Cells[0].Value.ToString(); if (curentcolumnindex == 2) { AddStudentGroup form = new AddStudentGroup(Convert.ToInt32(gid)); form.Show(); this.Hide(); } if (curentcolumnindex == 3) { ViewGroupStudents form = new ViewGroupStudents(Convert.ToInt32(gid)); form.Show(); this.Hide(); } if (curentcolumnindex == 4) { AddEvaluationGroup form = new AddEvaluationGroup(Convert.ToInt32(gid)); form.Show(); this.Hide(); } if (curentcolumnindex == 5) { ViewGroupEvaluation form = new ViewGroupEvaluation(Convert.ToInt32(gid)); form.Show(); this.Hide(); } if (curentcolumnindex == 6) { AddGroupProject form = new AddGroupProject(Convert.ToInt32(gid)); form.Show(); this.Hide(); } if (curentcolumnindex == 7) { ViewGroupProject form = new ViewGroupProject(Convert.ToInt32(gid)); form.Show(); this.Hide(); } if (curentcolumnindex == 8) { SqlConnection conn = new SqlConnection(conURL); conn.Open(); String DeleteCMD = "DELETE FROM GroupStudent WHERE GroupStudent.GroupId = @id"; SqlCommand DeleteCommand = new SqlCommand(DeleteCMD, conn); DeleteCommand.Parameters.Add(new SqlParameter("id", Convert.ToInt32(gid))); int count = DeleteCommand.ExecuteNonQuery(); String DeleteCMD2 = "DELETE FROM GroupEvaluation WHERE GroupEvaluation.GroupId = @id"; SqlCommand DeleteCommand2 = new SqlCommand(DeleteCMD2, conn); DeleteCommand2.Parameters.Add(new SqlParameter("id", Convert.ToInt32(gid))); count = DeleteCommand2.ExecuteNonQuery(); String DeleteCMD3 = "DELETE FROM GroupProject WHERE GroupProject.GroupId = @id"; SqlCommand DeleteCommand3 = new SqlCommand(DeleteCMD3, conn); DeleteCommand3.Parameters.Add(new SqlParameter("id", Convert.ToInt32(gid))); count = DeleteCommand3.ExecuteNonQuery(); String DeleteCMD4 = "DELETE FROM [Group] WHERE [Group].Id = @id"; SqlCommand DeleteCommand4 = new SqlCommand(DeleteCMD4, conn); DeleteCommand4.Parameters.Add(new SqlParameter("id", Convert.ToInt32(gid))); count = DeleteCommand4.ExecuteNonQuery(); GroupStudent form = new GroupStudent(); form.Show(); this.Hide(); } }