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);
}
