private void btnNEWER_Click(object sender, EventArgs e)
{
if (objSelectedReport != null && objSelectedReport.er_id > 0)
{
DialogResult dr = MessageBox.Show("Delete event??", "Confirm delete report", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (dr == DialogResult.Yes)
{
// Update DB
objSelectedReport.delete();
// Reload Event list
loadLinkedReport(objSelectedEvent.ee_id);
btnNEWER.Text = "NEW";
btnUPDATEER.Text = "INSERT";
}
}
else
{
if (btnNEWER.Text == "NEW")
{
btnNEWER.Text = "CREATE LINK";
btnUPDATEER.Text = "INSERT";
txt_er_uuid.Text = "";
txt_er_name.Text = "";
txt_er_sts.Checked = true;
// Reload Event list
}
else
{
// create new report, and link to event
objSelectedReport = new Eqpreport();
objSelectedReport.er_reportname = txt_er_name.Text;
objSelectedReport.er_uuid = txt_er_uuid.Text;
objSelectedReport.sts = txt_er_sts.Checked == true ? 1 : 0;
// Update DB
objSelectedReport.insert();
// link to event
string query = "insert into linkevent2report values('" + objSelectedEvent.ee_id + "','" + objSelectedReport.er_id + "','1','1')";
objSelectedReport.query(query);
// create new report, and link to event
btnNEWER.Text = "NEW";
btnUPDATEER.Text = "INSERT";
// Reload report list
loadLinkedReport(objSelectedEvent.ee_id);
// reload combo list
loadCbListreport();
//
}
}
}
private void btnUPDATEER_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(txt_er_uuid.Text))
{
MessageBox.Show("Report ID empty", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txt_er_uuid.Focus();
return;
}
if (string.IsNullOrWhiteSpace(txt_er_name.Text))
{
MessageBox.Show("Report name empty", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txt_er_name.Focus();
return;
}
if (objSelectedReport != null && objSelectedReport.er_id > 0)
{
objSelectedReport.er_reportname = txt_er_name.Text;
objSelectedReport.er_uuid = txt_er_uuid.Text;
objSelectedReport.sts = txt_er_sts.Checked == true ? 1 : 0;
// Update DB
objSelectedReport.update();
// Reload Event list
loadLinkedReport(objSelectedEvent.ee_id);
}
else
{
objSelectedReport = new Eqpreport();
objSelectedReport.er_reportname = txt_er_name.Text;
objSelectedReport.er_uuid = txt_er_uuid.Text;
objSelectedReport.sts = txt_ee_sts.Checked == true ? 1 : 0;
// Update DB
objSelectedReport.insert();
// Reload report list
loadLinkedReport(objSelectedEvent.ee_id);
// reload combo list
loadCbListreport();
//
}
//
//
}