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();
}
