private void AddButton_Click(object sender, EventArgs e) { for (int j = 0; j < ProjectDataGrid.RowCount; j++) { if (ProjectDataGrid.Rows[j].Cells[ProjectDataGrid.Columns["Select"].Index].Value == null) { ProjectDataGrid.Rows[j].Cells[ProjectDataGrid.Columns["Select"].Index].Value = false; } } try { List <int> idi = new List <int>(); for (int i = 0; i < ProjectDataGrid.RowCount; i++) { if ((bool)ProjectDataGrid.Rows[i].Cells[ProjectDataGrid.Columns["Select"].Index].Value) { idi.Add((int)ProjectDataGrid.Rows[i].Cells[ProjectDataGrid.Columns["Id"].Index].Value); } } foreach (int idk in idi) { String cmd = String.Format("INSERT INTO GroupProject(ProjectId, GroupId, AssignmentDate) VALUES({0}, {1}, GETDATE())", idk, id); DatabaseConnection.getInstance().exectuteQuery(cmd); } if (idi.Count == 0) { MessageBox.Show("Nothing was selected."); } else { par.Refresh(); this.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void AddButton_Click(object sender, EventArgs e) { int flag = 0; int obtainmark = 0; List <int> idi = new List <int>(); String ids = "-1"; for (int j = 0; j < ProjectDataGrid.RowCount; j++) { if (ProjectDataGrid.Rows[j].Cells[ProjectDataGrid.Columns["Select"].Index].Value == null) { ProjectDataGrid.Rows[j].Cells[ProjectDataGrid.Columns["Select"].Index].Value = false; } } for (int i = 0; i < ProjectDataGrid.RowCount; i++) { if ((bool)ProjectDataGrid.Rows[i].Cells[ProjectDataGrid.Columns["Select"].Index].Value) { idi.Add((int)ProjectDataGrid.Rows[i].Cells[ProjectDataGrid.Columns["Id"].Index].Value); ids = ids + ", " + ProjectDataGrid.Rows[i].Cells[ProjectDataGrid.Columns["Id"].Index].Value.ToString(); } } if ((string.IsNullOrEmpty(OMTextBox.Text))) { flag++; obtainmark = 0; } else if (Regexp("^[0-9]{1,3}", OMTextBox, OMError, "Only valid numbers are allowed.", 3)) { obtainmark = Convert.ToInt32(OMTextBox.Text); string cmd = "SELECT COUNT(*) FROM Evaluation WHERE Id IN (" + ids + ") AND TotalMarks < " + OMTextBox.Text; var reader = DatabaseConnection.getInstance().getData(cmd); while (reader.Read()) { if ((int)reader.GetValue(0) > 0) { flag--; OMError.ForeColor = System.Drawing.Color.Red; OMError.Text = "Total marks is less than current obtained marks."; } } flag++; } if (flag == 1) { try { int sum = 0; string cmd = "SELECT SUM(TotalWeightage) FROM Evaluation JOIN GroupEvaluation ON EvaluationId = Id WHERE GroupId = " + id; var reader = DatabaseConnection.getInstance().getData(cmd); while (reader.Read()) { if (reader.GetValue(0) == null) { sum = (int)reader.GetValue(0) + sum; } } foreach (int idk in idi) { cmd = "SELECT TotalWeightage FROM Evaluation WHERE Id = " + idk; reader = DatabaseConnection.getInstance().getData(cmd); while (reader.Read()) { sum = (int)reader.GetValue(0) + sum; if (sum > 100) { MessageBox.Show("Total Weightage of evaluation/s exceeds 100%.\nCurrent evaluation not added."); flag = 0; break; } } } if (flag != 0) { foreach (int idk in idi) { DateTime s = EDDatePicker.Value; cmd = String.Format("INSERT INTO GroupEvaluation(EvaluationId, GroupId, ObtainedMarks, EvaluationDate) VALUES({0}, {1}, {2}, '{3}')", idk, id, obtainmark, s.Month + "/" + s.Day + "/" + s.Year); DatabaseConnection.getInstance().exectuteQuery(cmd); } } if (idi.Count == 0) { MessageBox.Show("Nothing was selected."); } else if (flag != 0) { par.Refresh(); this.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } } }