/// <summary> /// Get Unit's Details /// </summary> private void GetDetails() { BusinessServices.Unit objUnit; DataTable dtbUnit; int intOrganisationID; //1. Get Unit details objUnit = new BusinessServices.Unit(); dtbUnit = objUnit.GetUnit(this.m_intUnitID); this.txtName.Text = dtbUnit.Rows[0]["Name"].ToString(); this.txtUnitID.Text = this.m_intUnitID.ToString(); if (dtbUnit.Rows[0]["Active"].ToString() == "True") { this.cboStatus.SelectedIndex = 0; } else { this.cboStatus.SelectedIndex = 1; } this.lblPathway.Text = dtbUnit.Rows[0]["Organisation"].ToString() + " > " + dtbUnit.Rows[0]["Pathway"].ToString(); DateTime dteOriginalDateUpdated = (DateTime)dtbUnit.Rows[0]["DateUpdated"]; this.OriginalDateUpdated = DatabaseTool.ToLongDateTimeString(dteOriginalDateUpdated); intOrganisationID = (int)dtbUnit.Rows[0]["OrganisationID"]; //2. Get Sub-Units tree DataSet dstUnits = objUnit.GetUnitsByOrganisation(intOrganisationID, "", "", "", this.m_intUnitID); string strUnits = UnitTreeConvert.ConvertXml(dstUnits); if (strUnits == "") { this.trvSubUnits.Visible = false; this.lblNoSubUnits.Visible = true; } else { this.trvSubUnits.Visible = true; this.lblNoSubUnits.Visible = false; this.trvSubUnits.LoadXml(strUnits); } }
} // grdPagination_UpdateCommand /// <summary> /// Even Handler for when the data is bound to the DataGrid. /// This adds the DateUpdated for every record to the commandargument parameter attribute. /// </summary> /// <param name="source"> The source of the event.</param> /// <param name="e"> Any arguments that the event fires.</param> /// <remarks> /// This event is fired for every record that is bound to the grid. /// It ignores the header row. /// </remarks> private void grdPagination_ItemDataBound(object source, System.Web.UI.WebControls.DataGridItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.SelectedItem || e.Item.ItemType == ListItemType.EditItem) { DataRowView drvAdminDetails = (DataRowView)e.Item.DataItem; string FirstName = (string)drvAdminDetails["FirstName"]; string LastName = (string)drvAdminDetails["LastName"]; DateTime dtOriginalUpdatedDate = (DateTime)drvAdminDetails["DateUpdated"]; //1. Make a reference to the add button. LinkButton lnkAddButton; lnkAddButton = (LinkButton)e.Item.Cells[3].Controls[0]; //2. The original date updated from the database to the command argument for each record in the grid.. if (lnkAddButton != null) { lnkAddButton.CommandArgument = DatabaseTool.ToLongDateTimeString(dtOriginalUpdatedDate); lnkAddButton.Text = ResourceManager.GetString("grid_AddButton"); } } } // grdPagination_ItemDataBound
} // SetPageState /// <summary> /// Loads the Data from the database for the speciied Organisation. /// </summary> private void LoadData() { DataTable dtLoadOrg; string strLangCode = Request.Cookies["currentCulture"].Value; Bdw.Application.Salt.BusinessServices.Organisation objOrganisation = new Bdw.Application.Salt.BusinessServices.Organisation(); dtLoadOrg = objOrganisation.GetOrganisation(strLangCode, UserContext.UserData.OrgID); // If an organisation Exists if (dtLoadOrg.Rows.Count > 0) { if (dtLoadOrg.Rows[0]["AllocatedDiskSpace"].ToString().Trim() != "") { long lngDiskSpace = (long)dtLoadOrg.Rows[0]["AllocatedDiskSpace"]; lngDiskSpace = lngDiskSpace / (1024 * 1024); //Convert from bytes to MegaBytes if (UserContext.UserData.UserType == UserType.SaltAdmin) { this.lblDiskSpaceDisplay.Visible = false; this.txtDiskSpace.Visible = true; this.txtDiskSpace.Text = lngDiskSpace.ToString(); this.lblDiskSpaceDisplay.Text = lngDiskSpace.ToString(); } else { this.txtDiskSpace.Visible = false; this.lblDiskSpaceDisplay.Visible = true; this.lblDiskSpaceDisplay.Text = lngDiskSpace.ToString(); this.txtDiskSpace.Text = lngDiskSpace.ToString(); } } this.chkBxShowLastPassDate.Checked = Boolean.Parse(dtLoadOrg.Rows[0]["ShowLastPassed"].ToString()); this.chkDisablePasswordField.Checked = Boolean.Parse(dtLoadOrg.Rows[0]["DisablePasswordField"].ToString()); if (chkDisablePasswordField.Checked) { chkurlrequest.Enabled = false; chkurlrequest.Checked = false; } else { chkurlrequest.Checked = Boolean.Parse(dtLoadOrg.Rows[0]["EnableUniqueURL"].ToString()); chkurlrequest.Enabled = true; } int OrganisationID = UserContext.UserData.OrgID; if (objOrganisation.GetOrganisationCPDEventAccess(UserContext.UserData.OrgID)) { truserevent.Visible = true; } else { truserevent.Visible = false; } this.chkuserCPDEvent.Checked = Boolean.Parse(dtLoadOrg.Rows[0]["EnableUserCPDEvent"].ToString()); this.txtOrganisationName.Text = dtLoadOrg.Rows[0]["OrganisationName"].ToString(); this.txtOrganisationNotes.Text = Server.HtmlDecode(dtLoadOrg.Rows[0]["Notes"].ToString()); this.lblLogo.Text = dtLoadOrg.Rows[0]["Logo"].ToString() + " "; this.cboDefaultLessonFrequency.SelectedValue = dtLoadOrg.Rows[0]["DefaultLessonFrequency"].ToString(); this.cboDefaultQuizFrequency.SelectedValue = dtLoadOrg.Rows[0]["DefaultQuizFrequency"].ToString(); this.txtDefaultQuizPassMark.Text = dtLoadOrg.Rows[0]["DefaultQuizPassMark"].ToString(); this.chkEbookNotification.Checked = Boolean.Parse(dtLoadOrg.Rows[0]["DefaultEbookEmailNotification"].ToString()); if (dtLoadOrg.Rows[0]["CPDReportName"].ToString().Equals(String.Empty)) { this.txtCPDReportName.Text = "Continuing Professional Development"; } else { this.txtCPDReportName.Text = dtLoadOrg.Rows[0]["CPDReportName"].ToString(); } this.ckbIncludeLogo.Checked = dtLoadOrg.Rows[0]["IncludeCertificateLogo"].ToString().Trim() == ""?false:Boolean.Parse(dtLoadOrg.Rows[0]["IncludeCertificateLogo"].ToString()); this.chkActivatePassword.Checked = Boolean.Parse(dtLoadOrg.Rows[0]["PasswordLockout"].ToString()); // Setup date dropdowns with value if (dtLoadOrg.Rows[0]["DefaultLessonCompletionDate"] != System.DBNull.Value) { DateTime defaultLessonCompletionDate = (DateTime)dtLoadOrg.Rows[0]["DefaultLessonCompletionDate"]; cboLCompletionDay.SelectedValue = defaultLessonCompletionDate.Day.ToString(); cboLCompletionMonth.SelectedValue = defaultLessonCompletionDate.Month.ToString(); cboLCompletionYear.SelectedValue = defaultLessonCompletionDate.Year.ToString(); } if (dtLoadOrg.Rows[0]["DefaultQuizCompletionDate"] != System.DBNull.Value) { DateTime defaultQuizCompletionDate = (DateTime)dtLoadOrg.Rows[0]["DefaultQuizCompletionDate"]; cboQCompletionDay.SelectedValue = defaultQuizCompletionDate.Day.ToString(); cboQCompletionMonth.SelectedValue = defaultQuizCompletionDate.Month.ToString(); cboQCompletionYear.SelectedValue = defaultQuizCompletionDate.Year.ToString(); } if (UserContext.UserData.UserType == UserType.SaltAdmin) { this.chkAdvancedReporting.Checked = (bool)dtLoadOrg.Rows[0]["AdvancedReporting"]; } else { this.lblAdvancedReporting.Text = (bool)dtLoadOrg.Rows[0]["AdvancedReporting"]?ResourceManager.GetString("Yes"):ResourceManager.GetString("No"); } DateTime dtOriginalDateUpdated = (DateTime)dtLoadOrg.Rows[0]["DateUpdated"]; this.OriginalDateUpdated = DatabaseTool.ToLongDateTimeString(dtOriginalDateUpdated); Classification objClassification = new Classification(); DataTable dtbClassificationType = objClassification.GetClassificationType(UserContext.UserData.OrgID); if (dtbClassificationType.Rows.Count > 0) { this.ClassificationTypeID = Int32.Parse(dtbClassificationType.Rows[0]["ClassificationTypeID"].ToString()); //this.lblCustomClasification.Text = dtbClassificationType.Rows[0]["Name"].ToString(); this.txtClassificationName.Text = dtbClassificationType.Rows[0]["Name"].ToString(); } } else { this.lblMessage.Text = ResourceManager.GetString("lblMessage.NoOrg");//"No Organisations Exist."; this.lblMessage.CssClass = "FeedbackMessage"; this.plhOrganisationDetails.Visible = false; } // hide the ebook checkbox if the organisation does not have ebook feature bool hasEbookAccess = objOrganisation.GetOrganisationEbookAccess(UserContext.UserData.OrgID); if (!hasEbookAccess) { this.plhEbookNotification.Visible = false; } else { this.plhEbookNotification.Visible = true; } if (!IsPostBack) { LoadTimeZone(); int OrgTZId = 0; Int32.TryParse(dtLoadOrg.Rows[0]["TimeZoneID"].ToString(), out OrgTZId); string orgFLBName = null; using (StoredProcedure sp = new StoredProcedure("prcTimeZone_GetFLBNamefromTZID", StoredProcedure.CreateInputParam("@TimezoneID", SqlDbType.Int, OrgTZId)) ) { orgFLBName = sp.ExecuteScalar().ToString(); } listTimeZone.SelectedValue = listTimeZone.Items.FindByText(orgFLBName).Value; } } // LoadData