public static bool Delete(int catId) { CleanCacheCategory(); using (Portal.Core.DAL.MainDB db = new Portal.Core.DAL.MainDB()) db.StoredProcedures.Category_Delete(catId); return(true); }
public static ArrayList getCatInfo(int _catid) { Portal.Core.DAL.CategoryRow objrow; ArrayList objresult = new ArrayList(); using (Portal.Core.DAL.MainDB objDb = new Portal.Core.DAL.MainDB()) { objrow = objDb.CategoryCollection.GetByPrimaryKey(_catid); } if (objrow != null) { objresult.Add(objrow.Cat_Name); objresult.Add(objrow.Cat_Description); objresult.Add(objrow.Cat_DisplayURL); objresult.Add(objrow.Cat_ParentID); if (!objrow.IsCat_isColumnNull) { objresult.Add(objrow.Cat_isColumn); } if (!objrow.IsCat_isHiddenNull) { objresult.Add(objrow.Cat_isHidden); } objresult.Add(objrow.Cat_Icon); objresult.Add(objrow.Cat_ViewNum); //SonPC objresult.Add(objrow.EditionType_ID); //SonPC } return(objresult); }
public static bool UpdateCategoryRow(Portal.Core.DAL.CategoryRow row) { CleanCacheCategory(); using (Portal.Core.DAL.MainDB objDb = new Portal.Core.DAL.MainDB()) { objDb.CategoryCollection.Update(row); } #region Cập nhập vào bảng Category ở database User Portal.User.Db.CategoryRow objCateUserRow = new Portal.User.Db.CategoryRow(); using (Portal.User.Db.MainDB objDb = new Portal.User.Db.MainDB()) { objCateUserRow = objDb.CategoryCollection.GetByPrimaryKey(row.Cat_ID); objCateUserRow.Cat_Name = row.Cat_Name; objCateUserRow.Cat_ParentID = row.Cat_ParentID; objCateUserRow.Cat_Order = row.Cat_Order; objCateUserRow.Channel_ID = Portal.API.Config.CurrentChannel; objDb.CategoryCollection.Update(objCateUserRow); } #endregion return(true); }
//SonPC 13/02/2008 public static int GetCatParent(Int32 Cate_ID) { Portal.Core.DAL.CategoryRow objrow; using (Portal.Core.DAL.MainDB objDb = new Portal.Core.DAL.MainDB()) { objrow = objDb.CategoryCollection.GetByPrimaryKey(Cate_ID); if (objrow.Cat_ParentID == 0) { return(Cate_ID); } else { return(GetCatParent(objrow.Cat_ParentID)); } } }
public static Portal.Core.DAL.CategoryRow getCatInfoAsCategoryRow(int _catid) { Portal.Core.DAL.CategoryRow objrow; ArrayList objresult = new ArrayList(); using (Portal.Core.DAL.MainDB objDb = new Portal.Core.DAL.MainDB()) { objrow = objDb.CategoryCollection.GetByPrimaryKey(_catid); } if (objrow != null) { return(objrow); } objrow = new Portal.Core.DAL.CategoryRow(); return(objrow); }
public static Portal.Core.DAL.CategoryRow CreateCat2(string name, int order, string description, string displayURL, int parentCatId, int editionId, string icon, bool isColumn, bool isHidden, string tabCloneRef) { CleanCacheCategory(); #region Cập nhật vào bảng Category ở database dữ liệu chính [Portal.Core.DAL.CategoryRow] Portal.Core.DAL.CategoryRow objrow = new Portal.Core.DAL.CategoryRow(); objrow.Cat_Name = name; objrow.Cat_Description = description; objrow.Cat_DisplayURL = displayURL; objrow.Cat_ParentID = parentCatId; objrow.EditionType_ID = editionId; objrow.Cat_Icon = icon; objrow.Cat_Order = order; objrow.Cat_isColumn = isColumn; objrow.Cat_isHidden = isHidden; Portal.Core.DAL.MainDB db = new Portal.Core.DAL.MainDB(); db.CategoryCollection.Insert(objrow); #endregion #region Cập nhập vào bảng Category ở database User [Portal.User.Db.CategoryRow] Portal.User.Db.CategoryRow objCateUserRow = new Portal.User.Db.CategoryRow(); objCateUserRow.Cat_ID = objrow.Cat_ID; objCateUserRow.Cat_Name = objrow.Cat_Name; objCateUserRow.Cat_ParentID = objrow.Cat_ParentID; objCateUserRow.Cat_Order = objrow.Cat_Order; objCateUserRow.Channel_ID = Portal.API.Config.CurrentChannel; using (Portal.User.Db.MainDB userDB = new Portal.User.Db.MainDB()) { userDB.CategoryCollection.Insert(objCateUserRow); } #endregion //#region Cập nhật file Portal.config //string parentTabRef = string.Empty; //if (parentCatId == 0) // parentTabRef = db.EditionTypeCollection.GetByPrimaryKey(editionId).EditionDisplayURL; //else // CategoryHelper.GetTabReferenceByCatId(parentCatId); //string newTabRef = parentTabRef + "." + name; //Gentabhelper.AddNewTab(newTabRef, parentTabRef, name, tabCloneRef); //#endregion return(objrow); }
private static string LoadRootCategoryByPermission(DropDownList cb_Cate, ListBox lb_Cate, CheckBoxList cbl_Cate) { string strResult = ""; MainSecurity objSec = new MainSecurity(); Role objrole = objSec.GetRole(HttpContext.Current.User.Identity.Name); DataTable objParentCat = objSec.getParentCategoryAssigned(HttpContext.Current.User.Identity.Name, Portal.API.Config.CurrentChannel); if (cb_Cate != null) { cb_Cate.Items.Add(new ListItem("-----Chọn tất cả -----", "0")); } if (lb_Cate != null) { lb_Cate.Items.Add(new ListItem("-----Chọn chuyên mục khác -----", "0")); } DataTable childRows = new DataTable(); DataTable childLevel3Rows = new DataTable(); using (Portal.Core.DAL.MainDB objDB = new Portal.Core.DAL.MainDB()) { foreach (DataRow objrow in objParentCat.Rows) { childRows = objDB.FrontEndStoreProcedure.Category_GetListByWhere(" Where Cat_ParentID=" + objrow["Cat_ID"] + "", " Order By Cat_Order "); strResult += objrow["Cat_ID"] + ","; if (cb_Cate != null) { cb_Cate.Items.Add(new ListItem("" + objrow["Cat_Name"].ToString().ToUpper() + "", objrow["Cat_ID"] + "")); } if (lb_Cate != null) { lb_Cate.Items.Add(new ListItem("" + objrow["Cat_Name"].ToString().ToUpper() + "", objrow["Cat_ID"] + "")); } if (cbl_Cate != null) { cbl_Cate.Items.Add(new ListItem("" + objrow["Cat_Name"].ToString().ToUpper() + "", objrow["Cat_ID"] + "")); } } } return(strResult); }
public static string GetChildCatIdByCatParentId(int cat_Parent_Id) { DataTable dt; string strCatId = ""; using (Portal.Core.DAL.MainDB objDb = new Portal.Core.DAL.MainDB()) { dt = objDb.CategoryCollection.GetAsDataTable(" Cat_ParentID = " + cat_Parent_Id.ToString(), ""); } foreach (DataRow dr in dt.Rows) { strCatId += "," + dr["Cat_ID"]; } if (strCatId.Trim() != "") { strCatId = strCatId.Substring(1); } return(strCatId); }
private static string LoadRootCat(DropDownList cb_Cate, ListBox lb_Cate, CheckBoxList cbl_Cate) { string strResult = ""; using (Portal.Core.DAL.MainDB objDB = new Portal.Core.DAL.MainDB()) { DataTable parentRows = objDB.FrontEndStoreProcedure.Category_GetListByWhere(" Where (Cat_ParentID =0 OR Cat_ParentID is null) ", " Order By Cat_Order "); if (cb_Cate != null) { cb_Cate.Items.Add(new ListItem("-----Chọn tất cả -----", "0")); } if (lb_Cate != null) { lb_Cate.Items.Add(new ListItem("-----Chọn chuyên mục khác -----", "0")); } DataTable childRows; DataTable childLevel3Rows; foreach (DataRow aRow in parentRows.Rows) { if (cb_Cate != null) { cb_Cate.Items.Add(new ListItem("" + aRow["Cat_Name"].ToString().ToUpper() + "", aRow["Cat_ID"] + "")); } if (lb_Cate != null) { lb_Cate.Items.Add(new ListItem("" + aRow["Cat_Name"].ToString().ToUpper() + "", aRow["Cat_ID"] + "")); } if (cbl_Cate != null) { cbl_Cate.Items.Add(new ListItem("" + aRow["Cat_Name"].ToString().ToUpper() + "", aRow["Cat_ID"] + "")); } strResult += aRow["Cat_ID"] + ","; } return(strResult); } }
public static string GetTabReferenceByCatId(int catId) { string tab = string.Empty; Portal.Core.DAL.MainDB db = new Portal.Core.DAL.MainDB(); Portal.Core.DAL.CategoryRow category = db.CategoryCollection.GetByPrimaryKey(catId); if (category != null) { tab = category.Cat_DisplayURL; while (category.Cat_ParentID != 0) { category = db.CategoryCollection.GetByPrimaryKey(category.Cat_ParentID); if (category != null) { tab = category.Cat_DisplayURL + "." + tab; } } tab = db.EditionTypeCollection.GetByPrimaryKey(category.EditionType_ID).EditionDisplayURL + "." + tab; } return(tab); }
public static bool CheckUpdateCate(int Cate_ID, int NewsParent, bool IsFirst) { if (NewsParent == 0) { return(true); } if (IsFirst && (Cate_ID == NewsParent)) { return(false); } using (Portal.Core.DAL.MainDB db = new Portal.Core.DAL.MainDB()) { Portal.Core.DAL.CategoryRow objrow; objrow = db.CategoryCollection.GetByPrimaryKey(NewsParent); if (Cate_ID == objrow.Cat_ParentID) { return(false); } else { return(CheckUpdateCate(Cate_ID, objrow.Cat_ParentID, false)); } } }
public static DataTable GetCategoriesByParent(int parentId) { Portal.Core.DAL.MainDB objDb = new Portal.Core.DAL.MainDB(); return(objDb.CategoryCollection.GetAsDataTable("Cat_ParentID = " + parentId, "Cat_Order")); }
public static void UpdateCate(int _catid, string _catname, string _catdes, string _caturl, int _catparent, int _catedition, string _caticon, bool _catiscolumn, bool _catishide) { CleanCacheCategory(); Portal.Core.DAL.CategoryRow objrow; Portal.Core.DAL.EditionTypeRow objEditRow = null; Portal.Core.DAL.CategoryRow objParentRow = null; Portal.Core.DAL.CategoryRow objrow_find_parent = null; string strOldUrl = ""; using (Portal.Core.DAL.MainDB objDb = new Portal.Core.DAL.MainDB()) { objrow = objDb.CategoryCollection.GetByPrimaryKey(_catid); objParentRow = objDb.CategoryCollection.GetByPrimaryKey(objrow.Cat_ParentID); objEditRow = objDb.EditionTypeCollection.GetByPrimaryKey(objrow.EditionType_ID); if (_catparent != 0) { int cat_id_find_parent = GetCatParent(Convert.ToInt32(_catparent)); objrow_find_parent = objDb.CategoryCollection.GetByPrimaryKey(cat_id_find_parent); _catedition = objrow_find_parent.EditionType_ID; } } if (objrow != null) { strOldUrl = objrow.Cat_DisplayURL; objrow.Cat_Name = _catname; objrow.Cat_Description = _catdes; objrow.Cat_DisplayURL = _caturl; objrow.Cat_ParentID = _catparent; objrow.EditionType_ID = _catedition; //objrow.EditionType_ID = objrow_find_parent.EditionType_ID; if (_caticon != null && _caticon != "") { objrow.Cat_Icon = _caticon; } objrow.Cat_isColumn = _catiscolumn; objrow.Cat_isHidden = _catishide; using (Portal.Core.DAL.MainDB objDb = new Portal.Core.DAL.MainDB()) { objDb.CategoryCollection.Update(objrow); //UpdateEditionType(objrow.Cat_ID, objrow.EditionType_ID, objDb); } //cap nhat lai tabref neu co su thay doi ten o displayUrl string strEditionRef = ""; string strParentTabRef = ""; string strNewRef = ""; string strOldRef = ""; if (objEditRow != null) { //strEditionRef = objEditRow.EditionDisplayURL; //SonPC String UseEditionType = System.Configuration.ConfigurationSettings.AppSettings["UseEditionType"]; if (UseEditionType.ToLower().IndexOf("false") >= 0) { strEditionRef = System.Configuration.ConfigurationSettings.AppSettings["PrefixEditionType"]; } else { strEditionRef = objEditRow.EditionDisplayURL; } //SonPC strOldRef = strEditionRef + "."; strNewRef = strEditionRef + "."; } if (objParentRow != null) { strParentTabRef = objParentRow.Cat_DisplayURL; strOldRef = strOldRef + "." + strParentTabRef + "."; strNewRef = strNewRef + "." + strParentTabRef + "."; } strOldRef = strOldRef + strOldUrl; strNewRef = strNewRef + _caturl; Gentabhelper objHelp = new Gentabhelper(); objHelp.SyncCategoryTab(strOldRef, strNewRef, _catname, strEditionRef, strParentTabRef, _caturl, _catname); #region Cập nhập vào bảng Category ở database User Portal.User.Db.CategoryRow objCateUserRow = new Portal.User.Db.CategoryRow(); using (Portal.User.Db.MainDB objDb = new Portal.User.Db.MainDB()) { objCateUserRow = objDb.CategoryCollection.GetByPrimaryKey(objrow.Cat_ID); } objCateUserRow.Cat_Name = objrow.Cat_Name; objCateUserRow.Cat_ParentID = objrow.Cat_ParentID; objCateUserRow.Cat_Order = objrow.Cat_Order; objCateUserRow.Channel_ID = Portal.API.Config.CurrentChannel; using (Portal.User.Db.MainDB objDb = new Portal.User.Db.MainDB()) { objDb.CategoryCollection.Update(objCateUserRow); } #endregion } }
public static void CreateCat(string _catname, string _catdes, string _caturl, int _catparent, int _catedition, string _caticon, bool _catiscolumn, bool _catishide) { CleanCacheCategory(); Portal.Core.DAL.CategoryRow objrow = new Portal.Core.DAL.CategoryRow(); objrow.Cat_Name = _catname; objrow.Cat_Description = _catdes; objrow.Cat_DisplayURL = _caturl; objrow.Cat_ParentID = _catparent; objrow.EditionType_ID = _catedition; objrow.Cat_Icon = _caticon; objrow.Cat_isColumn = _catiscolumn; objrow.Cat_isHidden = _catishide; EditionTypeRow objEditRow = null; Portal.Core.DAL.CategoryRow objParentRow = null; Portal.Core.DAL.CategoryRow objrow_find_parent = null; Portal.Core.DAL.CategoryRow[] objTopRows; int intMaxOrder = 0; using (Portal.Core.DAL.MainDB objDb = new Portal.Core.DAL.MainDB()) { if (_catparent != 0) { int cat_id_find_parent = GetCatParent(Convert.ToInt32(_catparent)); objrow_find_parent = objDb.CategoryCollection.GetByPrimaryKey(cat_id_find_parent); _catedition = objrow_find_parent.EditionType_ID; } //if (_catparent == 0) // objEditRow = objDb.EditionTypeCollection.GetByPrimaryKey(_catedition); //else //{ objParentRow = objDb.CategoryCollection.GetByPrimaryKey(_catparent); // objEditRow = objDb.EditionTypeCollection.GetByPrimaryKey(objParentRow.EditionType_ID); //} objEditRow = objDb.EditionTypeCollection.GetByPrimaryKey(_catedition); objTopRows = objDb.CategoryCollection.GetTopAsArray(1, "Cat_ParentID=" + _catparent, "Cat_Order DESC"); if (objTopRows.Length == 1) { if (objTopRows[0].IsCat_OrderNull) { intMaxOrder = 1; } else { intMaxOrder = objTopRows[0].Cat_Order + 1; } } objrow.Cat_Order = intMaxOrder; objrow.EditionType_ID = _catedition; objDb.CategoryCollection.Insert(objrow); } //#region Cập nhập vào bảng Category ở database User //Portal.User.Db.CategoryRow objCateUserRow = new Portal.User.Db.CategoryRow(); //objCateUserRow.Cat_ID = objrow.Cat_ID; //objCateUserRow.Cat_Name = objrow.Cat_Name; //objCateUserRow.Cat_ParentID = objrow.Cat_ParentID; //objCateUserRow.Cat_Order = objrow.Cat_Order; //objCateUserRow.Channel_ID = Portal.API.Config.CurrentChannel; //using (Portal.User.Db.MainDB objDb = new Portal.User.Db.MainDB()) //{ // objDb.CategoryCollection.Insert(objCateUserRow); //} //#endregion //cap nhat thong tin ve tab moi khi them cat string strEditionRef = ""; string strParentTabRef = ""; if (objEditRow != null) { //strEditionRef = objEditRow.EditionDisplayURL; //SonPC String UseEditionType = ConfigurationSettings.AppSettings["UseEditionType"]; if (UseEditionType.ToLower().IndexOf("false") >= 0) { strEditionRef = ConfigurationSettings.AppSettings["PrefixEditionType"]; } else { strEditionRef = objEditRow.EditionDisplayURL; } //SonPC } if (objParentRow != null) { strParentTabRef = objParentRow.Cat_DisplayURL; } //thuc hien lay doi tuong GenTabHelper Gentabhelper objHelp = new Gentabhelper(); objHelp.AddCategoryTab(strEditionRef, strParentTabRef, _caturl, _catname); }
//SonPC 13/02/2008 #endregion public static DataTable GetListCategory(string strNotInCatId) { strNotInCatId = "-1"; if (strNotInCatId.Trim() == "") { strNotInCatId = "-1"; } DataTable dtCat = new DataTable(); DataTable objresult = new DataTable(); DataTable dtz = new DataTable(); DataTable dt3 = new DataTable(); object[] objarr = null; Portal.Core.DAL.MainDB objDbCore = new Portal.Core.DAL.MainDB(); try { dtCat = objDbCore.FrontEndStoreProcedure.Category_GetListByWhere(" Where (Cat_ParentID = 0 or Cat_ParentID is null) AND Cat_ID NOT IN (" + strNotInCatId + ") ", ""); dtCat.Columns.Add(new DataColumn("ID")); dtCat.Columns.Add(new DataColumn("Title")); objresult = dtCat.Clone(); foreach (DataRow objrow in dtCat.Rows) { objarr = objrow.ItemArray; objarr.SetValue(objrow["Cat_ID"], objarr.Length - 2); objarr.SetValue(objrow["Cat_Name"], objarr.Length - 1); objresult.Rows.Add(objarr); // Get cac chuyen muc con dtz = objDbCore.FrontEndStoreProcedure.Category_GetListByWhere(" Where Cat_ParentID = " + objrow["Cat_ID"] + " AND Cat_ID NOT IN (" + strNotInCatId + ") ", ""); dtz.Columns.Add(new DataColumn("ID")); dtz.Columns.Add(new DataColumn("Title")); foreach (DataRow drz in dtz.Rows) { drz["Cat_Name"] = " " + drz["Cat_Name"]; objarr = drz.ItemArray; objarr.SetValue(drz["Cat_ID"], objarr.Length - 2); objarr.SetValue(drz["Cat_Name"], objarr.Length - 1); objresult.Rows.Add(objarr); #region Chuyen muc con cap 3 // Get cac chuyen muc con cap 3 dt3 = objDbCore.FrontEndStoreProcedure.Category_GetListByWhere(" Where Cat_ParentID = " + drz["Cat_ID"] + " AND Cat_ID NOT IN (" + strNotInCatId + ") ", ""); dt3.Columns.Add(new DataColumn("ID")); dt3.Columns.Add(new DataColumn("Title")); if (dt3.Rows.Count > 0) { foreach (DataRow dr3 in dt3.Rows) { dr3["Cat_Name"] = " " + dr3["Cat_Name"]; objarr = dr3.ItemArray; objarr.SetValue(dr3["Cat_ID"], objarr.Length - 1); objarr.SetValue(dr3["Cat_Name"], objarr.Length - 1); objresult.Rows.Add(objarr); } } #endregion } } } catch (Exception e) { } dtCat.Dispose(); dtz.Dispose(); return(objresult); }