private VideosCate VideosCateReader(SqlDataReader reader) { VideosCate videoscate = new VideosCate(); videoscate.VideosCateID = (int)reader["VideosCateID"]; videoscate.ParentCateID = (int)reader["ParentCateID"]; videoscate.VideosCateName = (string)reader["VideosCateName"]; videoscate.VideosCateTotal = (int)reader["VideosCateTotal"]; videoscate.VideosCateOrder = (int)reader["VideosCateOrder"]; videoscate.ImageThumb = (string)reader["ImageThumb"]; videoscate.ImageLarge = (string)reader["ImageLarge"]; videoscate.Description = (string)reader["Description"]; videoscate.UserName = (string)reader["UserName"]; videoscate.Created = (DateTime)reader["Created"]; videoscate.Language = (string)reader["Language"]; return(videoscate); }
protected void Page_Load(object sender, EventArgs e) { int Id = 0; if (!String.IsNullOrEmpty(Request["id"])) { int.TryParse(Request["id"], out Id); } hddID.Value = Convert.ToString(Id); int cId = 0; if (!String.IsNullOrEmpty(Request["cId"])) { int.TryParse(Request["cId"], out cId); } hddCateID.Value = Convert.ToString(cId); if (!IsPostBack) { // int cateID = Convert.ToInt32(hddValue.Value); ViewVideo(cId); VideosCateBSO videoCateBSO = new VideosCateBSO(); VideosCate videoCate = videoCateBSO.GetVideosCateById(cId); //string strIcon = ""; if (videoCate != null) { string strTitle = "<a class='news_cm_tt_a' style='float:left' href='" + ResolveUrl("~/") + "thu-vien-video/" + GetString(videoCate.VideosCateName) + "-" + videoCate.VideosCateID + ".aspx' title='" + videoCate.VideosCateName + "'>" + videoCate.VideosCateName + "</a>"; lblTitle.Text = strTitle; //strIcon += "<a href='" + ResolveUrl("~/") + "thu-vien-video/" + GetString(videoCate.VideosCateName) + "-" + GetString(videoCate.VideosCateName) + "-" + videoCate.VideosCateID + ".aspx' title='" + videoCate.VideosCateName + "'>"; //strIcon += "<img class='is_img onLaw2-icon1 onLaw1-Submit-Arrow' src='" + ResolveUrl("~/") + "images/invis.gif' style='border-width: 0px;'>"; //strIcon += "</a>"; //lblIcon.Text = strIcon; } else { lblTitle.Text = "Video"; } } }
/// <summary> /// Tao dieu huong cho danh muc /// Khi su dung can phai khai bao: string cate_navigator = ""; /// url co dang: Default.aspx?go=videoscate&id= ; /// </summary> /// <param name="cate_navigator"></param> /// <param name="cateId"></param> /// <param name="url"></param> public void CateNavigator(ref string cate_navigator, int cateId, string url) { try { VideosCate videoscate = GetVideosCateById(cateId); if (!string.IsNullOrEmpty(cate_navigator)) { cate_navigator = " » " + cate_navigator; } cate_navigator = "<a href='" + url + cateId + "'>" + videoscate.VideosCateName + "</a>" + cate_navigator; if (videoscate.ParentCateID != 0) { this.CateNavigator(ref cate_navigator, videoscate.ParentCateID, url); } } catch (Exception ex) { throw new BusinessException(ex.Message.ToString()); } }
public VideosCate GetVideosCateById(int cId) { VideosCate videoscate = null; using (SqlConnection connection = GetConnection()) { SqlCommand command = new SqlCommand("_VideosCateById", connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@VideosCateID", cId); connection.Open(); using (SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection)) { if (reader.Read()) { videoscate = VideosCateReader(reader); } //else // throw new DataAccessException("Không tìm thấy danh mục"); command.Dispose(); } } return(videoscate); }
public int CreateVideosCateGet(VideosCate videoscate) { int i = 0; using (SqlConnection connection = GetConnection()) { SqlCommand command = new SqlCommand("_VideosCateInsert", connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@Type", 0); command.Parameters.AddWithValue("@VideosCateID", 0); command.Parameters.AddWithValue("@ParentCateID", videoscate.ParentCateID); command.Parameters.AddWithValue("@VideosCateName", videoscate.VideosCateName); command.Parameters.AddWithValue("@VideosCateTotal", videoscate.VideosCateTotal); command.Parameters.AddWithValue("@VideosCateOrder", videoscate.VideosCateOrder); command.Parameters.AddWithValue("@ImageThumb", videoscate.ImageThumb); command.Parameters.AddWithValue("@ImageLarge", videoscate.ImageLarge); command.Parameters.AddWithValue("@Description", videoscate.Description); command.Parameters.AddWithValue("@UserName", videoscate.UserName); command.Parameters.AddWithValue("@Created", videoscate.Created); command.Parameters.AddWithValue("@Language", videoscate.Language); SqlParameter parameter = new SqlParameter("@ReturnId", SqlDbType.Int); parameter.Direction = ParameterDirection.ReturnValue; command.Parameters.Add(parameter); connection.Open(); if (command.ExecuteNonQuery() <= 0) { throw new DataAccessException("Khong them duoc san pham"); } else { i = (int)parameter.Value; command.Dispose(); } } return(i); }
public void UpdateVideosCate(VideosCate videoscate) { VideosCateDAO videoscateDAO = new VideosCateDAO(); videoscateDAO.UpdateVideosCate(videoscate); }
public int CreateCateNewGet(VideosCate videoscate) { VideosCateDAO videoscateDAO = new VideosCateDAO(); return(videoscateDAO.CreateVideosCateGet(videoscate)); }
public void CreateCateNew(VideosCate videoscate) { VideosCateDAO videoscateDAO = new VideosCateDAO(); videoscateDAO.CreateVideosCate(videoscate); }
public static void GetNavigation(string strSlugPage, string g, string cId, string Id, string urlRoot) { if (strSlugPage != string.Empty) { SYS_PageLayoutBSO _pageLayoutBSO = new SYS_PageLayoutBSO(); SYS_PageLayout _pageLayout = new SYS_PageLayout(); if (!AspNetCache.CheckCache("PageLayout_" + strSlugPage + "_" + Language.language.Replace("-", "_"))) { _pageLayout = _pageLayoutBSO.GetSYS_PageLayoutBySlug(strSlugPage, Language.language); if (_pageLayout == null) { _pageLayout = _pageLayoutBSO.GetSYS_PageLayoutBySlug("home", Language.language); } AspNetCache.SetCache("PageLayout_" + strSlugPage + "_" + Language.language.Replace("-", "_"), _pageLayout); } else { _pageLayout = (SYS_PageLayout)AspNetCache.GetCache("PageLayout_" + strSlugPage + "_" + Language.language.Replace("-", "_")); } Navigation.TitleName = _pageLayout.PageName; Navigation.TitleCate = "<li><a href='" + urlRoot + "'>Trang chủ</a></li>"; CateNewsGroupBSO cateNewsgroupBSO = new CateNewsGroupBSO(); NewsGroupBSO newsgroupBSO = new NewsGroupBSO(); CateNewsBSO catenewsBSO = new CateNewsBSO(); if (strSlugPage == "du-an") { if (!String.IsNullOrEmpty(Id)) { Navigation.TitleName = "Thông tin dự án"; string cate = "<li><a href='" + urlRoot + "c2/du-an-c/du-an-1.aspx'>Dự án"; cate += "</a></li>"; Navigation.TitleCate = "<li><a href='" + urlRoot + "Default.aspx'>" + Resources.resource.T_home + "</a></li>"; Navigation.TitleCate += cate; } } else if (strSlugPage == "detailvideos") { if (!String.IsNullOrEmpty(cId)) { VideosCateBSO videosCateBSO = new VideosCateBSO(); VideosCate videoCate = videosCateBSO.GetVideosCateById(Convert.ToInt32(cId)); Navigation.TitleName = "<a href='" + urlRoot + "thu-vien-video" + "-" + videoCate.VideosCateID + ".aspx'>" + videoCate.VideosCateName + "</a>"; string cate = "<li><a href='" + urlRoot + "thu-vien-video.aspx'>Thư viện Video"; string s1 = ""; while (videoCate.ParentCateID != 0) { int pId = videoCate.ParentCateID; videoCate = videosCateBSO.GetVideosCateById(pId); s1 = "<li><a href='" + urlRoot + "thu-vien-video/" + videoCate.VideosCateName + "-" + videoCate.VideosCateID + ".aspx'>" + videoCate.VideosCateName + "</a></li>" + s1; } // cate += "Video"; //Sửa lại cate += "</a></li>"; cate += s1; Navigation.TitleCate = "<li><a href='" + urlRoot + "Default.aspx'>" + Resources.resource.T_home + "</a></li>"; Navigation.TitleCate += cate; } } else if (strSlugPage == "detailalbums") { if (!String.IsNullOrEmpty(cId)) { AlbumsCateBSO albumsCateBSO = new AlbumsCateBSO(); AlbumsCate videoCate = albumsCateBSO.GetAlbumsCateById(Convert.ToInt32(cId)); Navigation.TitleName = "<a href='" + urlRoot + "thu-vien-video" + "-" + videoCate.AlbumsCateID + ".aspx'>" + videoCate.AlbumsCateName + "</a>"; string cate = "<li><a href='" + urlRoot + "thu-vien-video.aspx'>Thư viện Video"; string s1 = ""; while (videoCate.ParentCateID != 0) { int pId = videoCate.ParentCateID; videoCate = albumsCateBSO.GetAlbumsCateById(pId); s1 = "<li><a href='" + urlRoot + "thu-vien-video/" + videoCate.AlbumsCateName + "-" + videoCate.AlbumsCateID + ".aspx'>" + videoCate.AlbumsCateName + "</a></li>" + s1; } // cate += "Video"; //Sửa lại cate += "</a></li>"; cate += s1; Navigation.TitleCate = "<li><a href='" + urlRoot + "Default.aspx'>" + Resources.resource.T_home + "</a></li>"; Navigation.TitleCate += cate; } } else if (strSlugPage == "dh") { if (!String.IsNullOrEmpty(g)) { Navigation.TitleName = "<a href='" + urlRoot + "tim-truong/0-0-0-0-0-0-0/search.aspx'>Thông tin trường</a>"; Navigation.TitleCate = "<li><a href='" + urlRoot + "Default.aspx'>" + Resources.resource.T_home + "</a></li>"; } } else if (strSlugPage == "dang-ky-ts") { if (!String.IsNullOrEmpty(g)) { Navigation.TitleName = "<a href='" + urlRoot + "c2/dh-dk/Dang-ky-tuyen-sinh-truc-tuyen-20.aspx'>Trang Đăng ký tuyển sinh</a>"; Navigation.TitleCate = "<li><a href='" + urlRoot + "Default.aspx'>" + Resources.resource.T_home + "</a></li>"; } } else if (strSlugPage == "dh-dk") { if (!String.IsNullOrEmpty(g)) { Navigation.TitleName = "<a href='" + urlRoot + "c2/dh-dk/Dang-ky-tuyen-sinh-truc-tuyen-20.aspx'>Trang Đăng ký tuyển sinh</a>"; Navigation.TitleCate = "<li><a href='" + urlRoot + "Default.aspx'>" + Resources.resource.T_home + "</a></li>"; } } else if (!String.IsNullOrEmpty(Id)) { NewsGroup newsgroup = newsgroupBSO.GetNewsGroupById(Convert.ToInt32(Id)); if (newsgroup != null && newsgroup.CateNewsID > 0) { CateNews catenews = catenewsBSO.GetCateNewsById(newsgroup.CateNewsID); CateNewsGroup cateNewsGroup = cateNewsgroupBSO.GetCateNewsGroupByGroupCate(catenews.GroupCate, Language.language); Navigation.TitleName = "<a href='" + urlRoot + "c3/" + catenewsBSO.GetSlugByCateId(catenews.CateNewsID) + "/" + GetString(catenews.CateNewsName) + "-" + catenews.GroupCate + "-" + catenews.CateNewsID + ".aspx'>" + catenews.CateNewsName + "</a>"; string cate = "<li><a href='" + urlRoot + "c2/" + cateNewsgroupBSO.GetSlugById(cateNewsGroup.CateNewsGroupID) + "/" + GetString(cateNewsGroup.CateNewsGroupName) + "-" + catenews.GroupCate + ".aspx'>"; string s1 = ""; while (catenews.ParentNewsID != 0) { int pId = catenews.ParentNewsID; catenews = catenewsBSO.GetCateNewsById(pId); s1 = "<li><a href='" + urlRoot + "c3/" + catenewsBSO.GetSlugByCateId(catenews.CateNewsID) + "/" + GetString(catenews.CateNewsName) + "-" + catenews.GroupCate + "-" + catenews.CateNewsID + ".aspx'>" + catenews.CateNewsName + "</a></li>" + s1; } cate += cateNewsGroup.CateNewsGroupName.ToString(); //Sửa lại cate += "</a></li>"; cate += s1; Navigation.TitleCate = "<li><a href='" + urlRoot + "Default.aspx'>" + Resources.resource.T_home + "</a></li>"; Navigation.TitleCate += cate; } } else { if (!String.IsNullOrEmpty(cId) && !String.IsNullOrEmpty(g)) { CateNews cateNewsById = catenewsBSO.GetCateNewsById(Convert.ToInt32(cId)); CateNewsGroup groupByGroupCate = cateNewsgroupBSO.GetCateNewsGroupByGroupCate(Convert.ToInt32(g), Language.language); if (groupByGroupCate != null && cateNewsById != null) { Navigation.TitleName = cateNewsById.CateNewsName; string cate = "<li><a href='" + urlRoot + "c2/" + cateNewsgroupBSO.GetSlugById(groupByGroupCate.CateNewsGroupID) + "/" + GetString(groupByGroupCate.CateNewsGroupName) + "-" + cateNewsById.GroupCate + ".aspx' title='" + groupByGroupCate.CateNewsGroupName + "'>"; string s1 = ""; while (cateNewsById.ParentNewsID != 0) { int parentNewsId = cateNewsById.ParentNewsID; cateNewsById = catenewsBSO.GetCateNewsById(parentNewsId); s1 = "<li><a href='" + urlRoot + "c3/" + catenewsBSO.GetSlugByCateId(cateNewsById.CateNewsID) + "/" + GetString(cateNewsById.CateNewsName) + "-" + cateNewsById.GroupCate + "-" + cateNewsById.CateNewsID + ".aspx' title='" + cateNewsById.CateNewsName + "'>" + cateNewsById.CateNewsName + "</a></li>" + s1; } cate += groupByGroupCate.CateNewsGroupName.ToString() + "</a></li>" + s1; Navigation.TitleCate = "<li><a href='" + urlRoot + "Default.aspx'>" + Resources.resource.T_home + "</a></li>"; Navigation.TitleCate += cate; } } else { if (!String.IsNullOrEmpty(g)) { CateNewsGroup groupByGroupCate = cateNewsgroupBSO.GetCateNewsGroupByGroupCate(Convert.ToInt32(g), Language.language); Navigation.TitleCate = "<li><a href='" + urlRoot + "Default.aspx'>" + Resources.resource.T_home + "</a></li>"; if (groupByGroupCate != null) { Navigation.TitleName = groupByGroupCate.CateNewsGroupName; } } } } } }