private void SearchButtonP_Click(object sender, EventArgs e) { try { if (SearchTextBoxP.Text == "") { Refresh(); return; } String cmd = "Select Id, Title, Description, AssignmentDate from Project JOIN GroupProject ON Id = ProjectId WHERE GroupId = " + id.ToString() + " AND " + SearchCategoryP.Text + " = '" + SearchTextBoxP.Text + "'"; var reader = DatabaseConnection.getInstance().getData(cmd); List <ProjectClass> project = new List <ProjectClass>(); while (reader.Read()) { ProjectClass stu = new ProjectClass(); stu.Id = (int)reader.GetValue(0); stu.Titlle = reader.GetString(1); stu.Description = reader.GetString(2); stu.AssignmentDate = (DateTime)reader.GetValue(3); project.Add(stu); } ProjectDataGrid.DataSource = project; ProjectDataGrid.Columns["Id"].Visible = false; ProjectDataGrid.Columns["Description"].Visible = false; for (int j = 0; j < ProjectDataGrid.RowCount; j++) { ProjectDataGrid.Rows[j].Cells[ProjectDataGrid.Columns["Select"].Index].Value = false; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void SearchButton_Click(object sender, EventArgs e) { try { if (SearchTextBox.Text == "") { Refresh(); return; } String cmd = "Select Id, Title, Description from Project Where " + SearchCategory.Text + " = '" + SearchTextBox.Text + "'"; var reader = DatabaseConnection.getInstance().getData(cmd); List <ProjectClass> students = new List <ProjectClass>(); while (reader.Read()) { ProjectClass stu = new ProjectClass(); stu.Id = (int)reader.GetValue(0); stu.Titlle = reader.GetString(1); stu.Description = reader.GetString(2); students.Add(stu); } ProjectDataGrid.DataSource = students; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void Refresh() { ProjectDataGrid.Columns.Clear(); SearchCategory.Items.Clear(); try { DataGridViewCheckBoxColumn checkColumn = new DataGridViewCheckBoxColumn(); checkColumn.Name = "Select"; checkColumn.HeaderText = ""; checkColumn.TrueValue = true; checkColumn.FalseValue = false; checkColumn.Width = 20; checkColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.None; checkColumn.ReadOnly = false; //if the datagridview is resized (on form resize) the checkbox won't take up too much; value is relative to the other columns' fill values ProjectDataGrid.Columns.Add(checkColumn); String cmd = "SELECT Id, Title FROM Project WHERE Id NOT IN (Select Id from Project JOIN GroupProject ON Id = ProjectId WHERE GroupId = " + id.ToString() + ")"; var reader = DatabaseConnection.getInstance().getData(cmd); List <ProjectClass> project = new List <ProjectClass>(); while (reader.Read()) { ProjectClass stu = new ProjectClass(); stu.Id = (int)reader.GetValue(0); stu.Titlle = reader.GetString(1); project.Add(stu); } ProjectDataGrid.DataSource = project; for (int j = 0; j < ProjectDataGrid.RowCount; j++) { ProjectDataGrid.Rows[j].Cells[ProjectDataGrid.Columns["Select"].Index].Value = false; } ProjectDataGrid.Columns["Id"].Visible = false; ProjectDataGrid.Columns["Description"].Visible = false; ProjectDataGrid.Columns["AssignmentDate"].Visible = false; cmd = "Select Title from Project JOIN GroupProject ON Id = ProjectId"; reader = DatabaseConnection.getInstance().getData(cmd); int i = 0; while (reader.FieldCount > i) { if (!SearchCategory.Items.Contains(reader.GetName(i))) { SearchCategory.Items.Add(reader.GetName(i)); } i++; } SearchCategory.SelectedIndex = 0; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public ProjectDetails(int id) { InitializeComponent(); this.MinimumSize = new Size(this.Width, this.Height); String cmd = "SELECT Id, Title, Description FROM Project where Id = " + id.ToString(); var reader = DatabaseConnection.getInstance().getData(cmd); ProjectClass stuold = new ProjectClass(); while (reader.Read()) { stuold.Id = (int)reader.GetValue(0); stuold.Titlle = reader.GetString(1); stuold.Description = reader.GetString(2); } TitleLabel1.Text = stuold.Titlle; DescLabel.Text = stuold.Description; }
public ProjectEdit(int id, MainPage parent) { par = parent; InitializeComponent(); this.MinimumSize = new Size(this.Width, this.Height); TitleError.Text = ""; DesError.Text = ""; String cmd = "SELECT Id, Title, Description FROM Project where Id = " + id.ToString(); var reader = DatabaseConnection.getInstance().getData(cmd); stuold = new ProjectClass(); while (reader.Read()) { stuold.Id = (int)reader.GetValue(0); stuold.Titlle = reader.GetString(1); stuold.Description = reader.GetString(2); } TitleTextBox.Text = stuold.Titlle; DesTextBox.Text = stuold.Description; }
public void Refresh() { try { String cmd = "Select Id, Title, Description from Project"; var reader = DatabaseConnection.getInstance().getData(cmd); List <ProjectClass> students = new List <ProjectClass>(); while (reader.Read()) { ProjectClass stu = new ProjectClass(); stu.Id = (int)reader.GetValue(0); stu.Titlle = reader.GetString(1); stu.Description = reader.GetString(2); students.Add(stu); } ProjectDataGrid.DataSource = students; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void Add_Click(object sender, EventArgs e) { int flag = 0; try { ProjectClass stu = new ProjectClass(); stu.Titlle = null; stu.Description = null; if (Regexp("^[a-zA-Z]{1,100}", TitleTextBox, TitleError, "Only alphabets are allowed.", 100)) { stu.Titlle = TitleTextBox.Text; flag++; } if ((string.IsNullOrEmpty(DesTextBox.Text))) { flag++; } else { stu.Description = DesTextBox.Text; flag++; } if (flag == 2) { String cmd = String.Format("Update Project SET Title = '{0}', Description = '{1}' WHERE Id = '{2}'", stu.Titlle, stu.Description, stuold.Id); DatabaseConnection.getInstance().exectuteQuery(cmd); par.Refresh(); this.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void Refresh() { DeleteButtonP.Visible = false; EvalDeleteButton.Visible = false; StudentDataGrid.Columns.Clear(); SearchCategoryS.Items.Clear(); ProjectDataGrid.Columns.Clear(); SearchCategoryP.Items.Clear(); EvaluationDataGrid.Columns.Clear(); SearchCategoryE.Items.Clear(); try { String cmd = "Select Person.Id, FirstName, LastName, Contact, Email, DateOfBirth, Gender, RegistrationNo, GroupId, AssignmentDate, Value from ((Person JOIN Student ON Person.Id = Student.Id) JOIN GroupStudent ON Student.Id = StudentId) JOIN Lookup ON Lookup.Id = Status WHERE GroupId = " + id.ToString(); var reader = DatabaseConnection.getInstance().getData(cmd); List <StudentClass> students = new List <StudentClass>(); while (reader.Read()) { StudentClass stu = new StudentClass(); stu.Id = (int)reader.GetValue(0); stu.FirstName = reader.GetString(1); stu.LastName = reader.GetString(2); stu.Contact = reader.GetString(3); stu.Email = reader.GetString(4); stu.DateOfBirth = (DateTime)reader.GetValue(5); stu.Gender = (int)reader.GetValue(6); stu.RegistrationNo = reader.GetString(7); stu.GroupId = (int)reader.GetValue(8); stu.AssignmentDate = (DateTime)reader.GetValue(9); stu.Status = reader.GetString(10); students.Add(stu); } StudentDataGrid.DataSource = students; StudentDataGrid.Columns["Id"].Visible = false; StudentDataGrid.Columns["Gender"].Visible = false; StudentDataGrid.Columns["Contact"].Visible = false; StudentDataGrid.Columns["Email"].Visible = false; StudentDataGrid.Columns["FirstName"].Visible = false; StudentDataGrid.Columns["LastName"].Visible = false; StudentDataGrid.Columns["DateOfBirth"].Visible = false; StudentDataGrid.Columns["Genders"].Visible = false; StudentDataGrid.Columns["GroupId"].Visible = false; cmd = "Select RegistrationNo, Status As Statuses from (Person JOIN Student ON Person.Id = Student.Id) JOIN GroupStudent ON Student.Id = StudentId"; reader = DatabaseConnection.getInstance().getData(cmd); int i = 0; while (reader.FieldCount > i) { if (!SearchCategoryS.Items.Contains(reader.GetName(i))) { SearchCategoryS.Items.Add(reader.GetName(i)); } i++; } SearchCategoryS.SelectedIndex = 0; DataGridViewCheckBoxColumn checkColumn = new DataGridViewCheckBoxColumn(); checkColumn.Name = "Select"; checkColumn.HeaderText = ""; checkColumn.TrueValue = true; checkColumn.FalseValue = false; checkColumn.Width = 20; checkColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.None; checkColumn.ReadOnly = false; //if the datagridview is resized (on form resize) the checkbox won't take up too much; value is relative to the other columns' fill values ProjectDataGrid.Columns.Add(checkColumn); cmd = "Select Id, Title, Description, AssignmentDate from Project JOIN GroupProject ON Id = ProjectId WHERE GroupId = " + id.ToString(); reader = DatabaseConnection.getInstance().getData(cmd); List <ProjectClass> project = new List <ProjectClass>(); while (reader.Read()) { ProjectClass stu = new ProjectClass(); stu.Id = (int)reader.GetValue(0); stu.Titlle = reader.GetString(1); stu.Description = reader.GetString(2); stu.AssignmentDate = (DateTime)reader.GetValue(3); project.Add(stu); } ProjectDataGrid.DataSource = project; ProjectDataGrid.Columns["Id"].Visible = false; ProjectDataGrid.Columns["Description"].Visible = false; for (int j = 0; j < ProjectDataGrid.RowCount; j++) { ProjectDataGrid.Rows[j].Cells[ProjectDataGrid.Columns["Select"].Index].Value = false; } cmd = "Select Title from Project JOIN GroupProject ON Id = ProjectId"; reader = DatabaseConnection.getInstance().getData(cmd); i = 0; while (reader.FieldCount > i) { if (!SearchCategoryP.Items.Contains(reader.GetName(i))) { SearchCategoryP.Items.Add(reader.GetName(i)); } i++; } SearchCategoryP.SelectedIndex = 0; cmd = "Select Id, Name, TotalMarks, TotalWeightage, ObtainedMarks, EvaluationDate from Evaluation JOIN GroupEvaluation ON Id = EvaluationId WHERE GroupId = " + id.ToString(); reader = DatabaseConnection.getInstance().getData(cmd); DataGridViewCheckBoxColumn checkColumn2 = new DataGridViewCheckBoxColumn(); checkColumn2.Name = "Select"; checkColumn2.HeaderText = ""; checkColumn2.TrueValue = true; checkColumn2.FalseValue = false; checkColumn2.Width = 20; checkColumn2.AutoSizeMode = DataGridViewAutoSizeColumnMode.None; checkColumn2.ReadOnly = false; //if the datagridview is resized (on form resize) the checkbox won't take up too much; value is relative to the other columns' fill values EvaluationDataGrid.Columns.Add(checkColumn2); List <EvaluationClass> evaluation = new List <EvaluationClass>(); while (reader.Read()) { EvaluationClass stu = new EvaluationClass(); stu.Id = (int)reader.GetValue(0); stu.Name = reader.GetString(1); stu.TotalMarks = (int)reader.GetValue(2); stu.TotalWeightage = (int)reader.GetValue(3); stu.ObtainedMarks = (int)reader.GetValue(4); stu.EvaluationDate = (DateTime)reader.GetValue(5); evaluation.Add(stu); } EvaluationDataGrid.DataSource = evaluation; EvaluationDataGrid.Columns["Id"].Visible = false; for (int j = 0; j < EvaluationDataGrid.RowCount; j++) { EvaluationDataGrid.Rows[j].Cells[EvaluationDataGrid.Columns["Select"].Index].Value = false; } cmd = "Select Name, TotalMarks, TotalWeightage from Evaluation JOIN GroupEvaluation ON Id = EvaluationId"; reader = DatabaseConnection.getInstance().getData(cmd); i = 0; while (reader.FieldCount > i) { if (!SearchCategoryE.Items.Contains(reader.GetName(i))) { SearchCategoryE.Items.Add(reader.GetName(i)); } i++; } SearchCategoryE.SelectedIndex = 0; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public Project() { InitializeComponent(); this.MinimumSize = new Size(this.Width, this.Height); try { String cmd = "Select Id, Title, Description from Project"; var reader = DatabaseConnection.getInstance().getData(cmd); List <ProjectClass> students = new List <ProjectClass>(); while (reader.Read()) { ProjectClass stu = new ProjectClass(); stu.Id = (int)reader.GetValue(0); stu.Titlle = reader.GetString(1); stu.Description = reader.GetString(2); students.Add(stu); } ProjectDataGrid.DataSource = students; ProjectDataGrid.Columns[0].Visible = false; ProjectDataGrid.Columns[2].Visible = false; DataGridViewButtonColumn bcol3 = new DataGridViewButtonColumn(); bcol3.HeaderText = ""; bcol3.Text = "Details"; bcol3.Name = "btnDetails"; bcol3.UseColumnTextForButtonValue = true; ProjectDataGrid.Columns.Add(bcol3); DataGridViewButtonColumn bcol = new DataGridViewButtonColumn(); bcol.HeaderText = ""; bcol.Text = "Edit"; bcol.Name = "btnEdit"; bcol.UseColumnTextForButtonValue = true; ProjectDataGrid.Columns.Add(bcol); DataGridViewButtonColumn bcol1 = new DataGridViewButtonColumn(); bcol1.HeaderText = ""; bcol1.Text = "Delete"; bcol1.Name = "btnDelete"; bcol1.UseColumnTextForButtonValue = true; ProjectDataGrid.Columns.Add(bcol1); DataGridViewButtonColumn bcol2 = new DataGridViewButtonColumn(); bcol2.HeaderText = ""; bcol2.Text = "Group"; bcol2.Name = "btnGroup"; bcol2.UseColumnTextForButtonValue = true; ProjectDataGrid.Columns.Add(bcol2); cmd = "Select Title from Project"; reader = DatabaseConnection.getInstance().getData(cmd); int i = 0; while (reader.FieldCount > i) { if (!SearchCategory.Items.Contains(reader.GetName(i))) { SearchCategory.Items.Add(reader.GetName(i)); } i++; } SearchCategory.SelectedIndex = 0; } catch (Exception ex) { MessageBox.Show(ex.Message); } }