public void CreateAlbumsCate(AlbumsCate albumscate)
{
using (SqlConnection connection = GetConnection())
{
SqlCommand command = new SqlCommand("_AlbumsCateUpdate", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@Type", 0);
command.Parameters.AddWithValue("@AlbumsCateID", 0);
command.Parameters.AddWithValue("@ParentCateID", albumscate.ParentCateID);
command.Parameters.AddWithValue("@AlbumsCateName", albumscate.AlbumsCateName);
command.Parameters.AddWithValue("@AlbumsCateTotal", albumscate.AlbumsCateTotal);
command.Parameters.AddWithValue("@AlbumsCateOrder", albumscate.AlbumsCateOrder);
command.Parameters.AddWithValue("@ImageThumb", albumscate.ImageThumb);
command.Parameters.AddWithValue("@ImageLarge", albumscate.ImageLarge);
command.Parameters.AddWithValue("@Description", albumscate.Description);
command.Parameters.AddWithValue("@UserName", albumscate.UserName);
command.Parameters.AddWithValue("@Created", albumscate.Created);
command.Parameters.AddWithValue("@Language", albumscate.Language);
connection.Open();
if (command.ExecuteNonQuery() <= 0)
{
throw new DataAccessException("Không thể tạo danh mục tin");
}
else
{
command.Dispose();
}
}
}
public AlbumsCate GetAlbumsCateById(int cId)
{
AlbumsCate albumscate = null;
using (SqlConnection connection = GetConnection())
{
SqlCommand command = new SqlCommand("_AlbumsCateById", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@AlbumsCateID", cId);
connection.Open();
using (SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection))
{
if (reader.Read())
{
albumscate = AlbumsCateReader(reader);
}
else
{
throw new DataAccessException("Không tìm thấy danh mục");
}
command.Dispose();
}
}
return(albumscate);
}
private AlbumsCate AlbumsCateReader(SqlDataReader reader)
{
AlbumsCate albumscate = new AlbumsCate();
albumscate.AlbumsCateID = (int)reader["AlbumsCateID"];
albumscate.ParentCateID = (int)reader["ParentCateID"];
albumscate.AlbumsCateName = (string)reader["AlbumsCateName"];
albumscate.AlbumsCateTotal = (int)reader["AlbumsCateTotal"];
albumscate.AlbumsCateOrder = (int)reader["AlbumsCateOrder"];
albumscate.ImageThumb = (string)reader["ImageThumb"];
albumscate.ImageLarge = (string)reader["ImageLarge"];
albumscate.Description = (string)reader["Description"];
albumscate.UserName = (string)reader["UserName"];
albumscate.Created = (DateTime)reader["Created"];
albumscate.Language = (string)reader["Language"];
return(albumscate);
}
/// <summary>
/// Tao dieu huong cho danh muc
/// Khi su dung can phai khai bao: string cate_navigator = "";
/// url co dang: Default.aspx?go=albumcate&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
{
AlbumsCate albumcate = GetAlbumsCateById(cateId);
if (!string.IsNullOrEmpty(cate_navigator))
{
cate_navigator = " » " + cate_navigator;
}
cate_navigator = "<a href='" + url + cateId + "'>" + albumcate.AlbumsCateName + "</a>" + cate_navigator;
if (albumcate.ParentCateID != 0)
{
this.CateNavigator(ref cate_navigator, albumcate.ParentCateID, url);
}
}
catch (Exception ex)
{
throw new BusinessException(ex.Message.ToString());
}
}
public int CreateAlbumsCateGet(AlbumsCate albumscate)
{
int i = 0;
using (SqlConnection connection = GetConnection())
{
SqlCommand command = new SqlCommand("_AlbumsCateInsert", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@Type", 0);
command.Parameters.AddWithValue("@AlbumsCateID", 0);
command.Parameters.AddWithValue("@ParentCateID", albumscate.ParentCateID);
command.Parameters.AddWithValue("@AlbumsCateName", albumscate.AlbumsCateName);
command.Parameters.AddWithValue("@AlbumsCateTotal", albumscate.AlbumsCateTotal);
command.Parameters.AddWithValue("@AlbumsCateOrder", albumscate.AlbumsCateOrder);
command.Parameters.AddWithValue("@ImageThumb", albumscate.ImageThumb);
command.Parameters.AddWithValue("@ImageLarge", albumscate.ImageLarge);
command.Parameters.AddWithValue("@Description", albumscate.Description);
command.Parameters.AddWithValue("@UserName", albumscate.UserName);
command.Parameters.AddWithValue("@Created", albumscate.Created);
command.Parameters.AddWithValue("@Language", albumscate.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 UpdateAlbumsCate(AlbumsCate albumcate)
{
AlbumsCateDAO albumcateDAO = new AlbumsCateDAO();
albumcateDAO.UpdateAlbumsCate(albumcate);
}
public int CreateCateNewGet(AlbumsCate albumcate)
{
AlbumsCateDAO albumcateDAO = new AlbumsCateDAO();
return(albumcateDAO.CreateAlbumsCateGet(albumcate));
}
public void CreateCateNew(AlbumsCate albumcate)
{
AlbumsCateDAO albumcateDAO = new AlbumsCateDAO();
albumcateDAO.CreateAlbumsCate(albumcate);
}
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;
}
}
}
}
}
}
