protected void buttonAddComment_OnClick(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(tbComment.Text))
{
Utils.displayStatus(ref labelStatusReport, Color.Red, "Du må skrive inn en kommentar først");
return;
}
try
{
Database.Interface.open();
Database.RingtestReport report = new Database.RingtestReport();
if (!report.select_all_where_ID(new Guid(hiddenRingtestReportID.Value)))
{
Utils.reportStatus(ref labelStatusReport, Color.Red, "Ringtest.buttonAddComment_OnClick: Report not found");
return;
}
report.add_comment(ddCurrentActor.SelectedItem.Text, tbComment.Text);
gridComments.DataSource = Database.RingtestReport.get_comments(report.ID);
gridComments.DataBind();
tbComment.Text = "";
Utils.displayStatus(ref labelStatusReport, Color.SeaGreen, "Kommentar oppdatert");
}
catch (Exception ex)
{
Utils.displayStatus(ref labelStatusReport, Color.Red, ex.Message);
}
finally
{
Database.Interface.close();
}
}
protected void ddDetector_OnSelectedIndexChanged(object sender, EventArgs e)
{
labelStatusSelectDetector.Text = "";
buttonDetectorContinue.Enabled = true;
if (ddDetector.SelectedValue == Guid.Empty.ToString())
{
buttonDetectorContinue.Enabled = false;
labelDetectorInfo.Text = "";
return;
}
try
{
Database.Interface.open();
Database.RingtestReport report = new Database.RingtestReport();
if (report.select_all_where_accountID_detectorID_ringtestID(
new Guid(hiddenAccountID.Value),
new Guid(ddDetector.SelectedValue),
new Guid(hiddenRingtestID.Value)))
{
labelDetectorInfo.Text = Lang.Evaluated + ": " + (report.Evaluated ? "Ja" : "Nei");
labelDetectorInfo.Text += "<br>Godkjent: " + (report.Approved ? "Ja" : "Nei");
if (report.ContactID != Guid.Empty)
{
Database.Contact contact = new Database.Contact();
contact.select_all_by_ID(report.ContactID);
labelDetectorInfo.Text += "<br>" + Lang.Contact + ": " + contact.Name + " [" + (contact.Status == "Active" ? "Aktiv" : "Inaktiv") + "]";
if (contact.Status != "Active")
{
buttonDetectorContinue.Enabled = false;
}
}
else
{
labelDetectorInfo.Text += "<br>" + Lang.Contact + ": " + Lang.None;
}
}
else
{
labelDetectorInfo.Text = Lang.NoReportForDetector + ".<br>" + Lang.PressContinueForNewReport;
}
}
catch (Exception ex)
{
Utils.reportStatus(ref labelStatusSelectDetector, Color.Red, "Ringtest.ddDetector_OnSelectedIndexChanged: " + ex.Message);
}
finally
{
Database.Interface.close();
}
}
protected void buttonUpdateED_OnClick(object sender, EventArgs e)
{
if (ddCategoriesED.SelectedValue == Guid.Empty.ToString() ||
ddTypesED.SelectedValue == Guid.Empty.ToString() ||
String.IsNullOrEmpty(ddStatusED.Text) ||
ddOwnershipED.SelectedValue == Guid.Empty.ToString())
{
Utils.displayStatus(ref labelStatusCreate, Color.Red, "Mangler informasjon");
return;
}
try
{
Database.Interface.open();
Database.Device device = new Database.Device();
device.select_all_where_ID((Guid)gridDevicesED.SelectedDataKey.Value);
if (device.AccountID.ToString() != ddAccountED.SelectedValue)
{
Database.Ringtest ringtest = new Database.Ringtest();
if (ringtest.select_all_where_year(DateTime.Now.Year))
{
Database.RingtestReport report = new Database.RingtestReport();
if (report.select_all_where_ringtestID_AccountID_DetectorID_approved(ringtest.ID, device.AccountID, device.ID, false))
{
Utils.displayStatus(ref labelStatusEdit, Color.Red, "Oppdatering avbrutt. Kan ikke oppdatere innehaver fordi enheten har en aktiv ringtestrapport");
return;
}
}
}
device.DeviceCategoryID = new Guid(ddCategoriesEdit.SelectedValue);
device.DeviceTypeID = new Guid(ddTypesEdit.SelectedValue);
device.AccountID = new Guid(ddAccountED.SelectedValue);
device.SerialNumber = tbSerialnumberED.Text;
device.Status = ddStatusED.SelectedValue;
device.Ownership = ddOwnershipED.SelectedValue;
device.Comment = tbCommentED.Text;
device.ReceivedNew = String.IsNullOrEmpty(tbReceivedNewED.Text) ? DateTime.MinValue : DateTime.Parse(tbReceivedNewED.Text);
if (device.update_by_ID())
{
Utils.displayStatus(ref labelStatusEdit, Color.SeaGreen, "Enhet oppdatert");
}
else
{
Utils.displayStatus(ref labelStatusEdit, Color.SeaGreen, "Oppdatering av enhet feilet");
}
gridDevicesED.SelectedIndex = -1;
gridDevicesED.DataBind();
gridDevicesAllED.DataBind();
panelDeviceED.Visible = false;
}
catch (Exception ex)
{
Utils.displayStatus(ref labelStatusEdit, Color.Red, ex.Message);
}
finally
{
Database.Interface.close();
}
}
protected void buttonRingtestReportUpdate_OnClick(object sender, EventArgs e)
{
if (ddCurrentActor.SelectedValue == Guid.Empty.ToString())
{
Utils.displayStatus(ref labelStatusReport, Color.Red, Lang.You_must_select_contact_for_this_report);
return;
}
if (String.IsNullOrEmpty(tbMeasureDate.Text) || String.IsNullOrEmpty(tbRefDate.Text) || String.IsNullOrEmpty(tbActivityRef.Text))
{
Utils.displayStatus(ref labelStatusReport, Color.Red, Lang.Missing_fields);
return;
}
DateTime measureDate = DateTime.Now;
DateTime refDate = DateTime.Now;
try
{
measureDate = Convert.ToDateTime(tbMeasureDate.Text);
refDate = Convert.ToDateTime(tbRefDate.Text);
}
catch (Exception except)
{
Utils.displayStatus(ref labelStatusReport, Color.Red, Lang.Invalid_date_fields);
return;
}
try
{
Database.Interface.open();
Database.RingtestReport report = new Database.RingtestReport();
if (!report.select_all_where_ID(new Guid(hiddenRingtestReportID.Value)))
{
Utils.reportStatus(ref labelStatusReport, Color.Red, "Ringtest.buttonRingtestReportUpdate_OnClick: Report not found");
return;
}
if (report.Approved)
{
Utils.displayStatus(ref labelStatusReport, Color.Red, Lang.Update_failed_report_approved);
return;
}
if (cbWantEvaluation.Checked)
{
if (ddMCAType.SelectedValue == "Inspector1000")
{
if (ddCurrentActor.SelectedIndex == -1 || String.IsNullOrEmpty(tbGeometryFactor.Text) || String.IsNullOrEmpty(tbActivityRef.Text) ||
String.IsNullOrEmpty(tbAvgLivetimeSample.Text) || String.IsNullOrEmpty(tbUncertainty.Text))
{
Utils.displayStatus(ref labelStatusReport, Color.Red, Lang.Cannot_evaluate_missing_fields);
return;
}
}
else
{
if (ddCurrentActor.SelectedIndex == -1 || String.IsNullOrEmpty(tbBackground.Text) || String.IsNullOrEmpty(tbIntegralBackground.Text) ||
String.IsNullOrEmpty(tbCountingBackground.Text) || String.IsNullOrEmpty(tbGeometryFactor.Text) || String.IsNullOrEmpty(tbActivity.Text) ||
String.IsNullOrEmpty(tbActivityRef.Text) || String.IsNullOrEmpty(tbAvgIntegralSample.Text) || String.IsNullOrEmpty(tbAvgLivetimeSample.Text))
{
Utils.displayStatus(ref labelStatusReport, Color.Red, Lang.Cannot_evaluate_missing_fields);
return;
}
}
}
try
{
if (ddCurrentActor.SelectedIndex == -1)
{
report.ContactID = Guid.Empty;
}
else
{
report.ContactID = new Guid(ddCurrentActor.SelectedValue);
}
report.MCAType = ddMCAType.SelectedValue;
report.Background = String.IsNullOrEmpty(tbBackground.Text) ? float.MinValue : Convert.ToSingle(tbBackground.Text);
report.IntegralBackground = String.IsNullOrEmpty(tbIntegralBackground.Text) ? int.MinValue : Convert.ToInt32(tbIntegralBackground.Text);
report.CountingBackground = String.IsNullOrEmpty(tbCountingBackground.Text) ? int.MinValue : Convert.ToInt32(tbCountingBackground.Text);
report.GeometryFactor = String.IsNullOrEmpty(tbGeometryFactor.Text) ? float.MinValue : Convert.ToSingle(tbGeometryFactor.Text);
report.Activity = String.IsNullOrEmpty(tbActivity.Text) ? float.MinValue : Convert.ToSingle(tbActivity.Text);
report.ActivityRef = String.IsNullOrEmpty(tbActivityRef.Text) ? float.MinValue : Convert.ToSingle(tbActivityRef.Text);
report.Uncertainty = String.IsNullOrEmpty(tbUncertainty.Text) ? float.MinValue : Convert.ToSingle(tbUncertainty.Text);
report.AvgIntegralSample = String.IsNullOrEmpty(tbAvgIntegralSample.Text) ? float.MinValue : Convert.ToSingle(tbAvgIntegralSample.Text);
report.AvgLivetimeSample = String.IsNullOrEmpty(tbAvgLivetimeSample.Text) ? float.MinValue : Convert.ToSingle(tbAvgLivetimeSample.Text);
report.RefDate = refDate;
calRefDate.SelectedDate = report.RefDate;
report.MeasureDate = measureDate;
calMeasureDate.SelectedDate = report.MeasureDate;
report.WantEvaluation = cbWantEvaluation.Checked;
report.AnswerByEmail = cbAnswerByEmail.Checked;
}
catch (Exception except2)
{
Utils.displayStatus(ref labelStatusReport, Color.Red, Lang.Invalid_fields);
return;
}
if (!report.update_all_by_ID())
{
Utils.reportStatus(ref labelStatusReport, Color.Red, "Ringtest.buttonRingtestReportUpdate_OnClick: Update report failed");
return;
}
Utils.displayStatus(ref labelStatusReport, Color.SeaGreen, Lang.Report_updated);
}
catch (Exception ex)
{
Utils.displayStatus(ref labelStatusReport, Color.Red, ex.Message);
}
finally
{
Database.Interface.close();
}
//ddDetector_OnSelectedIndexChanged(sender, e);
}
protected void buttonDetectorContinue_OnClick(object sender, EventArgs e)
{
if (ddDetector.SelectedValue == Guid.Empty.ToString())
{
Utils.displayStatus(ref labelStatusSelectDetector, Color.Red, Lang.NoDetectorSelected);
return;
}
try
{
Database.Ringtest ringtest = new Database.Ringtest();
Database.RingtestReport report = new Database.RingtestReport();
Database.RingtestBox box = new Database.RingtestBox();
Database.Interface.open();
if (!ringtest.select_all_where_year(DateTime.Now.Year))
{
Utils.reportStatus(ref labelStatusSelectDetector, Color.Red, "Ringtest.buttonDetectorContinue_OnClick: No ringtest found for year " + DateTime.Now.Year.ToString());
return;
}
if (!report.select_all_where_accountID_detectorID_ringtestID(
new Guid(hiddenAccountID.Value),
new Guid(ddDetector.SelectedValue),
ringtest.ID))
{
report.AccountID = new Guid(hiddenAccountID.Value);
report.DetectorID = new Guid(ddDetector.SelectedValue);
report.RingtestID = ringtest.ID;
report.RingtestBoxID = new Guid(hiddenRingtestBoxID.Value);
report.AnswerByEmail = false;
report.MeasureDate = SqlDateTime.MinValue.Value;
report.RefDate = SqlDateTime.MinValue.Value;
if (!report.insert_with_ID(Guid.NewGuid()))
{
Utils.reportStatus(ref labelStatusSelectDetector, Color.Red, "Ringtest.buttonDetectorContinue_OnClick: Insert new report failed");
return;
}
}
if (!box.select_all_where_ID(report.RingtestBoxID))
{
Utils.reportStatus(ref labelStatusSelectDetector, Color.Red, "Ringtest.buttonDetectorContinue_OnClick: Ringtestbox not found");
return;
}
hiddenRingtestReportID.Value = report.ID.ToString();
multiViewRingtest.SetActiveView(viewRingtestReport);
Database.Device detector = new Database.Device();
if (!detector.select_all_where_ID(report.DetectorID))
{
Utils.reportStatus(ref labelStatusReport, Color.Red, "Ringtest.buttonDetectorContinue_OnClick: Detector not found");
return;
}
labelReportDetector.Text = detector.SerialNumber;
if (report.ContactID == Guid.Empty)
{
ddCurrentActor.SelectedIndex = -1;
}
else
{
ddCurrentActor.SelectedValue = report.ContactID.ToString();
}
ddMCAType.SelectedValue = report.MCAType;
labelBoxWeight.Text = Utils.roundOff(box.Weight, 1) + "g (" + box.KNumber + ")";
//calMeasureDate.SelectedDate = report.MeasureDate;
tbBackground.Text = Utils.roundOff(report.Background, 2);
tbIntegralBackground.Text = Utils.intToString(report.IntegralBackground);
tbCountingBackground.Text = Utils.intToString(report.CountingBackground);
tbGeometryFactor.Text = Utils.roundOff(report.GeometryFactor, 2);
tbActivity.Text = Utils.roundOff(report.Activity, 1);
tbActivityRef.Text = Utils.roundOff(report.ActivityRef, 1);
tbUncertainty.Text = Utils.roundOff(report.Uncertainty, 1);
tbAvgIntegralSample.Text = Utils.roundOff(report.AvgIntegralSample, 1);
tbAvgLivetimeSample.Text = Utils.roundOff(report.AvgLivetimeSample, 1);
//calRefDate.SelectedDate = report.RefDate;
cbWantEvaluation.Checked = report.WantEvaluation;
cbAnswerByEmail.Checked = report.AnswerByEmail;
cbEvaluated.Checked = report.Evaluated;
cbApproved.Checked = report.Approved;
gridComments.DataSource = Database.RingtestReport.get_comments(report.ID);
gridComments.DataBind();
if (report.MeasureDate != SqlDateTime.MinValue.Value)
{
calMeasureDate.SelectedDate = report.MeasureDate;
}
if (report.RefDate != SqlDateTime.MinValue.Value)
{
calRefDate.SelectedDate = report.RefDate;
}
if (report.Approved)
{
ddCurrentActor.Enabled = false;
ddMCAType.Enabled = false;
tbMeasureDate.Enabled = false;
tbBackground.ReadOnly = true;
tbIntegralBackground.ReadOnly = true;
tbCountingBackground.ReadOnly = true;
tbGeometryFactor.ReadOnly = true;
tbActivity.ReadOnly = true;
tbActivityRef.ReadOnly = true;
tbUncertainty.ReadOnly = true;
tbAvgIntegralSample.ReadOnly = true;
tbAvgLivetimeSample.ReadOnly = true;
tbRefDate.Enabled = false;
cbWantEvaluation.Enabled = false;
cbAnswerByEmail.Enabled = false;
buttonRingtestReportUpdate.Enabled = false;
}
else
{
ddCurrentActor.Enabled = true;
ddMCAType.Enabled = true;
tbMeasureDate.Enabled = true;
tbBackground.ReadOnly = false;
tbIntegralBackground.ReadOnly = false;
tbCountingBackground.ReadOnly = false;
tbGeometryFactor.ReadOnly = false;
tbActivity.ReadOnly = false;
tbActivityRef.ReadOnly = false;
tbUncertainty.ReadOnly = false;
tbAvgIntegralSample.ReadOnly = false;
tbAvgLivetimeSample.ReadOnly = false;
tbRefDate.Enabled = true;
cbWantEvaluation.Enabled = true;
cbAnswerByEmail.Enabled = true;
buttonRingtestReportUpdate.Enabled = true;
}
if (ddMCAType.SelectedValue == "Inspector1000")
{
tbIntegralBackground.Visible = false;
labelIntegralBackground.Visible = false;
tbCountingBackground.Visible = false;
labelCountingBackground.Visible = false;
tbBackground.Visible = false;
labelBackground.Visible = false;
tbAvgIntegralSample.Visible = false;
labelAvgIntegralSample.Visible = false;
tbActivity.Visible = false;
labelActivity.Visible = false;
labelGeometryFactor.Text = Lang.Efficiency;
labelUncertainty.Text = Lang.Uncertainty_insp1000;
}
else
{
tbIntegralBackground.Visible = true;
labelIntegralBackground.Visible = true;
tbCountingBackground.Visible = true;
labelCountingBackground.Visible = true;
tbBackground.Visible = true;
labelBackground.Visible = true;
tbAvgIntegralSample.Visible = true;
labelAvgIntegralSample.Visible = true;
tbActivity.Visible = true;
labelActivity.Visible = true;
labelGeometryFactor.Text = Lang.GeometryFactor;
labelUncertainty.Text = Lang.Uncertainty_serie10;
}
}
catch (Exception ex)
{
Utils.displayStatus(ref labelStatusSelectDetector, Color.Red, "Ringtest.buttonDetectorContinue_OnClick: " + ex.Message);
Utils.displayStatus(ref labelStatusReport, Color.Red, "Ringtest.buttonDetectorContinue_OnClick: " + ex.Message);
}
finally
{
Database.Interface.close();
}
}
