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 ddCourses_OnSelectedIndexChanged(object sender, EventArgs e) { if (ddCourses.SelectedValue == Guid.Empty.ToString()) { textBoxCourseTitleUpd.Text = ""; textBoxCourseDescriptionUpd.Text = ""; textBoxCourseCommentUpd.Text = ""; checkBoxCourseCompleteUpd.Checked = false; lbMembers.Items.Clear(); return; } try { Database.Interface.open(); Database.Course course = new Database.Course(); if (!course.select_all_where_ID(new Guid(ddCourses.SelectedValue))) { Utils.displayStatus(ref labelStatusCreate, Color.Red, "Kurs '" + ddCourses.SelectedItem.Text + "' ikke funnet"); return; } textBoxCourseTitleUpd.Text = course.Title; textBoxCourseDescriptionUpd.Text = course.Description; textBoxCourseCommentUpd.Text = course.Comment; checkBoxCourseCompleteUpd.Checked = course.Completed; Database.Contact contact = new Database.Contact(); Database.Account account = new Database.Account(); string accountName = ""; List <Guid> idList = new List <Guid>(); Database.Contact.select_ID_from_courseID(new Guid(ddCourses.SelectedValue), ref idList); lbMembers.Items.Clear(); foreach (Guid id in idList) { contact.select_all_by_ID(id); account.select_String_where_ID(contact.AccountID, "vchName", ref accountName); lbMembers.Items.Add(new ListItem(contact.Name + " fra " + accountName + " [" + (contact.Status == "Active" ? "Aktiv" : "Inaktiv") + "]")); } } catch (Exception ex) { Utils.displayStatus(ref labelStatusEdit, Color.Red, ex.Message); } finally { Database.Interface.close(); } }
protected void cbCourseActorBit_OnCheckChanged(object sender, EventArgs e) { if (gridCourse.SelectedDataKey == null) { Utils.displayStatus(ref labelStatus, Color.Red, Lang.No_courses_selected); clearAllActorBits(); return; } Guid courseID = (Guid)gridCourse.SelectedDataKey.Value; try { Database.Interface.open(); for (int i = 0; i < gridCourseActors.Rows.Count; i++) { Database.Contact contact = new Database.Contact(); contact.select_all_by_ID((Guid)gridCourseActors.DataKeys[i][0]); CheckBox cb = (CheckBox)gridCourseActors.Rows[i].FindControl("cbCourseActorBit"); if (cb.Checked) { contact.link_with_courseID(courseID); } else { contact.unlink_with_courseID(courseID); } Utils.displayStatus(ref labelStatus, Color.SeaGreen, Resources.Localization.StatusCourseUpdated); } } catch (Exception ex) { Utils.reportStatus(ref labelStatus, Color.Red, "Course.cbCourseActorBit_OnCheckChanged: " + ex.Message); } finally { Database.Interface.close(); } }
protected void ddActors_OnSelectedIndexChanged(object sender, EventArgs e) { if (ddActors.SelectedValue == Guid.Empty.ToString()) { textBoxNameUpd.Text = ""; textBoxEmailUpd.Text = ""; textBoxPhoneUpd.Text = ""; textBoxMobileUpd.Text = ""; ddStatus.SelectedIndex = -1; return; } try { Database.Interface.open(); Database.Contact contact = new Database.Contact(); if (!contact.select_all_by_ID(new Guid(ddActors.SelectedValue))) { Utils.reportStatus(ref labelStatusActors, Color.Red, "Actors.ddActors_OnSelectedIndexChanged: Contact not found"); return; } textBoxNameUpd.Text = contact.Name; textBoxEmailUpd.Text = contact.Email; textBoxPhoneUpd.Text = contact.Phone; textBoxMobileUpd.Text = contact.Mobile; ddStatus.SelectedValue = contact.Status; } catch (Exception ex) { Utils.reportStatus(ref labelStatusActors, Color.Red, "Actors.ddActors_OnSelectedIndexChanged: " + ex.Message); } finally { Database.Interface.close(); } }
protected void buttonUpdateActor_OnClick(object sender, EventArgs e) { if (ddActors.SelectedValue == Guid.Empty.ToString()) { return; } if (String.IsNullOrEmpty(textBoxNameUpd.Text) || String.IsNullOrEmpty(textBoxEmailUpd.Text)) { Utils.displayStatus(ref labelStatusActors, Color.Red, Resources.Localization.MissingInformation); return; } if (!Utils.isValidEmail(textBoxEmailUpd.Text)) { Utils.displayStatus(ref labelStatusActors, Color.Red, Lang.Email_invalid_address); return; } try { Database.Interface.open(); Database.Contact contact = new Database.Contact(); if (!contact.select_all_by_ID(new Guid(ddActors.SelectedValue))) { Utils.reportStatus(ref labelStatusActors, Color.Red, "Actors.buttonUpdateActor_OnClick: Contact not found"); return; } if (ddStatus.SelectedValue != "Active") { Database.Interface.open(); Database.Interface.command.Parameters.Clear(); Database.Interface.command.CommandText = @" SELECT COUNT(Contact.ID) FROM Contact, Course, Contact_Course WHERE Course.bitCompleted = 0 AND Contact.ID = Contact_Course.ContactID AND Course.ID = Contact_Course.CourseID AND Contact.ID = @contactID"; Database.Interface.command.CommandType = CommandType.Text; Database.Interface.command.Parameters.AddWithValue("@contactID", contact.ID); int count = (int)Database.Interface.command.ExecuteScalar(); if (count > 0) { Utils.displayStatus(ref labelStatusActors, Color.Red, "Kan ikke deaktivere. Den interne brukeren er oppmeldt til en eller flere kurs"); return; } Database.Interface.command.Parameters.Clear(); Database.Interface.command.CommandText = @" SELECT COUNT(RingtestReport.ID) FROM RingtestReport WHERE RingtestReport.bitApproved = 0 AND RingtestReport.ContactID = @contactID"; Database.Interface.command.CommandType = CommandType.Text; Database.Interface.command.Parameters.AddWithValue("@contactID", contact.ID); count = (int)Database.Interface.command.ExecuteScalar(); if (count > 0) { Utils.displayStatus(ref labelStatusActors, Color.Red, "Kan ikke deaktivere. Den interne brukeren har en eller flere ringtest rapporter"); return; } Database.Interface.command.Parameters.Clear(); } contact.Name = textBoxNameUpd.Text; contact.Email = textBoxEmailUpd.Text; contact.Phone = String.IsNullOrEmpty(textBoxPhoneUpd.Text) ? "" : textBoxPhoneUpd.Text; contact.Mobile = String.IsNullOrEmpty(textBoxMobileUpd.Text) ? "" : textBoxMobileUpd.Text; contact.Status = ddStatus.SelectedValue; if (!contact.update_all_by_ID()) { Utils.reportStatus(ref labelStatusActors, Color.Red, "Actors.buttonUpdateActor_OnClick: Update contact failed"); return; } Utils.displayStatus(ref labelStatusActors, Color.SeaGreen, Lang.Contact + " '" + textBoxNameUpd.Text + "' " + Lang.updated); textBoxNameUpd.Text = ""; textBoxEmailUpd.Text = ""; textBoxPhoneUpd.Text = ""; textBoxMobileUpd.Text = ""; ddStatus.SelectedIndex = -1; ddActors.DataBind(); } catch (Exception ex) { Utils.displayStatus(ref labelStatusActors, Color.Red, "Actors.buttonUpdateActor_OnClick: " + ex.Message); } finally { Database.Interface.close(); } }