Advertisement
Guest User

Untitled

a guest
Apr 19th, 2014
46
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.39 KB | None | 0 0
  1. <asp:Repeater ID="rptPendingCourses" runat="server" OnItemDataBound="rptPendingCourses_ItemDataBound">
  2. <ItemTemplate>
  3. <div class="coursesContainer">
  4. <div class="coursesContent as">
  5. <p class="title"><a onclick="linkcourse('<%#DataBinder.Eval(Container.DataItem, "CourseID")%>');return false;" href="#" title='Launch <%# DataBinder.Eval(Container.DataItem, "CourseTitle")%>'><%# System.Web.HttpUtility.HtmlEncode((String)(DataBinder.Eval(Container.DataItem, "CourseTitle").ToString().Length > 25 ? DataBinder.Eval(Container.DataItem, "CourseTitle").ToString().Remove(22) + "..." : DataBinder.Eval(Container.DataItem, "CourseTitle")))%></a></p>
  6. <ajax:Rating ID="courseRating" runat="server" Visible="false" MaxRating="5" ReadOnly="true"BackColor="Transparent"StarCssClass="ratingStar png" EmptyStarCssClass="emptyRatingStar png" WaitingStarCssClass="waitingRatingStar png" FilledStarCssClass="filledRatingStar png" />
  7. <div class="clear"></div>
  8. </div>
  9. </div>
  10. </ItemTemplate>
  11. </asp:Repeater>
  12.  
  13. <div class="courseWrapper">
  14. <div class="courseContainer">......</div>
  15. <div class="courseContainer">......</div>
  16. <div class="courseContainer">......</div>
  17. </div>
  18.  
  19. <div class="courseWrapper">
  20. <div class="courseContainer">......</div>
  21. <div class="courseContainer">......</div>
  22. <div class="courseContainer">......</div>
  23. </div>
  24.  
  25. /* Pending Courses */
  26. rptPendingCourses.DataSource = pendingCourses();
  27. rptPendingCourses.DataBind();
  28.  
  29. public DataSet pendingCourses()
  30. {
  31. DataSet dataSet = new DataSet();
  32. User user = (User)Context.Items["CurrentUser"];
  33.  
  34. SqlConnection selectConnection = new SqlConnection(ConfigurationSettings.AppSettings["DBConnectStr"]);
  35. SqlDataAdapter adapter = new SqlDataAdapter("dbo.procCataloguesGetAllCoursesByRating", selectConnection);
  36. adapter.SelectCommand.CommandType = CommandType.StoredProcedure;
  37.  
  38. // get results
  39. adapter.SelectCommand.Parameters.Add("@FilterByDomain", SqlDbType.Bit).Value = 0;
  40. if (user.Domain.Guid != Guid.Empty) {
  41. adapter.SelectCommand.Parameters.Add("@DomainID", SqlDbType.UniqueIdentifier).Value = user.Domain.Guid;
  42. }
  43. adapter.SelectCommand.Parameters.Add("@Culture", SqlDbType.VarChar, 6).Value = System.Threading.Thread.CurrentThread.CurrentCulture.Name;
  44. adapter.SelectCommand.Parameters.Add("@IsEnabled", SqlDbType.Bit).Value = 1;
  45. adapter.SelectCommand.Parameters.Add("@DomainAdminID", SqlDbType.UniqueIdentifier).Value = Guid.Empty;
  46.  
  47. try
  48. {
  49. dataSet = new DataSet();
  50. adapter.Fill(dataSet);
  51. }
  52. catch (Exception exception)
  53. {
  54. dataSet.Dispose();
  55. dataSet = null;
  56. LMS_DB.LMS_DB.LogErrorEvent(exception.Message, AuditEntryType.CatalogueCoursesGetCourses);
  57. }
  58. finally
  59. {
  60. if (selectConnection.State == ConnectionState.Open)
  61. {
  62. selectConnection.Close();
  63. }
  64. }
  65. return dataSet;
  66. }
  67.  
  68. protected void rptPendingCourses_ItemDataBound(object sender, RepeaterItemEventArgs e)
  69. {
  70. DataRowView dataItem = (DataRowView)e.Item.DataItem;
  71. if (Convert.ToBoolean(dataItem.Row["RatingsEnabled"]))
  72. {
  73. Rating rating = (Rating)e.Item.FindControl("courseRating");
  74. rating.Visible = true;
  75. rating.CurrentRating = Convert.ToInt32(dataItem.Row["AverageRating"]);
  76. }
  77.  
  78. }
  79.  
  80. <asp:ListView
  81. GroupItemCount="3"
  82. ID="rptPendingCourses"
  83. runat="server"
  84. OnItemDataBound="rptPendingCourses_ItemDataBound">
  85. <LayoutTemplate>
  86. <div runat="server" ID="groupPlaceholder"></div>
  87. </LayoutTemplate>
  88. <GroupTemplate>
  89. <div class="courseWrapper">
  90. <asp:PlaceHolder runat="server" ID="itemPlaceHolder" />
  91. </div>
  92. </GroupTemplate>
  93. <ItemTemplate>
  94. <div class="coursesContainer">
  95. <div class="coursesContent as">
  96. <p class="title"><a onclick="linkcourse('<%#DataBinder.Eval(Container.DataItem, "CourseID")%>');return false;" href="#" title='Launch <%# DataBinder.Eval(Container.DataItem, "CourseTitle")%>'><%# System.Web.HttpUtility.HtmlEncode((String)(DataBinder.Eval(Container.DataItem, "CourseTitle").ToString().Length > 25 ? DataBinder.Eval(Container.DataItem, "CourseTitle").ToString().Remove(22) + "..." : DataBinder.Eval(Container.DataItem, "CourseTitle")))%></a></p>
  97. <ajax:Rating ID="courseRating" runat="server" Visible="false" MaxRating="5" ReadOnly="true" BackColor="Transparent" StarCssClass="ratingStar png" EmptyStarCssClass="emptyRatingStar png" WaitingStarCssClass="waitingRatingStar png" FilledStarCssClass="filledRatingStar png" />
  98. <div class="clear"></div>
  99. </div>
  100. </div>
  101. </ItemTemplate>
  102. </asp:ListView>
  103.  
  104. protected void rptPendingCourses_ItemDataBound(object sender, ListViewItemEventArgs e)
  105. {
  106. if (e.Item.ItemType == ListViewItemType.DataItem)
  107. {
  108. ListViewDataItem listItem = (ListViewDataItem)e.Item;
  109. DataRowView dataItem = (DataRowView)listItem.DataItem;
  110. if (Convert.ToBoolean(dataItem.Row["RatingsEnabled"]))
  111. {
  112. Rating rating = (Rating)e.Item.FindControl("courseRating");
  113. rating.Visible = true;
  114. rating.CurrentRating = Convert.ToInt32(dataItem.Row["AverageRating"]);
  115. }
  116. }
  117. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement