/// <summary> /// Page Load Event Handler /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { // uiLnkDistanceLearning.HRef = GetPDFURL(LACESUtilities.GetApplicationConstants("DistanceEducationPDF")); // uiLnkCalculatingPDH.HRef = GetPDFURL(LACESUtilities.GetApplicationConstants("CalculatingPDF")); // uiLnkModelCertificateForm.HRef = GetPDFURL(LACESUtilities.GetApplicationConstants("ModelCertificateForm")); // uiLnkModelEvaluationForm.HRef = GetPDFURL(LACESUtilities.GetApplicationConstants("ModelEvaluationForm")); // uiLnkHSWClassification.HRef = GetPDFURL(LACESUtilities.GetApplicationConstants("HSWClassificationPDF")); if (!Page.IsPostBack) { //get id from query string if (Request.QueryString[LACESConstant.QueryString.PROVIDER_ID] != null) { int providerID = 0; int.TryParse(Request.QueryString[LACESConstant.QueryString.PROVIDER_ID].ToString(), out providerID); if (providerID > 0) { ApprovedProviderDataAccess providerDA = new ApprovedProviderDataAccess(); ApprovedProvider currentProvider = providerDA.GetApprovedProviderByID(providerID); // Get provider by id //if provider exists if (currentProvider != null) { PreparePreviewData(currentProvider); } } } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { //get id from query string if (Request.QueryString[LACESConstant.QueryString.PROVIDER_ID] != null) { int providerID = 0; int.TryParse(Request.QueryString[LACESConstant.QueryString.PROVIDER_ID].ToString(), out providerID); if (providerID > 0) { ApprovedProviderDataAccess providerDA = new ApprovedProviderDataAccess(); currentProvider = providerDA.GetApprovedProviderByID(providerID); // Get provider by id //if provider exists if (currentProvider != null) { PreparePreviewData(currentProvider); } } } } }
protected void Page_Load(object sender, EventArgs e) { ApprovedProvider provider = (ApprovedProvider)Session[LACESConstant.SessionKeys.LOGEDIN_APPROVED_PROVIDER]; if (provider != null) { string stritemsperpage = Request.QueryString["itemsperpage"] != null ? Request.QueryString["itemsperpage"] : "99999"; int itemsPerPage = 99999; if (int.TryParse(stritemsperpage, out itemsPerPage)) { } string strpage = Request.QueryString["page"] != null ? Request.QueryString["page"] : "1"; int page = 1; if (int.TryParse(strpage, out page)) { } string strKeyword = Request.QueryString["keyword"] != null ? Request.QueryString["keyword"] : ""; string strEndDate = Request.QueryString["enddate"] != null ? Request.QueryString["enddate"] : ""; string strStartDate = Request.QueryString["startdate"] != null ? Request.QueryString["startdate"] : ""; string strState = Request.QueryString["state"] != null ? Request.QueryString["state"] : ""; string strStatus = Request.QueryString["status"] != null ? Request.QueryString["status"] : ""; string strSubject = Request.QueryString["subject"] != null ? Request.QueryString["subject"] : ""; int totalCount = 0; CourseDataAccess objCourseDAL = new CourseDataAccess(); IList <Course> courseResult = new List <Course>(); courseResult = objCourseDAL.GetPagedCourseBySearchByProvider(strStartDate, strEndDate, strKeyword, 1, 99999, strStatus, provider.ID, strSubject, strState, ref totalCount); Response.Write(courseResult.Count.ToString()); } }
protected void FilterCoursesBind(string strStartDate, string strEndDate, string strKeyword, string strState, string strSubject, string strStatus, string strProviderList, string courseType) { try { int totalCount = 0; ApprovedProvider provider = (ApprovedProvider)Session[LACESConstant.SessionKeys.LOGEDIN_APPROVED_PROVIDER]; CourseDataAccess objCourseDAL = new CourseDataAccess(); IList <Course> courseResult = new List <Course>(); courseResult = objCourseDAL.GetPagedCourseBySearchAdmin(strStartDate, strEndDate, strKeyword, 0, 10000, strStatus, strProviderList, strSubject, strState, courseType, ref totalCount); if (courseResult.Count < 1) { dlCourseList.Visible = false; NoResult.Visible = true; } else { dlCourseList.DataSource = courseResult; dlCourseList.DataBind(); dlCourseList.Visible = true; NoResult.Visible = false; } } catch (Exception ex) { } }
/// <summary> /// Used to populate course information into UI. It get a course id from query string /// which detail information needed. Return none. /// </summary> private void populateCourseInfo() { long courseID = 0; if (Request.QueryString[LACESConstant.QueryString.COURSE_ID] != null) { try { //get the course id from query string courseID = Convert.ToInt64(Request.QueryString[LACESConstant.QueryString.COURSE_ID]); //get course detail by courseid and providerid ApprovedProvider provider = (ApprovedProvider)Session[LACESConstant.SessionKeys.LOGEDIN_APPROVED_PROVIDER]; // Get provider information from Session CourseDataAccess courseDAL = new CourseDataAccess(); Course course = courseDAL.GetCoursesDetailsByIDandProviderID(courseID, provider.ID); // Get Courses Details from Course ID and Provider ID if (course == null || course.ID < 1) { //btnSaveAddMore.Enabled = false; //btnSaveFinish.Enabled = false; lblMsg.Text = LACESConstant.Messages.COURSE_NOT_FOUND_IN_PROVIDER; // dvParticipantList.Visible = false; return; } Label lblMasterCourseName = (Label)Master.FindControl("lblCourseName"); lblMasterCourseName.Text = "Selected Course: <a href='CourseDetails.aspx?" + LACESConstant.QueryString.COURSE_ID + "=" + Server.HtmlEncode(course.ID.ToString()) + "'>" + Server.HtmlEncode(course.Title) + "</a>"; lblMasterCourseName.Attributes.Add("onclick", "javascript:return CheckChange(2,-1)"); } catch (Exception ex) { } } }
/// <summary> /// Page Load Event /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { if (Page.TemplateControl.AppRelativeVirtualPath.ToLower().IndexOf("addattendee.aspx") < 1) { if (Session[LACESConstant.SessionKeys.LOGEDIN_ADMIN] == null || Session[LACESConstant.SessionKeys.LOGEDIN_ADMIN].ToString() != "Yes") { if (Session[LACESConstant.SessionKeys.LOGEDIN_APPROVED_PROVIDER] == null && Session[LACESConstant.SessionKeys.LOGEDIN_INACTIVE_PROVIDER] == null) { ASP.usercontrols_visitormenu_ascx visitorMenu = (ASP.usercontrols_visitormenu_ascx)Page.LoadControl("~/usercontrols/VisitorMenu.ascx"); uiPhMenu.Controls.Add(visitorMenu); } else { string sessionKeyForProvider = LACESConstant.SessionKeys.LOGEDIN_APPROVED_PROVIDER; ApprovedProvider sessionProvider = (ApprovedProvider)Session[sessionKeyForProvider]; // Get provider information from Session if (sessionProvider.Status == LACESConstant.ProviderStatus.ACTIVE) { uiPhMenu.Controls.Add(LoadControl("~/usercontrols/ProviderMenu.ascx")); } //if provider is inactive, inactive provider menu will be shown else if (sessionProvider.Status == LACESConstant.ProviderStatus.INACTIVE) { uiPhMenu.Controls.Add(LoadControl("~/usercontrols/InactiveProviderMenu.ascx")); } } } } //for aboutus and ApprovedProviderGuidelines page do not include javascript files //otherwise it will produce error if (Request.CurrentExecutionFilePath.ToUpper().Contains("/LACES/ABOUTUS.ASPX") || Request.CurrentExecutionFilePath.ToUpper().Contains("/LACES/APPROVEDPROVIDERGUIDELINES.ASPX")) { LoadJavascript = false; } }
protected void Page_Load(object sender, EventArgs e) { ApprovedProvider provider = (ApprovedProvider)Session[LACESConstant.SessionKeys.LOGEDIN_APPROVED_PROVIDER]; if (provider != null) { string courseTitle = Request.QueryString["title"] != null ? Request.QueryString["title"] : ""; string StartDate = Request.QueryString["startdate"] != null ? Request.QueryString["startdate"] : ""; string EndDate = Request.QueryString["enddate"] != null ? Request.QueryString["enddate"] : ""; string Location = Request.QueryString["location"] != null ? Request.QueryString["location"] : ""; string FirstName = Request.QueryString["first"] != null ? Request.QueryString["first"] : ""; string LastName = Request.QueryString["last"] != null ? Request.QueryString["last"] : ""; string Email = Request.QueryString["email"] != null ? Request.QueryString["email"] : ""; string strOrderBy; if (Request.QueryString["Sort"] != null && Request.QueryString["Sort"].Length > 0) { strOrderBy = Request.QueryString["Sort"].ToString(); } else { strOrderBy = "S"; } //create the coures data access CourseDataAccess objCourseDAL = new CourseDataAccess(); //get the current provider IList <Course> courses; if (FirstName.Length == 0 && LastName.Length == 0 && Email.Length == 0) { courses = objCourseDAL.GetCoursesByProviderId(provider.ID, strOrderBy); } else { courses = objCourseDAL.GetCoursesByProviderIdAndAttendee(provider.ID, strOrderBy, FirstName, LastName, Email); } if (courseTitle.Length > 0) { courses = courses.Where(x => x.Title.ToLower().Contains(courseTitle.ToLower())).ToList(); } if (StartDate.Length > 0) { DateTime dtStartDate = new DateTime(); if (DateTime.TryParse(StartDate, out dtStartDate)) { courses = courses.Where(x => x.StartDate >= dtStartDate && x.EndDate >= dtStartDate).ToList(); } } if (EndDate.Length > 0) { DateTime dtEndDate = new DateTime(); if (DateTime.TryParse(EndDate, out dtEndDate)) { courses = courses.Where(x => x.EndDate < dtEndDate).ToList(); } } Response.Write(courses.Count.ToString()); } }
protected void Page_Load(object sender, EventArgs e) { ApprovedProvider provider = (ApprovedProvider)Session[LACESConstant.SessionKeys.LOGEDIN_APPROVED_PROVIDER]; if (provider != null) { string stritemsperpage = Request.QueryString["itemsperpage"] != null ? Request.QueryString["itemsperpage"] : "99999"; int itemsPerPage = 99999; if (int.TryParse(stritemsperpage, out itemsPerPage)) { } string strpage = Request.QueryString["page"] != null ? Request.QueryString["page"] : "1"; int page = 1; if (int.TryParse(strpage, out page)) { } string strKeyword = Request.QueryString["keyword"] != null ? Request.QueryString["keyword"] : ""; string strEndDate = Request.QueryString["enddate"] != null ? Request.QueryString["enddate"] : ""; string strStartDate = Request.QueryString["startdate"] != null ? Request.QueryString["startdate"] : ""; string strState = Request.QueryString["state"] != null ? Request.QueryString["state"] : ""; string strStatus = Request.QueryString["status"] != null ? Request.QueryString["status"] : ""; string strSubject = Request.QueryString["subject"] != null ? Request.QueryString["subject"] : ""; int totalCount = 0; CourseDataAccess objCourseDAL = new CourseDataAccess(); IList <Course> courseResult = new List <Course>(); courseResult = objCourseDAL.GetPagedCourseBySearchByProvider(strStartDate, strEndDate, strKeyword, 1, 99999, strStatus, provider.ID, strSubject, strState, ref totalCount); uiHdnResultCount.Value = courseResult.Count.ToString(); if (courseResult.Count < 1) { dlCourseList.Visible = false; NoResult.Visible = true; } else { int pageBegin = 0; if (page > 1) { pageBegin = (itemsPerPage * page) - itemsPerPage; } dlCourseList.Visible = true; NoResult.Visible = false; if (itemsPerPage < 999) { dlCourseList.DataSource = courseResult.Skip(pageBegin).Take(itemsPerPage); } else { dlCourseList.DataSource = courseResult; } dlCourseList.DataBind(); } } }
/// <summary> /// Checking Provider email address exist in the database and send forgot password email to provider email address. /// </summary> private void CheckAuthentication() { try { string DecryptedPassword = String.Empty; ApprovedProviderDataAccess providerDAL = new ApprovedProviderDataAccess(); ApprovedProvider provider = providerDAL.GetApprovedProviderByEmail(txtEmail.Text); if (provider != null && provider.ID > 0) { ///Decrypt provider password. DecryptedPassword = LACESUtilities.Decrypt(provider.Password); Response.Write(DecryptedPassword); Response.End(); SmtpClient smtpClient = new SmtpClient(); //Get the SMTP server Address from SMTP Web.conf smtpClient.Host = LACESUtilities.GetApplicationConstants(LACESConstant.SMTPSERVER); //Get the SMTP post 25; smtpClient.Port = Convert.ToInt32(LACESUtilities.GetApplicationConstants(LACESConstant.SMTPPORT)); //send email bool IsSent = SendEmail(smtpClient, DecryptedPassword); //Checking the email has sent if (IsSent == true) { lblErrorSummary.Visible = false; lblPostBackMessage.Text = LACESConstant.Messages.FORGETPASSWORD_POSTBACK_MESSAGE.Replace("{0}", txtEmail.Text.Trim()); tblControls.Visible = false; } } //if the provider does not existing in the database send invalid email address message. else { //if the provider does not existing in the database send invalid email address message. if (IsPostBack == true) { string ContactEmailAddresses = TranformEmailAddresses(); string AdminEmailWithFormat = "<a href=\"mailto:" + ContactEmailAddresses + "\">contact the " + LACESConstant.LACES_TEXT + " Administrators</a> "; lblErrorSummary.Text = LACESConstant.Messages.PORGETPASSEORD_INVALID_MESSAGE.Replace("{0}", AdminEmailWithFormat); lblPostBackMessage.Text = ""; isInvalidEmail = true; } else { lblErrorSummary.Text = ""; lblPostBackMessage.Text = ""; } } } catch (Exception ex) { throw ex; } }
/// <summary> /// Call every time when user click on Save Details button. /// Update provider information in database /// </summary> /// <param name="sender">sender object</param> /// <param name="e">EventArgs</param> protected void btnSaveDetails_Click(object sender, EventArgs e) { if (Password.Text == PasswordConfirm.Text) { HidPass.Value = Password.Text; } //create Provider Data Access object ApprovedProviderDataAccess providerDA = new ApprovedProviderDataAccess(); //Check for existence for Email address ApprovedProvider oProvider = providerDA.GetApprovedProviderByEmail(ApplicantEmail.Text); //provider in session ApprovedProvider sessionProvider = null; //now check weather it is in edit provider mode if (Session[LACESConstant.SessionKeys.LOGEDIN_APPROVED_PROVIDER] != null) { //get the provider from session sessionProvider = (ApprovedProvider)Session[LACESConstant.SessionKeys.LOGEDIN_APPROVED_PROVIDER]; // Get provider information from Session //provider changed email and that is set for other provider if (oProvider != null && oProvider.ID != sessionProvider.ID) { //The email is already used, so not allowed lblMsg.Text = "Email already exists. Please provide another email.<br /><br />"; lblMsg.ForeColor = System.Drawing.Color.Red; } else { sessionProvider = FIllApprovedProviderObjectByFormValues(sessionProvider); //update provider contact info ApprovedProvider currentProvider = providerDA.UpdateApprovedProvider(sessionProvider); if (currentProvider == null) { //exception occured lblMsg.Text = "Contact information information cannot be saved.<br /><br />"; lblMsg.ForeColor = System.Drawing.Color.Red; } else { //update the current provider information in the session Session[LACESConstant.SessionKeys.LOGEDIN_APPROVED_PROVIDER] = currentProvider; //data saved successfully lblMsg.Text = "Contact information updated successfully.<br /><br />"; lblMsg.ForeColor = System.Drawing.Color.Green; } } } }
/// <summary> /// Page Load Event Handler /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { string sessionKeyForProvider = LACESConstant.SessionKeys.LOGEDIN_APPROVED_PROVIDER; //if current user is inactive if (Session[LACESConstant.SessionKeys.LOGEDIN_INACTIVE_PROVIDER] != null) { sessionKeyForProvider = LACESConstant.SessionKeys.LOGEDIN_INACTIVE_PROVIDER; } //if current user is inactive if (Session[sessionKeyForProvider] == null) { Response.Redirect("Login.aspx"); } //show provider spacific menu in edit mode else { //get the provider from session ApprovedProvider sessionProvider = (ApprovedProvider)Session[sessionKeyForProvider]; // Get provider information from Session //Show loggedin provider name Label lblProviderName = (Label)Master.FindControl("lblProviderName"); if (lblProviderName != null) { lblProviderName.Text = "Signed in as: " + Server.HtmlEncode(sessionProvider.OrganizationName); } //load the provider menu bar HtmlTableCell oHtmlTableCell = (HtmlTableCell)Master.FindControl("tdMenu"); oHtmlTableCell.Controls.Clear(); //if provider is active,provider menu will be shown if (sessionProvider.Status == LACESConstant.ProviderStatus.ACTIVE) { oHtmlTableCell.Controls.Add(LoadControl("~/usercontrols/ProviderMenu.ascx")); } //if provider is inactive, inactive provider menu will be shown else if (sessionProvider.Status == LACESConstant.ProviderStatus.INACTIVE) { oHtmlTableCell.Controls.Add(LoadControl("~/usercontrols/InactiveProviderMenu.ascx")); } try { //change the login status ((HtmlTableCell)Master.FindControl("loginTd")).Attributes["class"] = "loggedIn providerloginStatus"; } catch (Exception ex) { } } }
/// <summary> /// Get course details information if any course found otherwise null /// </summary> /// <returns>course object</returns> private Course getCourseInfo() { try { //get course detail by courseid and providerid //Provider provider = (Provider)Session[LACESConstant.SessionKeys.LOGEDIN_PROVIDER]; // Get provider information from Session ApprovedProvider provider = (ApprovedProvider)Session[LACESConstant.SessionKeys.LOGEDIN_APPROVED_PROVIDER]; // get approved provider information from Session CourseDataAccess courseDAL = new CourseDataAccess(); return(courseDAL.GetCoursesDetailsByIDandProviderID(courseID, provider.ID)); // Get Courses Details from Course ID and Provider ID } catch (Exception ex) { throw ex; } }
protected void Page_Load(object sender, EventArgs e) { string uri = LACESUtilities.GetApplicationConstants("logosLACES_ASLA_CMS_Site_URL"); string relativeURL = "\"" + LACESUtilities.GetApplicationConstants("ImagesASLARelative"); string absoluteURL = "\"" + LACESUtilities.GetApplicationConstants("ImagesASLAAbsolute"); logosLACESDiv.InnerHtml = GetExternalWebData(uri).Replace(relativeURL, absoluteURL); if (Session[LACESConstant.SessionKeys.LOGEDIN_INACTIVE_PROVIDER] != null) { sessionKeyForProvider = LACESConstant.SessionKeys.LOGEDIN_INACTIVE_PROVIDER; } if (Session[sessionKeyForProvider] != null) { //get the provider from session ApprovedProvider sessionProvider = (ApprovedProvider)Session[sessionKeyForProvider]; // Get provider information from Session //Show loggedin provider name Label lblProviderName = (Label)Master.FindControl("lblProviderName"); if (lblProviderName != null) { lblProviderName.Text = "Signed in as: " + Server.HtmlEncode(sessionProvider.OrganizationName); } //load the provider menu bar HtmlTableCell oHtmlTableCell = (HtmlTableCell)Master.FindControl("tdMenu"); oHtmlTableCell.Controls.Clear(); //if provider is active,provider menu will be shown if (sessionProvider.Status == LACESConstant.ProviderStatus.ACTIVE) { oHtmlTableCell.Controls.Add(LoadControl("~/usercontrols/ProviderMenu.ascx")); } //if provider is inactive, inactive provider menu will be shown else if (sessionProvider.Status == LACESConstant.ProviderStatus.INACTIVE) { oHtmlTableCell.Controls.Add(LoadControl("~/usercontrols/InactiveProviderMenu.ascx")); } try { //change the login status ((HtmlTableCell)Master.FindControl("loginTd")).Attributes["class"] = "loggedIn providerloginStatus"; } catch (Exception ex) { } } }
/// <summary> /// Page load event handler /// Loads the course name based on course id /// Generates the redirect URL /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { long courseID = 0; string courseName = ""; //If CourseId is defined in URL if (Request.QueryString["CourseID"] != null) { try { courseID = Convert.ToInt64(Request.QueryString["CourseID"]); } catch (Exception ex) { throw ex; } //Get course information by courseId //Provider provider = (Provider)Session[LACESConstant.SessionKeys.LOGEDIN_PROVIDER]; // Get provider information from Session ApprovedProvider provider = (ApprovedProvider)Session[LACESConstant.SessionKeys.LOGEDIN_APPROVED_PROVIDER]; // get approved provider information from Session CourseDataAccess courseDAL = new CourseDataAccess(); Course course = courseDAL.GetCoursesDetailsByIDandProviderID(courseID, provider.ID); // Get Courses Details from Course ID and Provider ID //Generate linked course name to display courseName = "<a href=\"CourseDetails.aspx?CourseID=" + courseID + "\">" + Server.HtmlEncode(course.Title) + "</a>"; } else//If courseId is not defined in URL, display None { courseName = "<i>None</i>"; } //System.Diagnostics.Debugger.Break(); //Set value for the lblCourseName control of master page Label lblCourseName = (Label)Master.FindControl("lblCourseName"); if (lblCourseName != null) { lblCourseName.Text = "Selected Course: " + courseName; } } lblMessage.Text = ""; lblMessage.Visible = false; message = ""; txtCodeType.Focus(); }
protected void Page_Load(object sender, EventArgs e) { //show provider spacific menu in edit mode if (Session[LACESConstant.SessionKeys.LOGEDIN_APPROVED_PROVIDER] != null) { //get the provider from session ApprovedProvider sessionProvider = (ApprovedProvider)Session[LACESConstant.SessionKeys.LOGEDIN_APPROVED_PROVIDER]; // Get provider information from Session //Show loggedin provider name Label lblProviderName = (Label)Master.FindControl("lblProviderName"); if (lblProviderName != null) { lblProviderName.Text = "Signed in as: " + Server.HtmlEncode(sessionProvider.OrganizationName); } //load the provider menu bar HtmlTableCell oHtmlTableCell = (HtmlTableCell)Master.FindControl("tdMenu"); oHtmlTableCell.Controls.Clear(); oHtmlTableCell.Controls.Add(LoadControl("~/usercontrols/ProviderMenu.ascx")); try { //change the login status ((HtmlTableCell)Master.FindControl("loginTd")).Attributes["class"] = "loggedIn providerloginStatus"; } catch (Exception ex) { } } //now check weather it is in renew mode if (Request.QueryString["Renew"] != null && Request.QueryString["Renew"] == "true") { lblMsg.Text = "Thank you for renewing your LA CES Approved Provider certification. If you have any questions, please contact <a href='mailto:[email protected]'>[email protected]</a>."; } else if (Session[LACESConstant.SessionKeys.LOGEDIN_APPROVED_PROVIDER] != null) { lblMsg.Text = "Thank you for renewing your LA CES Approved Provider certification. If you have any questions, please contact <a href='mailto:[email protected]'>[email protected]</a>."; } else { lblMsg.Text = "The American Society of Landscape Architects received your application and $295 application fee for the Landscape Architecture Continuing Education System today.<br/><br/>American Society of Landscape Architects<br/>636 I Street, NW<br/>Washington, DC 20001<br/>202-898-2444<br/>FEID - 53-0259019<br/><br/><em>Note: Please print this page for your records and use as a receipt.</em><br /><br />To ensure you receive your login and password and renewal notifications from LA CES, please be sure to add <strong>[email protected]</strong> and <strong>[email protected]</strong> to your e-mail “safe” list. You can also check your SPAM filter settings. If you have any questions, please contact <a href='mailto:[email protected];[email protected];[email protected]'> the LA CES administrators</a>."; } }
protected void btDelete_Click(object sender, EventArgs e) { if (Request.QueryString[LACESConstant.QueryString.COURSE_ID] != null && Request.QueryString[LACESConstant.QueryString.COURSE_ID].ToString() != "") { CourseDataAccess objCourseDAL = new CourseDataAccess(); long courseId = Convert.ToInt64(Request.QueryString[LACESConstant.QueryString.COURSE_ID].ToString()); Course deletingCourse = objCourseDAL.GetCoursesDetailsByID(courseId); string coursetitle = deletingCourse.Title; string strSubject = coursetitle + " – Course Declined"; ApprovedProviderDataAccess apda = new ApprovedProviderDataAccess(); ApprovedProvider ap = apda.GetApprovedProviderByID(deletingCourse.ProviderID); string strSendEmaiTo = ap.ApplicantEmail; bool deleted = objCourseDAL.Delete(courseId); //call dal method to delete SendDeleteForeverEmail(strSendEmaiTo, strSubject, coursetitle); Response.Redirect("FindCourses.aspx?status=NP"); // redirect after saving course information } }
protected void uilnkDownloadAttendees_Click(object sender, EventArgs e) { long courseID; LinkButton btn = (LinkButton)(sender); string yourValue = btn.CommandArgument; if (long.TryParse(yourValue, out courseID)) { DataGrid dg = new DataGrid(); CourseDataAccess oCourseDataAccess = new CourseDataAccess(); ApprovedProvider provider = (ApprovedProvider)Session[LACESConstant.SessionKeys.LOGEDIN_APPROVED_PROVIDER]; // Get provider information from Session ParticipantDataAccess participantDAL = new ParticipantDataAccess(); IList <Participant> participantList = participantDAL.GetAllParticipantByCourseIDProviderID(courseID, provider.ID); // Get Participants of the course DataTable tab = ConvertToDataTable(participantList); ConvertToCSV(tab); } }
/// <summary> /// Checking the Email And Password Match Existing Provider values and return provider details /// </summary> /// <param name="email">Email of Provider</param> /// <param name="password">password</param> private void SignInUser(string email, string password) { ///Encrypt password using DES encryption string EncriptedPassword = LACESUtilities.Encrypt(password); ApprovedProviderDataAccess providerDAL = new ApprovedProviderDataAccess(); //inactivate all expired providers providerDAL.InactivateApprovedProviders(0, DateTime.Now); ApprovedProvider provider = providerDAL.GetByEmailandPassword(email, EncriptedPassword); if (provider != null && provider.ID > 0 && provider.Status == LACESConstant.ProviderStatus.ACTIVE) { //Set Active Provider Details to Session Session[LACESConstant.SessionKeys.LOGEDIN_APPROVED_PROVIDER] = provider; //Set Inactive Provider Details to null Session[LACESConstant.SessionKeys.LOGEDIN_INACTIVE_PROVIDER] = null; ///Redirect to CourseListing page of Provider Response.Redirect("AddCourses.aspx"); } else if (provider != null && provider.ID > 0 && provider.Status == LACESConstant.ProviderStatus.INACTIVE) { //Set Inactive Provider Details to Session Session[LACESConstant.SessionKeys.LOGEDIN_INACTIVE_PROVIDER] = provider; //Set Active Provider Details to null Session[LACESConstant.SessionKeys.LOGEDIN_APPROVED_PROVIDER] = null; ///Redirect to CourseListing page of Provider Response.Redirect("Renew.aspx"); } else { DisplayInvalidLogin(); } }
/// <summary> /// Page Load Event /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { if (Session[LACESConstant.SessionKeys.LOGEDIN_APPROVED_PROVIDER] == null && Session[LACESConstant.SessionKeys.LOGEDIN_INACTIVE_PROVIDER] == null) { ASP.usercontrols_visitormenu_ascx visitorMenu = (ASP.usercontrols_visitormenu_ascx)Page.LoadControl("~/usercontrols/VisitorMenu.ascx"); uiPhMenu.Controls.Add(visitorMenu); } else { string sessionKeyForProvider = LACESConstant.SessionKeys.LOGEDIN_APPROVED_PROVIDER; ApprovedProvider sessionProvider = (ApprovedProvider)Session[sessionKeyForProvider]; // Get provider information from Session if (sessionProvider.Status == LACESConstant.ProviderStatus.ACTIVE) { uiPhMenu.Controls.Add(LoadControl("~/usercontrols/ProviderMenu.ascx")); } //if provider is inactive, inactive provider menu will be shown else if (sessionProvider.Status == LACESConstant.ProviderStatus.INACTIVE) { uiPhMenu.Controls.Add(LoadControl("~/usercontrols/InactiveProviderMenu.ascx")); } } }
/// <summary> /// Populate course details in the UI using course object /// </summary> /// <param name="course">course object</param> /// <returns></returns> private void populateCourseInfo(Course course) { try { //get master page label for showing the course name Label lblMasterCourseName = (Label)Master.FindControl("lblCourseName"); //course is null if current provider is not assign for that course if (course == null || course.ID < 1) { ///Disable buttons btnRemovePerticipant.Enabled = false; btnSaveFinish.Enabled = false; lblMsg.Text = LACESConstant.Messages.COURSE_NOT_FOUND_IN_PROVIDER; } else { //this is for message in the right side of the page divRightMessage.InnerHtml = "Use this page to edit an attendees who attended the " + Server.HtmlEncode(course.Title) + " course. Removing an attendees from the course is a permanent action, and can not be undone."; //assign course name in to the master page control lblMasterCourseName.Text = "Selected Course: <a href='CourseDetails.aspx?" + LACESConstant.QueryString.COURSE_ID + "=" + Server.HtmlEncode(course.ID.ToString()) + "'>" + Server.HtmlEncode(course.Title) + "</a>"; //get course detail by courseid and providerid //Provider provider = (Provider)Session[LACESConstant.SessionKeys.LOGEDIN_PROVIDER]; // Get provider information from Session ApprovedProvider provider = (ApprovedProvider)Session[LACESConstant.SessionKeys.LOGEDIN_APPROVED_PROVIDER]; // get approved provider information from Session //set the provider name to the master page ProviderName label Label lblMasterProviderName = (Label)Master.FindControl("lblProviderName"); lblMasterProviderName.Text = Server.HtmlEncode("Signed in as: " + provider.OrganizationName); } } catch (Exception ex) { throw ex; } }
/// <summary> /// Populate the participants of the course. Get a course id which participant information want to get /// from database. Return none. /// </summary> /// <param name="courseID">Course ID</param> private void populateParticipantList(long courseID) { try { CourseDataAccess oCourseDataAccess = new CourseDataAccess(); ApprovedProvider provider = (ApprovedProvider)Session[LACESConstant.SessionKeys.LOGEDIN_APPROVED_PROVIDER]; // Get provider information from Session ParticipantDataAccess participantDAL = new ParticipantDataAccess(); IList <Participant> participantList = participantDAL.GetAllParticipantByCourseIDProviderID(courseID, provider.ID); // Get Participants of the course rptParticipantList.DataSource = participantList; rptParticipantList.DataBind(); //prepare the header //dvParticipantList.InnerHtml = "<div class='title'>Edit Attendees for: " + Server.HtmlEncode(oCourseDataAccess.GetCoursesDetailsByID(courseID).Title) + "</div><div class=''><table border='0' style='text-align:center;' cellpadding='0' cellspacing='0'>"; //if (participantList.Count > 0) //{ // dvParticipantList.InnerHtml += "<tr><td style='text-align:left; vertical-align:middle;' class='participantList'><strong>Last Name</strong></td><td style='text-align:left; vertical-align:middle;' class='participantList'><strong>First Name</strong></td></tr>"; // //dynamically add rest of the rows // foreach (Participant participant in participantList) // { // dvParticipantList.InnerHtml += "<tr><td style='text-align:left; vertical-align:middle;' class='participantList'><a href='EditAttendees.aspx?ParticipantID=" + participant.ID.ToString() + "&CourseID=" + courseID.ToString() + "'>" + Server.HtmlEncode(participant.LastName) + "</a></td>"; // dvParticipantList.InnerHtml += "<td style='text-align:left; vertical-align:middle;' class='participantList'>" + Server.HtmlEncode(participant.FirstName) + "</td></tr>"; // } //} //else //{ // dvParticipantList.InnerHtml += "<tr><td style='color:red'>No attendees found.</td></tr>"; //} //dvParticipantList.InnerHtml += "</div></table>"; //dvParticipantList.InnerHtml += "<br/><div><a href='../provider/UploadAttendees.aspx?courseid=" + courseID + "'>Upload Attendees in Excel</a><div>"; } catch (Exception ex) { throw ex; } }
/// <summary> /// Page Load Event Handler. Call every time when the page is loaded. /// </summary> /// <param name="sender">Sender object</param> /// <param name="e">EventArgs</param> protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //now check weather it is in edit provider mode if (Session[LACESConstant.SessionKeys.LOGEDIN_APPROVED_PROVIDER] != null) { //get the provider from session ApprovedProvider sessionProvider = (ApprovedProvider)Session[LACESConstant.SessionKeys.LOGEDIN_APPROVED_PROVIDER]; // Get provider information from Session //fill form by provider in session FillFormValuesByProviderObject(sessionProvider); //PopulateStateBasedOnCountry(OrganizationState, null); } } //reset the error message label lblMsg.Text = ""; lblMsg.ForeColor = System.Drawing.Color.Red; CheckUnsavedData(); }
/// <summary> /// This function fills an approved provider object with form values /// </summary> /// <returns></returns> private ApprovedProvider FIllApprovedProviderObjectByFormValues(ApprovedProvider sessionProvider) { sessionProvider.OrganizationName = OrganizationName.Text; sessionProvider.OrganizationStreetAddress = OrganizationStreetAddress.Text; sessionProvider.OrganizationCity = OrganizationCity.Text; sessionProvider.OrganizationState = OrganizationState.Text; sessionProvider.OrganizationZip = OrganizationZip.Text; sessionProvider.OrganizationCountry = OrganizationCountry.Text; sessionProvider.OrganizationPhone = OrganizationPhone.Text; sessionProvider.OrganizationFax = OrganizationFax.Text; sessionProvider.OrganizationWebSite = OrganizationWebSite.Text; sessionProvider.ApplicantName = ApplicantName.Text; sessionProvider.ApplicantPosition = ApplicantPosition.Text; sessionProvider.ApplicantPhone = ApplicantPhone.Text; sessionProvider.ApplicantFax = ApplicantFax.Text; sessionProvider.ApplicantEmail = ApplicantEmail.Text; //set the password fields sessionProvider.Password = LACESUtilities.Encrypt(HidPass.Value); return(sessionProvider); }
/// <summary> /// Override the onload event handler /// </summary> /// <param name="e"></param> protected override void OnLoad(EventArgs e) { try { ///Check Session for logged in provider information if (Session[LACESConstant.SessionKeys.LOGEDIN_APPROVED_PROVIDER] != null) { //Provider provider = (Provider)Session[LACESConstant.SessionKeys.LOGEDIN_PROVIDER]; ApprovedProvider provider = (ApprovedProvider)Session[LACESConstant.SessionKeys.LOGEDIN_APPROVED_PROVIDER]; // get approved provider information from Session if (provider.ID > 0) { ///Show loggedin provider name Label lblProviderName = (Label)Master.FindControl("lblProviderName"); if (lblProviderName != null) { lblProviderName.Text = "Signed in as: " + Server.HtmlEncode(provider.OrganizationName); } try { //change the login status ((HtmlGenericControl)Master.FindControl("loginTd")).Attributes["class"] = "loggedIn providerloginStatus"; } catch (Exception ex) { } base.OnLoad(e); } } else { Response.Redirect(LACESConstant.URLS.HOME_PAGE); } } catch (Exception ex) { } }
/// <summary> /// Return string array by spliting the string by a delimiter /// </summary> /// <param name="stringList">string</param> /// <returns>Array of String</returns> /// protected void SendMoreDataNeededEmail(Course c) { string strMessageBody = uiTxtEmailText.Text.Replace("\r\n", "<br />"); ApprovedProviderDataAccess apda = new ApprovedProviderDataAccess(); ApprovedProvider ap = apda.GetApprovedProviderByID(c.ProviderID); string strSendEmaiTo = ap.ApplicantEmail; SmtpClient smtpClient = new SmtpClient(); //Get the SMTP server Address from SMTP Web.conf smtpClient.Host = LACESUtilities.GetApplicationConstants(LACESConstant.SMTPSERVER); //Get the SMTP port 25; smtpClient.Port = Convert.ToInt32(LACESUtilities.GetApplicationConstants(LACESConstant.SMTPPORT)); //create the message body MailMessage message = new MailMessage(); message.From = new MailAddress(LACESUtilities.GetAdminFromEmail()); message.To.Add(new MailAddress(strSendEmaiTo)); message.CC.Add(new MailAddress(LACESUtilities.GetApplicationConstants(LACESConstant.ADMIN_CONTACT_TO_EMAIL))); message.Subject = "LA CES Course Needs More Information"; message.IsBodyHtml = true; message.Body = strMessageBody; if (ConfigurationManager.AppSettings["SendOutgoingEmail"].ToString() == "Y") { try { smtpClient.Send(message); } catch (Exception ex) { Response.Write(ex.Message); } } }
/// <summary> /// Populate form fields from provider object /// </summary> /// <param name="currentProvider"></param> private void FillFormValuesByProviderObject(ApprovedProvider currentProvider) { OrganizationName.Text = currentProvider.OrganizationName; OrganizationStreetAddress.Text = currentProvider.OrganizationStreetAddress; OrganizationCity.Text = currentProvider.OrganizationCity; OrganizationState.Text = currentProvider.OrganizationState; OrganizationZip.Text = currentProvider.OrganizationZip; OrganizationCountry.Text = currentProvider.OrganizationCountry; OrganizationPhone.Text = currentProvider.OrganizationPhone; OrganizationFax.Text = currentProvider.OrganizationFax; OrganizationWebSite.Text = currentProvider.OrganizationWebSite; ApplicantName.Text = currentProvider.ApplicantName; ApplicantPosition.Text = currentProvider.ApplicantPosition; ApplicantPhone.Text = currentProvider.ApplicantPhone; ApplicantFax.Text = currentProvider.ApplicantFax; ApplicantEmail.Text = currentProvider.ApplicantEmail; ApplicantEmailConfirm.Text = currentProvider.ApplicantEmail; //set the password fields HidPass.Value = LACESUtilities.Decrypt(currentProvider.Password); Password.Attributes.Add("value", HidPass.Value); PasswordConfirm.Attributes.Add("value", HidPass.Value); }
/// <summary> /// Uplaod an Excel file /// </summary> private bool UploadExcelFile() { string staticErrorMessage = "There has been an error with your upload. Please ensure you use our template to upload attendees.<br/> "; lb_error_message.Style["color"] = "red"; bool blnShowGetNewExcel = false; //check the file extension, if not .xls file then show error if (!FileUpload1.FileName.EndsWith(".xls") && !FileUpload1.FileName.EndsWith(".xlsx")) { lb_error_message.InnerHtml = staticErrorMessage + "<br />location=1";// "Your provided file type is not supported."; return(false); } //prepare the file path fileLocation = AppDomain.CurrentDomain.BaseDirectory + "xls\\" + System.DateTime.Now.Ticks + FileUpload1.FileName; try { //get the course id from query string long courseID = 0; List <Participant> participantList = new List <Participant>(); //create the file loacton FileStream oFileStream = File.Create(fileLocation); foreach (byte b in FileUpload1.FileBytes) { oFileStream.WriteByte(b); } oFileStream.Close(); Participant oParticipant = null; //Debugger.Break(); //now load it to UI if (Request.QueryString["courseid"] != null) { try { courseID = Convert.ToInt32(Request.QueryString["courseid"]); } catch { courseID = 0; } //no course found if (courseID == 0) { lb_error_message.InnerHtml = staticErrorMessage + "<br />location=2";//"Course ID is invalid/not exists."; return(false); } //get the current login provider ApprovedProvider provider = (ApprovedProvider)Session[LACESConstant.SessionKeys.LOGEDIN_APPROVED_PROVIDER]; //check is the course available or not CourseDataAccess oCourseDataAccess = new CourseDataAccess(); if (oCourseDataAccess.GetCoursesDetailsByIDandProviderID(courseID, provider.ID) == null) { lb_error_message.InnerHtml = staticErrorMessage + "<br />location=3";// "Course ID is invalid/not exists."; return(false); } } else { lb_error_message.InnerHtml = staticErrorMessage + "<br />location=4";//"Course ID is invalid."; return(false); } DataTable oDataTable = LACESUtilities.ReadXLFile(fileLocation, "Attendees"); // Response.Write(fileLocation); // Response.End(); if (oDataTable == null) { lb_error_message.InnerHtml = staticErrorMessage + "<br />location=5";// "Attendees' information does not match with the template."; return(false); } foreach (DataRow dr in oDataTable.Rows) { oParticipant = new Participant(); string last_name = dr["Last"].ToString().Trim(); string first_name = dr["First"].ToString().Trim(); string middle_name = dr["Middle"].ToString().Trim(); string asla_number = dr["ASLA"].ToString().Trim(); string clarb_number = dr["CLARB"].ToString().Trim(); string csla_name = dr["CSLA"].ToString().Trim(); string florida_number = dr["FL"].ToString().Trim(); string email = ""; if (dr.Table.Columns.Contains("email")) { email = dr["email"].ToString().Trim(); } else { blnShowGetNewExcel = true; } //if (last_name == "" && first_name == "") //{ // lb_error_message.InnerHtml = staticErrorMessage + "<br />location=6";//"In your uploaded file, one or more first name/last name are //empty."; // return false; //} //if any field is empty then exit the process if (last_name != "" && first_name != "")// && asla_number != "" && clarb_number != "" && florida_number != "") { oParticipant.LastName = last_name; oParticipant.FirstName = first_name; oParticipant.MiddleInitial = middle_name; oParticipant.ASLANumber = asla_number; oParticipant.CLARBNumber = clarb_number; oParticipant.CSLANumber = csla_name; oParticipant.FloridaStateNumber = florida_number; oParticipant.Email = email; //add in to the participant list participantList.Add(oParticipant); } else if (csla_name == "" && middle_name == "" && last_name == "" && first_name == "" && asla_number == "" && clarb_number == "" && florida_number == "") { //if empty row found then discard the row } else { //some empty field found. so inform the error lb_error_message.InnerHtml = staticErrorMessage + "<br />location=7";// "Attendees' information does not match with the template."; return(false); } } if (participantList.Count > 0) { //finally add the participant in to the database ParticipantDataAccess oParticipantDataAccess = new ParticipantDataAccess(); oParticipantDataAccess.AddParticipantByCourse(courseID, participantList); } //finally remove the excel file LACESUtilities.RemoveCreatedFileFromDisk(fileLocation); if (blnShowGetNewExcel) { lb_error_message.InnerHtml = "ALERT: Please download new Excel Template that now captures attendee email. This did not prevent your current attendee file from being successfully uploaded.<br/> "; lb_error_message.Style["color"] = "red"; } else { lb_error_message.InnerHtml = "Thank you. Your attendee file has been successfully uploaded.<br/> "; lb_error_message.Style["color"] = "green"; } //Response.Redirect("../Provider/ManageAttendees.aspx?courseid=" + courseID); } catch (Exception ex) { lb_error_message.InnerHtml = staticErrorMessage + "<br />location=1" + "<br />" + ex.Message;//"There has been an error with your upload. Please ensure you use our template to upload attendees."; if (File.Exists(fileLocation)) { File.Delete(fileLocation); } } return(true); }
private bool UploadExcelFile(string strUploadCourseID, string strCourseCodeType) { try { string fileLocation = ""; fileLocation = AppDomain.CurrentDomain.BaseDirectory + "xls\\MultipleCourseUpload\\" + System.DateTime.Now.Ticks + uiFUPSpreadsheet.FileName; //get the course id from query string List <Course> courseList = new List <Course>(); //create the file loacton FileStream oFileStream = File.Create(fileLocation); foreach (byte b in uiFUPSpreadsheet.FileBytes) { oFileStream.WriteByte(b); } oFileStream.Close(); Course oCourse = null; DataTable oDataTable = LACESUtilities.ReadXLFile(fileLocation, "Courses"); bool useNext = false; ApprovedProvider provider = (ApprovedProvider)Session[LACESConstant.SessionKeys.LOGEDIN_APPROVED_PROVIDER]; // get approved provider information from Session System.Text.StringBuilder sbResult = new System.Text.StringBuilder(); sbResult.Append("<br />"); int CourseUploadSuccess = 0; int CourseUploadMoreInfo = 0; int CourseUploadFailed = 0; int currentRow = 0; if (oDataTable != null) { foreach (DataRow dr in oDataTable.Rows) { oCourse = new Course(); string strCol1 = dr[0].ToString().Trim(); if (useNext) { string strCourseTitle = dr[0].ToString().Trim(); if (strCourseTitle.Length > 0) { oCourse.Title = strCourseTitle; string strCourseRegUrl = dr[1].ToString().Trim(); oCourse.Hyperlink = strCourseRegUrl; string strRegEligibility = dr[2].ToString().Trim(); oCourse.RegistrationEligibility = strRegEligibility; string strStartDate = dr[3].ToString().Trim(); DateTime dtStart; if (DateTime.TryParse(strStartDate, out dtStart)) { oCourse.StartDate = dtStart; } else { oCourse.StartDate = DateTime.Parse("1/1/2010"); } string strEndDate = dr[4].ToString().Trim(); DateTime dtEndDate; if (DateTime.TryParse(strEndDate, out dtEndDate)) { oCourse.EndDate = dtEndDate; } else { oCourse.EndDate = DateTime.Parse("1/1/2010"); } string strDescription = dr[5].ToString().Trim(); oCourse.Description = strDescription; string strCity = dr[6].ToString().Trim(); oCourse.City = strCity; string strState = dr[7].ToString().Trim(); oCourse.StateProvince = strState; string strDistanceEd = dr[8].ToString(); if (strDistanceEd.Length == 0) { oCourse.DistanceEducation = " "; } else { oCourse.DistanceEducation = strDistanceEd; } string strCourseEquivalency = dr[9].ToString(); if (strCourseEquivalency.Length == 0) { oCourse.CourseEquivalency = " "; } else { oCourse.CourseEquivalency = strCourseEquivalency; } string strSubjects = dr[10].ToString().Trim(); string strSubjects2 = dr[11].ToString().Trim(); if (strSubjects2.Length > 0) { strSubjects += ", " + strSubjects2; } oCourse.Subjects = strSubjects; string strHealthSafety = dr[12].ToString().Trim(); oCourse.Healths = strHealthSafety; string strPersonalDevelopmentHours = dr[13].ToString().Trim(); if (strPersonalDevelopmentHours.IndexOf(".") < 0) { strPersonalDevelopmentHours = strPersonalDevelopmentHours + ".00"; } oCourse.Hours = strPersonalDevelopmentHours; string strLearningOutcomes = dr[14].ToString().Trim(); oCourse.LearningOutcomes = strLearningOutcomes; string strInstructors = dr[15].ToString().Trim(); oCourse.Instructors = strInstructors; string strNoProprietary = dr[16].ToString().ToLower().Trim() == "yes" ? "Y" : "N"; oCourse.NoProprietaryInfo = strNoProprietary; string strCourseCode = dr[17].ToString().Trim(); oCourse.ProviderID = provider.ID; string strCourseErrors = LACESUtilities.CheckCourseValid(oCourse); //oCourse.OrgStateCourseIDNumber = strCourseCode; if (strCourseErrors.Length == 0) { oCourse.Status = "NP"; } else { oCourse.Status = "IC"; } oCourse.ProviderCustomCourseCode = strCourseCode; CourseDataAccess cd = new CourseDataAccess(); long lngCourseID = -1; try { if (long.TryParse(cd.AddCourseDetails(oCourse).ToString(), out lngCourseID)) { try { SqlConnection conn2 = new SqlConnection(ConfigurationManager.ConnectionStrings["LACESConnectionString"].ToString()); conn2.Open(); DataSet ds = new DataSet(); string sqlStatement = "LACES_InsertMultiCourse_Courses"; SqlCommand cmd = new SqlCommand(sqlStatement, conn2); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@MultiCourseID", strUploadCourseID); cmd.Parameters.AddWithValue("@CourseID", lngCourseID.ToString()); cmd.ExecuteNonQuery(); conn2.Close(); } catch (Exception ex) { Response.Write(ex.Message); Response.End(); } // if (strCourseCode.Trim().Length > 0) // { // CourseCodeDataAccess codeDAL = new CourseCodeDataAccess(); // CourseCode code = new CourseCode(); // long CodeID = GetCodeIDfromName(strCourseCodeType.Trim()); // if (CodeID > 0) // { // //code.Description = descList[i]; // code.CodeID = Convert.ToInt32(CodeID); // code.CourseID = lngCourseID; // code.Description = strCourseCode.Trim(); // try // { // codeDAL.AddCourseCode(code); // Add course Code // } // catch (Exception ex) // { // uiLblResults.Text = ex.Message; // Response.End(); // } // } // else // { // CourseTypeDataAccess courseTypeDAL = new CourseTypeDataAccess(); // int codeID = courseTypeDAL.AddCodeType(strCourseCodeType.Trim()); // code.CodeID = codeID; // code.CourseID = lngCourseID; // code.Description = strCourseCode.Trim(); // try // { // codeDAL.AddCourseCode(code); // Add course Code // } // catch (Exception ex) // { // uiLblResults.Text = ex.Message; // Response.End(); // } // } // } } } catch (Exception ex) { Response.Write(ex.Message); Response.End(); } if (strCourseErrors.Length == 0) { CourseUploadSuccess++; sbResult.Append("<span style=\"color:green\">SUCCESS </span>" + oCourse.Title + "<hr style=\"background-image: url(http://laces.asla.org/images/dotted.png); background-repeat: repeat-x; border: 0; height: 1px;\" />"); } else { CourseUploadMoreInfo++; sbResult.Append("<span style=\"color:orange\">ACTION REQUIRED</span> <a href=\"http://laces.asla.org/provider/CourseDetails.aspx?CourseID=" + lngCourseID.ToString() + "\" class=\"nostyle\">" + oCourse.Title + "</a><br />" + strCourseErrors + "<hr style=\"background-image: url(http://laces.asla.org/images/dotted.png); background-repeat: repeat-x; border: 0; height: 1px;\"/>"); } } else { DataRow drN = oDataTable.Rows[currentRow]; bool endprocess = true; for (int i = 0; i < 17; i++) { if (drN[i].ToString().Trim().Length > 0) { CourseUploadFailed++; sbResult.Append("<span style=\"color:red\"> ERROR: Excel Row " + (currentRow + 2).ToString() + " was missing a title which is required to begin processing</span><br /><hr style=\"background-image: url(http://laces.asla.org/images/dotted.png); background-repeat: repeat-x; border: 0; height: 1px;\"/>"); endprocess = false; break; } } if (endprocess) { DataRow drN1 = oDataTable.Rows[currentRow + 1]; if (drN1[0].ToString().Trim().Length == 0) { break; } } } } if (strCol1 == "*Course Title") { useNext = true; } currentRow++; //long newCourse = cd.AddCourseDetails(oCourse); } if (useNext && (CourseUploadMoreInfo + CourseUploadSuccess > 0)) { string strMultiName = uiTxtMultiName.Text; string strConfStartDate = txtStartDate.Text; string strConfEndDate = txtEndDate.Text; System.Text.StringBuilder Summary = new System.Text.StringBuilder(); Summary.Append("<br /><br /><br /><br /><strong>Thank you for your submission.</strong><br />"); Summary.Append("<br /><strong>Event Title: </strong> " + strMultiName + "<br />"); Summary.Append("<br /><strong>Start Date: </strong> " + strConfStartDate + "<br />"); Summary.Append("<br /><strong>End Date: </strong>" + strConfEndDate + "<br />"); Summary.Append("<br />" + (CourseUploadMoreInfo + CourseUploadSuccess).ToString() + " courses have been received.<br />"); Summary.Append(CourseUploadSuccess.ToString() + " courses are complete and pending approval by LA CES administrators.<br />"); Summary.Append(CourseUploadMoreInfo.ToString() + " courses are incomplete and require immediate attention.<br />"); if (CourseUploadFailed > 0) { Summary.Append(CourseUploadFailed.ToString() + " courses failed to upload and need to be resubmitted.<br />"); } Summary.Append("<br />Please review the list below or go to <a href=\"http://laces.asla.org/provider/CourseList.aspx?status=NP\">Pending Courses</a> to review your individual course details. All pending courses that require additional information will be listed with a status of \"Action Required\"."); Summary.Append("<br /><br /><br />An email with this information will be sent to the primary contact for your account."); Summary.Append("<br /><br /><br />Sincerely,"); Summary.Append("<br /><br /><br />LA CES Administrator"); uiLblResults.Text = Summary.ToString() + "<hr style=\"background-image: url(http://laces.asla.org/images/images/dotted.png); background-repeat: repeat-x; border: 0; height: 2px;\" />Upload Status – Course Title<br />" + sbResult.ToString(); SendEmail(Summary.ToString() + "<hr style=\"background-image: url(http://laces.asla.org/images/dotted.png); background-repeat: repeat-x; border: 0; height: 2px;\" />Upload Status– Course Title<br />" + sbResult.ToString(), provider.ApplicantEmail); } else { BuildExcelError(); SendEmail(uiLblResults.Text, provider.ApplicantEmail); } } else { BuildExcelError(); } } catch (Exception ex) { BuildExcelError(); } return(false); }
protected void btnApprove_Click(object sender, EventArgs e) { CourseDataAccess objCourseDAL = new CourseDataAccess(); ///Loop all items in data list to check approve checkbox for approve one course foreach (RepeaterItem dl in dlCourseList.Items) { CheckBox chkApp = (CheckBox)dl.FindControl("chkApprove"); ///Get Course Id from hidden field HiddenField hidCourseID = (HiddenField)dl.FindControl("hidCourseID"); if (chkApp.Checked == true) { long courseId = Convert.ToInt64(hidCourseID.Value); if (courseId > 0) { bool approved = objCourseDAL.ApproveCourseByCourseId(courseId); if (approved) { Course approvedCourse = objCourseDAL.GetCoursesDetailsByID(courseId); string strTitle = approvedCourse.Title; string strHyperlink = approvedCourse.Hyperlink; string strStartDate = approvedCourse.StartDate.ToShortDateString(); string strEndDate = approvedCourse.EndDate.ToShortDateString(); string strDesc = approvedCourse.Description; string strCity = approvedCourse.City; string strState = approvedCourse.StateProvince; string strDistanceEd = approvedCourse.DistanceEducation; string strSubjects = approvedCourse.Subjects; string strHours = approvedCourse.Hours; string strLearningOutcomes = approvedCourse.LearningOutcomes; ApprovedProviderDataAccess apda = new ApprovedProviderDataAccess(); ApprovedProvider ap = apda.GetApprovedProviderByID(approvedCourse.ProviderID); string strSendEmaiTo = ap.ApplicantEmail; StringBuilder strbApprovedEmail = new StringBuilder(); string strEmailTitle = "An LA CES Course has been approved"; string strBodyIntro = "Congratulations, a course has been approved by LA CES administrators. Please review the information below carefully as it may have been revised during the approval process. <br />"; string strBodyEnd = "Please contact <a href=\"mailto:[email protected]\"> LA CES administrators </a> with any questions about the course."; strbApprovedEmail.Append(strBodyIntro + "<br />"); strbApprovedEmail.Append("Course Title: " + strTitle + "<br />"); strbApprovedEmail.Append("Course Hyperlink: " + strHyperlink + "<br />"); strbApprovedEmail.Append("Start Date: " + strStartDate + "<br />"); strbApprovedEmail.Append("End Date: " + strEndDate + "<br />"); strbApprovedEmail.Append("Description: " + strDesc + "<br />"); strbApprovedEmail.Append("City: " + strCity + "<br />"); strbApprovedEmail.Append("State: " + strState + "<br />"); strbApprovedEmail.Append("Distance Education: " + strDistanceEd + "<br />"); strbApprovedEmail.Append("Subject: " + strSubjects + "<br />"); strbApprovedEmail.Append("Hours: " + strHours + "<br />"); strbApprovedEmail.Append("Learning Outcomes: " + strLearningOutcomes + "<br /><br />"); strbApprovedEmail.Append(strBodyEnd + "<br />"); SmtpClient smtpClient = new SmtpClient(); //Get the SMTP server Address from SMTP Web.conf smtpClient.Host = LACESUtilities.GetApplicationConstants(LACESConstant.SMTPSERVER); //Get the SMTP port 25; smtpClient.Port = Convert.ToInt32(LACESUtilities.GetApplicationConstants(LACESConstant.SMTPPORT)); //create the message body MailMessage message = new MailMessage(); message.From = new MailAddress(LACESUtilities.GetAdminFromEmail()); message.To.Add(new MailAddress(strSendEmaiTo)); message.Subject = strEmailTitle; message.IsBodyHtml = true; message.Body = strbApprovedEmail.ToString(); if (ConfigurationManager.AppSettings["SendOutgoingEmail"].ToString() == "Y") { try { // smtpClient.Send(message); } catch (Exception ex) { Response.Write(ex.Message); } } } } } } ///Re-load pending courses pendingCourses = objCourseDAL.GetAllPendingCourses(); dlCourseList.DataSource = pendingCourses; dlCourseList.DataBind(); ///Show success message lblMsg.Visible = true; lblMsg.ForeColor = System.Drawing.Color.Green; lblMsg.Text = "Selected course(s) approved successfully."; }
protected void SendApprovedEmail(long courseId) { CourseDataAccess objCourseDAL = new CourseDataAccess(); Course approvedCourse = objCourseDAL.GetCoursesDetailsByID(courseId); string strTitle = approvedCourse.Title; string strHyperlink = approvedCourse.Hyperlink; string strStartDate = approvedCourse.StartDate.ToShortDateString(); string strEndDate = approvedCourse.EndDate.ToShortDateString(); string strDesc = approvedCourse.Description; string strCity = approvedCourse.City; string strState = approvedCourse.StateProvince; string strDistanceEd = approvedCourse.DistanceEducation; string strSubjects = approvedCourse.Subjects; string strHours = approvedCourse.Hours; string strLearningOutcomes = approvedCourse.LearningOutcomes; ApprovedProviderDataAccess apda = new ApprovedProviderDataAccess(); ApprovedProvider ap = apda.GetApprovedProviderByID(approvedCourse.ProviderID); string strSendEmaiTo = ap.ApplicantEmail; StringBuilder strbApprovedEmail = new StringBuilder(); string strEmailTitle = "An LA CES Course has been approved"; string strBodyIntro = "Congratulations, a course has been approved by LA CES administrators. Please review the information below carefully as it may have been revised during the approval process. <br />"; string strBodyEnd = "Please contact <a href=\"mailto:[email protected]\"> LA CES administrators </a> with any questions about the course."; strbApprovedEmail.Append(strBodyIntro + "<br />"); strbApprovedEmail.Append("Course Title: " + strTitle + "<br />"); strbApprovedEmail.Append("Course Hyperlink: " + strHyperlink + "<br />"); strbApprovedEmail.Append("Start Date: " + strStartDate + "<br />"); strbApprovedEmail.Append("End Date: " + strEndDate + "<br />"); strbApprovedEmail.Append("Description: " + strDesc + "<br />"); strbApprovedEmail.Append("City: " + strCity + "<br />"); strbApprovedEmail.Append("State: " + strState + "<br />"); strbApprovedEmail.Append("Distance Education: " + strDistanceEd + "<br />"); strbApprovedEmail.Append("Subject: " + strSubjects + "<br />"); strbApprovedEmail.Append("Hours: " + strHours + "<br />"); strbApprovedEmail.Append("Learning Outcomes: " + strLearningOutcomes + "<br /><br />"); strbApprovedEmail.Append(strBodyEnd + "<br />"); SmtpClient smtpClient = new SmtpClient(); //Get the SMTP server Address from SMTP Web.conf smtpClient.Host = LACESUtilities.GetApplicationConstants(LACESConstant.SMTPSERVER); //Get the SMTP port 25; smtpClient.Port = Convert.ToInt32(LACESUtilities.GetApplicationConstants(LACESConstant.SMTPPORT)); //create the message body MailMessage message = new MailMessage(); message.From = new MailAddress(LACESUtilities.GetAdminFromEmail()); message.To.Add(new MailAddress(strSendEmaiTo)); message.Subject = strEmailTitle; message.IsBodyHtml = true; message.Body = strbApprovedEmail.ToString(); if (ConfigurationManager.AppSettings["SendOutgoingEmail"].ToString() == "Y") { try { smtpClient.Send(message); } catch (Exception ex) { Response.Write(ex.Message); } } }