/**
* Get list of Departments by User ID
*/
public static List <TBL_PHONG_BAN> getDepartments_ByUserID(int intUserID, ATCLEntities entities)
{
List <TBL_PHONG_BAN> lstObj = entities.TBL_NGUOI_DUNG_PHONG_BAN.Join(entities.TBL_PHONG_BAN, NDPB => NDPB.DepartmentID, PB => PB.Id, (NDPB, PB) => new { NDPB, PB })
.Where(x => (x.NDPB.UserID == intUserID) && (x.PB.isDeleted == false)).Select(y => y.PB).ToList();
return(lstObj);
}
public static void getMenuType(DropDownList drpMenuType, ATCLEntities entities)
{
drpMenuType.DataSource = entities.TBL_MENU_LOAI.ToList();
drpMenuType.DataValueField = "ID";
drpMenuType.DataTextField = "TIEU_DE";
drpMenuType.DataBind();
drpMenuType.Items.Insert(0, new ListItem(Commons.CommonFuncs.BLANK_ITEM_TITLE, Commons.CommonFuncs.BLANK_ITEM_VALUE));
drpMenuType.SelectedIndex = 0;
}
/**
* get Rules of the login user
*/
public static List <string> getRulesOfUser(ATCLEntities entities)
{
int intUserId = (int)Commons.CheckUserInfo.GetUserId();
List <string> lstRights = entities.TBL_NGUOI_DUNG_QUYEN
.Join(entities.TBL_QUYEN, NDQ => NDQ.ID_QUYEN, Q => Q.ID, (NDQ, Q) => new { NDQ, Q })
.Where(x => x.NDQ.ID_NGUOI_DUNG == intUserId).Select(y => (string)y.Q.CODE).ToList();
return(lstRights);
}
/**
* Get DS Nguoi Dung
*/
public static void getNguoiDung(DropDownList drpObj, ATCLEntities entities)
{
drpObj.DataSource = entities.TBL_NGUOI_DUNG.Where(x => x.isEnabled == true).OrderBy(y => y.UserName).ToList();
drpObj.DataValueField = "Id";
drpObj.DataTextField = "FullName";
drpObj.DataBind();
drpObj.Items.Insert(0, new ListItem(Commons.CommonFuncs.BLANK_ITEM_TITLE, Commons.CommonFuncs.BLANK_ITEM_VALUE));
drpObj.SelectedIndex = 0;
}
/**
* Get DS Danh muc
*/
public static void getDanhMuc(DropDownList drpObj, ATCLEntities entities, string strMaDanhMuc)
{
drpObj.DataSource = entities.TBL_DANH_MUC.Where(x => (strMaDanhMuc.Equals(x.MA_DANH_MUC)) && (x.TT_XOA == false)).OrderBy(y => y.STT).ToList();
drpObj.DataValueField = "ID";
drpObj.DataTextField = "TEN";
drpObj.DataBind();
drpObj.Items.Insert(0, new ListItem(Commons.CommonFuncs.BLANK_ITEM_TITLE, Commons.CommonFuncs.BLANK_ITEM_VALUE));
drpObj.SelectedIndex = 0;
}
/**
* Get DS Hop Dong
*/
public static void getHopDong(DropDownList drpObj, ATCLEntities entities)
{
drpObj.DataSource = entities.TBL_HOP_DONG.Where(x => x.TT_XOA == false).OrderBy(y => y.STT).ToList();
drpObj.DataValueField = "ID";
drpObj.DataTextField = "TEN";
drpObj.DataBind();
drpObj.Items.Insert(0, new ListItem(Commons.CommonFuncs.BLANK_ITEM_TITLE, Commons.CommonFuncs.BLANK_ITEM_VALUE));
drpObj.SelectedIndex = 0;
}
public static List <string> getRulesOfUser_New(ATCLEntities entities)
{
int intUserId = (int)Commons.CheckUserInfo.GetUserId();
List <int> lstRights = entities.TBL_NGUOI_DUNG_QUYEN
.Join(entities.TBL_QUYEN, NDQ => NDQ.ID_QUYEN, Q => Q.ID, (NDQ, Q) => new { NDQ, Q })
.Where(x => x.NDQ.ID_NGUOI_DUNG == intUserId).Select(y => (int)y.Q.ID).ToList();
//add temperary (to avoid NULL)
lstRights.Add(ATCL_Consts.NUMBER_INVALID_INTEGER);
List <string> lstRules = entities.TBL_RULE
.Join(entities.TBL_QUYEN_RULE, R => R.ID, QR => QR.ID_RULE, (R, QR) => new { R, QR })
.Where(x => lstRights.Contains(x.QR.ID_QUYEN)).Select(y => (string)y.R.CODE).ToList();
return(lstRules);
}
/**
* Draw Tree for List Box
*/
public static void drawTreeInListBox(int intCapMenu, string strID, ListBox objListBox, string strTableName, ATCLEntities entities)
{
int intID = 0; bool blNumber = false;
if (!String.IsNullOrEmpty(strID))
{
intID = Convert.ToInt32(strID);
blNumber = true;
}
else //Begin --> reset DropDownlist
{
if (objListBox != null)
{
objListBox.Items.Clear();
ListItem objListItem = new ListItem();
objListItem.Value = Commons.TitleConst.getTitleConst("BLANK_ITEM_VALUE");
objListItem.Text = Commons.TitleConst.getTitleConst("BLANK_ITEM_TITLE");
objListBox.Items.Add(objListItem);
}
}
List <TreeObject> lstTreeObjects = new List <TreeObject>();
if (Commons.TitleConst.getTitleConst("TABLE_QT_MENUS").Equals(strTableName))
{
var lstObjects = entities.TBL_MENU.Where(x => (blNumber && x.ID_CHA == intID) || (blNumber == false && x.ID_CHA == 0)).ToList();
if ((lstObjects != null) && (lstObjects.Count > 0))
{
foreach (var item in lstObjects)
{
TreeObject objTreeObject = new TreeObject();
objTreeObject.ID = item.ID;
objTreeObject.TIEU_DE = item.TEN;
lstTreeObjects.Add(objTreeObject);
}
}
}
else if (Commons.TitleConst.getTitleConst("TABLE_PHONG_BAN").Equals(strTableName))
{
var lstObjects = entities.TBL_PHONG_BAN.Where(x => (blNumber && x.IdParent == intID) || (blNumber == false && ((x.IdParent == 0) || (x.IdParent == null)))).ToList();
if ((lstObjects != null) && (lstObjects.Count > 0))
{
foreach (var item in lstObjects)
{
TreeObject objTreeObject = new TreeObject();
objTreeObject.ID = item.Id;
objTreeObject.TIEU_DE = item.DepartmentName;
lstTreeObjects.Add(objTreeObject);
}
}
}
if ((lstTreeObjects != null) && (lstTreeObjects.Count > 0))
{
foreach (var item in lstTreeObjects)
{
string strLine = "";
strLine = strLine.PadLeft(intCapMenu * 6, (char)Commons.TitleConst.getTitleConst("TITLE_ICON").ElementAt(0));
if (objListBox != null)
{
ListItem objListItem = new ListItem();
objListItem.Value = item.ID.ToString();
objListItem.Text = strLine + item.TIEU_DE;
if (intCapMenu == 0) //Begining Level
{
objListItem.Attributes.Add("style", "font-weight: bold");
}
objListBox.Items.Add(objListItem);
}
drawTreeInListBox(intCapMenu + 1, item.ID.ToString(), objListBox, strTableName, entities);
}
}
}
public static void DrawTelericTreeView_DS_Quyen(ASPxTreeView radTreeView, int intQuyenID, int intParentNodeID, TreeViewNode node, ATCLEntities entities)
{
bool blCheck = false;
bool blZero = false;
if (intParentNodeID == 0)
{
blZero = true;
}
//var objMenus = entities.jos_menu.Where(x => (blZero ? x.parent == 0 : x.parent == intParentNodeID) && (x.id_menutype == intMenuType)).ToList();
var objQuyen = entities.TBL_RULE.Where(x => (x.isEnabled) &&
(blZero ? x.ID_PARENT == 0 : x.ID_PARENT == intParentNodeID)
).OrderBy(y => y.ORDER).ToList();
if ((objQuyen != null) && (objQuyen.Count > 0))
{
foreach (var item in objQuyen)
{
var objQuyenRule = entities.TBL_QUYEN_RULE.Where(x => x.ID_QUYEN == intQuyenID && x.ID_RULE == item.ID).ToList();
if (objQuyenRule != null && objQuyenRule.Count > 0)
{
blCheck = true;
}
else
{
blCheck = false;
}
string strMoTa = item.NAME;
if (node == null)
{
TreeViewNode nodeCap1 = new TreeViewNode(strMoTa);
nodeCap1.Name = item.ID.ToString();
DrawTelericTreeView_DS_Quyen(radTreeView, (int)intQuyenID, (int)item.ID, nodeCap1, entities);
nodeCap1.Expanded = true; //Expand all
nodeCap1.Checked = blCheck;
radTreeView.Nodes.Add(nodeCap1);
}
else
{
TreeViewNode child = new TreeViewNode(strMoTa);
child.Name = item.ID.ToString();
child.Expanded = true; //Expand all
child.Checked = blCheck;
node.Nodes.Add(child);
DrawTelericTreeView_DS_Quyen(radTreeView, (int)intQuyenID, (int)item.ID, child, entities);
}
}
}
}
/**
* Telerik:RadtreeView: variable to create TreeView (get DB from tbl SO_TAI_KHOAN)
* intCap: Begin from 1
* intParentNodeID: Begin from 0
* node: Begin is null
**/
public static void DrawTelericTreeView_Menus(ASPxTreeView radTreeView, int intVaiTroID, int intParentNodeID, TreeViewNode node, string strMenuType, ATCLEntities entities)
{
bool blCheck = false;
bool blZero = false;
if (intParentNodeID == 0)
{
blZero = true;
}
//var objMenus = entities.jos_menu.Where(x => (blZero ? x.parent == 0 : x.parent == intParentNodeID) && (x.id_menutype == intMenuType)).ToList();
var objMenus = entities.TBL_MENU.Join(entities.TBL_MENU_LOAI, M => (int)M.ID_LOAI_MENU, T => T.ID, (M, T) => new { M, T })
.Where(x => (x.M.isEnabled) &&
(blZero ? x.M.ID_CHA == 0 : x.M.ID_CHA == intParentNodeID) &&
(strMenuType.Equals(x.T.CODE))).Select(z => z.M).OrderBy(y => y.STT).ToList();
if ((objMenus != null) && (objMenus.Count > 0))
{
foreach (var item in objMenus)
{
var objVaiTroMenu = entities.TBL_MENU_QUYEN.Where(x => x.ID_QUYEN == intVaiTroID && x.ID_MENU == item.ID).ToList();
if (objVaiTroMenu != null && objVaiTroMenu.Count > 0)
{
blCheck = true;
}
else
{
blCheck = false;
}
string strMoTa = item.TEN;//item.TIEU_DE
if (node == null)
{
TreeViewNode nodeCap1 = new TreeViewNode(strMoTa);
nodeCap1.Name = item.ID.ToString();
DrawTelericTreeView_Menus(radTreeView, (int)intVaiTroID, (int)item.ID, nodeCap1, strMenuType, entities);
nodeCap1.Expanded = true; //Expand all
nodeCap1.Checked = blCheck;
radTreeView.Nodes.Add(nodeCap1);
}
else
{
TreeViewNode child = new TreeViewNode(strMoTa);
child.Name = item.ID.ToString();
child.Expanded = true; //Expand all
child.Checked = blCheck;
node.Nodes.Add(child);
DrawTelericTreeView_Menus(radTreeView, (int)intVaiTroID, (int)item.ID, child, strMenuType, entities);
}
}
}
}
public static string getPositionByCategory(string strCategoryName, string strPositionName_Origin, DropDownList drpCategory, ATCLEntities entities)
{
string strPositionName = "";
switch (strCategoryName)
{
case "Home":
if (!String.IsNullOrEmpty(strPositionName_Origin) && (strPositionName_Origin.Equals(CommonFuncs.POSITION_BANNER)))
{
strPositionName = CommonFuncs.POSITION_BANNER;
}
break;
case "OurTeams":
strPositionName = CommonFuncs.POSITION_BANNER;
break;
case "About":
strPositionName = CommonFuncs.POSITION_BANNER + " " + CommonFuncs.POSITION_RIGHT;
break;
case "Services":
strPositionName = CommonFuncs.POSITION_BANNER;
break;
case "CaseStudy":
strPositionName = "";
break;
case "News":
strPositionName = "";
break;
case "Clients":
strPositionName = "";
break;
case "Support":
strPositionName = "";
break;
default:
break;
}
return(strPositionName);
}
/**
* @Description: This function to draw menus for "Quan Ly tien do du an"
* @Parameters: Label Menu
* @Return: void
* @Written by: TuyenDV
**/
public static void getMenus_QLDA(Label lbMenus, string strMenuType, string strActiveURL, ATCLEntities entities)
{
lbMenus.Text = lbMenus.Text + @"
<div class='page-header'><h1 class='panel-title'>Thông tin chung về dự án</h1></div>
<div class='bg_100pecents_css margin_css'>
<div class='col-xs-3'>
<label class='control-label'>Ngày bắt đầu</label>: 30-07-2020
</div>
<div class='col-xs-3'>
<label class='control-label'>Ngày kết thúc</label>: 31-12-2020
</div>
<div class='col-xs-3'>
<label class='control-label'>Số ngày triển khai</label>: 90
</div>
<div class='col-xs-3'>
<label class='control-label'>Số ngày còn lại</label>: 45
</div>
</div>
<div class='bg_100pecents_css margin_css'>
<div class='col-xs-3'>
<label class='control-label'>Số task hoàn thành</label>: 9/50
</div>
<div class='col-xs-3'>
<label class='control-label'>Số task quá hạn</label>: 10/50
</div>
<div class='col-xs-3'>
<label class='control-label'>Số lượng rủi ro</label>: 3
</div>
<div class='col-xs-3'>
<label class='control-label'>Kết quả</label>: 18%
</div>
</div>
<div class='bg_100pecents_css margin_css' style='margin-bottom: 50px;'>
<div class='col-xs-3'>
<span style='background-color: red; padding: 2px; color: #ffffff'>Quá hạn</span>
</div>
</div>
";
lbMenus.Text = lbMenus.Text + @"
<div class='container' style='float:left; width: 100%; margin-bottom: 0px !important;'>
<nav class='navbar navbar-default'>
<div class='container-fluid'>
<div class='navbar-header'>
<button type='button' class='navbar-toggle collapsed' data-toggle='collapse' data-target='#navbar' aria-expanded='false' aria-controls='navbar'>
<span class='sr-only'>Toggle navigation</span>
<span class='icon-bar'></span>
<span class='icon-bar'></span>
<span class='icon-bar'></span> </button>
<a class='navbar-brand' href='#'> </a>
</div>
<div id='navbar' class='navbar-collapse collapse'>
<ul class='nav navbar-nav'>
";
//get Menu Type ID
var objMenuType = entities.TBL_MENU_LOAI.Where(x => strMenuType.Equals(x.CODE)).FirstOrDefault();
if (objMenuType != null)
{
//draw Menus
var objMenus = entities.TBL_MENU.Where(x => (x.ID_LOAI_MENU == objMenuType.ID) && (x.isEnabled == true)).OrderBy(y => y.STT).ToList();
if (objMenus != null)
{
foreach (var item in objMenus)
{
lbMenus.Text = lbMenus.Text + String.Format("<li><a {0} href='{1}'>{2}</a></li>", strActiveURL.Equals(item.LINK) ? "class='active_menu_css'" : "", item.LINK, item.TEN);
}
}
}
lbMenus.Text = lbMenus.Text + @"
</div><!--/.nav-collapse -->
</div><!--/.container-fluid -->
</nav>
</div>
";
}
/**
* Get Department Name from Session
*/
public static string getDepartmentName_OfUser_FromSession(HttpSessionState objSession, ATCLEntities entities)
{
try
{
int intDepartmentID = getDepartmentID_OfUser_FromSession(objSession);
return(entities.TBL_PHONG_BAN.Find(intDepartmentID).DepartmentName);
}
catch (Exception ex)
{
return(null);
}
}
/**
* Get DropDownList of Departments by User ID
*/
public static void getDropDownList_Departments_ByUserID(DropDownList drpDepartments, int intUserID, HttpSessionState objSession, ATCLEntities entities)
{
List <TBL_PHONG_BAN> lstObj = entities.TBL_NGUOI_DUNG_PHONG_BAN.Join(entities.TBL_PHONG_BAN, NDPB => NDPB.DepartmentID, PB => PB.Id, (NDPB, PB) => new { NDPB, PB })
.Where(x => (x.NDPB.UserID == intUserID) && (x.PB.isDeleted == false)).Select(y => y.PB).ToList();
drpDepartments.DataSource = lstObj;
drpDepartments.DataTextField = "DepartmentName";
drpDepartments.DataValueField = "Id";
drpDepartments.DataBind();
string strDepartmentID = (string)objSession[ATCL_Consts.SESSION_NAME_DEPARTMENT_ID];
if (!String.IsNullOrEmpty(strDepartmentID))
{
drpDepartments.SelectedValue = strDepartmentID;
}
else //Null or Empty
{
objSession[ATCL_Consts.SESSION_NAME_DEPARTMENT_ID] = drpDepartments.SelectedValue;
}
}
/**
* Get Department ID by DepartmentCode
*/
public static int getDepartmentID_ByDepartmentCode(string strDepartmentCode, ATCLEntities entities)
{
return(entities.TBL_PHONG_BAN.Where(x => (strDepartmentCode.Equals(x.DepartmentCode) && (x.isDeleted == false))).Select(y => (int)y.Id).FirstOrDefault());
}
