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