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