public IEnumerable<PermissionItem> PostPermissionItemAll(PermissionItem item)
{
objConn = objDB.EstablishConnection();
List<PermissionItem> permissionItem = new List<PermissionItem>();
string strSQL = "SELECT PermissionItemID FROM staffrole sr INNER JOIN staffaccess sa ON sa.StaffRoleID = sr.StaffRoleID WHERE sr.StaffRoleID = '"+item.StaffRoleID+"';";
DataTable dt = objDB.List(strSQL, objConn);
objConn.Close();
PermissionItem PermissionItem = new PermissionItem();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
if (i == 0)
PermissionItem.PermissionItemID += Convert.ToInt32(dt.Rows[i]["PermissionItemID"].ToString());
else
PermissionItem.PermissionItemID += "," + Convert.ToInt32(dt.Rows[i]["PermissionItemID"].ToString());
}
}
permissionItem.Add(PermissionItem);
return permissionItem.ToArray();
}
public IEnumerable<PermissionItem> PostPermissionItem(PermissionItem item)
{
return repository.PostPermissionItemAll(item);
}