protected void gvExistingCourses_ItemDataBound(object sender, RepeaterItemEventArgs e) { Course thiscourse = (Course)e.Item.DataItem; if (thiscourse != null) { using (Utility.ASLA_Laces_ProdEntities item = new Utility.ASLA_Laces_ProdEntities()) { Label LblModifiedDate = (Label)e.Item.FindControl("uiLblModifiedDate"); Utility.tblParticipantCource course = item.tblParticipantCources.Where(x => x.CourseID == thiscourse.ID).OrderByDescending(y => y.DateAdded).FirstOrDefault(); if (course != null) { LblModifiedDate.Text = course.DateAdded.Value.ToShortDateString(); } else { LblModifiedDate.Text = "None"; } } } }
/// <summary> /// Get Search Criteria and redirect to search result page /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnFindCourses_Click(object sender, EventArgs e) { //string searchCriteria = buildSearchCriteria(); SearchCourse objSearchCourse = buildSearchCriteria(); objSearchCourse.SortColumn = "StartDate"; objSearchCourse.SortOrder = "DESC"; using (Utility.ASLA_Laces_ProdEntities item = new Utility.ASLA_Laces_ProdEntities()) { string subject = ddlSubject.SelectedValue; string location = ddlLocation.SelectedValue; Utility.LACES_Search_Terms terms = new Utility.LACES_Search_Terms(); terms.Location = location; terms.SubjectArea = subject; terms.DateSearched = System.DateTime.Now; item.LACES_Search_Terms.Add(terms); item.SaveChanges(); } //Add search criteria into session Session.Add(LACESConstant.SessionKeys.SEARCH_VISITOR_CRITERIA, objSearchCourse); Response.Redirect("~/visitor/CourseResult.aspx"); }
protected void uiLnkGenerateReport_Click(object sender, EventArgs e) { string reporttype = uiDDLReportType.SelectedValue; string startdate = txtStartDate.Text.Length > 0 ? txtStartDate.Text : "1/1/1900"; string enddate = txtEndDate.Text.Length > 0 ? txtEndDate.Text : "1/1/2050"; Utility.ASLA_Laces_ProdEntities item = new Utility.ASLA_Laces_ProdEntities(); switch (reporttype) { case "coursesbysubject": // create all parameters you need var cmdText = "[LACES_VisualizationSubjectByDate] @StartDate = @startdate_param, @EndDate = @enddate_param"; var paramsa = new[] { new SqlParameter("startdate_param", "1/1/1920"), new SqlParameter("enddate_param", "1/1/2020") }; List <Utility.LACES_VisualizationSubjectByDate_Result> queryresults = item.Database.SqlQuery <Utility.LACES_VisualizationSubjectByDate_Result>(cmdText, paramsa).ToList(); int i = 0; foreach (Utility.LACES_VisualizationSubjectByDate_Result result in queryresults) { string subject = result.declaration; string count = result.subjectcount.Value.ToString(); i++; } DataTable tab = ConvertToDataTable(queryresults); ConvertToCSV(tab); break; case "coursesbylocation": // create all parameters you need var cmdText1 = "[LACES_VisualizationSubjectByLocation] @StartDate = @startdate_param, @EndDate = @enddate_param"; var paramsa1 = new[] { new SqlParameter("startdate_param", "1/1/1920"), new SqlParameter("enddate_param", "1/1/2020") }; List <Utility.LACES_VisualizationSubjectByLocation_Result> queryresults1 = item.Database.SqlQuery <Utility.LACES_VisualizationSubjectByLocation_Result>(cmdText1, paramsa1).ToList(); int j = 0; foreach (Utility.LACES_VisualizationSubjectByLocation_Result result in queryresults1) { string subject = result.StateProvince; string count = result.locationcount.Value.ToString(); j++; } DataTable tab1 = ConvertToDataTable(queryresults1); ConvertToCSV(tab1); break; case "providersbytype": var cmdText2 = "[LACES_VisualizationNewProviders] @StartDate = @startdate_param, @EndDate = @enddate_param"; var paramsa2 = new[] { new SqlParameter("startdate_param", "1/1/1920"), new SqlParameter("enddate_param", "1/1/2020") }; List <Utility.LACES_VisualizationNewProviders_Result> queryresults2 = item.Database.SqlQuery <Utility.LACES_VisualizationNewProviders_Result>(cmdText2, paramsa2).ToList(); int k = 0; foreach (Utility.LACES_VisualizationNewProviders_Result result in queryresults2) { string subject = result.ProviderType; string count = result.providercount.Value.ToString(); k++; } DataTable tab2 = ConvertToDataTable(queryresults2); ConvertToCSV(tab2); break; } }
protected void Page_Load(object sender, EventArgs e) { string reporttype = Request.QueryString["reporttype"] != null ? Request.QueryString["reporttype"] : ""; string startdate = Request.QueryString["startdate"] != null ? Request.QueryString["startdate"] : "1/1/1900"; string enddate = Request.QueryString["enddate"] != null ? Request.QueryString["enddate"] : "1/1/2050"; Utility.ASLA_Laces_ProdEntities item = new Utility.ASLA_Laces_ProdEntities(); switch (reporttype) { case "coursesbysubject": // create all parameters you need var cmdText = "[LACES_VisualizationSubjectByDate] @StartDate = @startdate_param, @EndDate = @enddate_param"; var paramsa = new[] { new SqlParameter("startdate_param", "1/1/1920"), new SqlParameter("enddate_param", "1/1/2020") }; List <Utility.LACES_VisualizationSubjectByDate_Result> queryresults = item.Database.SqlQuery <Utility.LACES_VisualizationSubjectByDate_Result>(cmdText, paramsa).ToList(); int i = 0; foreach (Utility.LACES_VisualizationSubjectByDate_Result result in queryresults) { string subject = result.declaration; string count = result.subjectcount.Value.ToString(); jsondata += "{x:" + i.ToString() + ",y: " + count + ", indexLabel: \"" + subject + "\" },"; i++; } jsondata = jsondata.TrimEnd(','); break; case "coursesbylocation": // create all parameters you need var cmdText1 = "[LACES_VisualizationSubjectByLocation] @StartDate = @startdate_param, @EndDate = @enddate_param"; var paramsa1 = new[] { new SqlParameter("startdate_param", "1/1/1920"), new SqlParameter("enddate_param", "1/1/2020") }; List <Utility.LACES_VisualizationSubjectByLocation_Result> queryresults1 = item.Database.SqlQuery <Utility.LACES_VisualizationSubjectByLocation_Result>(cmdText1, paramsa1).ToList(); int j = 0; foreach (Utility.LACES_VisualizationSubjectByLocation_Result result in queryresults1) { string subject = result.StateProvince; string count = result.locationcount.Value.ToString(); jsondata += "{x:" + j.ToString() + ",y: " + count + ", indexLabel: \"" + subject + "\" },"; j++; } jsondata = jsondata.TrimEnd(','); break; case "providersbytype": var cmdText2 = "[LACES_VisualizationNewProviders] @StartDate = @startdate_param, @EndDate = @enddate_param"; var paramsa2 = new[] { new SqlParameter("startdate_param", "1/1/1920"), new SqlParameter("enddate_param", "1/1/2020") }; List <Utility.LACES_VisualizationNewProviders_Result> queryresults2 = item.Database.SqlQuery <Utility.LACES_VisualizationNewProviders_Result>(cmdText2, paramsa2).ToList(); int k = 0; foreach (Utility.LACES_VisualizationNewProviders_Result result in queryresults2) { string subject = result.ProviderType; string count = result.providercount.Value.ToString(); jsondata += "{x:" + k.ToString() + ",y: " + count + ", indexLabel: \"" + subject + "\" },"; k++; } jsondata = jsondata.TrimEnd(','); break; } }