private void removeProjectKristal() { int rowCount = dgv_KristalRef.Rows.GetRowCount(DataGridViewElementStates.Selected); if (rowCount > 0) { List <int> removedRefs = new List <int>(); for (int i = 0; i < rowCount; i++) { int rowIndex = dgv_KristalRef.SelectedRows[i].Index; int projectKristalID = Convert.ToInt32(dgv_KristalRef.Rows[rowIndex].Cells["ProjectKristalID"].Value); string kristalRef = dgv_KristalRef.Rows[rowIndex].Cells["Kristal Ref"].Value.ToString(); DialogResult removeRef = MessageBox.Show($"Remove {kristalRef} from project record?", "", MessageBoxButtons.YesNo); if (removeRef == DialogResult.Yes) { Kristal kristal = new Kristal(); kristal.deleteProjectKristal(projectKristalID); removedRefs.Add(rowIndex); } } foreach (int rowIndex in removedRefs) { dgv_KristalRef.Rows.RemoveAt(rowIndex); } } }
private bool addProjectKristal() { if (cb_GrantStage.SelectedIndex > -1) { mdl_Kristal newKristal = new mdl_Kristal(); newKristal.GrantStageID = (int)cb_GrantStage.SelectedValue; newKristal.KristalName = tb_KristalName.Text; int testRef; // if KristalRef is an integer if (int.TryParse(tb_KristalRef.Text, out testRef)) { newKristal.KristalRef = testRef; if (newKristal.KristalRef > 0) { Kristal kristal = new Kristal(); kristal.insertProjectKristalReference(projectNumber, newKristal); return(true); } } else { MessageBox.Show("Please enter a Kristal Reference."); } } else { MessageBox.Show("Please select an application stage."); } return(false); }
private void dgv_KristalRef_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { int r = e.RowIndex; if (r > -1) { try { Kristal kristal = new Kristal(); mdl_Kristal mdl_Kristal = new mdl_Kristal(); mdl_Kristal = kristal.fetchCurrentKristal(Convert.ToInt32(dgv_KristalRef.Rows[r].Cells["Kristal Ref"].Value)); DataTable tlkGrantStage = ds_Project.Tables["tlkGrantStage"]; using (frm_Kristal Kristal = new frm_Kristal(mdl_Kristal)) { Kristal.ShowDialog(); fillProjectsDataSet(); setProjectKristalRef(mdl_CurrentProject.ProjectNumber); } } catch (Exception ex) { MessageBox.Show("Please double click on a data row to see Kristal details." + Environment.NewLine + ex.Message); } } }
/// <summary> /// Method to add a note to a project record. /// If the textbox control tb_NewProjectNote is not empty the entered value is inserted into a table within /// the SQL Server database. /// Assigns the contents of tb_NewProjectNote to a variable (newProjectNote), creates a new Project class /// object and passes the parameter pNumber and variable newProjectNote to a method it contains (insertProjectNote). /// Refreshes class DataSet (ds_Project) and datagrid view before clearing the contents of the text box (tb_NewProjectNote). /// </summary> /// <param name="pNumber"></param> private void addKristalNote(int kristalRef) { string newKristalNote; if (tb_NewKristalNote.Text != "") { try { //place the new note text into the string variable (newProjectNote) newKristalNote = tb_NewKristalNote.Text; //instantiate new Project type object that contains methods to update db Kristal kristal = new Kristal(); //add the note to the SQL table kristal.insertKristalNote(kristalRef, newKristalNote); //refresh the DataSet (ds_Project) ds_Kristal = kristal.getKristalDataSet(); //repopulate the DataGridView (dgv_pNotes) setKristalNotes(); //clear the textbox control tb_NewKristalNote.Clear(); } catch (Exception ex) { MessageBox.Show("Failed to add new note" + Environment.NewLine + ex); throw; } } }
private bool addKristal() { if (cb_GrantStage.SelectedIndex > -1) { mdl_Kristal newKristal = new mdl_Kristal(); newKristal.GrantStageID = (int)cb_GrantStage.SelectedValue; newKristal.KristalName = tb_KristalName.Text; int testRef; if (int.TryParse(tb_KristalRef.Text, out testRef)) { newKristal.KristalRef = testRef; if (newKristal.KristalRef > 0) { Kristal kristal = new Kristal(); if (kristal.insertKristal(newKristal) == true) { MessageBox.Show("Item added"); newKristalRef = newKristal.KristalRef; return(true); } } } else { MessageBox.Show("Please enter a Kristal Reference."); } } else { MessageBox.Show("Please select an application stage."); } return(false); }
public bool updateKristal(mdl_Kristal currentKristal) { mdl_Kristal newKristal = new mdl_Kristal(); try { newKristal.KristalRef = currentKristal.KristalRef; newKristal.GrantStageID = (int)cb_GrantStage.SelectedValue; newKristal.KristalName = tb_KristalName.Text; } catch (Exception ex) { MessageBox.Show("Please enter valid details." + Environment.NewLine + Environment.NewLine + ex.Message); } //if details remain same, do nothing if (currentKristal == newKristal) { return(true); } //if details changed, update if (newKristal != currentKristal) { Kristal kristal = new Kristal(); //logically delete current record from dbo.tblKristal if (kristal.deleteKristal(current_Kristal.KristalID)) { //insert new record to dbo.tblKristal kristal.insertKristal(newKristal); current_Kristal = newKristal; return(true); } } return(false); }
public void setKristal(mdl_Kristal mdl_Kristal) { try { current_Kristal = mdl_Kristal; Kristal kristal = new Kristal(); ds_Kristal = kristal.getKristalDataSet(); lbl_KristalRefValue.Text = current_Kristal.KristalRef.ToString(); DataView GrantStages = new DataView(ds_Kristal.Tables["tlkGrantStage"]); GrantStages.RowFilter = "[ValidTo] is null"; cb_GrantStage.DataSource = GrantStages; cb_GrantStage.ValueMember = "GrantStageID"; cb_GrantStage.DisplayMember = "GrantStageDescription"; cb_GrantStage.SelectedValue = current_Kristal.GrantStageID; tb_KristalName.Text = current_Kristal.KristalName; } catch (Exception ex) { MessageBox.Show("Method setKristalEdit of class frm_ProjectKristalEdit has failed" + Environment.NewLine + Environment.NewLine + ex.Message); } }
private void fillKristalDataSet() { Kristal kristal = new Kristal(); ds_kristal = kristal.getKristalDataSet(); }