public IEnumerable<PermissionItemdata> PostPermissionGroupAll(PermissionItemdata item) { objConn = objDB.EstablishConnection(); List<PermissionItemdata> manage = new List<PermissionItemdata>(); string strSQL = "SELECT pg.PermissionGroupID, pg.PermissionGroupName FROM permissionitems pt "; strSQL += "INNER JOIN permissiongroup pg ON pg.PermissionGroupID = pt.PermissionGroupID "; strSQL += "LEFT JOIN staffaccess sa ON sa.PermissionItemID = pt.PermissionItemID "; strSQL += "WHERE pt.PermissionItemParent = 0 AND pt.Deleted = 0 AND sa.StaffRoleID = '" + item.StaffRoleID + "' "; strSQL += "GROUP BY sa.StaffRoleID, pt.PermissionGroupID ORDER BY sa.StaffRoleID, pt.PermissionGroupID, pt.PermissionItemID;"; string strSQLitem = "SELECT pg.PermissionGroupID, pt.PermissionItemUrl, pt.PermissionItemID, pt.PermissionItemName FROM permissionitems pt "; strSQLitem += "INNER JOIN permissiongroup pg ON pg.PermissionGroupID = pt.PermissionGroupID "; strSQLitem += "LEFT JOIN staffaccess sa ON sa.PermissionItemID = pt.PermissionItemID "; strSQLitem += "WHERE pt.PermissionItemParent = 0 AND pt.Deleted = 0 AND sa.StaffRoleID = '" + item.StaffRoleID + "' "; strSQLitem += "GROUP BY pt.PermissionItemID;"; DataTable dt = objDB.List(strSQL, objConn); DataTable dtitem = objDB.List(strSQLitem, objConn); objConn.Close(); if (dt.Rows.Count > 0) { // Create Main Array // Create Object for (int i = 0; i < dt.Rows.Count; i++) { PermissionItemdata manageStaff = new PermissionItemdata(); manageStaff.GroupName = Convert.ToString(dt.Rows[i]["PermissionGroupName"]); // Add Group Name AS String DataRow[] dr = dtitem.Select(" PermissionGroupID = " + dt.Rows[i]["PermissionGroupID"].ToString()); // Add Group Parent AS Array List<PermissionItemParent> manageParent = new List<PermissionItemParent>(); if (dr.Length > 0) { for (int j = 0; j < dr.Length; j++) { PermissionItemParent manageStaffparent = new PermissionItemParent(); // Add Object PermissionGroupID manageStaffparent.PermissionGroupID = Convert.ToString(dr[j]["PermissionGroupID"]); // Add Object PermissionItemUrl manageStaffparent.PermissionItemUrl = Convert.ToString(dr[j]["PermissionItemUrl"]); // Add Object PermissionItemID manageStaffparent.PermissionItemID = Convert.ToString(dr[j]["PermissionItemID"]); // Add Object PermissionItemName manageStaffparent.PermissionItemName = Convert.ToString(dr[j]["PermissionItemName"]); manageParent.Add(manageStaffparent); } } manageStaff.GroupParent = manageParent; manage.Add(manageStaff); } } return manage.ToArray(); }
public IEnumerable<PermissionItemdata> PostPermissionGroup(PermissionItemdata item) { return repository.PostPermissionGroupAll(item); }